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.OE_DELAYED_REQUESTS_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 3547: mtl_material_transactions m

3543: ABS(SUM(u.transaction_quantity)) transaction_quantity,
3544: ABS(SUM(u.secondary_transaction_quantity)) secondary_transaction_quantity -- INVCONV
3545: FROM mtl_transaction_lot_numbers u,
3546: mtl_lot_numbers l,
3547: mtl_material_transactions m
3548: WHERE m.transaction_id = u.transaction_id
3549: AND u.inventory_item_id = l_inventory_item_id
3550: AND m.transaction_source_type_id = 2
3551: AND m.trx_source_line_id = l_reference_line_id

Line 3563: mtl_material_transactions m

3559: -- Added fix for bug 4493305
3560: CURSOR serial_numbers is
3561: SELECT DISTINCT u.serial_number
3562: FROM mtl_unit_transactions_all_v u,
3563: mtl_material_transactions m
3564: WHERE m.transaction_id = u.transaction_id
3565: AND m.INVENTORY_ITEM_ID = l_inventory_item_id
3566: AND u.serial_number = NVL(l_serial_number,u.serial_number)
3567: AND u.inventory_item_id = l_inventory_item_id

Line 3578: mtl_material_transactions m,

3574: CURSOR lot_serial_numbers is
3575: SELECT DISTINCT t.lot_number,
3576: u.serial_number
3577: FROM mtl_unit_transactions_all_v u,
3578: mtl_material_transactions m,
3579: mtl_transaction_lot_val_v t
3580: WHERE u.serial_number = NVL(l_serial_number,u.serial_number)
3581: AND u.INVENTORY_ITEM_ID = t.inventory_item_id
3582: AND t.serial_transaction_id = u.transaction_id