APPS.PO_SHIPMENTS_SV1 dependencies on PO_LINE_LOCATIONS

Line 22: FROM po_line_locations PLL

18: -- If this is not a release, pass in the po_line_id
19: IF (X_po_release_id is NOT NULL) THEN
20: SELECT max(PLL.shipment_num) + 1
21: INTO X_shipment_num
22: FROM po_line_locations PLL
23: WHERE PLL.po_release_id = X_po_release_id;
24:
25: ELSE
26: SELECT max(PLL.shipment_num) + 1

Line 28: FROM po_line_locations PLL

24:
25: ELSE
26: SELECT max(PLL.shipment_num) + 1
27: INTO X_shipment_num
28: FROM po_line_locations PLL
29: WHERE PLL.po_line_id = X_po_line_id
30: AND PLL.shipment_type in ('STANDARD', 'PLANNED', 'PRICE BREAK');
31:
32: END IF;

Line 116: FROM PO_LINE_LOCATIONS PLL

112: PLL.receive_close_tolerance,
113: PLL.accrue_on_receipt_flag,
114: PLL.receipt_required_flag,
115: PLL.inspection_required_flag
116: FROM PO_LINE_LOCATIONS PLL
117: WHERE PLL.line_location_id = X_source_shipment_id;
118:
119: BEGIN
120:

Line 219: FROM po_line_locations PLL

215: X_progress := '020';
216:
217: SELECT sum(PLL.quantity - nvl(PLL.quantity_cancelled,0))
218: INTO X_quantity_released
219: FROM po_line_locations PLL
220: WHERE PLL.po_line_id = X_source_id
221: AND PLL.shipment_type = 'SCHEDULED' ;
222:
223: ELSIF (X_entity_level = 'SHIPMENT') THEN /* Entity level is SHIPMENT */

Line 233: FROM po_line_locations PLL

229: X_progress := '030';
230:
231: SELECT sum(PLL.quantity - nvl(PLL.quantity_cancelled,0))
232: INTO X_quantity_released
233: FROM po_line_locations PLL
234: WHERE PLL.source_shipment_id = X_source_id
235: AND PLL.shipment_type = 'SCHEDULED' ;
236:
237: -- Bug 3840143: Added qty released calculation for distributions