[Home] [Help]
27: SYS_NO CONSTANT INTEGER := 2;
28:
29: -- ========================================================================
30: --
31: -- Selects the rows in MRP_RECOMMENDATIONS for all orgs in a given plan
32: -- that meet the auto-release criteria and release those planned orders.
33: --
34: -- ========================================================================
35:
140: mtl_parameters mparam,
141: mtl_system_items master_msi,
142: mtl_system_items msi,
143: mrp_system_items rsi,
144: mrp_recommendations mr,
145: mrp_plan_organizations_v mpo
146: WHERE mpo.organization_id = arg_org_id
147: AND mpo.compile_designator = arg_plan_name
148: AND mr.organization_id = mpo.planned_organization
450: -- Update WIP Jobs planned orders
451: -- --------------------------------------------------------------------
452: var_entity := 'WIP Planned Orders';
453:
454: UPDATE mrp_recommendations
455: SET old_order_quantity = new_order_quantity,
456: quantity_in_process = new_order_quantity,
457: implement_date = new_schedule_date,
458: implement_quantity = new_order_quantity,
513: msik.planner_code
514: INTO var_org_code, var_item, var_planner_code
515: FROM mtl_system_items_kfv msik,
516: mtl_parameters param,
517: mrp_recommendations mr
518: WHERE mr.rowid = var_rowid
519: AND msik.organization_id = mr.organization_id
520: AND msik.inventory_item_id = mr.inventory_item_id
521: AND param.organization_id = mr.organization_id;
542: -- Update PO Reqs planned orders
543: -- ------------------------------------------------------------------
544: var_entity := 'PO Planned Orders';
545:
546: UPDATE mrp_recommendations
547: SET old_order_quantity = new_order_quantity,
548: quantity_in_process = new_order_quantity,
549: implement_date = new_schedule_date,
550: implement_quantity = new_order_quantity,