DBA Data[Home] [Help]

APPS.MSC_ATP_REFRESH_MVIEW dependencies on ALL_TAB_PARTITIONS

Line 90: FROM all_tab_partitions

86: --l_sub_part,
87: l_tbspace
88: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
89: --FROM dba_tab_partitions
90: FROM all_tab_partitions
91: WHERE table_owner = l_apps_schema
92: AND table_name IN ('MSC_ITEM_HIERARCHY_MV', 'MSC_RESOURCE_HIERARCHY_MV')
93: ORDER BY table_name, partition_name;
94:

Line 145: FROM all_tab_partitions

141: --l_sub_part,
142: l_tbspace
143: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
144: --FROM dba_tab_partitions
145: FROM all_tab_partitions
146: WHERE table_owner = l_apps_schema
147: AND table_name = 'MSC_ITEM_HIERARCHY_MV'
148: ORDER BY partition_name;
149: