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.RCV_DCP_PVT dependencies on MTL_SERIAL_NUMBERS

Line 757: FROM mtl_serial_numbers msn,

753: , rti.transaction_type
754: , msn.last_update_date
755: , msn.current_status
756: , wlpn.lpn_context
757: FROM mtl_serial_numbers msn,
758: rcv_transactions_interface rti,
759: mtl_serial_numbers_temp msnt,
760: wms_license_plate_numbers wlpn
761: WHERE rti.interface_transaction_id = p_interface_transaction_id

Line 759: mtl_serial_numbers_temp msnt,

755: , msn.current_status
756: , wlpn.lpn_context
757: FROM mtl_serial_numbers msn,
758: rcv_transactions_interface rti,
759: mtl_serial_numbers_temp msnt,
760: wms_license_plate_numbers wlpn
761: WHERE rti.interface_transaction_id = p_interface_transaction_id
762: AND msnt.product_code = 'RCV'
763: AND msnt.product_transaction_id = rti.interface_transaction_id

Line 779: FROM mtl_serial_numbers msn,

775: , rt.transaction_type
776: , msn.last_update_date
777: , msn.current_status
778: , wlpn.lpn_context
779: FROM mtl_serial_numbers msn,
780: rcv_transactions rt,
781: mtl_unit_transactions mut,
782: wms_license_plate_numbers wlpn
783: WHERE rt.interface_transaction_id = p_interface_transaction_id