APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_ODS_TABLE_V

Line 2319: FROM MSC_ODS_TABLE_V a,DBA_TAB_PARTITIONS b

2315: ,b.high_value_length
2316: ,SUBSTR(b.partition_name,INSTR(b.partition_name,'__',-1)+2) part_inst_id
2317: ,nvl(instance_id_flag,'N') instance_id_flag
2318: ,nvl(plan_id_flag,'N') plan_id_flag
2319: FROM MSC_ODS_TABLE_V a,DBA_TAB_PARTITIONS b
2320: WHERE a.table_name = b.table_name
2321: AND b.table_owner = p_schema
2322: AND a.instance_id_flag = 'Y'
2323: AND a.PARTITION_TYPE <> 'U' -- Table is Partitioned

Line 2401: MSC_ODS_TABLE_V b

2397: ,a.instance_id
2398: ,nvl(instance_id_flag,'N') instance_id_flag
2399: ,nvl(plan_id_flag,'N') plan_id_flag
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