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 3304: mtl_material_transactions m

3300: ABS(SUM(u.transaction_quantity)) transaction_quantity,
3301: ABS(SUM(u.secondary_transaction_quantity)) secondary_transaction_quantity -- INVCONV
3302: FROM mtl_transaction_lot_numbers u,
3303: mtl_lot_numbers l,
3304: mtl_material_transactions m
3305: WHERE m.transaction_id = u.transaction_id
3306: AND u.inventory_item_id = l_inventory_item_id
3307: AND m.transaction_source_type_id = 2
3308: AND m.trx_source_line_id = l_reference_line_id

Line 3320: mtl_material_transactions m

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)
3324: AND u.inventory_item_id = l_inventory_item_id

Line 3335: mtl_material_transactions m,

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
3339: AND t.serial_transaction_id = u.transaction_id