VIEW: APPS.CSD_RO_DIAGNOSTIC_CODES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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