APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_ODS_TABLE_V

Line 2047: FROM MSC_ODS_TABLE_V a,DBA_TAB_PARTITIONS b

2043: ,b.high_value_length
2044: ,SUBSTR(b.partition_name,INSTR(b.partition_name,'__',-1)+2) part_inst_id
2045: ,nvl(instance_id_flag,'N') instance_id_flag
2046: ,nvl(plan_id_flag,'N') plan_id_flag
2047: FROM MSC_ODS_TABLE_V a,DBA_TAB_PARTITIONS b
2048: WHERE a.table_name = b.table_name
2049: AND b.table_owner = p_schema
2050: AND a.instance_id_flag = 'Y'
2051: AND a.PARTITION_TYPE <> 'U' -- Table is Partitioned

Line 2129: MSC_ODS_TABLE_V b

2125: ,a.instance_id
2126: ,nvl(instance_id_flag,'N') instance_id_flag
2127: ,nvl(plan_id_flag,'N') plan_id_flag
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