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_DIAGNOSTICS_PKG dependencies on MTL_ONHAND_QUANTITIES

Line 8866: FROM mtl_onhand_quantities moq

8862: AND msi_mast.organization_id = mp.master_organization_id
8863: AND nvl(msi_mast.comms_nl_trackable_flag,'N') = 'Y')
8864: AND EXISTS (
8865: SELECT '1'
8866: FROM mtl_onhand_quantities moq
8867: WHERE moq.inventory_item_id = msn.inventory_item_id
8868: AND moq.organization_id = msn.current_organization_id
8869: AND moq.subinventory_code = msn.current_subinventory_code
8870: AND nvl(moq.locator_id,-999) = nvl(msn.current_locator_id,-999)

Line 13585: , mtl_onhand_quantities moq

13581: , msi.primary_uom_code primary_uom_code
13582: , sum(moq.transaction_quantity) onhand_qty
13583: from
13584: mtl_system_items msi
13585: , mtl_onhand_quantities moq
13586: where msi.inventory_item_id = moq.inventory_item_id
13587: and msi.organization_id = moq.organization_id
13588: and msi.serial_number_control_code in (1,6) -- No Serial control and at SO Issue Items
13589: group by

Line 14641: from MTL_ONHAND_QUANTITIES

14637: v_qty := 0;
14638: Begin
14639: select NVL(sum(transaction_quantity),0)
14640: into v_qty
14641: from MTL_ONHAND_QUANTITIES
14642: where inventory_item_id = inventory_item_id_mig(i)
14643: and organization_id = organization_id_mig(i)
14644: and subinventory_code = subinv_mig(i)
14645: and nvl(locator_id,-999) = nvl(locator_id_mig(i),-999)