View: XLE_FP_LEDGER_V

Product:	XLE - Legal Entity Configurator
Description:
Implementation/DBA Data:	APPS.XLE_FP_LEDGER_V

View Text

SELECT LG.LEDGER_ID
, LG.NAME LEDGER_NAME
, LG.SHORT_NAME LEDGER_SHORT_NAME
, NVL ( BSV.LEGAL_ENTITY_ID
, XLEP.LEGAL_ENTITY_ID ) LEGAL_ENTITY_ID
, XLEP.NAME LEGAL_ENTITY_NAME
, XLEP.LEGAL_ENTITY_IDENTIFIER
, HZG.COUNTRY_CODE LEGAL_ENTITY_COUNTRY
, XLEP.EFFECTIVE_FROM LE_EFFECTIVE_FROM
, XLEP.EFFECTIVE_TO LE_EFFECTIVE_TO
, LG.LEDGER_CATEGORY_CODE
, BSV.SEGMENT_VALUE
, BSV.START_DATE
, BSV.END_DATE
FROM GL_LEDGER_NORM_SEG_VALS BSV
, GL_LEDGERS LG
, GL_LEDGER_CONFIGURATIONS GLC
, XLE_ENTITY_PROFILES XLEP
, HZ_GEOGRAPHIES HZG
WHERE BSV.SEGMENT_TYPE_CODE = 'B'
AND NVL ( BSV.STATUS_CODE
, 'I') <> 'D'
AND LG.LEDGER_ID = BSV.LEDGER_ID
AND XLEP.LEGAL_ENTITY_ID = NVL ( BSV.LEGAL_ENTITY_ID
, XLEP.LEGAL_ENTITY_ID )
AND LG.CONFIGURATION_ID = GLC.CONFIGURATION_ID
AND GLC.COMPLETION_STATUS_CODE <> 'IN_PROGRESS'
AND XLEP.GEOGRAPHY_ID = HZG.GEOGRAPHY_ID
AND HZG.GEOGRAPHY_TYPE = 'COUNTRY'