View: CS_KB_SECTIONS_V

Product:	CS - Service
Description:	View nolonger used.
Implementation/DBA Data:	APPS.CS_KB_SECTIONS_V

View Text

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

Columns