VIEW: APPS.JTF_TERR_TYPES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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