View: FII_OU_LEDGER_V

Product:	FII - Financial Intelligence
Description:	This view is based on tables gl_sets_of_books and hr_organization_information. It will contain information about the Currency corresponding to a Ledger.
Implementation/DBA Data:	APPS.FII_OU_LEDGER_V

View Text

SELECT SOB.SET_OF_BOOKS_ID LEDGER_ID
, SOB.CURRENCY_CODE LEDGER_CURRENCY_CODE
, ORGI.ORGANIZATION_ID OPERATING_UNIT_ID
FROM GL_SETS_OF_BOOKS SOB
, HR_ORGANIZATION_INFORMATION ORGI
WHERE SOB.SET_OF_BOOKS_ID = ORGI.ORG_INFORMATION1 (+)
AND ORGI.ORG_INFORMATION_CONTEXT (+) = 'LEGAL ENTITY ACCOUNTING'

Columns