View: CSD_KB_LINKS_V

Product:	CSD - Depot Repair
Description:	Views that gets all the solutions from Knowledge Base.
Implementation/DBA Data:	APPS.CSD_KB_LINKS_V

View Text

SELECT SETTYPE.NAME SET_TYPE
, SETS.NAME SET_NAME
, SETELE.ELEMENT_ORDER ELEMENT_ORDER
, ELETYPE.NAME ELEMENT_TYPE
, SETELE.ASSOC_DEGREE NOT_TRUE
, ELE.NAME ELEMENT_NAME
, SETLINK.OTHER_ID REPAIR_LINE_ID
, SETS.SET_ID SET_ID
, ELE.ELEMENT_ID ELEMENT_ID
, SETTYPE.SET_TYPE_ID SET_TYPE_ID
, ELETYPE.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
FROM CS_KB_SET_LINKS SETLINK
, CS_KB_SETS_VL SETS
, CS_KB_SET_TYPES_VL SETTYPE
, CS_KB_ELEMENT_TYPES_VL ELETYPE
, CS_KB_SET_ELES SETELE
, CS_KB_ELEMENTS_VL ELE
WHERE SETS.SET_TYPE_ID = SETTYPE.SET_TYPE_ID
AND SETLINK.SET_ID = SETS.SET_ID
AND SETLINK.SET_ID = SETELE.SET_ID
AND SETELE.ELEMENT_ID = ELE.ELEMENT_ID
AND ELE.ELEMENT_TYPE_ID = ELETYPE.ELEMENT_TYPE_ID
AND SETLINK.OBJECT_CODE = 'DR' UNION SELECT NULL
, NULL
, TO_NUMBER(NULL)
, ELETYPE.NAME
, TO_NUMBER(NULL)
, ELE.NAME
, ELELINK.OTHER_ID
, TO_NUMBER(NULL)
, ELE.ELEMENT_ID ELEMENT_ID
, TO_NUMBER(NULL)
, ELETYPE.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
FROM CS_KB_ELEMENT_LINKS ELELINK
, CS_KB_ELEMENT_TYPES_VL ELETYPE
, CS_KB_ELEMENTS_VL ELE
WHERE ELELINK.ELEMENT_ID = ELE.ELEMENT_ID
AND ELE.ELEMENT_TYPE_ID = ELETYPE.ELEMENT_TYPE_ID
AND ELELINK.OBJECT_CODE = 'DR'

Columns