Product: | AS - Sales Foundation |
---|---|
Description: | Territories view |
Implementation/DBA Data: | APPS.AS_TERRITORIES_V |
SELECT TERR.ROWID
, TERR.TERR_ID
, TERR.LAST_UPDATE_DATE
, TERR.LAST_UPDATED_BY
, TERR.CREATION_DATE
, TERR.CREATED_BY
, TERR.LAST_UPDATE_LOGIN
, TERR.REQUEST_ID
, TERR.PROGRAM_APPLICATION_ID
, TERR.PROGRAM_ID
, TERR.PROGRAM_UPDATE_DATE
, TERR.ENABLED_FLAG
, TERR.ATTRIBUTE_CATEGORY
, TERR.ATTRIBUTE1
, TERR.ATTRIBUTE2
, TERR.ATTRIBUTE3
, TERR.ATTRIBUTE4
, TERR.ATTRIBUTE5
, TERR.ATTRIBUTE6
, TERR.ATTRIBUTE7
, TERR.ATTRIBUTE8
, TERR.ATTRIBUTE9
, TERR.ATTRIBUTE10
, TERR.ATTRIBUTE11
, TERR.ATTRIBUTE12
, TERR.ATTRIBUTE13
, TERR.ATTRIBUTE14
, TERR.ATTRIBUTE15
, TERR.NAME
, TERR.START_DATE_ACTIVE
, TERR.END_DATE_ACTIVE
, TERR.DESCRIPTION
, QUALTYPE.DESCRIPTION
FROM JTF_QUAL_TYPES QUALTYPE
, JTF_QUAL_TYPE_USGS QUALTYPEUSG
, JTF_TERR_QTYPE_USGS QTYPEUSG
, JTF_TERR TERR
WHERE TERR.TERR_ID = QTYPEUSG.TERR_ID(+)
AND QTYPEUSG.QUAL_TYPE_USG_ID = QUALTYPEUSG.QUAL_TYPE_USG_ID(+)
AND QUALTYPEUSG.SOURCE_ID = -1001
AND QUALTYPEUSG.QUAL_TYPE_ID = QUALTYPE.QUAL_TYPE_ID(+)