APPS.EAM_TEXT_INDEX_PVT dependencies on ALL_INDEXES

Line 322: FROM all_indexes

318:
319: SELECT 'tablespace ' || tablespace_name ||
320: ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
321: INTO tspace_idx_param
322: FROM all_indexes
323: WHERE owner = g_Prod_Schema
324: AND index_name = 'EAM_ASSET_TEXT_U1'
325: AND table_name = 'EAM_ASSET_TEXT';
326:

Line 648: FROM all_indexes

644:
645: -- Check for existing indexes in the EAM product, APPS Universal, and interMedia schemas.
646: --
647: FOR index_rec IN ( SELECT owner, index_name, status, domidx_status, domidx_opstatus
648: FROM all_indexes
649: WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
650: AND table_name = 'EAM_ASSET_TEXT'
651: AND index_name = p_Index_Name )
652: LOOP

Line 1044: FROM all_indexes

1040:
1041: SELECT 'tablespace ' || tablespace_name ||
1042: ' storage (initial 1M next 1M minextents 1 maxextents unlimited pctincrease 0)'
1043: INTO tspace_idx_param
1044: FROM all_indexes
1045: WHERE owner = g_Prod_Schema
1046: AND index_name = 'EAM_WORK_ORDER_TEXT_U1'
1047: AND table_name = 'EAM_WORK_ORDER_TEXT';
1048:

Line 1373: FROM all_indexes

1369:
1370: -- Check for existing indexes in the EAM product, APPS Universal, and interMedia schemas.
1371: --
1372: FOR index_rec IN ( SELECT owner, index_name, status, domidx_status, domidx_opstatus
1373: FROM all_indexes
1374: WHERE ( owner = g_Prod_Schema OR owner = USER OR owner = g_Ctx_Schema )
1375: AND table_name = 'EAM_WORK_ORDER_TEXT'
1376: AND index_name = p_Index_Name )
1377: LOOP