DBA Data[Home] [Help]

APPS.JTF_RS_DBI_CONC_PUB dependencies on ALL_INDEXES

Line 202: FROM ALL_INDEXES

198: -- Check owner name for the tables and indexes.
199: BEGIN
200: SELECT owner, table_owner, tablespace_name
201: INTO l_index_owner, l_table_owner, l_index_tblspace
202: FROM ALL_INDEXES
203: WHERE TABLE_NAME = 'JTF_RS_DBI_DENORM_RES_GROUPS'
204: AND index_name = 'JTF_RS_DBI_DENORM_RES_GRPS_N1'
205: AND table_owner= l_jtfu;
206:

Line 216: FROM ALL_INDEXES

212:
213: -- Check some ther index which will definitly exist
214: SELECT owner, table_owner, tablespace_name
215: INTO l_index_owner, l_table_owner, l_index_tblspace
216: FROM ALL_INDEXES
217: WHERE TABLE_NAME = 'JTF_RS_GROUPS_DENORM'
218: AND index_name = 'JTF_RS_GROUPS_DENORM_U1'
219: AND table_owner= l_jtfu;
220: