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.MTL_INV_UTIL_GRP dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 264: FROM MTL_ONHAND_QUANTITIES_DETAIL

260: subinv IN VARCHAR2, rev IN VARCHAR2, loc IN NUMBER,
261: lot IN VARCHAR2, cost IN NUMBER) IS
262: SELECT
263: NVL(sum(primary_transaction_quantity), 0) SYSTEM_QUANTITY
264: FROM MTL_ONHAND_QUANTITIES_DETAIL
265: WHERE inventory_item_id = itemid
266: AND organization_id = org
267: AND subinventory_code = subinv
268: AND NVL(lot_number, '@') = NVL(lot, '@')

Line 535: FROM mtl_onhand_quantities_detail

531: )
532: IS
533: SELECT NVL (SUM (primary_transaction_quantity), 0) system_quantity,
534: NVL (SUM (secondary_transaction_quantity), 0) secondary_system_quantity
535: FROM mtl_onhand_quantities_detail
536: WHERE inventory_item_id = itemid
537: AND organization_id = org
538: AND subinventory_code = subinv
539: AND NVL (lot_number, '@') = NVL (lot, '@')