VIEW: APPS.OTA_CONFERENCE_SERVERS_VL

Source

View Text - Preformatted

SELECT CFS.ROWID ,CFS.CONFERENCE_SERVER_ID ,CFT.NAME ,CFT.DESCRIPTION ,CFS.URL ,CFS.TYPE ,CFS.BUSINESS_GROUP_ID ,CFS.OBJECT_VERSION_NUMBER ,CFS.OWC_SITE_ID ,CFS.OWC_AUTH_TOKEN ,CFS.START_DATE_ACTIVE ,CFS.END_DATE_ACTIVE ,CFS.CREATED_BY ,CFS.CREATION_DATE ,CFS.LAST_UPDATE_DATE ,CFS.LAST_UPDATED_BY ,CFS.LAST_UPDATE_LOGIN ,CFS.ATTRIBUTE_CATEGORY ,CFS.ATTRIBUTE1 ,CFS.ATTRIBUTE2 ,CFS.ATTRIBUTE3 ,CFS.ATTRIBUTE4 ,CFS.ATTRIBUTE5 ,CFS.ATTRIBUTE6 ,CFS.ATTRIBUTE7 ,CFS.ATTRIBUTE8 ,CFS.ATTRIBUTE9 ,CFS.ATTRIBUTE10 ,CFS.ATTRIBUTE11 ,CFS.ATTRIBUTE12 ,CFS.ATTRIBUTE13 ,CFS.ATTRIBUTE14 ,CFS.ATTRIBUTE15 ,CFS.ATTRIBUTE16 ,CFS.ATTRIBUTE17 ,CFS.ATTRIBUTE18 ,CFS.ATTRIBUTE19 ,CFS.ATTRIBUTE20 FROM OTA_CONFERENCE_SERVERS_B CFS , OTA_CONFERENCE_SERVERS_TL CFT WHERE CFS.CONFERENCE_SERVER_ID = CFT.CONFERENCE_SERVER_ID AND CFT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT CFS.ROWID
, CFS.CONFERENCE_SERVER_ID
, CFT.NAME
, CFT.DESCRIPTION
, CFS.URL
, CFS.TYPE
, CFS.BUSINESS_GROUP_ID
, CFS.OBJECT_VERSION_NUMBER
, CFS.OWC_SITE_ID
, CFS.OWC_AUTH_TOKEN
, CFS.START_DATE_ACTIVE
, CFS.END_DATE_ACTIVE
, CFS.CREATED_BY
, CFS.CREATION_DATE
, CFS.LAST_UPDATE_DATE
, CFS.LAST_UPDATED_BY
, CFS.LAST_UPDATE_LOGIN
, CFS.ATTRIBUTE_CATEGORY
, CFS.ATTRIBUTE1
, CFS.ATTRIBUTE2
, CFS.ATTRIBUTE3
, CFS.ATTRIBUTE4
, CFS.ATTRIBUTE5
, CFS.ATTRIBUTE6
, CFS.ATTRIBUTE7
, CFS.ATTRIBUTE8
, CFS.ATTRIBUTE9
, CFS.ATTRIBUTE10
, CFS.ATTRIBUTE11
, CFS.ATTRIBUTE12
, CFS.ATTRIBUTE13
, CFS.ATTRIBUTE14
, CFS.ATTRIBUTE15
, CFS.ATTRIBUTE16
, CFS.ATTRIBUTE17
, CFS.ATTRIBUTE18
, CFS.ATTRIBUTE19
, CFS.ATTRIBUTE20
FROM OTA_CONFERENCE_SERVERS_B CFS
, OTA_CONFERENCE_SERVERS_TL CFT
WHERE CFS.CONFERENCE_SERVER_ID = CFT.CONFERENCE_SERVER_ID
AND CFT.LANGUAGE = USERENV('LANG')