[Home] [Help]
View: BIS_FUNCTIONAL_AREAS_VL
View Text
SELECT FA.FUNCTIONAL_AREA_ID
, FA.SHORT_NAME
, FA_TL.NAME
, FA_TL.DESCRIPTION
, FA.CREATED_BY
, FA.CREATION_DATE
, FA.LAST_UPDATED_BY
, FA.LAST_UPDATE_DATE
, FA.LAST_UPDATE_LOGIN
FROM BIS_FUNCTIONAL_AREAS FA
, BIS_FUNCTIONAL_AREAS_TL FA_TL
WHERE FA.FUNCTIONAL_AREA_ID = FA_TL.FUNCTIONAL_AREA_ID
AND FA_TL.LANGUAGE = USERENV('LANG')