View: CSD_RO_DIAGNOSTIC_CODES_V

Product:	CSD - Depot Repair
Description:	Displays Diagnostic Codes associated to Repair Orders.
Implementation/DBA Data:	APPS.CSD_RO_DIAGNOSTIC_CODES_V

View Text

SELECT CRDC.ROWID
, CRDC.RO_DIAGNOSTIC_CODE_ID
, CRDC.OBJECT_VERSION_NUMBER
, CRDC.REPAIR_LINE_ID
, CRDC.DIAGNOSTIC_CODE_ID
, CRDC.CREATED_BY
, CRDC.CREATION_DATE
, CRDC.LAST_UPDATED_BY
, CRDC.LAST_UPDATE_DATE
, CRDC.LAST_UPDATE_LOGIN
, CR.REPAIR_NUMBER
, CDCB.DIAGNOSTIC_CODE
, CDCTL.NAME
, CDCTL.DESCRIPTION
, CDCB.ACTIVE_FROM
, CDCB.ACTIVE_TO
, CRDC.ATTRIBUTE_CATEGORY
, CRDC.ATTRIBUTE1
, CRDC.ATTRIBUTE2
, CRDC.ATTRIBUTE3
, CRDC.ATTRIBUTE4
, CRDC.ATTRIBUTE5
, CRDC.ATTRIBUTE6
, CRDC.ATTRIBUTE7
, CRDC.ATTRIBUTE8
, CRDC.ATTRIBUTE9
, CRDC.ATTRIBUTE10
, CRDC.ATTRIBUTE11
, CRDC.ATTRIBUTE12
, CRDC.ATTRIBUTE13
, CRDC.ATTRIBUTE14
, CRDC.ATTRIBUTE15
, CRDC.DIAGNOSTIC_ITEM_ID
FROM CSD_RO_DIAGNOSTIC_CODES CRDC
, CSD_DIAGNOSTIC_CODES_B CDCB
, CSD_DIAGNOSTIC_CODES_TL CDCTL
, CSD_REPAIRS CR
WHERE CR.REPAIR_LINE_ID = CRDC.REPAIR_LINE_ID
AND CRDC.DIAGNOSTIC_CODE_ID = CDCB.DIAGNOSTIC_CODE_ID
AND CDCTL.LANGUAGE = USERENV('LANG')
AND CDCB.DIAGNOSTIC_CODE_ID = CDCTL.DIAGNOSTIC_CODE_ID

Columns