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 304: FROM mtl_unit_transactions mut,

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

Line 316: FROM mtl_unit_transactions mut,

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

Line 2239: FROM mtl_unit_transactions mut

2235: CURSOR srl_cur(p_mtl_txn_id IN number) IS
2236: SELECT mut.serial_number serial_number,
2237: to_char(null) lot_number,
2238: 1 quantity
2239: FROM mtl_unit_transactions mut
2240: WHERE mut.transaction_id = p_mtl_txn_id
2241: UNION
2242: SELECT mut.serial_number serial_number,
2243: mtln.lot_number lot_number,

Line 2246: mtl_unit_transactions mut

2242: SELECT mut.serial_number serial_number,
2243: mtln.lot_number lot_number,
2244: 1 quantity
2245: FROM mtl_transaction_lot_numbers mtln,
2246: mtl_unit_transactions mut
2247: WHERE mtln.transaction_id = p_mtl_txn_id
2248: AND mut.transaction_id = mtln.serial_transaction_id;
2249:
2250: CURSOR nsrl_inst_cur(p_csi_txn_id IN number, p_inventory_item_id IN number) IS