DBA Data[Home] [Help]

APPS.PO_SHIPMENTS_SV5 dependencies on PO_LINES

Line 63: FROM po_lines

59: IF (X_shipment_type = 'SCHEDULED') THEN
60:
61: SELECT quantity
62: INTO X_planned_qty_ordered
63: FROM po_lines
64: WHERE po_line_id = X_po_line_id;
65:
66: SELECT sum(quantity - nvl(quantity_cancelled,0))
67: INTO X_quantity_released