View: JTF_TERR_TRANS_DENORM_V

Product:	JTF - CRM Foundation
Description:	This shows the denormalised territory transactions horizontally.
Implementation/DBA Data:	APPS.JTF_TERR_TRANS_DENORM_V

View Text

SELECT J1.TERR_ID
, J3.SOURCE_ID
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1002
, 'Y'
, NULL)) ACCOUNT
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1003
, 'Y'
, NULL)) LEAD
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1004
, 'Y'
, NULL)) OPPOR
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1005
, 'Y'
, NULL)) SERV_REQ
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1006
, 'Y'
, NULL)) TASK
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1007
, 'Y'
, NULL)) TRD_ACCT
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1008
, 'Y'
, NULL)) TRD_CLSS
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1009
, 'Y'
, NULL)) SRV_TASK
, MIN(DECODE(J3.QUAL_TYPE_ID
, -1010
, 'Y'
, NULL)) DEF_MGMT
FROM JTF_TERR_QTYPE_USGS J1
, JTF_TERR J2
, JTF_QUAL_TYPE_USGS J3
WHERE J1.TERR_ID = J2.TERR_ID
AND J1.QUAL_TYPE_USG_ID = J3.QUAL_TYPE_USG_ID GROUP BY J1.TERR_ID
, J3.SOURCE_ID

Columns