View: CSD_REPAIR_KB_SOLUTIONS_V

Product:	CSD - Depot Repair
Description:	Views that gets all the solutions from Knowledge Base based on reapair orders.
Implementation/DBA Data:	APPS.CSD_REPAIR_KB_SOLUTIONS_V

View Text

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 ) ) )

Columns