Product: | JTF - CRM Foundation |
---|---|
Description: | Shows Territory Type usage by joining the JTF_TERR_TYPE_USGS table |
Implementation/DBA Data: | APPS.JTF_TERR_TYPES_V |
SELECT JTT.TERR_TYPE_ID
, JTTU.TERR_TYPE_USG_ID
, JTT.LAST_UPDATED_BY
, JTT.LAST_UPDATE_DATE
, JTT.CREATED_BY
, JTT.CREATION_DATE
, JTT.LAST_UPDATE_LOGIN
, JTT.APPLICATION_SHORT_NAME
, JTT.NAME
, JS.SOURCE_ID
, JS.LOOKUP_CODE
, JS.DESCRIPTION
, JTT.ENABLED_FLAG
, JTT.DESCRIPTION
, JTT.START_DATE_ACTIVE
, JTT.END_DATE_ACTIVE
, FND_ACCESS_CONTROL_UTIL.GET_ORG_NAME(JTT.ORG_ID)
, JTT.ORG_ID
, JTT.ATTRIBUTE_CATEGORY
, JTT.ATTRIBUTE1
, JTT.ATTRIBUTE2
, JTT.ATTRIBUTE3
, JTT.ATTRIBUTE4
, JTT.ATTRIBUTE5
, JTT.ATTRIBUTE6
, JTT.ATTRIBUTE7
, JTT.ATTRIBUTE8
, JTT.ATTRIBUTE9
, JTT.ATTRIBUTE10
, JTT.ATTRIBUTE11
, JTT.ATTRIBUTE12
, JTT.ATTRIBUTE13
, JTT.ATTRIBUTE14
, JTT.ATTRIBUTE15
FROM JTF_TERR_TYPES JTT
, JTF_TERR_TYPE_USGS JTTU
, JTF_SOURCES_ALL JS
WHERE JTT.TERR_TYPE_ID = JTTU.TERR_TYPE_ID
AND JTTU.SOURCE_ID = JS.SOURCE_ID