[Home] [Help]
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: */
61: PROCEDURE process_lot_serial_intf(
62: x_return_status OUT NOCOPY VARCHAR2
63: , x_msg_count OUT NOCOPY NUMBER
454: SELECT rs.rcv_transaction_id
455: , rsh.receipt_source_code
456: , rs.unit_of_measure
457: , rs.secondary_unit_of_measure --OPM Convergence
458: FROM rcv_supply rs, rcv_serials_supply rss, rcv_transactions rt, rcv_shipment_headers rsh
459: WHERE rs.rcv_transaction_id = rt.transaction_id
460: AND rsh.shipment_header_id = rs.shipment_header_id
461: AND rt.inspection_status_code = 'NOT INSPECTED'
462: AND rs.supply_type_code = 'RECEIVING'
1066: * Process the lot numbers and serial numbers corresponding to the RTI
1067: * that was just created.
1068: * Since the lots and serials are stored by receiving tables, the
1069: * changes to RTI must be reflected in RCV_LOTS_SUPPLY (lot controlled item)
1070: * and RCV_SERIALS_SUPPLY (serial controlled item).
1071: * We would be creating the interface records in MTLI and MSNI corresponding
1072: * to the inspected quantity, lot number and the serial numbers inspected
1073: * Do this only if WMS and PO patch levels are J or higher
1074: */