[Home] [Help]
View: JTF_TERR_INHERITED_QUAL_V
Product: | JTF - CRM Foundation |
Description: | This view is used to show the qualifiers that a territory inherits from the territories above it in the territory hierarchy (if a hierarchy exists). |
Implementation/DBA Data: |
APPS.JTF_TERR_INHERITED_QUAL_V
|
View Text
SELECT J4.QUAL_USG_ID QUAL_USG_ID
, J4.SEEDED_QUAL_NAME SEEDED_QUAL_NAME
, J4.QUAL_TYPE_ID QUAL_TYPE_ID
, J4.QUALIFIER_TYPE_DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
, J3.TERR_ID TERR_ID
, J1.NAME TERR_NAME
, J2.NAME PARENT_TERR_NAME
, NULL HIERARCHY_LEVEL
FROM JTF_TERR J1
, JTF_TERR J2
, JTF_TERR_QUAL J3
, JTF_SEEDED_QUAL_USGS_V J4
WHERE J1.PARENT_TERRITORY_ID = J2.TERR_ID
AND J3.TERR_ID = J1.TERR_ID
AND J3.QUAL_USG_ID = J4.QUAL_USG_ID
AND J4.QUAL_TYPE_ID <> -1001
Columns
Name |
QUAL_USG_ID |
SEEDED_QUAL_NAME |
QUAL_TYPE_ID |
QUALIFIER_TYPE_DESCRIPTION |
TERR_ID |
TERR_NAME |
PARENT_TERR_NAME |
HIERARCHY_LEVEL |