[Home] [Help]
1283: -- from rcv_fte_transactions_v for the input p_shipment_line_id
1284: -- and then sum up the received correction quantities, to the
1285: -- received quantities and sum up the returned correction quantities
1286: -- to the returned quantities passing the final received quantity
1287: -- and the returned quantity for a shipment_line_id in rcv_fte_lines_v
1288: -- Please refer to the example in the Appendix.1 under the dld
1289: -- for corrections and rtv to get the description of what this API
1290: -- does.
1291: --========================================================================
1559:
1560: -- VERSION : current version 1.0
1561: -- initial version 1.0
1562: -- COMMENT : This procedure is used to query the rcv shipment lines
1563: -- from rcv_fte_lines_v
1564: -- based on the transaction type and other input parameters
1565: -- mentioned. We are using a procedure to do this instead
1566: -- of doing a direct query because we need to get the
1567: -- cumulative quantities of the received quantity and
1600: l_api_version_number CONSTANT NUMBER := 1.0;
1601: l_api_name CONSTANT VARCHAR2(30):= 'get_shipment_lines';
1602:
1603: -- This cursor is used to query all the shipment lines for a given
1604: -- shipment_header_id from rcv_fte_lines_v. This cursor is used
1605: -- for the following cases -
1606: -- 1. When the Transaction Type is ASN or
1607: -- 2. When the Transaction Type is Receipt and the transaction
1608: -- is completely pending or
1640: porel.release_num,
1641: rfl.asn_line_flag,
1642: rfl.revision_num po_revision_num,
1643: porel.revision_num rel_revision_num
1644: from rcv_fte_lines_v rfl,
1645: mtl_system_items_vl msiv,
1646: po_releases_all porel,
1647: rcv_shipment_lines rsl
1648: where rfl.shipment_header_id = p_shipment_header_id
1655: rfl.po_line_location_id,
1656: rfl.shipment_line_id;
1657:
1658: -- This cursor is used to query partial set of shipment lines for a given
1659: -- shipment_header_id from rcv_fte_lines_v. This cursor is used
1660: -- when the status of the receipt transaction is MATCHED_AND_CHILD_PENDING
1661: -- and user is trying to the match the pending transactions for the receipt.
1662: -- We query only those lines for which there are records present in
1663: -- wsh_inbound_txn_history for that shipment_header_id.
1693: porel.release_num,
1694: rfl.asn_line_flag,
1695: rfl.revision_num po_revision_num,
1696: porel.revision_num rel_revision_num
1697: from rcv_fte_lines_v rfl,
1698: mtl_system_items_vl msiv,
1699: po_releases_all porel,
1700: wsh_inbound_txn_history wth,
1701: rcv_shipment_lines rsl