It provides the items candidate for Personalization
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT SECTION_ITEMS.INVENTORY_ITEM_ID , 'INVENTORY_ITEM' , 'DUMMY ITEM NAME' , 'DUMMY ITEM DESCRIPTION' FROM IBE_DSP_MSITE_SCT_ITEMS MSITE_SECTION , IBE_DSP_SECTION_ITEMS SECTION_ITEMS WHERE MSITE_SECTION.SECTION_ITEM_ID=SECTION_ITEMS.SECTION_ITEM_ID AND (MSITE_SECTION.START_DATE_ACTIVE <= SYSDATE) AND (SECTION_ITEMS.START_DATE_ACTIVE <= SYSDATE ) AND (SECTION_ITEMS.END_DATE_ACTIVE IS NULL OR SECTION_ITEMS.END_DATE_ACTIVE >= SYSDATE) AND (MSITE_SECTION.END_DATE_ACTIVE IS NULL OR MSITE_SECTION.END_DATE_ACTIVE >= SYSDATE)