DBA Data[Home] [Help]

APPS.RCV_VALIDATE_PO dependencies on PO_LINES_ALL

Line 251: po_lines_all pol

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
255: AND rsl.quantity_shipped IS NOT NULL

Line 362: po_lines_all pol

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
366: AND rsl.quantity_shipped IS NOT NULL