DBA Data[Home] [Help]

APPS.MSC_ATP_REFRESH_MVIEW dependencies on ALL_TAB_PARTITIONS

Line 83: FROM all_tab_partitions

79: --l_sub_part,
80: l_tbspace
81: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
82: --FROM dba_tab_partitions
83: FROM all_tab_partitions
84: WHERE table_owner = l_msc_schema
85: AND table_name IN ('MSC_ITEM_HIERARCHY_MV', 'MSC_RESOURCE_HIERARCHY_MV')
86: ORDER BY table_name, partition_name;
87:

Line 138: FROM all_tab_partitions

134: --l_sub_part,
135: l_tbspace
136: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
137: --FROM dba_tab_partitions
138: FROM all_tab_partitions
139: WHERE table_owner = l_msc_schema
140: AND table_name = 'MSC_ITEM_HIERARCHY_MV'
141: ORDER BY partition_name;
142: