DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_INST_PARTITIONS

Line 2063: FOR inst IN (select instance_id from MSC_INST_PARTITIONS )

2059: -- row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2060: --
2061: -- Generate List of Instances passed --
2062: lv_inst_str := ',';
2063: FOR inst IN (select instance_id from MSC_INST_PARTITIONS )
2064: LOOP
2065: lv_inst_str := lv_inst_str || inst.instance_id || ',' ;
2066: END LOOP;
2067:

Line 2128: from msc_inst_partitions a,

2124: select b.table_name
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