VIEW: APPS.AS_TERRITORIES_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)