APPS.EAM_SYNC_WO_TEXT_INDEX_PVT dependencies on ALL_INDEXES

Line 41: FROM all_indexes

37:
38: l_ctx_schema := 'CTXSYS';
39:
40: SELECT count(*) into l_count
41: FROM all_indexes
42: WHERE (owner = g_prod_schema OR owner = USER OR owner = l_ctx_schema)
43: AND table_name = 'EAM_WORK_ORDER_TEXT' AND index_name = 'EAM_WORK_ORDER_TEXT_CTX1'
44: AND status = 'VALID' AND domidx_status = 'VALID' AND domidx_opstatus = 'VALID';
45: