[Home] [Help]
1268: --========================================================================
1269: -- PROCEDURE : Get_Cum_Rcvd_Rtv_Quantities --
1270: -- This procedure is called only from
1271: -- the Inbound Reconciliation UI to
1272: -- query the rcv shipment lines.
1273: --
1274: -- PARAMETERS: p_delivery_id_tab Table of delivery Ids to be reverted
1275: -- p_status_code_tab Table of Status Code values to updated
1276: -- on the deliveries stored in
1542: -- p_init_msg_list FND_API.G_TRUE to reset list
1543: -- p_shipment_header_id Shipment Header Id of the transaction
1544: -- p_transaction_type transaction type (ASN or RECEIPT)
1545: -- p_view_only_flag Used to decide wether to query all
1546: -- rcv shipment lines or only the ones
1547: -- that user is matching.
1548: -- It gets a value of "Y" if user is
1549: -- reverting a transaction or viewing a
1550: -- matched transaction. Otherwise it gets
1549: -- reverting a transaction or viewing a
1550: -- matched transaction. Otherwise it gets
1551: -- "N".
1552: -- x_shpmt_lines_out_rec This is a record of tables
1553: -- to store the rcv shipment lines
1554: -- information that needs to be displayed.
1555: -- x_max_rcv_txn_id Not used anymore
1556: -- x_msg_count number of messages in the list
1557: -- x_msg_data text of messages
1558: -- x_return_status return status of the API
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
1573: -- Following the logical flow of this API -
1574: -- 1. If the transaction type is 'RECEIPT', then we call the API
1575: -- get_cum_rcvd_rtv_quantities to the cumulative received quantities
1576: -- and returned quantities for each shipment line id for that receipt
1577: -- 2. Then, if the uom of the quantitities for each line in rcv_shipment_lines
1578: -- is different from the UOM on the corresponding delivery details
1579: -- (i.e. delivery details belonging to the same po_line_location_id)
1580: -- , then we call convert_quantity to convert the quantity on
1581: -- rcv shipment_lines to the UOM present on the delivery details.
1577: -- 2. Then, if the uom of the quantitities for each line in rcv_shipment_lines
1578: -- is different from the UOM on the corresponding delivery details
1579: -- (i.e. delivery details belonging to the same po_line_location_id)
1580: -- , then we call convert_quantity to convert the quantity on
1581: -- rcv shipment_lines to the UOM present on the delivery details.
1582: --
1583: --========================================================================
1584:
1585: PROCEDURE get_shipment_lines(
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
1649: and rsl.shipment_header_id = p_shipment_header_id
1650: and rsl.shipment_line_id = rfl.shipment_line_id
1651: and rfl.item_id = msiv.inventory_item_id(+)
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
1702: where rfl.shipment_header_id = p_shipment_header_id
1703: and rsl.shipment_header_id = p_shipment_header_id
1704: and rsl.shipment_line_id = rfl.shipment_line_id
1705: and rfl.item_id = msiv.inventory_item_id(+)
2045: --
2046: IF (nvl(shpmt_line_rec.asn_line_flag,'N') = 'Y' AND p_transaction_type = 'RECEIPT') THEN
2047: --{
2048: -- This is very important check. This tells us whether the record in
2049: -- rcv_shipment_lines actually belongs to the receipt or if that shipment
2050: -- line was created as a part of the ASN transaction.
2051: open l_chk_receipt_txn_csr(shpmt_line_rec.shipment_line_id);
2052: fetch l_chk_receipt_txn_csr into l_rcv_txn_rec_exists_flag;
2053: close l_chk_receipt_txn_csr;