Product: | CSD - Depot Repair |
---|---|
Description: | View that displays Diagnostic Codes information. |
Implementation/DBA Data: | APPS.CSD_DIAGNOSTIC_CODES_VL |
SELECT CDCB.ROWID
, CDCB.DIAGNOSTIC_CODE_ID
, CDCB.OBJECT_VERSION_NUMBER
, CDCB.CREATED_BY
, CDCB.CREATION_DATE
, CDCB.LAST_UPDATED_BY
, CDCB.LAST_UPDATE_DATE
, CDCB.LAST_UPDATE_LOGIN
, CDCB.DIAGNOSTIC_CODE
, CDCTL.NAME
, CDCTL.DESCRIPTION
, CDCB.ACTIVE_FROM
, CDCB.ACTIVE_TO
, CDCB.ATTRIBUTE_CATEGORY
, CDCB.ATTRIBUTE1
, CDCB.ATTRIBUTE2
, CDCB.ATTRIBUTE3
, CDCB.ATTRIBUTE4
, CDCB.ATTRIBUTE5
, CDCB.ATTRIBUTE6
, CDCB.ATTRIBUTE7
, CDCB.ATTRIBUTE8
, CDCB.ATTRIBUTE9
, CDCB.ATTRIBUTE10
, CDCB.ATTRIBUTE11
, CDCB.ATTRIBUTE12
, CDCB.ATTRIBUTE13
, CDCB.ATTRIBUTE14
, CDCB.ATTRIBUTE15
FROM CSD_DIAGNOSTIC_CODES_B CDCB
, CSD_DIAGNOSTIC_CODES_TL CDCTL
WHERE CDCTL.LANGUAGE = USERENV('LANG')
AND CDCB.DIAGNOSTIC_CODE_ID = CDCTL.DIAGNOSTIC_CODE_ID