VIEW: APPS.OZF_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, JTL.END_DATE_ACTIVE END_DATE_ACTIVE, JTL.PARENT_TERRITORY_ID PARENT_TERRITORY_ID FROM OZF_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 AND JTL.HIERARCHY_NAME IS NOT NULL GROUP BY JTL.Heirarchy_id, JT.NAME, JTL.LEVEL_DEPTH, JTL.TERR_TYPE_ID, JTT.NAME, JTL.END_DATE_ACTIVE, JTL.PARENT_TERRITORY_ID

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
, JTL.END_DATE_ACTIVE END_DATE_ACTIVE
, JTL.PARENT_TERRITORY_ID PARENT_TERRITORY_ID
FROM OZF_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
AND JTL.HIERARCHY_NAME IS NOT NULL GROUP BY JTL.HEIRARCHY_ID
, JT.NAME
, JTL.LEVEL_DEPTH
, JTL.TERR_TYPE_ID
, JTT.NAME
, JTL.END_DATE_ACTIVE
, JTL.PARENT_TERRITORY_ID