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.WMS_PARAMETER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 4865: FROM mtl_system_items

4861: l_current_quantity NUMBER;
4862:
4863: CURSOR c_primary_uom IS
4864: SELECT primary_uom_code
4865: FROM mtl_system_items
4866: WHERE organization_id = p_organization_id
4867: AND inventory_item_id = p_locator_inventory_item_id;
4868:
4869: --bug 2200812: change where clause so that we always assume p_locator_id is

Line 4876: FROM mtl_system_items msi

4872: CURSOR l_tot_onhand IS
4873: SELECT onhand.inventory_item_id
4874: , NVL(SUM(onhand.oh_quantity), 0)
4875: , msi.primary_uom_code
4876: FROM mtl_system_items msi
4877: , (-- on-hand
4878: SELECT moq.organization_id organization_id
4879: , moq.inventory_item_id inventory_item_id
4880: , moq.subinventory_code subinventory_code