VIEW: APPS.CSD_RO_SOLNS_V

Source

View Text - Preformatted

SELECT kb.set_id, kb.set_number, kb.set_name, kb.set_link_type, kb.set_link_type_meaning, kb.other_id as repair_line_id, decode(csd.applied_flag, 'Y', 'Y', 'N') as applied_flag FROM cs_kb_linked_solutions_view kb, (SELECT distinct 'Y' as applied_flag, csd1.repair_line_id, csd1.source_solution_id FROM csd_ro_service_codes csd1, cs_kb_linked_solutions_view kb1 WHERE csd1.repair_line_id = kb1.other_id and csd1.source_type_code = 'SOLUTION' and csd1.source_solution_id = kb1.set_id and (applied_to_est_flag = 'Y' or applied_to_work_flag = 'Y')) csd WHERE csd.repair_line_id (+) = kb.other_id and csd.source_solution_id (+) = kb.set_id and kb.object_code = 'DR' and kb.set_published_status = 'PUB'

View Text - HTML Formatted

SELECT KB.SET_ID
, KB.SET_NUMBER
, KB.SET_NAME
, KB.SET_LINK_TYPE
, KB.SET_LINK_TYPE_MEANING
, KB.OTHER_ID AS REPAIR_LINE_ID
, DECODE(CSD.APPLIED_FLAG
, 'Y'
, 'Y'
, 'N') AS APPLIED_FLAG
FROM CS_KB_LINKED_SOLUTIONS_VIEW KB
, (SELECT DISTINCT 'Y' AS APPLIED_FLAG
, CSD1.REPAIR_LINE_ID
, CSD1.SOURCE_SOLUTION_ID
FROM CSD_RO_SERVICE_CODES CSD1
, CS_KB_LINKED_SOLUTIONS_VIEW KB1
WHERE CSD1.REPAIR_LINE_ID = KB1.OTHER_ID
AND CSD1.SOURCE_TYPE_CODE = 'SOLUTION'
AND CSD1.SOURCE_SOLUTION_ID = KB1.SET_ID
AND (APPLIED_TO_EST_FLAG = 'Y' OR APPLIED_TO_WORK_FLAG = 'Y')) CSD
WHERE CSD.REPAIR_LINE_ID (+) = KB.OTHER_ID
AND CSD.SOURCE_SOLUTION_ID (+) = KB.SET_ID
AND KB.OBJECT_CODE = 'DR'
AND KB.SET_PUBLISHED_STATUS = 'PUB'