VIEW: APPS.CS_KB_SECTIONS_V

Source

View Text - Preformatted

SELECT B.SECTION_ID,B.SOLUTION_AGE,TL.LANGUAGE,TL.SOURCE_LANG,TL.NAME,D.SECTION_DETAILS_ID,D.SOLUTION_TYPE_ID,TYPE.NAME FROM CS_KB_SECTIONS_B B,CS_KB_SECTIONS_TL TL,CS_KB_SECTION_DETAILS D,CS_KB_SET_TYPES_TL TYPE WHERE b.section_id = tl.section_id and b.section_id = d.section_id and d.solution_type_id = type.SET_TYPE_ID and type.language = userenv('LANG') and tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.SECTION_ID
, B.SOLUTION_AGE
, TL.LANGUAGE
, TL.SOURCE_LANG
, TL.NAME
, D.SECTION_DETAILS_ID
, D.SOLUTION_TYPE_ID
, TYPE.NAME
FROM CS_KB_SECTIONS_B B
, CS_KB_SECTIONS_TL TL
, CS_KB_SECTION_DETAILS D
, CS_KB_SET_TYPES_TL TYPE
WHERE B.SECTION_ID = TL.SECTION_ID
AND B.SECTION_ID = D.SECTION_ID
AND D.SOLUTION_TYPE_ID = TYPE.SET_TYPE_ID
AND TYPE.LANGUAGE = USERENV('LANG')
AND TL.LANGUAGE = USERENV('LANG')