[Home] [Help]
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
Name |
TERR_ID |
SOURCE_ID |
ACCOUNT |
LEAD |
OPPOR |
SERV_REQ |
TASK |
TRD_ACCT |
TRD_CLSS |
SRV_TASK |
DEF_MGMT |