APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_STAGING_TABLE_V

Line 1877: from MSC_STAGING_TABLE_V mst

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

Line 1931: FROM MSC_STAGING_TABLE_V a,DBA_TAB_PARTITIONS b

1927: ,b.partition_name
1928: ,b.high_value
1929: ,b.high_value_length
1930: --,SUBSTR(b.partition_name,INSTR(partition_name,'_',-1)+1) part_inst_id
1931: FROM MSC_STAGING_TABLE_V a,DBA_TAB_PARTITIONS b
1932: WHERE a.table_name = b.table_name
1933: AND b.table_owner = p_schema
1934: AND a.PARTITION_TYPE <> 'U' -- Table is Partitioned
1935: ORDER BY a.table_name ;

Line 2186: FROM msc_staging_table_v mst,

2182: SELECT mst.application_id,
2183: mst.table_name,
2184: mai.instance_id instance_id,
2185: mai.instance_type instance_type
2186: FROM msc_staging_table_v mst,
2187: msc_apps_instances mai
2188: WHERE mst.table_name = cp_table AND
2189: mst.PARTITION_TYPE = 'L' AND
2190: (

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

2217:
2218: lv_schema:=msc_util.get_schema_name(724);
2219:
2220: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Following Partitions to be created');
2221: for stg_tab in (select table_name from msc_staging_table_v where PARTITION_TYPE = 'L' ) loop
2222:
2223: open c_leg_part (lv_schema,stg_tab.table_name);
2224: fetch c_leg_part into lv_count;
2225: if c_leg_part%notfound then