View: FII_OPERATING_UNITS_V

Product:	FII - Financial Intelligence
Description:	Internal view used to support operating unit information in DBI
Implementation/DBA Data:	APPS.FII_OPERATING_UNITS_V

View Text

SELECT ORG.ORGANIZATION_ID
, OTL.NAME
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_INFORMATION ORGI
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE ORG.ORGANIZATION_ID = ORGI.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')
AND ORGI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND ORGI.ORG_INFORMATION1 = 'OPERATING_UNIT'

Columns