[Home] [Help]
View: CS_KB_LIB_PROPERTIES_V
View Text
SELECT C.CATEGORY_ID
, C.PARENT_CATEGORY_ID
, C.NAME
, C.DESCRIPTION
, C.LANGUAGE
, C.SOURCE_LANG
, P.PROPERTY_ID
, P.LEVELS_TO_DISPLAY
, P.HIDE_LIBRARY_FLAG
, P.HIDE_SECTION_FLAG
, P.DETAILS
FROM CS_KB_SOLN_CATEGORIES_VL C
, CS_KB_LIB_PROPERTIES_VL P
WHERE C.CATEGORY_ID = P.CATEGORY_ID(+)
Columns
Name |
CATEGORY_ID |
PARENT_CATEGORY_ID |
NAME |
DESCRIPTION |
LANGUAGE |
SOURCE_LANG |
PROPERTY_ID |
LEVELS_TO_DISPLAY |
HIDE_LIBRARY_FLAG |
HIDE_SECTION_FLAG |
DETAILS |