[Home] [Help]
View: JTF_TYPE_QTYPE_USGS_V
Product: | JTF - CRM Foundation |
Description: | Shows Territory Type's qualifer type usage description |
Implementation/DBA Data: |
APPS.JTF_TYPE_QTYPE_USGS_V
|
View Text
SELECT JQTU.TYPE_QTYPE_USG_ID
, JQTU.LAST_UPDATED_BY
, JQTU.LAST_UPDATE_DATE
, JQTU.CREATED_BY
, JQTU.CREATION_DATE
, JQTU.LAST_UPDATE_LOGIN
, JQTU.TERR_TYPE_ID
, JQTU.QUAL_TYPE_USG_ID
, JQTU.ORG_ID
, JQT.NAME
, JQT.DESCRIPTION
, JQT.QUAL_TYPE_ID
FROM JTF_TYPE_QTYPE_USGS JQTU
, JTF_QUAL_TYPE_USGS JQUT
, JTF_QUAL_TYPES JQT
WHERE JQTU.QUAL_TYPE_USG_ID = JQUT.QUAL_TYPE_USG_ID
AND JQUT.QUAL_TYPE_ID = JQT.QUAL_TYPE_ID
Columns
Name |
TYPE_QTYPE_USG_ID |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_LOGIN |
TERR_TYPE_ID |
QUAL_TYPE_USG_ID |
ORG_ID |
QUALIFIER_TYPE |
QUAL_TYPE_DESCRIPTION |
QUAL_TYPE_ID |