APPS.RCV_VALIDATE_PO dependencies on PO_LINE_LOCATIONS_ALL

Line 155: po_line_locations_all poll

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
159: AND rsl.po_header_id = poll.po_header_id

Line 172: po_line_locations_all poll

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
176: AND rsl.po_header_id = poll.po_header_id

Line 250: po_line_locations_all poll,

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
254: AND pol.po_line_id = poll.po_line_id

Line 361: po_line_locations_all poll,

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
365: AND pol.po_line_id = poll.po_line_id