VIEW: APPS.CS_KB_SET_ELEMENTS_V

Source

View Text - Preformatted

SELECT CS_KB_SETS_V.SET_ID SET_ID, CS_KB_SETS_V.SET_TYPE_ID SET_TYPE_ID, CS_KB_SETS_V.SET_TYPE_NAME SET_TYPE_NAME, CS_KB_SETS_V.STATUS, CS_KB_SETS_V.NAME SET_NAME, CS_KB_SETS_V.DESCRIPTION SET_DESCRIPTION, CS_KB_SETS_V.COMPOSITE_ASSOC_INDEX SET_COMPOSITE_ASSOC_INDEX, CS_KB_SETS_V.POSITIVE_ASSOC_INDEX SET_POSITIVE_ASSOC_INDEX, CS_KB_SETS_V.NEGATIVE_ASSOC_INDEX SET_NEGATIVE_ASSOC_INDEX, CS_KB_SETS_V.CREATION_DATE SET_CREATION_DATE, CS_KB_SETS_V.CREATED_BY SET_CREATED_BY, CS_KB_SETS_V.LAST_UPDATE_DATE SET_LAST_UPDATE_DATE, CS_KB_SETS_V.LAST_UPDATED_BY SET_LAST_UPDATED_BY, CS_KB_SETS_V.LAST_UPDATE_LOGIN SETS_LAST_UPDATE_LOGIN, CS_KB_SETS_V.ATTRIBUTE_CATEGORY SET_ATTRIBUTE_CATEGORY, CS_KB_SETS_V.ATTRIBUTE1 SET_ATTRIBUTE1, CS_KB_SETS_V.ATTRIBUTE2 SET_ATTRIBUTE2, CS_KB_SETS_V.ATTRIBUTE3 SET_ATTRIBUTE3, CS_KB_SETS_V.ATTRIBUTE4 SET_ATTRIBUTE4, CS_KB_SETS_V.ATTRIBUTE5 SET_ATTRIBUTE5, CS_KB_SETS_V.ATTRIBUTE6 SET_ATTRIBUTE6, CS_KB_SETS_V.ATTRIBUTE7 SET_ATTRIBUTE7, CS_KB_SETS_V.ATTRIBUTE8 SET_ATTRIBUTE8, CS_KB_SETS_V.ATTRIBUTE9 SET_ATTRIBUTE9, CS_KB_SETS_V.ATTRIBUTE10 SET_ATTRIBUTE10, CS_KB_SETS_V.ATTRIBUTE11 SET_ATTRIBUTE11, CS_KB_SETS_V.ATTRIBUTE12 SET_ATTRIBUTE12, CS_KB_SETS_V.ATTRIBUTE13 SET_ATTRIBUTE13, CS_KB_SETS_V.ATTRIBUTE14 SET_ATTRIBUTE14, CS_KB_SETS_V.ATTRIBUTE15 SET_ATTRIBUTE15, CS_KB_SE.ELEMENT_ORDER ELEMENT_ORDER, CS_KB_SE.ASSOC_DEGREE ASSOC_DEGREE, CS_KB_ELEMENTS_V.ELEMENT_ID ELEMENT_ID, CS_KB_ELEMENTS_V.ELEMENT_TYPE_ID ELEMENT_TYPE_ID, CS_KB_ELEMENTS_V.ELEMENT_TYPE_NAME ELEMENT_TYPE_NAME, CS_KB_ELEMENTS_V.NAME ELEMENT_NAME, CS_KB_ELEMENTS_V.DESCRIPTION ELEMENT_DESCRIPTION, CS_KB_ELEMENTS_V.CREATION_DATE ELEMENT_CREATION_DATE, CS_KB_ELEMENTS_V.CREATED_BY ELEMENT_CREATED_BY, CS_KB_ELEMENTS_V.LAST_UPDATE_DATE ELEMENT_LAST_UPDATE_DATE, CS_KB_ELEMENTS_V.LAST_UPDATED_BY ELEMENT_LAST_UPDATED_BY, CS_KB_ELEMENTS_V.LAST_UPDATE_LOGIN ELEMENT_LAST_UPDATE_LOGIN, CS_KB_ELEMENTS_V.ATTRIBUTE_CATEGORY ELEMENT_ATTRIBUTE_CATEGORY, CS_KB_ELEMENTS_V.ATTRIBUTE1 ELEMENT_ATTRIBUTE1, CS_KB_ELEMENTS_V.ATTRIBUTE2 ELEMENT_ATTRIBUTE2, CS_KB_ELEMENTS_V.ATTRIBUTE3 ELEMENT_ATTRIBUTE3, CS_KB_ELEMENTS_V.ATTRIBUTE4 ELEMENT_ATTRIBUTE4, CS_KB_ELEMENTS_V.ATTRIBUTE5 ELEMENT_ATTRIBUTE5, CS_KB_ELEMENTS_V.ATTRIBUTE6 ELEMENT_ATTRIBUTE6, CS_KB_ELEMENTS_V.ATTRIBUTE7 ELEMENT_ATTRIBUTE7, CS_KB_ELEMENTS_V.ATTRIBUTE8 ELEMENT_ATTRIBUTE8, CS_KB_ELEMENTS_V.ATTRIBUTE9 ELEMENT_ATTRIBUTE9, CS_KB_ELEMENTS_V.ATTRIBUTE10 ELEMENT_ATTRIBUTE10, CS_KB_ELEMENTS_V.ATTRIBUTE11 ELEMENT_ATTRIBUTE11, CS_KB_ELEMENTS_V.ATTRIBUTE12 ELEMENT_ATTRIBUTE12, CS_KB_ELEMENTS_V.ATTRIBUTE13 ELEMENT_ATTRIBUTE13, CS_KB_ELEMENTS_V.ATTRIBUTE14 ELEMENT_ATTRIBUTE14, CS_KB_ELEMENTS_V.ATTRIBUTE15 ELEMENT_ATTRIBUTE15 FROM CS_KB_SETS_V CS_KB_SETS_V ,CS_KB_ELEMENTS_V CS_KB_ELEMENTS_V ,CS_KB_SET_ELES CS_KB_SE WHERE CS_KB_SETS_V.SET_ID = CS_KB_SE.SET_ID AND CS_KB_SE.ELEMENT_ID = CS_KB_ELEMENTS_V.ELEMENT_ID

