DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on ALL_TAB_PARTITIONS

Line 3004: FROM all_tab_partitions

3000: SELECT count(*)
3001: INTO l_count
3002: --bug 2495962: Change refrence from dba_xxx to all_xxx tables
3003: --FROM dba_tab_partitions
3004: FROM all_tab_partitions
3005: WHERE table_name = l_table_name
3006: AND partition_name = l_partition_name
3007: AND table_owner = l_msc_schema;
3008: EXCEPTION

Line 3122: FROM all_tab_partitions t,

3118: END IF;
3119:
3120: SELECT t.tablespace_name, NVL(i.def_tablespace_name, t.tablespace_name)
3121: INTO l_tbspace, l_ind_tbspace
3122: FROM all_tab_partitions t,
3123: all_part_indexes i
3124: WHERE t.table_owner = l_msc_schema
3125: AND t.table_name = 'MSC_ATP_PEGGING'
3126: AND t.partition_name = l_partition_name