[Home] [Help]
748: SUBSTR(md.order_number,1,30) col17,
749: md.organization_id col18,
750: md.demand_class col19,
751: md.demand_id col20
752: from msc_demands md,
753: -- Inline view for Customers
754: ( select mtil.sr_instance_id sr_instance_id,
755: mtil.tp_id tp_id,
756: max(mtil.sr_tp_id) sr_tp_id
774: (
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
785: and oldp.refresh_number < mpr.apps_lrn
786: and oldp.sr_instance_id = mpr.sr_instance_id
787: and not exists (
788: select sales_order_line_id
789: from msc_demands md1
790: where md1.plan_id = p_new_plan_id
791: and md1.origination_type in (6,30)
792: and md1.sr_instance_id = oldp.sr_instance_id
793: and md1.sales_order_line_id = oldp.sales_order_line_id
801: (
802: -- Demands in both plans but have been rescheduled
803: select max(oldp.demand_id),
804: oldp.sr_instance_id
805: from msc_demands oldp,
806: msc_demands newp
807: where oldp.plan_id = p_old_plan_id
808: and newp.plan_id = p_new_plan_id
809: and oldp.origination_type in (6,30)
802: -- Demands in both plans but have been rescheduled
803: select max(oldp.demand_id),
804: oldp.sr_instance_id
805: from msc_demands oldp,
806: msc_demands newp
807: where oldp.plan_id = p_old_plan_id
808: and newp.plan_id = p_new_plan_id
809: and oldp.origination_type in (6,30)
810: and newp.origination_type in (6,30)
812: and oldp.sales_order_line_id = newp.sales_order_line_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
828: )
829: and newp.demand_id = (
830: -- select demand id for a particular sales order line ID
831: select max (md2.demand_id)
832: from msc_demands md2
833: where md2.origination_type in (6,30)
834: and md2.plan_id = p_new_plan_id
835: and md2.sales_order_line_id = oldp.sales_order_line_id
836: and md2.using_assembly_item_id = oldp.using_assembly_item_id
1039: md.ship_set_name col29, -- Ship Set Name
1040: md.arrival_set_name col30, -- Arrival Set Name
1041: 0 col31, -- Insert Flag
1042: md.demand_source_type col32 -- bug 8473835
1043: from msc_demands md,
1044: -- Inline view for Customers
1045: ( select mtil.sr_instance_id sr_instance_id,
1046: mtil.tp_id tp_id,
1047: max(mtil.sr_tp_id) sr_tp_id
1063: and md.origination_type in (6,30)
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)
1251:
1252: conc_debug ('Updating Data at :' || l_sysdate);
1253:
1254: forall l_counter in 1..p_atp_table.calling_module.count
1255: update msc_demands
1256: set atp_synchronization_flag = 1,
1257: last_updated_by = G_FND_USER,
1258: last_update_login = G_FND_USER,
1259: last_update_date = l_sysdate
1267: and NVL(atp_synchronization_flag, -1) <> 1;
1268:
1269: conc_debug ('Rows Updated : ' || sql%rowcount);
1270:
1271: /* Not Needed as component records aren't selected from msc_demands
1272: -- CTO Re-arch changes, need to update demands for ATO Model's options/ OC's
1273: conc_debug ('Updating CTO Component Demands');
1274:
1275: forall l_counter in 1..p_atp_table.calling_module.count
1272: -- CTO Re-arch changes, need to update demands for ATO Model's options/ OC's
1273: conc_debug ('Updating CTO Component Demands');
1274:
1275: forall l_counter in 1..p_atp_table.calling_module.count
1276: update msc_demands
1277: set atp_synchronization_flag = 1,
1278: last_updated_by = G_FND_USER,
1279: last_update_login = G_FND_USER,
1280: last_update_date = l_sysdate