JTF Grid Datasources

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
JTF grid (CRM spreadtable) datasource and column definition
Run JTF Grid Datasources and other Oracle EBS reports with Blitz Report™ on our demo environment
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
AR Aging - 7 Buckets - By Salesperson/Agent COPY OF: GL Account Analysis GL Account Analysis AR Transactions and Lines Avalara VAT listing Yanmar - Discount on order lines check ONT Credit Order Detail ASO Quote Data Template AR Customers and Sites
Blitz Report™

Blitz Report™ provides multiple benefits: