APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_STAGING_TABLE_V

Line 2149: from MSC_STAGING_TABLE_V mst

2145: BEGIN
2146: lv_schema:=msc_util.get_schema_name(724);
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

Line 2203: FROM MSC_STAGING_TABLE_V a,DBA_TAB_PARTITIONS b

2199: ,b.partition_name
2200: ,b.high_value
2201: ,b.high_value_length
2202: --,SUBSTR(b.partition_name,INSTR(partition_name,'_',-1)+1) part_inst_id
2203: FROM MSC_STAGING_TABLE_V a,DBA_TAB_PARTITIONS b
2204: WHERE a.table_name = b.table_name
2205: AND b.table_owner = p_schema
2206: AND a.PARTITION_TYPE <> 'U' -- Table is Partitioned
2207: ORDER BY a.table_name ;

Line 2458: FROM msc_staging_table_v mst,

2454: SELECT mst.application_id,
2455: mst.table_name,
2456: mai.instance_id instance_id,
2457: mai.instance_type instance_type
2458: FROM msc_staging_table_v mst,
2459: msc_apps_instances mai
2460: WHERE mst.table_name = cp_table AND
2461: mst.PARTITION_TYPE = 'L' AND
2462: (

Line 2493: for stg_tab in (select table_name from msc_staging_table_v where PARTITION_TYPE = 'L' ) loop

2489:
2490: lv_schema:=msc_util.get_schema_name(724);
2491:
2492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Following Partitions to be created');
2493: for stg_tab in (select table_name from msc_staging_table_v where PARTITION_TYPE = 'L' ) loop
2494:
2495: open c_leg_part (lv_schema,stg_tab.table_name);
2496: fetch c_leg_part into lv_count;
2497: if c_leg_part%notfound then