View: CS_SR_KB_SOLUTION_LINKS_V

Product:	CS - Service
Description:	This is the base view in the notes section of the workbench tab for Knowledge Base solution notes.
Implementation/DBA Data:	APPS.CS_SR_KB_SOLUTION_LINKS_V

View Text

SELECT INC.INCIDENT_NUMBER
, CSKB.SET_ID
, CSKB.SET_NUMBER
, CSKB.SET_NAME
, CSKB.SET_VISIBILITY_ID
, CSKB.SET_LINK_TYPE
, CSKB.SET_LINK_TYPE_MEANING
, CSKB.SET_PUBLISHED_STATUS
, CSKB.SET_LAST_UPDATE_DATE
, CSKB.OBJECT_CODE
, CSKB.OTHER_ID
, CSKB.SET_TYPE_NAME
, CSKB.VISIBILITY_NAME
, CSKBL.CREATION_DATE
FROM CS_INCIDENTS_ALL_B INC
, CS_KB_LINKED_SOLUTIONS_VIEW CSKB
, CS_KB_SET_LINKS CSKBL
WHERE INC.INCIDENT_ID=CSKB.OTHER_ID
AND CSKB.OBJECT_CODE='SR'
AND CSKBL.OTHER_ID=INC.INCIDENT_ID
AND CSKBL.OBJECT_CODE='SR'
AND CSKB.SET_ID = CSKBL.SET_ID

Columns