View: JTF_TERR_TRANSACTIONS_V

Product:	JTF - CRM Foundation
Description:	This view shows the transactions that are assigned to a territory.
Implementation/DBA Data:	APPS.JTF_TERR_TRANSACTIONS_V

View Text

SELECT JTQU.ROWID ROW_ID
, JTQU.TERR_QTYPE_USG_ID TERR_QTYPE_USG_ID
, JTQU.LAST_UPDATE_DATE LAST_UPDATE_DATE
, JTQU.LAST_UPDATED_BY LAST_UPDATED_BY
, JTQU.CREATION_DATE CREATION_DATE
, JTQU.CREATED_BY CREATED_BY
, JTQU.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JTQU.TERR_ID TERR_ID
, JTQU.QUAL_TYPE_USG_ID QUAL_TYPE_USG_ID
, JTQU.ORG_ID ORG_ID
, JQTU.SOURCE_ID SOURCE_ID
, JQT.QUAL_TYPE_ID QUAL_TYPE_ID
, JQT.NAME QUALIFIER_TYPE_NAME
, JQT.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
FROM JTF_TERR_QTYPE_USGS JTQU
, JTF_QUAL_TYPE_USGS JQTU
, JTF_QUAL_TYPES JQT
WHERE JTQU.QUAL_TYPE_USG_ID = JQTU.QUAL_TYPE_USG_ID
AND JQTU.QUAL_TYPE_ID = JQT.QUAL_TYPE_ID

Columns