DBA Data[Home] [Help]

APPS.JTF_GRIDDB dependencies on JTF_GRID_COLS_VL

Line 1134: from jtf_grid_cols_vl grc

1130: ,grc.db_sort_column
1131: ,grc.fire_post_query_flag
1132: ,grc.image_description_col
1133: ,null -- SQL column alias
1134: from jtf_grid_cols_vl grc
1135: where grc.grid_datasource_name = dataSource
1136: order by grc.query_seq;
1137:
1138: cursor columnFolderDef(gridName in varchar2, dataSource in varchar2,x_custom_grid_id in number) is

Line 1166: from jtf_grid_cols_vl grc

1162: ,grc.db_sort_column
1163: ,grc.fire_post_query_flag
1164: ,grc.image_description_col
1165: ,null -- sql column alias
1166: from jtf_grid_cols_vl grc
1167: ,jtf_custom_grid_cols cgc
1168: where grc.grid_datasource_name = dataSource
1169: and grc.grid_datasource_name = cgc.grid_datasource_name(+)
1170: and grc.grid_col_alias = cgc.grid_col_alias(+)

Line 1183: from jtf_grid_cols_vl grc

1179: order by grc.display_seq;
1180:
1181: cursor folderDisplaySeq(dataSource in varchar2, x_custom_grid_id in number) is
1182: select grc.grid_col_alias
1183: from jtf_grid_cols_vl grc
1184: ,jtf_custom_grid_cols cgc
1185: where grc.grid_datasource_name = datasource
1186: and grc.grid_datasource_name = cgc.grid_datasource_name(+)
1187: and grc.grid_col_alias = cgc.grid_col_alias(+)