VIEW: APPS.JTF_TERR_TRANS_DENORM_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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