eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CSD_RO_SOLN_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT SVL.SET_ID SOLUTION_ID
, SVL.SET_NUMBER SOLUTION_NUMBER
, SVL.NAME SOLUTION_TITLE
, ROS.REPAIR_LINE_ID
FROM CS_KB_SETS_VL SVL
, CSD_RO_SOLUTIONS ROS
WHERE SVL.SET_NUMBER = ROS.SOLUTION_NUMBER
AND SVL.SET_ID = ( SELECT MAX(SB.SET_ID)
FROM CS_KB_SET_LINKS LINKS
, CS_KB_SETS_B SB
WHERE LINKS.OBJECT_CODE= 'DRSC'
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 GROUP BY SB.SET_NUMBER)

Columns

Name
SOLUTION_ID
SOLUTION_NUMBER
SOLUTION_TITLE
REPAIR_LINE_ID