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.

[Home] [Help]

View: AMS_IBA_OP_TXNMY_CATEGORY_ITEM

Product:	AMS - Marketing
Description:	It provides the information about the relationship among item,category and taxonomy
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DISTINCT MSITE_SECTION.MINI_SITE_ID
, SECTION_ITEMS.SECTION_ID
, SECTION_ITEMS.INVENTORY_ITEM_ID
, 'INVENTORY_ITEM' ITEM_TYPE
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)

Columns

Name
TAXONOMY_ID
CATEGORY_ID
ITEM_ID
ITEM_TYPE