DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on DBA_INDEXES

Line 13163: FROM dba_indexes

13159:
13160: -- Disable indexes on fact table
13161: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
13162: , partitioned
13163: FROM dba_indexes
13164: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
13165: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME
13166: AND status <> 'UNUSABLE') LOOP
13167:

Line 13181: FROM dba_indexes

13177:
13178: -- Put the indexes back
13179: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
13180: , partitioned
13181: FROM dba_indexes
13182: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
13183: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
13184:
13185: IF ind_lp.partitioned = 'YES' THEN

Line 13206: FROM dba_indexes

13202: /* Added for bug 14636607 Starts */
13203: -- Put the indexes back
13204: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
13205: , partitioned
13206: FROM dba_indexes
13207: WHERE table_name = 'PJI_FP_XBS_ACCUM_F'
13208: AND table_owner = PJI_UTILS.GET_PJI_SCHEMA_NAME) LOOP
13209:
13210: IF ind_lp.partitioned = 'YES' THEN