VIEW: APPS.CSD_REPAIR_KB_SOLUTIONS_V

Source

View Text - Preformatted

SELECT kb_set.row_id, kb_set.SET_ID solution_id, kb_set.SET_NUMBER solution_number, kb_set.NAME solution_title, repair_line_id FROM cs_kb_set_links kb_set_link, cs_kb_set_types_vl kb_set_type, CS_KB_SETS_VL kb_set, CS_LOOKUPS csl , csd_repairs cr WHERE kb_set_link.SET_ID = kb_set.SET_ID and kb_set.set_type_id = kb_set_type.set_type_id and kb_set_link.object_code = 'DR' and kb_set_link.other_id = cr.repair_line_id and csl.lookup_code(+) = kb_set_link.Link_Type and csl.lookup_type(+) = 'CS_KB_LINK_TYPE' and kb_set.set_id = decode( ( select count( b3.set_id ) from cs_kb_sets_b b3 where b3.status = 'OBS' and b3.set_number = kb_set.set_number ), 1, null, decode( ( select count( b2.set_id ) from cs_kb_sets_b b2 where b2.status = 'PUB' and b2.set_number = kb_set.set_number ), 1, ( select b2.set_id from cs_kb_sets_b b2 where b2.status = 'PUB' and b2.set_number = kb_set.set_number ), ( select max(b2.set_id) from cs_kb_sets_b b2 where b2.set_number = kb_set.set_number ) ) )

View Text - HTML Formatted

SELECT KB_SET.ROW_ID
, KB_SET.SET_ID SOLUTION_ID
, KB_SET.SET_NUMBER SOLUTION_NUMBER
, KB_SET.NAME SOLUTION_TITLE
, REPAIR_LINE_ID
FROM CS_KB_SET_LINKS KB_SET_LINK
, CS_KB_SET_TYPES_VL KB_SET_TYPE
, CS_KB_SETS_VL KB_SET
, CS_LOOKUPS CSL
, CSD_REPAIRS CR
WHERE KB_SET_LINK.SET_ID = KB_SET.SET_ID
AND KB_SET.SET_TYPE_ID = KB_SET_TYPE.SET_TYPE_ID
AND KB_SET_LINK.OBJECT_CODE = 'DR'
AND KB_SET_LINK.OTHER_ID = CR.REPAIR_LINE_ID
AND CSL.LOOKUP_CODE(+) = KB_SET_LINK.LINK_TYPE
AND CSL.LOOKUP_TYPE(+) = 'CS_KB_LINK_TYPE'
AND KB_SET.SET_ID = DECODE( ( SELECT COUNT( B3.SET_ID )
FROM CS_KB_SETS_B B3
WHERE B3.STATUS = 'OBS'
AND B3.SET_NUMBER = KB_SET.SET_NUMBER )
, 1
, NULL
, DECODE( ( SELECT COUNT( B2.SET_ID )
FROM CS_KB_SETS_B B2
WHERE B2.STATUS = 'PUB'
AND B2.SET_NUMBER = KB_SET.SET_NUMBER )
, 1
, ( SELECT B2.SET_ID
FROM CS_KB_SETS_B B2
WHERE B2.STATUS = 'PUB'
AND B2.SET_NUMBER = KB_SET.SET_NUMBER )
, ( SELECT MAX(B2.SET_ID)
FROM CS_KB_SETS_B B2
WHERE B2.SET_NUMBER = KB_SET.SET_NUMBER ) ) )