[Home] [Help]
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
Name |
TERR_TYPE_QUAL_ID |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_LOGIN |
QUALIFIER_TYPE |
QUALIFIER_TYPE_DESCRIPTION |
QUAL_USG_ID |
QUALIFIER_NAME |
TERR_TYPE_ID |
EXCLUSIVE_USE_FLAG |
OVERLAP_ALLOWED_FLAG |
IN_USE_FLAG |
ORG_ID |
QUALIFIER_MODE |