APPS.MRP_EXP_WF dependencies on MRP_RECOMMENDATIONS

Line 47: mrp_recommendations rec,

43: CURSOR SUPPLIER_C(p_exception_id in number) IS
44: SELECT vend.vendor_id,
45: vend.vendor_name
46: FROM po_vendors vend,
47: mrp_recommendations rec,
48: mrp_exception_details_v exp
49: WHERE vend.vendor_id = rec.vendor_id
50: AND rec.transaction_id = exp.transaction_id
51: AND exp.exception_id = p_exception_id;

Line 62: mrp_recommendations rec,

58: FROM po_vendor_sites_all site,
59: po_headers_all poh,
60: po_vendors vend,
61: mrp_item_purchase_orders ipo,
62: mrp_recommendations rec,
63: mrp_exception_details_v exp
64: WHERE site.vendor_site_id = poh.vendor_site_id
65: AND site.org_id = poh.org_id
66: AND poh.po_header_id = ipo.purchase_order_id

Line 201: FROM mrp_recommendations rec,

197: l_workflow_process := 'EXCEPTION_PROCESS2';
198:
199: SELECT rec.order_type
200: INTO l_order_type_code
201: FROM mrp_recommendations rec,
202: mrp_exception_details_v exp
203: WHERE rec.transaction_id = exp.transaction_id
204: AND exp.exception_id = l_exception_id;
205:

Line 1739: UPDATE mrp_recommendations

1735: WHERE exception_id = l_exception_id;
1736:
1737: if (l_order_type in (3, 13)) then
1738:
1739: UPDATE mrp_recommendations
1740: SET implement_date = new_schedule_date,
1741: implement_quantity = DECODE(l_exception_type, 8, 0,
1742: new_order_quantity),
1743: implement_demand_class = demand_class,

Line 1771: UPDATE mrp_recommendations supplies

1767: WHEN NO_DATA_FOUND THEN
1768: l_location_id := NULL;
1769: END;
1770:
1771: UPDATE mrp_recommendations supplies
1772: SET old_order_quantity = new_order_quantity,
1773: quantity_in_process = new_order_quantity,
1774: implement_date = new_schedule_date,
1775: implement_quantity = decode(disposition_status_type,2,0,new_order_quantity), /** Bug 2226979 **/