Product: | CSD - Depot Repair |
---|---|
Description: | Displays Service Codes associated to Repair Orders. |
Implementation/DBA Data: | APPS.CSD_RO_SERVICE_CODES_V |
SELECT CRSC.ROWID
, CRSC.RO_SERVICE_CODE_ID
, CRSC.OBJECT_VERSION_NUMBER
, CRSC.REPAIR_LINE_ID
, CRSC.SERVICE_CODE_ID
, CRSC.CREATED_BY
, CRSC.CREATION_DATE
, CRSC.LAST_UPDATED_BY
, CRSC.LAST_UPDATE_DATE
, CRSC.LAST_UPDATE_LOGIN
, CR.REPAIR_NUMBER
, CSC.SERVICE_CODE
, CSC.NAME
, CSC.DESCRIPTION
, CSC.ACTIVE_FROM
, CSC.ACTIVE_TO
, CRSC.APPLICABLE_FLAG
, CRSC.SOURCE_TYPE_CODE
, FND.MEANING
, CRSC.SOURCE_SOLUTION_ID
, KB.SET_NUMBER
, KB.SET_NAME
, CRSC.APPLIED_TO_EST_FLAG
, CRSC.APPLIED_TO_WORK_FLAG
, CRSC.ATTRIBUTE_CATEGORY
, CRSC.ATTRIBUTE1
, CRSC.ATTRIBUTE2
, CRSC.ATTRIBUTE3
, CRSC.ATTRIBUTE4
, CRSC.ATTRIBUTE5
, CRSC.ATTRIBUTE6
, CRSC.ATTRIBUTE7
, CRSC.ATTRIBUTE8
, CRSC.ATTRIBUTE9
, CRSC.ATTRIBUTE10
, CRSC.ATTRIBUTE11
, CRSC.ATTRIBUTE12
, CRSC.ATTRIBUTE13
, CRSC.ATTRIBUTE14
, CRSC.ATTRIBUTE15
, CRSC.SERVICE_ITEM_ID
, CRSC.REC_TYPE_CODE
, FND2.MEANING
FROM CSD_RO_SERVICE_CODES CRSC
, CSD_SERVICE_CODES_VL CSC
, CSD_REPAIRS_V CR
, CS_KB_LINKED_SOLUTIONS_VIEW KB
, FND_LOOKUPS FND
, FND_LOOKUPS FND2
WHERE CRSC.SERVICE_CODE_ID = CSC.SERVICE_CODE_ID
AND CR.REPAIR_LINE_ID = CRSC.REPAIR_LINE_ID
AND CRSC.REPAIR_LINE_ID = KB.OTHER_ID (+)
AND KB.OBJECT_CODE (+) = 'DR'
AND FND.LOOKUP_TYPE = 'CSD_SOURCE_TYPE'
AND CRSC.SOURCE_TYPE_CODE = FND.LOOKUP_CODE
AND CRSC.SOURCE_SOLUTION_ID = KB.SET_ID(+)
AND FND2.LOOKUP_TYPE (+) = 'CSD_SC_RECOMMENDATION_TYPES'
AND CRSC.REC_TYPE_CODE = FND2.LOOKUP_CODE (+)