DBA Data[Home] [Help]

APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on MSC_INST_PARTITIONS

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

2331: -- row_limit := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
2332: --
2333: -- Generate List of Instances passed --
2334: lv_inst_str := ',';
2335: FOR inst IN (select instance_id from MSC_INST_PARTITIONS )
2336: LOOP
2337: lv_inst_str := lv_inst_str || inst.instance_id || ',' ;
2338: END LOOP;
2339:

Line 2400: from msc_inst_partitions a,

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