VIEW: APPS.CSD_BULLETINS_V

Source

View Text - Preformatted

SELECT csbb.rowid , csbb.bulletin_id , csbt.name , csbt.description , csbb.bulletin_type_code , btype_fnd.meaning , btype_fnd.description , csbb.active_from , csbb.active_to , csbb.published_flag , csbb.escalation_code , etype_fnd.meaning , etype_fnd.description , csbb.mandatory_flag , csbb.frequency_code , freq_fnd.meaning , freq_fnd.description , csbb.wf_item_type , csbb.wf_process_name , wf_proc.display_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 , fnd_lookups btype_fnd , fnd_lookups etype_fnd , fnd_lookups freq_fnd , WF_RUNNABLE_PROCESSES_V WF_PROC WHERE csbb.bulletin_id = csbt.bulletin_id and csbt.language = userenv('LANG') and btype_fnd.lookup_type = 'CSD_BULLETIN_TYPES' and btype_fnd.lookup_code = csbb.bulletin_type_code and etype_fnd.lookup_type(+) = 'CSD_ESCALATION_CODES' and etype_fnd.lookup_code(+) = csbb.escalation_code and freq_fnd.lookup_type = 'CSD_BULLETIN_FREQUENCY' and freq_fnd.lookup_code = csbb.frequency_code and csbb.wf_process_name = wf_proc.process_name(+) and csbb.wf_item_type = wf_proc.item_type(+)

View Text - HTML Formatted

SELECT CSBB.ROWID
, CSBB.BULLETIN_ID
, CSBT.NAME
, CSBT.DESCRIPTION
, CSBB.BULLETIN_TYPE_CODE
, BTYPE_FND.MEANING
, BTYPE_FND.DESCRIPTION
, CSBB.ACTIVE_FROM
, CSBB.ACTIVE_TO
, CSBB.PUBLISHED_FLAG
, CSBB.ESCALATION_CODE
, ETYPE_FND.MEANING
, ETYPE_FND.DESCRIPTION
, CSBB.MANDATORY_FLAG
, CSBB.FREQUENCY_CODE
, FREQ_FND.MEANING
, FREQ_FND.DESCRIPTION
, CSBB.WF_ITEM_TYPE
, CSBB.WF_PROCESS_NAME
, WF_PROC.DISPLAY_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
, FND_LOOKUPS BTYPE_FND
, FND_LOOKUPS ETYPE_FND
, FND_LOOKUPS FREQ_FND
, WF_RUNNABLE_PROCESSES_V WF_PROC
WHERE CSBB.BULLETIN_ID = CSBT.BULLETIN_ID
AND CSBT.LANGUAGE = USERENV('LANG')
AND BTYPE_FND.LOOKUP_TYPE = 'CSD_BULLETIN_TYPES'
AND BTYPE_FND.LOOKUP_CODE = CSBB.BULLETIN_TYPE_CODE
AND ETYPE_FND.LOOKUP_TYPE(+) = 'CSD_ESCALATION_CODES'
AND ETYPE_FND.LOOKUP_CODE(+) = CSBB.ESCALATION_CODE
AND FREQ_FND.LOOKUP_TYPE = 'CSD_BULLETIN_FREQUENCY'
AND FREQ_FND.LOOKUP_CODE = CSBB.FREQUENCY_CODE
AND CSBB.WF_PROCESS_NAME = WF_PROC.PROCESS_NAME(+)
AND CSBB.WF_ITEM_TYPE = WF_PROC.ITEM_TYPE(+)