View: FII_OU_V

Product:	FII - Financial Intelligence
Description:	This view is based on tables hr_organization_information and hr_all_organization_units_tl. It will contain information about the Operating Units.
Implementation/DBA Data:	APPS.FII_OU_V

View Text

SELECT ORG.ORGANIZATION_ID ID
, OTL.NAME VALUE
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