View: AMS_TERR_HIER_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_TERR_HIER_V

View Text

SELECT DISTINCT 'MARKET' DIMENSION
, JTL.HEIRARCHY_ID HIERARCHY_ID
, JT.NAME HIERARCHY_NAME
, JTL.TERR_TYPE_ID HIERARCHY_LEVEL_ID
, JTT.NAME HIERARCHY_LEVEL
, JTL.LEVEL_DEPTH LEVEL_DEPTH
FROM AMS_TERR_LEVELS_ALL JTL
, JTF_TERR_TYPES_ALL JTT
, JTF_TERR_ALL JT
WHERE JTL.TERR_TYPE_ID = JTT.TERR_TYPE_ID
AND JT.TERR_ID = JTL.HEIRARCHY_ID GROUP BY JTL.HEIRARCHY_ID
, JT.NAME
, JTL.LEVEL_DEPTH
, JTL.TERR_TYPE_ID
, JTT.NAME

Columns