View Text - HTML Formatted

SELECT CS_KB_SETS_V.SET_ID SET_ID
, CS_KB_SETS_V.SET_TYPE_ID SET_TYPE_ID
, CS_KB_SETS_V.SET_TYPE_NAME SET_TYPE_NAME
, CS_KB_SETS_V.STATUS
, CS_KB_SETS_V.NAME SET_NAME
, CS_KB_SETS_V.DESCRIPTION SET_DESCRIPTION
, CS_KB_SETS_V.COMPOSITE_ASSOC_INDEX SET_COMPOSITE_ASSOC_INDEX
, CS_KB_SETS_V.POSITIVE_ASSOC_INDEX SET_POSITIVE_ASSOC_INDEX
, CS_KB_SETS_V.NEGATIVE_ASSOC_INDEX SET_NEGATIVE_ASSOC_INDEX
, CS_KB_SETS_V.CREATION_DATE SET_CREATION_DATE
, CS_KB_SETS_V.CREATED_BY SET_CREATED_BY
, CS_KB_SETS_V.LAST_UPDATE_DATE SET_LAST_UPDATE_DATE
, CS_KB_SETS_V.LAST_UPDATED_BY SET_LAST_UPDATED_BY
, CS_KB_SETS_V.LAST_UPDATE_LOGIN SETS_LAST_UPDATE_LOGIN
, CS_KB_SETS_V.ATTRIBUTE_CATEGORY SET_ATTRIBUTE_CATEGORY
, CS_KB_SETS_V.ATTRIBUTE1 SET_ATTRIBUTE1
, CS_KB_SETS_V.ATTRIBUTE2 SET_ATTRIBUTE2
, CS_KB_SETS_V.ATTRIBUTE3 SET_ATTRIBUTE3
, CS_KB_SETS_V.ATTRIBUTE4 SET_ATTRIBUTE4
, CS_KB_SETS_V.ATTRIBUTE5 SET_ATTRIBUTE5
, CS_KB_SETS_V.ATTRIBUTE6 SET_ATTRIBUTE6
, CS_KB_SETS_V.ATTRIBUTE7 SET_ATTRIBUTE7
, CS_KB_SETS_V.ATTRIBUTE8 SET_ATTRIBUTE8
, CS_KB_SETS_V.ATTRIBUTE9 SET_ATTRIBUTE9
, CS_KB_SETS_V.ATTRIBUTE10 SET_ATTRIBUTE10
, CS_KB_SETS_V.ATTRIBUTE11 SET_ATTRIBUTE11
, CS_KB_SETS_V.ATTRIBUTE12 SET_ATTRIBUTE12
, CS_KB_SETS_V.ATTRIBUTE13 SET_ATTRIBUTE13
, CS_KB_SETS_V.ATTRIBUTE14 SET_ATTRIBUTE14
, CS_KB_SETS_V.ATTRIBUTE15 SET_ATTRIBUTE15
, CS_KB_SE.ELEMENT_ORDER ELEMENT_ORDER
, CS_KB_SE.ASSOC_DEGREE ASSOC_DEGREE
, CS_KB_ELEMENTS_V.ELEMENT_ID ELEMENT_ID
, CS_KB_ELEMENTS_V.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, CS_KB_ELEMENTS_V.ELEMENT_TYPE_NAME ELEMENT_TYPE_NAME
, CS_KB_ELEMENTS_V.NAME ELEMENT_NAME
, CS_KB_ELEMENTS_V.DESCRIPTION ELEMENT_DESCRIPTION
, CS_KB_ELEMENTS_V.CREATION_DATE ELEMENT_CREATION_DATE
, CS_KB_ELEMENTS_V.CREATED_BY ELEMENT_CREATED_BY
, CS_KB_ELEMENTS_V.LAST_UPDATE_DATE ELEMENT_LAST_UPDATE_DATE
, CS_KB_ELEMENTS_V.LAST_UPDATED_BY ELEMENT_LAST_UPDATED_BY
, CS_KB_ELEMENTS_V.LAST_UPDATE_LOGIN ELEMENT_LAST_UPDATE_LOGIN
, CS_KB_ELEMENTS_V.ATTRIBUTE_CATEGORY ELEMENT_ATTRIBUTE_CATEGORY
, CS_KB_ELEMENTS_V.ATTRIBUTE1 ELEMENT_ATTRIBUTE1
, CS_KB_ELEMENTS_V.ATTRIBUTE2 ELEMENT_ATTRIBUTE2
, CS_KB_ELEMENTS_V.ATTRIBUTE3 ELEMENT_ATTRIBUTE3
, CS_KB_ELEMENTS_V.ATTRIBUTE4 ELEMENT_ATTRIBUTE4
, CS_KB_ELEMENTS_V.ATTRIBUTE5 ELEMENT_ATTRIBUTE5
, CS_KB_ELEMENTS_V.ATTRIBUTE6 ELEMENT_ATTRIBUTE6
, CS_KB_ELEMENTS_V.ATTRIBUTE7 ELEMENT_ATTRIBUTE7
, CS_KB_ELEMENTS_V.ATTRIBUTE8 ELEMENT_ATTRIBUTE8
, CS_KB_ELEMENTS_V.ATTRIBUTE9 ELEMENT_ATTRIBUTE9
, CS_KB_ELEMENTS_V.ATTRIBUTE10 ELEMENT_ATTRIBUTE10
, CS_KB_ELEMENTS_V.ATTRIBUTE11 ELEMENT_ATTRIBUTE11
, CS_KB_ELEMENTS_V.ATTRIBUTE12 ELEMENT_ATTRIBUTE12
, CS_KB_ELEMENTS_V.ATTRIBUTE13 ELEMENT_ATTRIBUTE13
, CS_KB_ELEMENTS_V.ATTRIBUTE14 ELEMENT_ATTRIBUTE14
, CS_KB_ELEMENTS_V.ATTRIBUTE15 ELEMENT_ATTRIBUTE15
FROM CS_KB_SETS_V CS_KB_SETS_V
, CS_KB_ELEMENTS_V CS_KB_ELEMENTS_V
, CS_KB_SET_ELES CS_KB_SE
WHERE CS_KB_SETS_V.SET_ID = CS_KB_SE.SET_ID
AND CS_KB_SE.ELEMENT_ID = CS_KB_ELEMENTS_V.ELEMENT_ID