VIEW: APPS.GMF_LEGAL_ENTITIES

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'