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 2063: FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES mic

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

Line 2523: FROM MTL_SYSTEM_ITEMS_B MSIB, MTL_ITEM_CATEGORIES MIC

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