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.CSI_INV_DISCREPANCY_PKG dependencies on MTL_ONHAND_QUANTITIES

Line 183: , mtl_onhand_quantities moq

179: , msi.primary_uom_code primary_uom_code
180: , SUM(moq.transaction_quantity) onhand_qty
181: From
182: mtl_system_items msi
183: , mtl_onhand_quantities moq
184: Where msi.inventory_item_id = moq.inventory_item_id
185: And msi.organization_id = moq.organization_id
186: And msi.serial_number_control_code in (1,6) -- No Serial control and at SO Issue Items
187: Group By

Line 594: FROM mtl_onhand_quantities moq

590: AND msi_mast.organization_id = mp.master_organization_id)
591: -- AND nvl(msi_mast.comms_nl_trackable_flag,'N') = 'Y') --commented to query all the non-trackable items
592: AND EXISTS (
593: SELECT '1'
594: FROM mtl_onhand_quantities moq
595: WHERE moq.inventory_item_id = msn.inventory_item_id
596: AND moq.organization_id = msn.current_organization_id
597: AND moq.subinventory_code = msn.current_subinventory_code
598: AND nvl(moq.locator_id,-999) = nvl(msn.current_locator_id,-999)