VIEW: APPS.CSD_RO_SERVICE_CODES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)