APPS.PO_SHIPMENTS_SV5 dependencies on PO_LINE_LOCATIONS

Line 68: FROM po_line_locations

64: WHERE po_line_id = X_po_line_id;
65:
66: SELECT sum(quantity - nvl(quantity_cancelled,0))
67: INTO X_quantity_released
68: FROM po_line_locations
69: WHERE po_line_id = X_po_line_id
70: AND shipment_type = 'SCHEDULED';
71:
72: IF (X_planned_qty_ordered = X_quantity_released) THEN

Line 86: FROM po_line_locations

82: X_progress := '020';
83:
84: SELECT nvl(sum(nvl(quantity,0) - nvl(quantity_cancelled, 0)),0)
85: INTO X_total_line_quantity
86: FROM po_line_locations
87: WHERE po_line_id = X_po_line_id
88: AND shipment_type = 'SCHEDULED';
89:
90: ELSIF (X_shipment_type = 'PLANNED') THEN

Line 97: FROM po_line_locations

93: X_progress := '030';
94:
95: SELECT sum(quantity - nvl(quantity_cancelled, 0))
96: INTO X_total_line_quantity
97: FROM po_line_locations
98: WHERE po_line_id = X_po_line_id
99: AND shipment_type <> 'PRICE BREAK';
100:
101: END IF;