DBA Data[Home] [Help]

VIEW: APPS.CS_KB_LIB_PROPERTIES_VL

Source

View Text - Preformatted

SELECT B.CATEGORY_ID,B.PROPERTY_ID,B.LEVELS_TO_DISPLAY,B.HIDE_LIBRARY_FLAG,B.HIDE_SECTION_FLAG,TL.LANGUAGE,TL.SOURCE_LANG,TL.DETAILS FROM CS_KB_LIB_PROPERTIES_B B,CS_KB_LIB_PROPERTIES_TL TL WHERE b.property_id = tl.property_id and tl.language = userenv('LANG')
View Text - HTML Formatted

SELECT B.CATEGORY_ID
, B.PROPERTY_ID
, B.LEVELS_TO_DISPLAY
, B.HIDE_LIBRARY_FLAG
, B.HIDE_SECTION_FLAG
, TL.LANGUAGE
, TL.SOURCE_LANG
, TL.DETAILS
FROM CS_KB_LIB_PROPERTIES_B B
, CS_KB_LIB_PROPERTIES_TL TL
WHERE B.PROPERTY_ID = TL.PROPERTY_ID
AND TL.LANGUAGE = USERENV('LANG')