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_UNIT_TRANSACTIONS_ALL_V

Line 3319: FROM mtl_unit_transactions_all_v u,

3315:
3316: -- Added fix for bug 4493305
3317: CURSOR serial_numbers is
3318: SELECT DISTINCT u.serial_number
3319: FROM mtl_unit_transactions_all_v u,
3320: mtl_material_transactions m
3321: WHERE m.transaction_id = u.transaction_id
3322: AND m.INVENTORY_ITEM_ID = l_inventory_item_id
3323: AND u.serial_number = NVL(l_serial_number,u.serial_number)

Line 3334: FROM mtl_unit_transactions_all_v u,

3330:
3331: CURSOR lot_serial_numbers is
3332: SELECT DISTINCT t.lot_number,
3333: u.serial_number
3334: FROM mtl_unit_transactions_all_v u,
3335: mtl_material_transactions m,
3336: mtl_transaction_lot_val_v t
3337: WHERE u.serial_number = NVL(l_serial_number,u.serial_number)
3338: AND u.INVENTORY_ITEM_ID = t.inventory_item_id