VIEW: APPS.CS_KB_SECURE_SOLUTIONS_VIEW

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')