DBA Data[Home] [Help]

APPS.MSC_ATP_PEG dependencies on ALL_TAB_PARTITIONS

Line 3002: FROM all_tab_partitions

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

Line 3120: FROM all_tab_partitions t,

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