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