VIEW: APPS.AMS_TERR_HIER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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