VIEW: APPS.OZF_TERR_V

Source

View Text - Preformatted

SELECT DISTINCT JTL.heirarchy_id HIERARCHY_ID, JTT.NAME HIERARCHY_LEVEL, JTT.terr_type_id HIERARCHY_LEVEL_ID, JTL.LEVEL_DEPTH LEVEL_DEPTH, JTL.PARENT_TERRITORY_ID PARENT_ID, JTL.TERRITORY_ID NODE_ID, JT.NAME NODE_VALUE, JT.end_date_active END_DATE_ACTIVE FROM JTF_TERR_ALL JT, JTF_TERR_TYPES_ALL JTT, OZF_TERR_LEVELS_ALL JTL WHERE JTT.terr_TYPE_ID = JT.TERRITORY_TYPE_ID AND JTL.parent_territory_id = JT.parent_territory_id AND JTL.territory_id = JT.terr_id AND JTL.terr_type_ID = JTT.TERR_TYPE_ID ORDER BY level_depth

View Text - HTML Formatted

SELECT DISTINCT JTL.HEIRARCHY_ID HIERARCHY_ID
, JTT.NAME HIERARCHY_LEVEL
, JTT.TERR_TYPE_ID HIERARCHY_LEVEL_ID
, JTL.LEVEL_DEPTH LEVEL_DEPTH
, JTL.PARENT_TERRITORY_ID PARENT_ID
, JTL.TERRITORY_ID NODE_ID
, JT.NAME NODE_VALUE
, JT.END_DATE_ACTIVE END_DATE_ACTIVE
FROM JTF_TERR_ALL JT
, JTF_TERR_TYPES_ALL JTT
, OZF_TERR_LEVELS_ALL JTL
WHERE JTT.TERR_TYPE_ID = JT.TERRITORY_TYPE_ID
AND JTL.PARENT_TERRITORY_ID = JT.PARENT_TERRITORY_ID
AND JTL.TERRITORY_ID = JT.TERR_ID
AND JTL.TERR_TYPE_ID = JTT.TERR_TYPE_ID ORDER BY LEVEL_DEPTH