View: JTF_TERR_TYPE_QUAL_V

Product:	JTF - CRM Foundation
Description:	Shows Territory Type's qualifer and qualifer type usage description
Implementation/DBA Data:	APPS.JTF_TERR_TYPE_QUAL_V

View Text

SELECT JTTQ.TERR_TYPE_QUAL_ID
, JTTQ.LAST_UPDATED_BY
, JTTQ.LAST_UPDATE_DATE
, JTTQ.CREATED_BY
, JTTQ.CREATION_DATE
, JTTQ.LAST_UPDATE_LOGIN
, JSQU.QUALIFIER_TYPE_NAME
, JSQU.QUALIFIER_TYPE_DESCRIPTION
, JTTQ.QUAL_USG_ID
, JSQU.SEEDED_QUAL_NAME
, JTTQ.TERR_TYPE_ID
, JTTQ.EXCLUSIVE_USE_FLAG
, JTTQ.OVERLAP_ALLOWED_FLAG
, JTTQ.IN_USE_FLAG
, JTTQ.ORG_ID
, JTTQ.QUALIFIER_MODE
FROM JTF_TERR_TYPE_QUAL JTTQ
, JTF_SEEDED_QUAL_USGS_V JSQU
WHERE JTTQ.QUAL_USG_ID = JSQU.QUAL_USG_ID

Columns