VIEW: APPS.CSD_KB_LINKS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'