Product: | CSD - Depot Repair |
---|---|
Description: | View to fetch all Service Bulletins |
Implementation/DBA Data: | APPS.CSD_BULLETINS_V |
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(+)