Oracle iStore - 'How To?' Part 2

Q6. Query to get the Item details associated to a Section.

Select unique (description),
ORDERABLE_ON_WEB_FLAG,
WEB_STATUS
From MTL_SYSTEM_ITEMS_B where inventory_item_id in (select inventory_item_id from IBE_DSP_SECTION_ITEMS where section_id = &Section_Id)

Q7. The Item is not appearing in the iStore UI, What are the parameters to be checked?

Check the Item Web Status and Orderable on web flag in the Item master for the Item that is not appearing in the iStore UI.The Web Status should be “Published” and The Orderable on the Web flag should be enabled.

Q8. Query to get all the Items listed in the minisite.

Select distinct (inventory_item_id), description from mtl_system_items_b
Where inventory_item_id in (select mini_site_section_item_id
From IBE_DSP_MSITE_SCT_ITEMS where mini_site_id = &Minisite_Id);

Q9. Query to get all the Items assigned to a particular section

Select distinct (inventory_item_id), description from mtl_system_items_b
Where inventory_item_id in (select inventory_item_id
From IBE_DSP_SECTION_ITEMS where section_id = 10022);

Q10. How to clear client Side cookies?

Browser: IE (Internet Explorer)

In the Menu, navigate to Tools --> Internet Options --> Click on Delete Cookies and Delete Files options.


Browser: Mozilla Firefox

In the Menu, navigate to Tools --> Options --> Privacy --> Cookies -->Show Cookies --> Remove All Cookies
Tools --> Options -->Privacy --> Private Data --> Clear Now