[Home] [Help]
775: -- Sales orders in old plan not in New plan
776: select max (oldp.demand_id),
777: oldp.sr_instance_id
778: from msc_demands oldp,
779: msc_plan_refreshes mpr
780: where oldp.plan_id = p_old_plan_id
781: and oldp.origination_type in (6,30)
782: and NVL(oldp.atp_synchronization_flag,-1) <> 1
783: and mpr.plan_id = p_new_plan_id
813: and oldp.using_assembly_item_id = newp.using_assembly_item_id
814: and oldp.demand_id = (
815: select max (md1.demand_id)
816: from msc_demands md1,
817: msc_plan_refreshes mpr1
818: where md1.origination_type in (6,30)
819: and md1.plan_id = p_old_plan_id
820: and md1.sr_instance_id = oldp.sr_instance_id
821: and NVL(md1.atp_synchronization_flag,-1) <> 1
902:
903: ---------------------------------------------------------------------------------
904: -- Get records that have been inserted or modified after the start of collections.
905: -- These records will have a refresh number > the refresh number populated by
906: -- collections and suitably transferred by planning to MSC_PLAN_REFRESHES.
907:
908: -- CTO Re-arch changes, added session_id as an IN param, as it will now be retrieved in ATP_Synchronize
909: PROCEDURE Get_Records_Post_Collections (
910: p_old_plan_id IN number,
1064: and (md.demand_id, md.sr_instance_id) in (
1065: select max (md1.demand_id),
1066: md1.sr_instance_id
1067: from msc_demands md1,
1068: msc_plan_refreshes mpr,
1069: msc_plan_organizations mpo
1070: where md1.plan_id = p_old_plan_id
1071: and md1.origination_type in (6,30)
1072: and mpr.plan_id = p_new_plan_id
1685: x_refresh_number := -1;
1686:
1687: select apps_lrn
1688: into x_refresh_number
1689: from msc_plan_refreshes
1690: where plan_id = p_plan_id
1691: and sr_instance_id = p_instance_id;
1692:
1693: conc_debug ('Refresh Number : ' || x_refresh_number);