View: CS_KB_LINKED_SOLUTIONS_VIEW

Product:	CS - Service
Description:	Linked Solutions View
Implementation/DBA Data:	APPS.CS_KB_LINKED_SOLUTIONS_VIEW

View Text

SELECT SETEO.SET_NUMBER
, SETEO.SET_ID
, SETEO.NAME
, SETEO.VISIBILITY_ID
, SETLINKEO.LINK_TYPE
, SETLINKEOMEANING.MEANING
, DECODE( SETEO.STATUS
, 'PUB'
, 'PUB'
, 'NONPUB')
, SETLINKEO.LAST_UPDATE_DATE
, SETLINKEO.OBJECT_CODE
, SETLINKEO.OTHER_ID
, SETTYPESEO.NAME
, VIS.NAME
FROM CS_KB_SETS_VL SETEO
, CS_KB_SET_LINKS SETLINKEO
, CS_LOOKUPS SETLINKEOMEANING
, CS_KB_SET_TYPES_VL SETTYPESEO
, CS_KB_VISIBILITIES_VL VIS
WHERE SETTYPESEO.SET_TYPE_ID = SETEO.SET_TYPE_ID
AND SETLINKEO.SET_ID = SETEO.SET_ID
AND SETEO.VIEWABLE_VERSION_FLAG = 'Y'
AND SETLINKEOMEANING.LOOKUP_CODE(+) = SETLINKEO.LINK_TYPE
AND SETLINKEOMEANING.LOOKUP_TYPE(+) = 'CS_KB_LINK_TYPE'
AND SETEO.VISIBILITY_ID = VIS.VISIBILITY_ID
AND VIS.POSITION >= CS_KB_SECURITY_PVT.GET_SOLN_VISIBILITY_POSITION
AND EXISTS (SELECT 'X'
FROM CS_KB_SET_CATEGORIES SETCAT
, CS_KB_CAT_GROUP_DENORM CATGROUPDENORM
WHERE SETCAT.SET_ID = SETEO.SET_ID
AND SETCAT.CATEGORY_ID = CATGROUPDENORM.CHILD_CATEGORY_ID
AND CATGROUPDENORM.CATEGORY_GROUP_ID = CS_KB_SECURITY_PVT.GET_CATEGORY_GROUP_ID
AND CATGROUPDENORM.VISIBILITY_POSITION >= CS_KB_SECURITY_PVT.GET_SOLN_VISIBILITY_POSITION )

Columns