APPS.IBE_CATALOG_PRELOAD_PUB dependencies on IBE_DSP_SECTION_ITEMS

Line 143: -- IBE_DSP_SECTION_ITEMS). Current implementation returns inventory

139: -- Function : Returns ref cursor containing inventory_item_ids of items to be
140: -- preloaded into the cache. Item IDs should come from
141: -- MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID or a table with a foreign
142: -- key to MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID (such as
143: -- IBE_DSP_SECTION_ITEMS). Current implementation returns inventory
144: -- item ids of all items in featured sections.
145: --
146: -- Pre-reqs : None.
147: -- Parameters :

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);