[Home] [Help]
52:
53: /* FP-J Lot/Serial Support Enhancement
54: * Helper routine to create interface records for the inspected lot number
55: * (in MTL_TRANSACTION_LOT_NUMBERS) and/or the inspected serial number (in
56: * MTL_SERIAL_NUMBERS_INTERFACE) if the item is lot and/or serial controlled.
57: * The interface records created here would be used by the receiving TM to
58: * update the receiving onhand for the lots and serials (RCV_LOTS_SUPPLY and
59: * RCV_SERIALS_SUPPLY)
60: */
179: IF (p_serial_control_code > 1 AND p_serial_number IS NOT NULL) THEN
180: --Get the serial status
181: SELECT status_id
182: INTO l_serial_status_id
183: FROM mtl_serial_numbers
184: WHERE serial_number = p_serial_number
185: AND inventory_item_id = p_inventory_item_id;
186:
187: --If the item is also lot controlled then set use the serial_transaction_temp_id
1364:
1365: -- We cannot assume that the serial number range belong to the samelot..
1366: select lot_number
1367: into l_lot_number
1368: from mtl_serial_numbers
1369: where inventory_item_id = p_inventory_item_id
1370: and serial_number = l_cur_serial_number;
1371:
1372: -- Call processing for each serial number