DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on RCV_SHIPMENT_LINES

Line 1794: rcv_shipment_lines rsl,

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

Line 1813: l_rcv_shipment_line_id RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID%TYPE;

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:

Line 2314: rcv_shipment_lines rsl,

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