[Home] [Help]
81: /* --------------------------------------------------------------------
82: Procedure Name : DropShipment Receiving
83: Description : This callback function is called from PO receiving function
84: for non-inventory items and INV for inventory items.
85: Fetch the record from RCV_TRANSACTIONS.
86: If there are records in RCV_LOT_TRANSACTIONS, fetch them
87: in a loop.
88: For each record in RCV_LOT_TRANSACTIONS (or for the one
89: record in RCV_TRANSACTIONS):
85: Fetch the record from RCV_TRANSACTIONS.
86: If there are records in RCV_LOT_TRANSACTIONS, fetch them
87: in a loop.
88: For each record in RCV_LOT_TRANSACTIONS (or for the one
89: record in RCV_TRANSACTIONS):
90: 1. If the application is INV, call decrement inventory
91: 2. Compute the quantity shipped.
92:
93: If the application is INV, call
201: RT.PO_HEADER_ID, -- bug 4402566
202: nvl(OL.SHIPPED_QUANTITY,0) shp_qty
203: FROM OE_ORDER_LINES_ALL OL,
204: OE_DROP_SHIP_SOURCES OD,
205: RCV_TRANSACTIONS RT
206: WHERE OL.LINE_ID = OD.LINE_ID
207: AND OL.SOURCE_TYPE_CODE = 'EXTERNAL'
208: AND OD.PO_HEADER_ID = RT.PO_HEADER_ID
209: AND OD.PO_LINE_ID = RT.PO_LINE_ID
402: l_rcv_primary_quantity -- 12794393
403: FROM mtl_system_items mi,
404: mtl_secondary_inventories msinv,
405: rcv_shipment_lines rs,
406: rcv_transactions rt
407: WHERE rt.transaction_id = l_transaction_id
408: AND rs.shipment_line_id = rt.shipment_line_id
409: AND mi.organization_id = rt.organization_id
410: AND mi.inventory_item_id = rs.item_id
455: -- ,rl.sublot_num -- OPM
456: ,rt.transaction_id
457: ,Nvl(rl.primary_quantity,0) -- 12794393
458: FROM rcv_lot_transactions rl,
459: rcv_transactions rt
460: WHERE rt.transaction_id = l_transaction_id
461: AND rl.transaction_id (+) = rt.transaction_id;
462:
463:
825: from the main dropshipreceive function, to decrement
826: inventory in the system.
827: This API is called in a loop from the DropShipReceive
828: function. The receiving transactions are stored in
829: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there
830: are lot level transactions). This API will be called only
831: once (for the record in RCV_TRANSACTIONS) if not lots are
832: associated. If there are multiple lots in the transaction,
833: it will be called for every lot.
827: This API is called in a loop from the DropShipReceive
828: function. The receiving transactions are stored in
829: RCV_TRANSACTIONS table and RCV_LOT_TRANSACTIONS (if there
830: are lot level transactions). This API will be called only
831: once (for the record in RCV_TRANSACTIONS) if not lots are
832: associated. If there are multiple lots in the transaction,
833: it will be called for every lot.
834:
835: This API will insert records into
840: receipt (serial controlled
841: items.)
842: MTL_TRANSACTIONS_INTERFACE : For every transaction
843: (corresponds to qty recd
844: in RCV_TRANSACTIONS)
845:
846: IMPORTANT: ALL THE RECORDS INSERTED IN THE ABOVE TABLE FOR A
847: PARTICULAR TRANSACTION HAVE THE SAME TRANSACTION_INTERFACE_ID.
848: We pass the p_transaction_header_id to this API which is
1068: AND nvl(msn.current_subinventory_code,' ') = p_secondary_inventory
1069: AND nvl(msn.current_locator_id,0) = nvl(p_locator_id,0)
1070: AND msn.current_status=3
1071: AND msn.group_mark_id is NULL
1072: AND exists (select 1 from mtl_material_transactions mmt, rcv_transactions rt
1073: where mmt.transaction_id = msn.last_transaction_id
1074: and mmt.transaction_source_type_id = 1
1075: and rt.transaction_id = p_transaction_id
1076: and rt.transaction_id = mmt.rcv_transaction_id
1296:
1297: BEGIN
1298: SELECT RT.TRANSACTION_DATE
1299: INTO l_transaction_date
1300: FROM RCV_TRANSACTIONS RT
1301: WHERE RT.TRANSACTION_ID = p_transaction_id;
1302: EXCEPTION
1303: WHEN NO_DATA_FOUND THEN
1304: l_transaction_date := sysdate;