[Home] [Help]
83:
84:
85: -- ========================================================================
86: --
87: -- Selects the rows in MSC_SUPPLIES for all orgs in a given plan
88: -- that meet the auto-release criteria and release those planned orders and reschedules
89: --
90: -- ========================================================================
91:
252: msc_planners mpl,
253: msc_trading_partners mparam,
254: msc_system_items msi,
255: msc_system_items rsi,
256: msc_supplies mr,
257: msc_plan_organizations_v mpo,
258: msc_plans mps,
259: msc_trading_partners mt
260: WHERE mpo.organization_id = arg_org_id
309: AND rsi.inventory_item_id = mr.inventory_item_id
310: AND ( NVL(rsi.in_source_plan, 2) <> 1
311: OR
312: mr.transaction_id in (
313: select a.transaction_id from msc_supplies a, msc_supplies b,MSC_DESIGNATORS d, msc_system_items e
314: where a.schedule_designator_id is not null
315: and a.schedule_designator_id = b.schedule_designator_id
316: and a.organization_id = mr.organization_id
317: and a.organization_id = b.organization_id
408: ms.order_type,
409: ms.sr_instance_id ,
410: ms.plan_id
411: from
412: msc_supplies ms,
413: msc_system_items msi,
414: msc_trading_partners mtp,
415: msc_calendar_dates cal1,
416: msc_calendar_dates cal2
452: ms.order_type,
453: ms.sr_instance_id ,
454: ms.plan_id
455: from
456: msc_supplies ms,
457: msc_system_items msi,
458: msc_trading_partners mtp,
459: msc_calendar_dates cal1,
460: msc_calendar_dates cal2
491: and ms.batch_id is null
492: and
493: not exists (select 1 from msc_full_pegging mfp,
494: msc_demands md,
495: msc_supplies ms1
496: where mfp.sr_instance_id = ms.sr_instance_id and
497: mfp.plan_id = ms.plan_id and
498: mfp.transaction_id =ms.transaction_id and
499: mfp.demand_id =md.demand_id and
711:
712: EXIT WHEN planned_orders_and_reschedules%NOTFOUND;
713:
714:
715: UPDATE msc_supplies
716: SET batch_id = MSC_Rel_Plan_PUB.g_batch_id
717: WHERE transaction_id = var_transaction_id
718: AND sr_instance_id = var_sr_instance_id
719: AND plan_id = var_plan_id ;
911: EXECUTE IMMEDIATE var_sql_stmt
912: INTO var_wip_job_number;
913: END IF;
914:
915: UPDATE msc_supplies
916: SET old_order_quantity = new_order_quantity,
917: quantity_in_process = new_order_quantity,
918: implement_date = new_schedule_date,
919: implement_quantity = new_order_quantity,
1019: msi.planner_code
1020: INTO var_org_code, var_item, var_planner_code
1021: FROM msc_system_items msi,
1022: msc_trading_partners param,
1023: msc_supplies mr
1024: WHERE mr.transaction_id = var_transaction_id
1025: AND mr.sr_instance_id = var_sr_instance_id
1026: AND mr.plan_id = var_plan_id
1027: AND msi.organization_id = mr.organization_id
1057: -- Update PO Reqs planned orders and reschedules
1058: -- ------------------------------------------------------------------
1059: var_entity := 'PO Planned Orders';
1060:
1061: UPDATE msc_supplies
1062: SET old_order_quantity = new_order_quantity,
1063: quantity_in_process = new_order_quantity,
1064: implement_date = new_schedule_date,
1065:
1135: p_error_rows
1136: );
1137:
1138:
1139: UPDATE msc_supplies
1140: SET batch_id = MSC_Rel_Plan_PUB.g_batch_id,
1141: load_type =decode(var_order_type,PLANNED_ERO,ERO_LOAD,IRO_LOAD)
1142: WHERE transaction_id = var_transaction_id
1143: AND sr_instance_id = var_sr_instance_id
1168: p_total_rows ,
1169: p_succ_rows ,
1170: p_error_rows
1171: );
1172: UPDATE msc_supplies
1173: SET batch_id = MSC_Rel_Plan_PUB.g_batch_id,
1174: load_type =TRANSFER_LOAD
1175: WHERE transaction_id = var_transaction_id
1176: AND sr_instance_id = var_sr_instance_id