DBA Data[Home] [Help]

APPS.AP_MATCHING_UTILS_PKG dependencies on RCV_SHIPMENT_LINES

Line 1726: rcv_shipment_lines rsl,

1722: SELECT rcv.transaction_id,
1723: pll.matching_basis,
1724: pll.line_location_id
1725: FROM rcv_transactions rcv,
1726: rcv_shipment_lines rsl,
1727: po_line_locations pll
1728: WHERE rcv.shipment_line_id = rsl.shipment_line_id
1729: AND rsl.shipment_line_id = p_rcv_shipment_line_id
1730: AND pll.line_location_id = rcv.po_line_location_id

Line 1745: l_rcv_shipment_line_id RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID%TYPE;

1741: AND PRIOR transaction_type <> 'DELIVER';
1742:
1743: l_dist_tab AP_MATCHING_PKG.DIST_TAB_TYPE;
1744:
1745: l_rcv_shipment_line_id RCV_SHIPMENT_LINES.SHIPMENT_LINE_ID%TYPE;
1746: l_po_line_location_id PO_LINE_LOCATIONS.LINE_LOCATION_ID%TYPE;
1747: l_total_match_quantity NUMBER;
1748: l_total_match_amount NUMBER;
1749:

Line 2244: rcv_shipment_lines rsl,

2240: SELECT rcv.transaction_id,
2241: pll.matching_basis,
2242: pll.line_location_id
2243: FROM rcv_transactions rcv,
2244: rcv_shipment_lines rsl,
2245: po_line_locations pll
2246: WHERE rcv.shipment_line_id = rsl.shipment_line_id
2247: AND rsl.shipment_line_id = p_rcv_shipment_line_id
2248: AND pll.line_location_id = rcv.po_line_location_id