APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on ALL_TAB_PARTITIONS

Line 402: FROM ALL_TAB_PARTITIONS atp ,

398: decode(atp.ini_trans, NULL, '', ' INITRANS ' || atp.ini_trans),
399: decode(atp.max_trans, NULL, '', ' MAXTRANS ' || atp.max_trans),
400: dt.EXTENT_MANAGEMENT,
401: dt.ALLOCATION_TYPE
402: FROM ALL_TAB_PARTITIONS atp ,
403: dba_tablespaces dt
404: WHERE atp.table_name = p_tbl
405: AND atp.table_owner = p_owner
406: AND atp.partition_name=p_partname

Line 441: from ALL_TAB_PARTITIONS

437: trc('i='|| lv_msg_data);
438: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '<>');
439: select count(*)
440: into lv_part_exists
441: from ALL_TAB_PARTITIONS
442: where table_name = pTableName
443: AND table_owner = v_msc_schema
444: AND partition_name=lv_partition_name;
445:

Line 1488: FROM all_tab_partitions t1

1484: decode(t1.initial_extent, NULL, '', ' INITIAL ' || t1.initial_extent),
1485: decode(t1.next_extent, NULL, '', ' NEXT ' || t1.next_extent),
1486: decode(t1.pct_increase, NULL, '', ' PCTINCREASE ' || t1.pct_increase)
1487: INTO lv_tblspace_name, lv_pct_free, lv_pct_used, lv_init_ext, lv_nxt_ext, lv_pct_inc
1488: FROM all_tab_partitions t1
1489: WHERE t1.table_name = p_table_name
1490: AND t1.partition_name = lv_base_part
1491: AND t1.table_owner = lv_msc_schema
1492: AND NOT EXISTS (SELECT 1 FROM all_tab_partitions t2

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

1488: FROM all_tab_partitions t1
1489: WHERE t1.table_name = p_table_name
1490: AND t1.partition_name = lv_base_part
1491: AND t1.table_owner = lv_msc_schema
1492: AND NOT EXISTS (SELECT 1 FROM all_tab_partitions t2
1493: WHERE t2.table_name = t1.table_name
1494: AND t2.partition_name = p_part_name
1495: AND t2.table_owner = t1.table_owner);
1496:

Line 1628: FROM all_tab_partitions atp

1624: flv.language = userenv('lang') AND
1625: flv.attribute5 = 'L' AND
1626: EXISTS (
1627: SELECT 1
1628: FROM all_tab_partitions atp
1629: WHERE atp.table_name = flv.attribute2 AND
1630: atp.partition_name = substr(flv.attribute2, 8) || '_' || to_char(p_instance_id)
1631: );
1632:

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

2147: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Following DEFAULT partitions are missing');
2148: FOR tab in (select table_name
2149: from MSC_STAGING_TABLE_V mst
2150: where partition_type <> 'U'
2151: and not exists (select 1 from all_tab_partitions ATP
2152: where ATP.table_owner = lv_schema
2153: and atp.table_name=mst.table_name
2154: and partition_name like '%_DEF') )
2155: loop

Line 2404: FROM all_tab_partitions atp

2400: from msc_inst_partitions a,
2401: MSC_ODS_TABLE_V b
2402: WHERE b.PARTITION_TYPE='R'
2403: AND NOT EXISTS ( select 1
2404: FROM all_tab_partitions atp
2405: WHERE atp.table_name = b.table_name AND
2406: atp.table_owner = cp_schema AND
2407: atp.partition_name = substr(b.table_name, 5) || '__' || to_char(a.instance_id)
2408: )

Line 2466: FROM all_tab_partitions atp

2462: (
2463: mai.instance_type = 3 OR
2464: NOT EXISTS (
2465: select 1
2466: FROM all_tab_partitions atp
2467: WHERE atp.table_name = mst.table_name AND
2468: atp.table_owner = cp_owner AND
2469: atp.partition_name = substr(mst.table_name, 8) || '_' || to_char(mai.instance_id)
2470: )

Line 2476: from all_tab_partitions

2472: order by mst.table_name;
2473:
2474: cursor c_leg_part(cp_owner varchar2,cp_table varchar2) IS
2475: SELECT 1
2476: from all_tab_partitions
2477: where table_owner = cp_owner
2478: AND table_name = cp_table
2479: AND partition_name = substr(table_name,5)||'_LEG';
2480:

Line 2570: from all_tab_partitions

2566:
2567: FUNCTION get_next_high_val_part(powner varchar2,p_tab varchar2,p_high_val varchar2) return VARCHAR2 IS
2568: BEGIN
2569: For i in (select partition_name,high_value,high_value_length
2570: from all_tab_partitions
2571: where table_name = p_tab
2572: AND table_owner= powner
2573: order by partition_position
2574: )