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_TXN_VALIDATIONS dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 2081: mtl_transaction_lots_temp mtlt,

2077: begin
2078: select 1
2079: into l_cnt
2080: from mtl_serial_numbers_temp msnt,
2081: mtl_transaction_lots_temp mtlt,
2082: mtl_material_transactions_temp mmtt
2083: where mmtt.organization_id = p_org_id
2084: and mmtt.inventory_item_id = l_inventory_item_id
2085: and mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)

Line 2212: mtl_transaction_lots_temp mtlt,

2208:
2209: select 1
2210: into l_cnt
2211: from mtl_serial_numbers_temp msnt,
2212: mtl_transaction_lots_temp mtlt,
2213: mtl_material_transactions_temp mmtt
2214: where mmtt.organization_id = p_org_id
2215: and mmtt.inventory_item_id = p_item_id
2216: and mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)

Line 3612: from mtl_transaction_lots_temp mtlt,

3608: else
3609: begin
3610: select 1
3611: into l_serial_exist
3612: from mtl_transaction_lots_temp mtlt,
3613: mtl_serial_numbers_temp msnt
3614: where mtlt.transaction_temp_id = l_transaction_temp_id
3615: and mtlt.lot_number = p_lot
3616: and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id