APPS.EAM_SYNC_WO_TEXT_INDEX_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 40

     SELECT count(*) into l_count
     FROM all_indexes
     WHERE (owner = g_prod_schema OR owner = USER OR owner = l_ctx_schema)
		AND table_name = 'EAM_WORK_ORDER_TEXT' AND index_name = 'EAM_WORK_ORDER_TEXT_CTX1'
		AND status = 'VALID' AND domidx_status = 'VALID' AND domidx_opstatus = 'VALID';