View: CS_KB_SECURE_SOLUTIONS_VIEW

Product:	CS - Service
Description:	Secure Solutions View
Implementation/DBA Data:	APPS.CS_KB_SECURE_SOLUTIONS_VIEW

View Text

SELECT B.SET_ID
, B.SET_NUMBER
, B.SET_TYPE_ID
, TL.NAME
, TL.COMPOSITE_ASSOC_INDEX
, B.STATUS
, B.LOCKED_BY
, B.FLOW_DETAILS_ID
, B.LAST_UPDATE_DATE
, B.VISIBILITY_ID
, B.VIEWABLE_VERSION_FLAG
, B.LATEST_VERSION_FLAG
FROM CS_KB_CAT_GROUP_DENORM MV
, CS_KB_SET_CATEGORIES SC
, CS_KB_SETS_B B
, CS_KB_SETS_TL TL
, CS_KB_VISIBILITIES_B VB
WHERE MV.CHILD_CATEGORY_ID = SC.CATEGORY_ID
AND SC.SET_ID = B.SET_ID
AND B.SET_ID = TL.SET_ID
AND B.VISIBILITY_ID = VB.VISIBILITY_ID
AND MV.CATEGORY_GROUP_ID = CS_KB_SECURITY_PVT.GET_CATEGORY_GROUP_ID
AND MV.VISIBILITY_POSITION >= CS_KB_SECURITY_PVT.GET_SOLN_VISIBILITY_POSITION
AND VB.POSITION >= CS_KB_SECURITY_PVT.GET_SOLN_VISIBILITY_POSITION
AND TL.LANGUAGE = USERENV('LANG')

Columns