Product: | CSD - Depot Repair |
---|---|
Description: | View to join CSD_BULLETINS_B and CSD_BULLETINS_TL |
Implementation/DBA Data: | APPS.CSD_BULLETINS_VL |
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')