APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on DBA_TAB_PARTITIONS

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