VIEW: APPS.OTA_ANNOUNCEMENTS_VL

Source

View Text - Preformatted

SELECT OAN.ROWID ,OAN.ANNOUNCEMENT_ID ,OAL.ANNOUNCEMENT_TITLE ,OAN.BUSINESS_GROUP_ID ,OAL.ANNOUNCEMENT_BODY ,OAN.OBJECT_VERSION_NUMBER ,OAN.START_DATE_ACTIVE ,OAN.END_DATE_ACTIVE ,OAN.OWNER_ID ,OAN.CREATED_BY ,OAN.CREATION_DATE ,OAN.LAST_UPDATE_DATE ,OAN.LAST_UPDATED_BY ,OAN.LAST_UPDATE_LOGIN ,OAN.ATTRIBUTE_CATEGORY ,OAN.ATTRIBUTE1 ,OAN.ATTRIBUTE2 ,OAN.ATTRIBUTE3 ,OAN.ATTRIBUTE4 ,OAN.ATTRIBUTE5 ,OAN.ATTRIBUTE6 ,OAN.ATTRIBUTE7 ,OAN.ATTRIBUTE8 ,OAN.ATTRIBUTE9 ,OAN.ATTRIBUTE10 ,OAN.ATTRIBUTE11 ,OAN.ATTRIBUTE12 ,OAN.ATTRIBUTE13 ,OAN.ATTRIBUTE14 ,OAN.ATTRIBUTE15 ,OAN.ATTRIBUTE16 ,OAN.ATTRIBUTE17 ,OAN.ATTRIBUTE18 ,OAN.ATTRIBUTE19 ,OAN.ATTRIBUTE20 FROM OTA_ANNOUNCEMENTS OAN , OTA_ANNOUNCEMENTS_TL OAL WHERE OAN.ANNOUNCEMENT_ID= OAL.ANNOUNCEMENT_ID AND OAL.LANGUAGE= USERENV('LANG')

View Text - HTML Formatted

SELECT OAN.ROWID
, OAN.ANNOUNCEMENT_ID
, OAL.ANNOUNCEMENT_TITLE
, OAN.BUSINESS_GROUP_ID
, OAL.ANNOUNCEMENT_BODY
, OAN.OBJECT_VERSION_NUMBER
, OAN.START_DATE_ACTIVE
, OAN.END_DATE_ACTIVE
, OAN.OWNER_ID
, OAN.CREATED_BY
, OAN.CREATION_DATE
, OAN.LAST_UPDATE_DATE
, OAN.LAST_UPDATED_BY
, OAN.LAST_UPDATE_LOGIN
, OAN.ATTRIBUTE_CATEGORY
, OAN.ATTRIBUTE1
, OAN.ATTRIBUTE2
, OAN.ATTRIBUTE3
, OAN.ATTRIBUTE4
, OAN.ATTRIBUTE5
, OAN.ATTRIBUTE6
, OAN.ATTRIBUTE7
, OAN.ATTRIBUTE8
, OAN.ATTRIBUTE9
, OAN.ATTRIBUTE10
, OAN.ATTRIBUTE11
, OAN.ATTRIBUTE12
, OAN.ATTRIBUTE13
, OAN.ATTRIBUTE14
, OAN.ATTRIBUTE15
, OAN.ATTRIBUTE16
, OAN.ATTRIBUTE17
, OAN.ATTRIBUTE18
, OAN.ATTRIBUTE19
, OAN.ATTRIBUTE20
FROM OTA_ANNOUNCEMENTS OAN
, OTA_ANNOUNCEMENTS_TL OAL
WHERE OAN.ANNOUNCEMENT_ID= OAL.ANNOUNCEMENT_ID
AND OAL.LANGUAGE= USERENV('LANG')