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 3297: -- Removed the view mtl_transaction_lot_val_v in the below cursor and used the tables involved in the view for bug 5395763

3293: OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3294:
3295: -- Now Absolute value of transaction_quantity is selected to fix 1610964.
3296: -- Modified query to take care of over-shipped order lines(Bug # 1643433).
3297: -- Removed the view mtl_transaction_lot_val_v in the below cursor and used the tables involved in the view for bug 5395763
3298: CURSOR lot_numbers is
3299: SELECT u.lot_number,
3300: ABS(SUM(u.transaction_quantity)) transaction_quantity,
3301: ABS(SUM(u.secondary_transaction_quantity)) secondary_transaction_quantity -- INVCONV

Line 3336: mtl_transaction_lot_val_v t

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