APPS.EAM_TEXT_UTIL dependencies on ALL_INDEXES

Line 725: FROM all_indexes

721: l_table := 'EAM_ASSET_TEXT';
722: l_index := 'EAM_ASSET_TEXT_CTX1';
723: l_status := 'VALID';
724: SELECT count(*) into l_count
725: FROM all_indexes
726: WHERE (owner = l_eam OR owner = USER OR owner = l_ctx)
727: AND table_name = l_table AND index_name = l_index
728: AND status = l_status AND domidx_status = l_status AND domidx_opstatus = l_status;
729: IF (l_count > 0) THEN

Line 849: FROM all_indexes

845: l_table := 'EAM_WORK_ORDER_TEXT';
846: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';
847: l_status := 'VALID';
848: SELECT count(*) into l_count
849: FROM all_indexes
850: WHERE (owner = l_eam OR owner = USER OR owner = l_ctx)
851: AND table_name = l_table AND index_name = l_index
852: AND status = l_status AND domidx_status = l_status AND domidx_opstatus = l_status;
853: IF (l_count > 0) THEN

Line 918: FROM all_indexes

914: l_index := 'EAM_WORK_ORDER_TEXT_CTX1';
915: l_status := 'VALID';
916:
917: SELECT count(*) into l_count
918: FROM all_indexes
919: WHERE (owner = l_eam OR owner = USER OR owner = l_ctx)
920: AND table_name = l_table AND index_name = l_index
921: AND status = l_status AND domidx_status = l_status AND domidx_opstatus = l_status;
922: