APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on ALL_TAB_PARTITIONS

Line 283: FROM ALL_TAB_PARTITIONS atp ,

279: decode(atp.ini_trans, NULL, '', ' INITRANS ' || atp.ini_trans),
280: decode(atp.max_trans, NULL, '', ' MAXTRANS ' || atp.max_trans),
281: dt.EXTENT_MANAGEMENT,
282: dt.ALLOCATION_TYPE
283: FROM ALL_TAB_PARTITIONS atp ,
284: dba_tablespaces dt
285: WHERE atp.table_name = p_tbl
286: AND atp.table_owner = p_owner
287: AND atp.partition_name=p_partname

Line 321: from ALL_TAB_PARTITIONS

317: trc('i='|| lv_msg_data);
318:
319: select count(*)
320: into lv_part_exists
321: from ALL_TAB_PARTITIONS
322: where table_name = pTableName
323: AND table_owner = v_msc_schema
324: AND partition_name=lv_partition_name;
325:

Line 1217: FROM all_tab_partitions t1

1213: decode(t1.initial_extent, NULL, '', ' INITIAL ' || t1.initial_extent),
1214: decode(t1.next_extent, NULL, '', ' NEXT ' || t1.next_extent),
1215: decode(t1.pct_increase, NULL, '', ' PCTINCREASE ' || t1.pct_increase)
1216: INTO lv_tblspace_name, lv_pct_free, lv_pct_used, lv_init_ext, lv_nxt_ext, lv_pct_inc
1217: FROM all_tab_partitions t1
1218: WHERE t1.table_name = p_table_name
1219: AND t1.partition_name = lv_base_part
1220: AND t1.table_owner = lv_msc_schema
1221: AND NOT EXISTS (SELECT 1 FROM all_tab_partitions t2

Line 1221: AND NOT EXISTS (SELECT 1 FROM all_tab_partitions t2

1217: FROM all_tab_partitions t1
1218: WHERE t1.table_name = p_table_name
1219: AND t1.partition_name = lv_base_part
1220: AND t1.table_owner = lv_msc_schema
1221: AND NOT EXISTS (SELECT 1 FROM all_tab_partitions t2
1222: WHERE t2.table_name = t1.table_name
1223: AND t2.partition_name = p_part_name
1224: AND t2.table_owner = t1.table_owner);
1225:

Line 1357: FROM all_tab_partitions atp

1353: flv.language = userenv('lang') AND
1354: flv.attribute5 = 'L' AND
1355: EXISTS (
1356: SELECT 1
1357: FROM all_tab_partitions atp
1358: WHERE atp.table_name = flv.attribute2 AND
1359: atp.partition_name = substr(flv.attribute2, 8) || '_' || to_char(p_instance_id)
1360: );
1361:

Line 1879: and not exists (select 1 from all_tab_partitions ATP

1875: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Following DEFAULT partitions are missing');
1876: FOR tab in (select table_name
1877: from MSC_STAGING_TABLE_V mst
1878: where partition_type <> 'U'
1879: and not exists (select 1 from all_tab_partitions ATP
1880: where ATP.table_owner = lv_schema
1881: and atp.table_name=mst.table_name
1882: and partition_name like '%_DEF') )
1883: loop

Line 2132: FROM all_tab_partitions atp

2128: from msc_inst_partitions a,
2129: MSC_ODS_TABLE_V b
2130: WHERE b.PARTITION_TYPE='R'
2131: AND NOT EXISTS ( select 1
2132: FROM all_tab_partitions atp
2133: WHERE atp.table_name = b.table_name AND
2134: atp.table_owner = cp_schema AND
2135: atp.partition_name = substr(b.table_name, 5) || '__' || to_char(a.instance_id)
2136: )

Line 2194: FROM all_tab_partitions atp

2190: (
2191: mai.instance_type = 3 OR
2192: NOT EXISTS (
2193: select 1
2194: FROM all_tab_partitions atp
2195: WHERE atp.table_name = mst.table_name AND
2196: atp.table_owner = cp_owner AND
2197: atp.partition_name = substr(mst.table_name, 8) || '_' || to_char(mai.instance_id)
2198: )

Line 2204: from all_tab_partitions

2200: order by mst.table_name;
2201:
2202: cursor c_leg_part(cp_owner varchar2,cp_table varchar2) IS
2203: SELECT 1
2204: from all_tab_partitions
2205: where table_owner = cp_owner
2206: AND table_name = cp_table
2207: AND partition_name = substr(table_name,5)||'_LEG';
2208:

Line 2298: from all_tab_partitions

2294:
2295: FUNCTION get_next_high_val_part(powner varchar2,p_tab varchar2,p_high_val varchar2) return VARCHAR2 IS
2296: BEGIN
2297: For i in (select partition_name,high_value,high_value_length
2298: from all_tab_partitions
2299: where table_name = p_tab
2300: AND table_owner= powner
2301: order by partition_position
2302: )