1790: SELECT rcv.transaction_id,
1791: pll.matching_basis,
1792: pll.line_location_id
1793: FROM rcv_transactions rcv,
1794: rcv_shipment_lines rsl,
1795: po_line_locations pll
1796: WHERE rcv.shipment_line_id = rsl.shipment_line_id
1797: AND rsl.shipment_line_id = p_rcv_shipment_line_id
1798: AND pll.line_location_id = rcv.po_line_location_id
1809: AND PRIOR transaction_type <> 'DELIVER';
1810:
1811: l_dist_tab AP_MATCHING_PKG.DIST_TAB_TYPE;
1812:
1813: l_rcv_shipment_line_id RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID%TYPE;
1814: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
1815: l_total_match_quantity NUMBER;
1816: l_total_match_amount NUMBER;
1817:
2310: SELECT rcv.transaction_id,
2311: pll.matching_basis,
2312: pll.line_location_id
2313: FROM rcv_transactions rcv,
2314: rcv_shipment_lines rsl,
2315: po_line_locations pll
2316: WHERE rcv.shipment_line_id = rsl.shipment_line_id
2317: AND rsl.shipment_line_id = p_rcv_shipment_line_id
2318: AND pll.line_location_id = rcv.po_line_location_id