DBA Data[Home] [Help]

VIEW: APPS.CS_KB_LIB_PROPERTIES_V

Source

View Text - Preformatted

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(+)
View Text - HTML Formatted

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(+)