VIEW: APPS.CS_KB_LINKED_SOLUTIONS_VIEW

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )