View: GMF_LEGAL_ENTITIES

Product:	GMF - Process Manufacturing Financials
Description:	Internal view to retrieve Legal Entity information
Implementation/DBA Data:	APPS.GMF_LEGAL_ENTITIES

View Text

SELECT LE.LEGAL_ENTITY_ID
, LE.NAME
, LG.LEDGER_ID PRIMARY_LEDGER_ID
, LG.NAME PRIMARY_LEDGER_NAME
, LG.SHORT_NAME PRIMARY_LEDGER_CODE
, LG.CURRENCY_CODE BASE_CURRENCY_CODE
, LG.CHART_OF_ACCOUNTS_ID
FROM XLE_ENTITY_PROFILES LE
, GL_LEDGERS LG
, GL_LEDGER_CONFIG_DETAILS CFGDET
WHERE CFGDET.CONFIGURATION_ID = LG.CONFIGURATION_ID
AND CFGDET.OBJECT_TYPE_CODE(+) = 'LEGAL_ENTITY'
AND CFGDET.OBJECT_ID(+) = LE.LEGAL_ENTITY_ID
AND NVL(LG.COMPLETE_FLAG
, 'Y') = 'Y'
AND LG.LEDGER_CATEGORY_CODE = 'PRIMARY'

Columns