FND Design Data [Home] [Help]

View: CSD_BULLETINS_VL

Product: CSD - Depot Repair
Description: View to join CSD_BULLETINS_B and CSD_BULLETINS_TL
Implementation/DBA Data: ViewAPPS.CSD_BULLETINS_VL
View Text

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')

Columns

Name
ROW_ID
BULLETIN_ID
NAME
DESCRIPTION
BULLETIN_TYPE_CODE
ACTIVE_FROM
ACTIVE_TO
PUBLISHED_FLAG
ESCALATION_CODE
MANDATORY_FLAG
FREQUENCY_CODE
WF_ITEM_TYPE
WF_PROCESS_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15