View: CSD_RO_SOLN_SC_V

View Text

SELECT SVL.SET_ID SOLUTION_ID
, SVL.SET_NUMBER SOLUTION_NUMBER
, SVL.NAME SOLUTION_TITLE
, ROS.REPAIR_LINE_ID
, MR.MR_HEADER_ID SERVICE_CODE_ID
, MR.TITLE SERVICE_CODE
, MR.EFFECTIVE_FROM
, MR.EFFECTIVE_TO
, MR.STATUS
FROM CS_KB_SETS_VL SVL
, CSD_RO_SOLUTIONS ROS
, AHL_MR_HEADERS_V MR
, CS_KB_SET_LINKS LINKS
WHERE SVL.SET_NUMBER = ROS.SOLUTION_NUMBER
AND LINKS.SET_ID = SVL.SET_ID
AND LINKS.OBJECT_CODE = 'DRSD'
AND LINKS.OTHER_ID = MR.MR_HEADER_ID
AND SVL.SET_ID = ( SELECT MAX(SB.SET_ID)
FROM CS_KB_SET_LINKS LINKS
, CS_KB_SETS_B SB
WHERE LINKS.OBJECT_CODE= 'DR'
AND LINKS.OTHER_ID = ROS.REPAIR_LINE_ID
AND LINKS.SET_ID = SB.SET_ID
AND LINKS.LINK_TYPE = 'S'
AND SB.SET_NUMBER = ROS.SOLUTION_NUMBER )

Columns