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.CSE_ASSET_CREATION_PKG dependencies on MTL_UNIT_TRANSACTIONS

Line 302: FROM mtl_unit_transactions mut,

298: mmt.transaction_id mtl_txn_id,
299: mmt.transaction_action_id mtl_action_id,
300: mmt.transaction_source_type_id mtl_src_type_id,
301: mmt.ship_to_location_id location_id
302: FROM mtl_unit_transactions mut,
303: mtl_material_transactions mmt
304: WHERE mut.serial_number = p_serial_number
305: AND mut.inventory_item_id = p_item_id
306: AND mmt.transaction_id = mut.transaction_id

Line 314: FROM mtl_unit_transactions mut,

310: mmt.transaction_id mtl_txn_id,
311: mmt.transaction_action_id mtl_action_id,
312: mmt.transaction_source_type_id mtl_src_type_id,
313: mmt.ship_to_location_id location_id
314: FROM mtl_unit_transactions mut,
315: mtl_transaction_lot_numbers mtln,
316: mtl_material_transactions mmt
317: WHERE mut.serial_number = p_serial_number
318: AND mut.inventory_item_id = p_item_id

Line 2083: FROM mtl_unit_transactions mut

2079: CURSOR srl_cur(p_mtl_txn_id IN number) IS
2080: SELECT mut.serial_number serial_number,
2081: to_char(null) lot_number,
2082: 1 quantity
2083: FROM mtl_unit_transactions mut
2084: WHERE mut.transaction_id = p_mtl_txn_id
2085: UNION
2086: SELECT mut.serial_number serial_number,
2087: mtln.lot_number lot_number,

Line 2090: mtl_unit_transactions mut

2086: SELECT mut.serial_number serial_number,
2087: mtln.lot_number lot_number,
2088: 1 quantity
2089: FROM mtl_transaction_lot_numbers mtln,
2090: mtl_unit_transactions mut
2091: WHERE mtln.transaction_id = p_mtl_txn_id
2092: AND mut.transaction_id = mtln.serial_transaction_id;
2093:
2094: CURSOR nsrl_inst_cur(p_csi_txn_id IN number, p_inventory_item_id IN number) IS