Product: | CSD - Depot Repair |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CSD_SERVICE_CODES_VL |
SELECT CSCB.ROWID
, CSCB.SERVICE_CODE_ID
, CSCB.OBJECT_VERSION_NUMBER
, CSCB.CREATED_BY
, CSCB.CREATION_DATE
, CSCB.LAST_UPDATED_BY
, CSCB.LAST_UPDATE_DATE
, CSCB.LAST_UPDATE_LOGIN
, CSCB.SERVICE_CODE
, CSCT.NAME
, CSCT.DESCRIPTION
, CSCB.ACTIVE_FROM
, CSCB.ACTIVE_TO
, CSCB.ATTRIBUTE_CATEGORY
, CSCB.ATTRIBUTE1
, CSCB.ATTRIBUTE2
, CSCB.ATTRIBUTE3
, CSCB.ATTRIBUTE4
, CSCB.ATTRIBUTE5
, CSCB.ATTRIBUTE6
, CSCB.ATTRIBUTE7
, CSCB.ATTRIBUTE8
, CSCB.ATTRIBUTE9
, CSCB.ATTRIBUTE10
, CSCB.ATTRIBUTE11
, CSCB.ATTRIBUTE12
, CSCB.ATTRIBUTE13
, CSCB.ATTRIBUTE14
, CSCB.ATTRIBUTE15
FROM CSD_SERVICE_CODES_B CSCB
, CSD_SERVICE_CODES_TL CSCT
WHERE CSCT.LANGUAGE = USERENV('LANG')
AND CSCB.SERVICE_CODE_ID = CSCT.SERVICE_CODE_ID