APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on DBA_TAB_PARTITIONS

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 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