APPS.IBE_CATALOG_PRELOAD_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 204: FROM IBE_DSP_SECTIONS_B s, IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B i

200: IBE_UTIL.debug('IBE_CATALOG_PRELOAD_PUB.Get_Preload_Item_Ids(+)');
201: -- begin API body
202: OPEN x_item_id_csr FOR
203: SELECT DISTINCT si.INVENTORY_ITEM_ID
204: FROM IBE_DSP_SECTIONS_B s, IBE_DSP_SECTION_ITEMS si, MTL_SYSTEM_ITEMS_B i
205: WHERE s.SECTION_TYPE_CODE = 'F' AND s.SECTION_ID = si.SECTION_ID
206: AND si.INVENTORY_ITEM_ID = i.INVENTORY_ITEM_ID AND i.WEB_STATUS = 'PUBLISHED'
207: AND sysdate between s.start_date_active and nvl(s.end_date_active,sysdate)
208: AND sysdate between si.start_date_active and nvl(si.end_date_active,sysdate);