DBA Data[Home] [Help]

APPS.PO_MULTI_MOD_VALIDATIONS dependencies on PO_LINES_ALL

Line 3414: po_lines_all pol

3410: SELECT Nvl(Sum(Nvl(rsl.quantity_received, 0) * NVL(poll.price_override, pol.unit_price) ), 0)
3411: INTO l_receipt_amount
3412: FROM rcv_shipment_lines rsl,
3413: po_line_locations_all poll,
3414: po_lines_all pol
3415: WHERE rsl.po_line_location_id = poll.line_location_id
3416: AND rsl.po_line_id = pol.po_line_id
3417: AND pol.po_line_id = poll.po_line_id
3418: AND rsl.quantity_shipped IS NOT NULL