APPS.RCV_VALIDATE_PO dependencies on RCV_SHIPMENT_LINES

Line 154: rcv_shipment_lines rsl,

150: SELECT DISTINCT shipment_header_id
151: FROM (
152: SELECT rsl.shipment_header_id, rsl.shipment_line_id, rsl.quantity_received
153: FROM rcv_transactions rt,
154: rcv_shipment_lines rsl,
155: po_line_locations_all poll
156: WHERE rt.transaction_type IN ('RECEIVE', 'MATCH')
157: AND rt.shipment_line_id = rsl.shipment_line_id
158: AND rsl.po_line_location_id = poll.line_location_id

Line 171: rcv_shipment_lines rsl,

167: HAVING rsl.quantity_received > Sum(Nvl(rt.quantity_billed, 0))
168: UNION
169: SELECT rsl.shipment_header_id, rsl.shipment_line_id, rsl.amount_received
170: FROM rcv_transactions rt,
171: rcv_shipment_lines rsl,
172: po_line_locations_all poll
173: WHERE rt.transaction_type IN ('RECEIVE', 'MATCH')
174: AND rt.shipment_line_id = rsl.shipment_line_id
175: AND rsl.po_line_location_id = poll.line_location_id

Line 249: FROM rcv_shipment_lines rsl,

245: GROUP BY rsh.receipt_num;
246:
247: SELECT Nvl(Sum(Nvl(rsl.quantity_received, 0) * NVL(poll.price_override, pol.unit_price) ), 0)
248: INTO l_receipt_amount
249: FROM rcv_shipment_lines rsl,
250: po_line_locations_all poll,
251: po_lines_all pol
252: WHERE rsl.po_line_location_id = poll.line_location_id
253: AND rsl.po_line_id = pol.po_line_id

Line 261: FROM rcv_shipment_lines rsl

257:
258: IF l_receipt_amount = 0 THEN
259: SELECT Nvl(Sum(Nvl(rsl.amount_received, 0)), 0)
260: INTO l_receipt_amount
261: FROM rcv_shipment_lines rsl
262: WHERE rsl.quantity_shipped IS NULL
263: AND rsl.shipment_header_id = l_shipment_header_id ;
264:
265: END IF;

Line 360: FROM rcv_shipment_lines rsl,

356:
357: l_progress := '080';
358: SELECT Sum(Nvl(rsl.quantity_received, 0) * NVL(poll.price_override, pol.unit_price) )
359: INTO l_receipt_amount
360: FROM rcv_shipment_lines rsl,
361: po_line_locations_all poll,
362: po_lines_all pol
363: WHERE rsl.po_line_location_id = poll.line_location_id
364: AND rsl.po_line_id = pol.po_line_id

Line 372: FROM rcv_shipment_lines rsl

368:
369: IF l_receipt_amount = 0 THEN
370: SELECT Sum(Nvl(rsl.amount_received, 0))
371: INTO l_receipt_amount
372: FROM rcv_shipment_lines rsl
373: WHERE rsl.quantity_shipped IS NULL
374: AND rsl.shipment_header_id = l_shipment_header_id ;
375:
376: END IF;