[Home] [Help]
108:
109: /* FP-J Lot/Serial Support Enhancement
110: * Helper routine to create interface records for the inspected lot number
111: * (in MTL_TRANSACTION_LOT_NUMBERS) and/or the inspected serial number (in
112: * MTL_SERIAL_NUMBERS_INTERFACE) if the item is lot and/or serial controlled.
113: * The interface records created here would be used by the receiving TM to
114: * update the receiving onhand for the lots and serials (RCV_LOTS_SUPPLY and
115: * RCV_SERIALS_SUPPLY)
116: */
235: IF (p_serial_control_code > 1 AND p_serial_number IS NOT NULL) THEN
236: --Get the serial status
237: SELECT status_id
238: INTO l_serial_status_id
239: FROM mtl_serial_numbers
240: WHERE serial_number = p_serial_number
241: AND inventory_item_id = p_inventory_item_id;
242:
243: --If the item is also lot controlled then set use the serial_transaction_temp_id
756: l_rcv_transaction_id
757: THEN
758: SELECT status_id
759: INTO l_serial_status_id
760: FROM mtl_serial_numbers
761: WHERE serial_number = l_rt_serial_tbl (i).serial_number
762: AND inventory_item_id = p_inventory_item_id;
763:
764: IF (l_lot_control_code > 1 AND p_lot_number IS NOT NULL)
3264: END LOOP; -- brought the loop to outside 12942776
3265:
3266: SELECT lot_number
3267: INTO l_lot_number
3268: FROM mtl_serial_numbers
3269: WHERE inventory_item_id = p_inventory_item_id
3270: AND serial_number = l_cur_serial_number;
3271:
3272: -- Call processing for each serial number