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_SC_ROUTE_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
, MRR.MR_HEADER_ID
, MRR.ROUTE_ID
, MRR.ROUTE_NUMBER
, MRR.ROUTE_DESCRIPTION
, MRR.START_DATE_ACTIVE
, MRR.END_DATE_ACTIVE
, R.REVISION_STATUS_CODE
FROM CS_KB_SETS_VL SVL
, CSD_RO_SOLUTIONS ROS
, AHL_MR_ROUTES_V MRR
, AHL_ROUTES_V R
, CS_KB_SET_LINKS LINKS
WHERE SVL.SET_NUMBER = ROS.SOLUTION_NUMBER
AND LINKS.SET_ID = SVL.SET_ID
AND LINKS.OBJECT_CODE = 'DRSC'
AND LINKS.OTHER_ID = MRR.MR_HEADER_ID
AND MRR.ROUTE_ID = R.ROUTE_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

Name
SOLUTION_ID
SOLUTION_NUMBER
SOLUTION_TITLE
REPAIR_LINE_ID
MR_HEADER_ID
ROUTE_ID
ROUTE_NUMBER
ROUTE_DESCRIPTION
START_DATE_ACTIVE
END_DATE_ACTIVE
REVISION_STATUS_CODE