[Home] [Help]
View: AMS_TERR_VALUES_V
View Text
SELECT DISTINCT JTL.HEIRARCHY_ID HIERARCHY_ID
, JTT.NAME HIERARCHY_LEVEL
, JTL.LEVEL_DEPTH LEVEL_DEPTH
, JTL.TERRITORY_ID PARENT_ID
, JT.NAME PARENT_NAME
, JTV.LOW_VALUE_CHAR_ID LEAF_NODE_ID
, JTV.LOW_VALUE_CHAR LEAF_NODE_VALUE
FROM JTF_TERR_VALUES_ALL JTV
, JTF_TERR_ALL JT
, JTF_TERR_TYPES_ALL JTT
, AMS_TERR_LEVELS_ALL JTL
, JTF_TERR_QUAL_ALL JTQ
WHERE JTT.TERR_TYPE_ID = JT.TERRITORY_TYPE_ID
AND JTL.TERR_TYPE_ID = JTT.TERR_TYPE_ID
AND JT.TERR_ID = JTQ.TERR_ID
AND JTQ.TERR_QUAL_ID = JTV.TERR_QUAL_ID
AND JTL.TERRITORY_ID = JT.TERR_ID
Columns
Name |
HEIRARCHY_ID |
HIERARCHY_LEVEL |
LEVEL_DEPTH |
PARENT_ID |
PARENT_NAME |
LEAF_NODE_ID |
LEAF_NODE_VALUE |