eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_STD_INSPECT_APIS dependencies on RCV_LOTS_SUPPLY

Line 114: * update the receiving onhand for the lots and serials (RCV_LOTS_SUPPLY and

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: */
117: PROCEDURE process_lot_serial_intf(
118: x_return_status OUT NOCOPY VARCHAR2

Line 1161: rcv_lots_supply rls,

1157: rs.secondary_unit_of_measure --OPM Convergence
1158: ,
1159: rls.quantity quantity
1160: FROM rcv_supply rs,
1161: rcv_lots_supply rls,
1162: rcv_transactions rt,
1163: rcv_shipment_headers rsh
1164: WHERE rs.rcv_transaction_id = rt.transaction_id
1165: AND rsh.shipment_header_id = rs.shipment_header_id

Line 2272: FROM rcv_supply rs, rcv_lots_supply rls, rcv_transactions rt, rcv_shipment_headers rsh

2268: , rsh.receipt_source_code
2269: , rs.unit_of_measure
2270: , rs.secondary_unit_of_measure --OPM Convergence
2271: , Sum(rls.quantity) quantity --Bug 14117094
2272: FROM rcv_supply rs, rcv_lots_supply rls, rcv_transactions rt, rcv_shipment_headers rsh
2273: WHERE rs.rcv_transaction_id = rt.transaction_id
2274: AND rsh.shipment_header_id = rs.shipment_header_id
2275: AND rs.supply_type_code = 'RECEIVING'
2276: AND rt.transaction_type <> 'UNORDERED'

Line 2960: * changes to RTI must be reflected in RCV_LOTS_SUPPLY (lot controlled item)

2956: /* FP-J Lot/Serial Support Enhancement
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