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

Line 2062: FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES mic

2058: -- open category id cursor for return if category set id is not null
2059: IF (p_category_set_id IS NOT NULL) THEN
2060: OPEN x_category_id_csr FOR
2061: SELECT MSIV.INVENTORY_ITEM_ID, mic.CATEGORY_ID
2062: FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES mic
2063: WHERE MSIV.INVENTORY_ITEM_ID = l_itmid
2064: AND MSIV.ORGANIZATION_ID = p_organization_id
2065: AND NVL(MSIV.START_DATE_ACTIVE, SYSDATE) <= SYSDATE
2066: AND NVL(MSIV.END_DATE_ACTIVE, SYSDATE) >= SYSDATE

Line 2522: FROM MTL_SYSTEM_ITEMS_B MSIB, MTL_ITEM_CATEGORIES MIC

2518: cursor l_category_id_csr(l_itmid NUMBER,
2519: l_organization_id NUMBER,
2520: l_category_set_id NUMBER) IS
2521: select MIC.category_id
2522: FROM MTL_SYSTEM_ITEMS_B MSIB, MTL_ITEM_CATEGORIES MIC
2523: WHERE MSIB.inventory_item_id = l_itmid
2524: AND MSIB.organization_id = l_organization_id
2525: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
2526: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE