[Home] [Help]
80: /* --------------------------------------------------------------------
81: Procedure Name : DropShipment Receiving
82: Description : This callback function is called from PO receiving function
83: for non-inventory items and INV for inventory items.
84: Fetch the record from RCV_TRANSACTIONS.
85: If there are records in RCV_LOT_TRANSACTIONS, fetch them
86: in a loop.
87: For each record in RCV_LOT_TRANSACTIONS (or for the one
88: record in RCV_TRANSACTIONS):
84: Fetch the record from RCV_TRANSACTIONS.
85: If there are records in RCV_LOT_TRANSACTIONS, fetch them
86: in a loop.
87: For each record in RCV_LOT_TRANSACTIONS (or for the one
88: record in RCV_TRANSACTIONS):
89: 1. If the application is INV, call decrement inventory
90: 2. Compute the quantity shipped.
91:
92: If the application is INV, call
198: RT.PO_HEADER_ID, -- bug 4402566
199: nvl(OL.SHIPPED_QUANTITY,0) shp_qty
200: FROM OE_ORDER_LINES_ALL OL,
201: OE_DROP_SHIP_SOURCES OD,
202: RCV_TRANSACTIONS RT
203: WHERE OL.LINE_ID = OD.LINE_ID
204: AND OL.SOURCE_TYPE_CODE = 'EXTERNAL'
205: AND OD.PO_HEADER_ID = RT.PO_HEADER_ID
206: AND OD.PO_LINE_ID = RT.PO_LINE_ID
395: l_transfer_lpn_id -- bug 3544019
396: FROM mtl_system_items mi,
397: mtl_secondary_inventories msinv,
398: rcv_shipment_lines rs,
399: rcv_transactions rt
400: WHERE rt.transaction_id = l_transaction_id
401: AND rs.shipment_line_id = rt.shipment_line_id
402: AND mi.organization_id = rt.organization_id
403: AND mi.inventory_item_id = rs.item_id
446: ,rl.secondary_quantity -- OPM
447: -- ,rl.sublot_num -- OPM
448: ,rt.transaction_id
449: FROM rcv_lot_transactions rl,
450: rcv_transactions rt
451: WHERE rt.transaction_id = l_transaction_id
452: AND rl.transaction_id (+) = rt.transaction_id;
453:
454:
800: from the main dropshipreceive function, to decrement
801: inventory in the system.
802: This API is called in a loop from the DropShipReceive
803: function. The receiving transactions are stored in
804: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there
805: are lot level transactions). This API will be called only
806: once (for the record in RCV_TRANSACTIONS) if not lots are
807: associated. If there are multiple lots in the transaction,
808: it will be called for every lot.
802: This API is called in a loop from the DropShipReceive
803: function. The receiving transactions are stored in
804: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there
805: are lot level transactions). This API will be called only
806: once (for the record in RCV_TRANSACTIONS) if not lots are
807: associated. If there are multiple lots in the transaction,
808: it will be called for every lot.
809:
810: This API will insert records into
815: receipt (serial controlled
816: items.)
817: MTL_TRANSACTIONS_INTERFACE : For every transaction
818: (corresponds to qty recd
819: in RCV_TRANSACTIONS)
820:
821: IMPORTANT: ALL THE RECORDS INSERTED IN THE ABOVE TABLE FOR A
822: PARTICULAR TRANSACTION HAVE THE SAME TRANSACTION_INTERFACE_ID.
823: We pass the p_transaction_header_id to this API which is
1043: AND nvl(msn.current_subinventory_code,' ') = p_secondary_inventory
1044: AND nvl(msn.current_locator_id,0) = nvl(p_locator_id,0)
1045: AND msn.current_status=3
1046: AND msn.group_mark_id is NULL
1047: AND exists (select 1 from mtl_material_transactions mmt, rcv_transactions rt
1048: where mmt.transaction_id = msn.last_transaction_id
1049: and mmt.transaction_source_type_id = 1
1050: and rt.transaction_id = p_transaction_id
1051: and rt.transaction_id = mmt.rcv_transaction_id
1271:
1272: BEGIN
1273: SELECT RT.TRANSACTION_DATE
1274: INTO l_transaction_date
1275: FROM RCV_TRANSACTIONS RT
1276: WHERE RT.TRANSACTION_ID = p_transaction_id;
1277: EXCEPTION
1278: WHEN NO_DATA_FOUND THEN
1279: l_transaction_date := sysdate;