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.

VIEW: APPS.RCV_RECEIPT_CONF_LOTSERIAL_V

Source

View Text - Preformatted


SELECT rt.shipment_header_id, rt.transaction_id, rt.source_transaction_num, mtln.lot_number, mtln.transaction_quantity lot_quantity, NULL serial_number FROM rcv_shipment_headers rsh, rcv_transactions rt, mtl_material_transactions mmt, mtl_transaction_lot_numbers mtln WHERE rsh.shipment_header_id = rt.shipment_header_id AND rt.transaction_id = mmt.rcv_transaction_id AND mmt.transaction_id = mtln.transaction_id AND ( mtln.serial_transaction_id IS NULL OR mtln.serial_transaction_id = 0 ) UNION ALL /* lot+serial controlled */ SELECT rt.shipment_header_id, rt.transaction_id, rt.source_transaction_num, mtln.lot_number, 1 lot_quantity, mut.serial_number FROM rcv_shipment_headers rsh, rcv_transactions rt, mtl_material_transactions mmt, mtl_transaction_lot_numbers mtln, mtl_unit_transactions mut WHERE rsh.shipment_header_id = rt.shipment_header_id AND rt.transaction_id = mmt.rcv_transaction_id AND mmt.transaction_id = mtln.transaction_id AND mtln.serial_transaction_id > 0 AND mtln.serial_transaction_id = mut.transaction_id UNION ALL /* serial controlled */ SELECT rt.shipment_header_id, rt.transaction_id, rt.source_transaction_num, NULL, 1 lot_quantity, mut.serial_number FROM rcv_shipment_headers rsh, rcv_transactions rt, mtl_material_transactions mmt, mtl_unit_transactions mut WHERE rsh.shipment_header_id = rt.shipment_header_id AND rt.transaction_id = mmt.rcv_transaction_id AND mut.transaction_id = mmt.transaction_id

View Text - HTML Formatted

SELECT RT.SHIPMENT_HEADER_ID
, RT.TRANSACTION_ID
, RT.SOURCE_TRANSACTION_NUM
, MTLN.LOT_NUMBER
, MTLN.TRANSACTION_QUANTITY LOT_QUANTITY
, NULL SERIAL_NUMBER
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_LOT_NUMBERS MTLN
WHERE RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND RT.TRANSACTION_ID = MMT.RCV_TRANSACTION_ID
AND MMT.TRANSACTION_ID = MTLN.TRANSACTION_ID
AND ( MTLN.SERIAL_TRANSACTION_ID IS NULL OR MTLN.SERIAL_TRANSACTION_ID = 0 ) UNION ALL /* LOT+SERIAL CONTROLLED */ SELECT RT.SHIPMENT_HEADER_ID
, RT.TRANSACTION_ID
, RT.SOURCE_TRANSACTION_NUM
, MTLN.LOT_NUMBER
, 1 LOT_QUANTITY
, MUT.SERIAL_NUMBER
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TRANSACTION_LOT_NUMBERS MTLN
, MTL_UNIT_TRANSACTIONS MUT
WHERE RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND RT.TRANSACTION_ID = MMT.RCV_TRANSACTION_ID
AND MMT.TRANSACTION_ID = MTLN.TRANSACTION_ID
AND MTLN.SERIAL_TRANSACTION_ID > 0
AND MTLN.SERIAL_TRANSACTION_ID = MUT.TRANSACTION_ID UNION ALL /* SERIAL CONTROLLED */ SELECT RT.SHIPMENT_HEADER_ID
, RT.TRANSACTION_ID
, RT.SOURCE_TRANSACTION_NUM
, NULL
, 1 LOT_QUANTITY
, MUT.SERIAL_NUMBER
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RT
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_UNIT_TRANSACTIONS MUT
WHERE RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID
AND RT.TRANSACTION_ID = MMT.RCV_TRANSACTION_ID
AND MUT.TRANSACTION_ID = MMT.TRANSACTION_ID