VIEW: APPS.CSD_BULLETINS_VL

Source

View Text - Preformatted

SELECT csbb.rowid , csbb.bulletin_id , csbt.name , csbt.description , csbb.bulletin_type_code , csbb.active_from , csbb.active_to , csbb.published_flag , csbb.escalation_code , csbb.mandatory_flag , csbb.frequency_code , csbb.wf_item_type , csbb.wf_process_name , csbb.created_by , csbb.creation_date , csbb.last_updated_by , csbb.last_update_date , csbb.last_update_login , csbb.object_version_number , csbb.attribute_category , csbb.attribute1 , csbb.attribute2 , csbb.attribute3 , csbb.attribute4 , csbb.attribute5 , csbb.attribute6 , csbb.attribute7 , csbb.attribute8 , csbb.attribute9 , csbb.attribute10 , csbb.attribute11 , csbb.attribute12 , csbb.attribute13 , csbb.attribute14 , csbb.attribute15 FROM csd_bulletins_b csbb , csd_bulletins_tl csbt WHERE csbb.bulletin_id = csbt.bulletin_id and csbt.language = userenv('LANG')

View Text - HTML Formatted

SELECT CSBB.ROWID
, CSBB.BULLETIN_ID
, CSBT.NAME
, CSBT.DESCRIPTION
, CSBB.BULLETIN_TYPE_CODE
, CSBB.ACTIVE_FROM
, CSBB.ACTIVE_TO
, CSBB.PUBLISHED_FLAG
, CSBB.ESCALATION_CODE
, CSBB.MANDATORY_FLAG
, CSBB.FREQUENCY_CODE
, CSBB.WF_ITEM_TYPE
, CSBB.WF_PROCESS_NAME
, CSBB.CREATED_BY
, CSBB.CREATION_DATE
, CSBB.LAST_UPDATED_BY
, CSBB.LAST_UPDATE_DATE
, CSBB.LAST_UPDATE_LOGIN
, CSBB.OBJECT_VERSION_NUMBER
, CSBB.ATTRIBUTE_CATEGORY
, CSBB.ATTRIBUTE1
, CSBB.ATTRIBUTE2
, CSBB.ATTRIBUTE3
, CSBB.ATTRIBUTE4
, CSBB.ATTRIBUTE5
, CSBB.ATTRIBUTE6
, CSBB.ATTRIBUTE7
, CSBB.ATTRIBUTE8
, CSBB.ATTRIBUTE9
, CSBB.ATTRIBUTE10
, CSBB.ATTRIBUTE11
, CSBB.ATTRIBUTE12
, CSBB.ATTRIBUTE13
, CSBB.ATTRIBUTE14
, CSBB.ATTRIBUTE15
FROM CSD_BULLETINS_B CSBB
, CSD_BULLETINS_TL CSBT
WHERE CSBB.BULLETIN_ID = CSBT.BULLETIN_ID
AND CSBT.LANGUAGE = USERENV('LANG')