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.OZF_SD_REQUEST_PUB dependencies on MTL_ITEM_CATEGORIES

Line 408: FROM mtl_item_categories

404: ,p_uom_code IN VARCHAR2) IS
405: SELECT DISTINCT a.uom_code
406: FROM mtl_item_uoms_view a,
407: (SELECT inventory_item_id
408: FROM mtl_item_categories
409: WHERE category_id IN(SELECT child_id
410: FROM eni_denorm_hierarchies
411: WHERE parent_id = p_parent_id
412: AND organization_id = p_org_id)) b

Line 431: FROM mtl_item_categories

427: WHERE MTLUOM2.uom_code = MTLUCV.uom_code
428: AND MTLITM1.organization_id = p_org_id
429: AND MTLITM1.inventory_item_id IN
430: (SELECT inventory_item_id
431: FROM mtl_item_categories
432: WHERE category_id = p_category_id
433: AND organization_id = p_org_id
434: )
435: AND NVL( MTLUCV.DISABLE_DATE, TRUNC(SYSDATE) +1 ) > TRUNC(SYSDATE)