JTF Grid Datasources

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
JTF grid (CRM spreadtable) datasource and column definition

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
jgdv.grid_datasource_name datasource_name,
jgdv.title_text title,
jgdv.db_view_name view_name,
jgcv.grid_col_alias column_alias,
jgcv.db_col_name view_column,
xxen_util.meaning(jgcv.data_type_code,'COLUMN_TYPE',0) data_type,
jgcv.query_seq query_sequence,
xxen_util.meaning(jgcv.sortable_flag,'WSH_DEBUG_ENABLED',665) sortable,
jgcv.label_text label,
jgcv.display_seq display_sequence,
jgcv.display_hsize display_width,
xxen_util.meaning(jgcv.display_type_code,'JTF_DISPLAY_TYPE',0) display_type
from
jtf_grid_datasources_vl jgdv,
jtf_grid_cols_vl jgcv
where
1=1 and
jgdv.grid_datasource_name=jgcv.grid_datasource_name
order by
jgdv.grid_datasource_name,
jgcv.query_seq
Parameter Name SQL text Validation
Datasource Name 
jgdv.grid_datasource_name=:datasource_name
 LOV
Download
   
Related Blitz Reports
Blitz Report Security AR Aging XXRG GL Account Analysis COPY OF: AR Aging - 7 Buckets - By Salesperson/Agent GL Account Analysis AR Transactions and Lines EOS GL Account Analysis with Tax ASO Quote Data Template AR Customers and Sites
Blitz Report™

Blitz Report™ provides multiple benefits: