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