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_SYSTEM_ITEMS_B

Line 84: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B MSIB ' ||

80: L_MSIB_STMT CONSTANT VARCHAR2(2000) :=
81: 'SELECT si.inventory_item_id, si.organization_id, si.usage_name, MSIB.web_status, ' ||
82: ' si.start_date_active assoc_start_dt, si.end_date_active assoc_end_date, ' ||
83: ' MSIB.start_date_active start_dt, MSIB.end_date_active end_dt ' ||
84: 'FROM IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B MSIB ' ||
85: 'WHERE si.section_id = :sect_id ' ||
86: 'AND si.inventory_item_id = MSIB.inventory_item_id ' ||
87: 'AND si.organization_id = MSIB.organization_id ' ||
88: 'AND (MSIB.WEB_STATUS = ''PUBLISHED'' OR MSIB.WEB_STATUS = ''UNPUBLISHED'') ' ||

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