Product: | JTF - CRM Foundation |
---|---|
Description: | Shows the transaction types ( Qualifier types) associated with a Territory Type |
Implementation/DBA Data: | APPS.JTF_TYPE_TRANSACTIONS_V |
SELECT J1.ROWID ROW_ID
, J1.TYPE_QTYPE_USG_ID TYPE_QTYPE_USG_ID
, J1.LAST_UPDATED_BY LAST_UPDATED_BY
, J1.LAST_UPDATE_DATE LAST_UPDATE_DATE
, J1.CREATED_BY CREATED_BY
, J1.CREATION_DATE CREATION_DATE
, J1.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, J1.TERR_TYPE_ID TERR_TYPE_ID
, J1.QUAL_TYPE_USG_ID QUAL_TYPE_USG_ID
, J1.ORG_ID ORG_ID
, J2.SOURCE_ID SOURCE_ID
, J3.QUAL_TYPE_ID QUAL_TYPE_ID
, J3.NAME QUALIFIER_TYPE_NAME
, J3.DESCRIPTION QUALIFIER_TYPE_DESCRIPTION
FROM JTF_TYPE_QTYPE_USGS J1
, JTF_QUAL_TYPE_USGS J2
, JTF_QUAL_TYPES J3
WHERE J1.QUAL_TYPE_USG_ID = J2.QUAL_TYPE_USG_ID
AND J2.QUAL_TYPE_ID = J3.QUAL_TYPE_ID