[Home] [Help]
View: AMS_TERR_V
Product: | AMS - Marketing |
Description: | |
Implementation/DBA Data: |
APPS.AMS_TERR_V
|
View Text
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
FROM JTF_TERR_ALL JT
, JTF_TERR_TYPES_ALL JTT
, AMS_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
Columns
Name |
HIERARCHY_ID |
HIERARCHY_LEVEL |
HIERARCHY_LEVEL_ID |
LEVEL_DEPTH |
PARENT_ID |
NODE_ID |
NODE_VALUE |