View: BIS_FUNCTIONAL_AREAS_VL

Product:	BIS - Applications BIS
Description:
Implementation/DBA Data:	APPS.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')