[Home] [Help]
211: 2,
212: 1
213: FROM mtl_parameters param,
214: mrp_system_items msi,
215: mrp_recommendations mr,
216: mrp_plan_organizations_v orgs
217: WHERE param.organization_id = msi.organization_id
218: AND msi.inventory_item_id = mr.inventory_item_id
219: AND msi.compile_designator = mr.compile_designator
312: Decode(var_upd_req_date_rel,'Y',mr.implement_date,NULL)
313: FROM mtl_parameters param,
314: mrp_item_wip_entities w,
315: mrp_system_items msi,
316: mrp_recommendations mr,
317: mrp_plan_organizations_v orgs
318: WHERE param.organization_id = msi.organization_id
319: AND msi.inventory_item_id = mr.inventory_item_id
320: AND msi.compile_designator = mr.compile_designator
534: org_organization_definitions ood,
535: mtl_parameters mp,
536: mtl_system_items mti,
537: mrp_system_items msi,
538: mrp_recommendations mr,
539: mrp_plan_organizations_v orgs
540: WHERE ccga.cost_group_id (+)= nvl(mpp.costing_group_id, -23453)
541: AND ccga.organization_id(+)= mpp.organization_id
542: AND mpp.organization_id (+)= mr.organization_id
603: FROM
604: mtl_parameters mp,
605: mrp_item_purchase_orders mipo,
606: mrp_system_items msi,
607: mrp_recommendations mr,
608: mrp_plan_organizations_v orgs
609: WHERE mipo.transaction_id = mr.disposition_id
610: AND mipo.line_id IS NOT NULL
611: AND mipo.compile_designator = mr.compile_designator
663: FROM
664: mtl_parameters mp,
665: mrp_item_purchase_orders mipo,
666: mrp_system_items msi,
667: mrp_recommendations mr,
668: mrp_plan_organizations_v orgs
669: WHERE mipo.transaction_id = mr.disposition_id
670: AND mipo.line_id IS NOT NULL
671: AND mipo.compile_designator = mr.compile_designator
809: IF (arg_loaded_jobs > 0 OR arg_loaded_reqs > 0 OR
810: arg_resched_jobs > 0 OR arg_resched_reqs > 0)
811: THEN
812: UPDATE
813: mrp_recommendations
814: SET implement_demand_class = NULL,
815: implement_date = NULL,
816: implement_quantity = NULL,
817: implement_firm = NULL,