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
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
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:=