DBA Data[Home] [Help]

APPS.MRP_PO_RESCHEDULE dependencies on MRP_PO_RESCHEDULE_GT

Line 107: 'INSERT INTO mrp_po_reschedule_gt (

103: RETURN;
104: END IF;
105:
106: l_sql_stmt :=
107: 'INSERT INTO mrp_po_reschedule_gt (
108: purchase_order_id
109: , po_number
110: , line_id
111: , line_location_id

Line 299: FROM mrp_po_reschedule_gt i,

295: , g_qtys
296: , g_promise_dates
297: , g_uoms
298: , g_operating_units
299: FROM mrp_po_reschedule_gt i,
300: mtl_uom_conversions u
301: WHERE i.uom = u.uom_code
302: AND u.inventory_item_id = 0
303: AND i.action <> 2

Line 649: ' from mrp_po_reschedule_gt ' ||

645: ' select '|| --?????
646: ' purchase_order_id,'||
647: ' line_id,'||
648: ' po_number'||
649: ' from mrp_po_reschedule_gt ' ||
650: ' where action = 2 '||
651: ' order by po_number ';
652: ELSE
653: sql_stmt:=