APPS.MSC_POST_PRO dependencies on MSC_PLAN_ORGANIZATIONS

Line 775: from msc_plan_organizations

771: -- IO Perf:3693983: Moved update of msc_system_items to Load_Plan_SD from atp_snapshot_hook
772:
773: select organization_id, sr_instance_id
774: BULK COLLECT INTO l_organization_id, l_sr_instance_id
775: from msc_plan_organizations
776: WHERE plan_id=p_plan_id;
777:
778: --FORALL j IN l_organization_id.first.. l_organization_id.last
779: FOR j IN l_organization_id.first.. l_organization_id.last LOOP

Line 1300: from msc_plan_organizations mpo

1296: update msc_demands
1297: set atp_synchronization_flag = 0 -- null
1298: where (plan_id, sr_instance_id, organization_id) IN
1299: (select mpo.plan_id, mpo.sr_instance_id, mpo.organization_id
1300: from msc_plan_organizations mpo
1301: where mpo.plan_id = l_old_plan)
1302: and origination_type in (6,30);
1303:
1304: COMMIT;

Line 1452: FROM msc_system_items i ,msc_plan_organizations po

1448: --bug3663487 start SQL_ID 9428030
1449: -- ATP4drp Removed commented code for fetch from msc_system_items.
1450: SELECT 1
1451: INTO l_time_phased
1452: FROM msc_system_items i ,msc_plan_organizations po
1453: WHERE po.plan_id = p_plan_id
1454: AND i.aggregate_time_fence_date IS NOT NULL
1455: AND i.plan_id = po.plan_id
1456: AND i.organization_id = po.organization_id

Line 8954: msc_util.msc_log('atp_snapshot_hook: Updating msc_plan_organizations..');

8950:
8951: msc_util.msc_log('atp_snapshot_hook: l_count: '|| nvl(l_count,0));
8952:
8953: IF ( NVL(l_count,0) > 0) THEN
8954: msc_util.msc_log('atp_snapshot_hook: Updating msc_plan_organizations..');
8955: UPDATE msc_plan_organizations mpo
8956: SET so_lrn =(SELECT so_lrn
8957: FROM msc_instance_orgs mio
8958: WHERE mio.sr_instance_id=mpo.sr_instance_id

Line 8955: UPDATE msc_plan_organizations mpo

8951: msc_util.msc_log('atp_snapshot_hook: l_count: '|| nvl(l_count,0));
8952:
8953: IF ( NVL(l_count,0) > 0) THEN
8954: msc_util.msc_log('atp_snapshot_hook: Updating msc_plan_organizations..');
8955: UPDATE msc_plan_organizations mpo
8956: SET so_lrn =(SELECT so_lrn
8957: FROM msc_instance_orgs mio
8958: WHERE mio.sr_instance_id=mpo.sr_instance_id
8959: AND mio.organization_id=mpo.organization_id