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_TAXONOMY_CATEGORY_V

Product:	AMS - Marketing
Description:	It provides information about categories that are part of different taxonomies
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT (MSS.LEVEL_NUMBER- AMS_OP_UTILITY_PVT.GET_ROOT_SECTION_LEVEL(MSITE_SEC.MINI_SITE_ID)) LEVEL_NUMBER
, MSITE_SEC.MINI_SITE_ID
, MSITE_SEC.PARENT_SECTION_ID
, MSITE_SEC.CHILD_SECTION_ID
FROM IBE_DSP_MSITE_SCT_SECTS MSITE_SEC
, IBE_DSP_MSITE_SCT_SECTS MSS
WHERE MSITE_SEC.PARENT_SECTION_ID IS NOT NULL
AND (MSITE_SEC.START_DATE_ACTIVE <= SYSDATE)
AND (MSITE_SEC.END_DATE_ACTIVE IS NULL OR MSITE_SEC.END_DATE_ACTIVE >= SYSDATE)
AND MSITE_SEC.CHILD_SECTION_ID=MSS.CHILD_SECTION_ID
AND MSS.MINI_SITE_ID = (SELECT MS.MSITE_ID
FROM IBE_MSITES_B MS
WHERE MS.MASTER_MSITE_FLAG = 'Y')
AND (MSS.LEVEL_NUMBER-AMS_OP_UTILITY_PVT. GET_ROOT_SECTION_LEVEL(MSITE_SEC.MINI_SITE_ID)) <> 0

Columns

Name
TAXONOMY_LEVEL
TAXONOMY_ID
PARENT_ID
CHILD_ID