DBA Data[Home] [Help]

APPS.MSC_POST_PRO dependencies on ALL_PART_INDEXES

Line 5103: all_part_indexes i

5099: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
5100: --FROM dba_tab_partitions t,
5101: -- dba_part_indexes i
5102: FROM all_tab_partitions t,
5103: all_part_indexes i
5104: WHERE t.table_owner = l_msc_schema
5105: AND t.table_name = 'MSC_ALLOC_DEMANDS'
5106: AND t.partition_name = 'ALLOC_DEMANDS_' || to_char(l_plan_id)
5107: AND i.owner (+) = t.table_owner

Line 5655: all_part_indexes i

5651: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
5652: --FROM dba_tab_partitions t,
5653: -- dba_part_indexes i
5654: FROM all_tab_partitions t,
5655: all_part_indexes i
5656: WHERE t.table_owner = l_msc_schema
5657: AND t.table_name = 'MSC_ALLOC_SUPPLIES'
5658: AND t.partition_name = 'ALLOC_SUPPLIES_' || to_char(l_plan_id)
5659: AND i.owner (+) = t.table_owner