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_TRANSACTION_LOT_VAL_V

Line 3540: -- Removed the view mtl_transaction_lot_val_v in the below cursor and used the tables involved in the view for bug 5395763

3536: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3537:
3538: -- Now Absolute value of transaction_quantity is selected to fix 1610964.
3539: -- Modified query to take care of over-shipped order lines(Bug # 1643433).
3540: -- Removed the view mtl_transaction_lot_val_v in the below cursor and used the tables involved in the view for bug 5395763
3541: CURSOR lot_numbers is
3542: SELECT u.lot_number,
3543: ABS(SUM(u.transaction_quantity)) transaction_quantity,
3544: ABS(SUM(u.secondary_transaction_quantity)) secondary_transaction_quantity -- INVCONV

Line 3579: mtl_transaction_lot_val_v t

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
3583: AND t.INVENTORY_ITEM_ID = m.INVENTORY_ITEM_ID