[Home] [Help]
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: */
117: PROCEDURE process_lot_serial_intf(
118: x_return_status OUT NOCOPY VARCHAR2
119: , x_msg_count OUT NOCOPY NUMBER
647:
648: SELECT rt.transaction_id,
649: rss.serial_num
650: BULK COLLECT INTO l_rt_serial_tbl
651: FROM rcv_transactions rt, rcv_serials_supply rss
652: WHERE rt.transaction_id = l_rcv_transaction_id
653: AND rss.transaction_id = rt.transaction_id
654: AND rss.serial_num IN (SELECT *
655: FROM TABLE (list_serials));
1397: rs.secondary_unit_of_measure,
1398: COUNT (rs.rcv_transaction_id)
1399: BULK COLLECT INTO t_tmp_tbl
1400: FROM rcv_supply rs,
1401: rcv_serials_supply rss,
1402: rcv_transactions rt,
1403: rcv_shipment_headers rsh
1404: WHERE rs.rcv_transaction_id = rt.transaction_id
1405: and rs.rcv_transaction_id = nvl(l_mol_txn_src_id, rs.rcv_transaction_id)
2294: SELECT rs.rcv_transaction_id
2295: , rsh.receipt_source_code
2296: , rs.unit_of_measure
2297: , rs.secondary_unit_of_measure --OPM Convergence
2298: FROM rcv_supply rs, rcv_serials_supply rss, rcv_transactions rt, rcv_shipment_headers rsh
2299: WHERE rs.rcv_transaction_id = rt.transaction_id
2300: -- added 12942776 start
2301: and rs.rcv_transaction_id = nvl(l_mol_txn_src_id, rs.rcv_transaction_id)
2302: AND DECODE(l_mol_ref_code,4, Decode(l_mol_ref, 'PO_LINE_LOCATION_ID' , rs.po_line_location_id,
2957: * Process the lot numbers and serial numbers corresponding to the RTI
2958: * that was just created.
2959: * Since the lots and serials are stored by receiving tables, the
2960: * changes to RTI must be reflected in RCV_LOTS_SUPPLY (lot controlled item)
2961: * and RCV_SERIALS_SUPPLY (serial controlled item).
2962: * We would be creating the interface records in MTLI and MSNI corresponding
2963: * to the inspected quantity, lot number and the serial numbers inspected
2964: * Do this only if WMS and PO patch levels are J or higher
2965: */