XLE_FP_LEDGER_V

Details

• Schema: FUSION

• Object owner: XLE

• Object type: VIEW

Columns

Name
LEDGER_ID LEDGER_NAME LEDGER_SHORT_NAME LEGAL_ENTITY_ID LEGAL_ENTITY_NAME LEGAL_ENTITY_IDENTIFIER LEGAL_ENTITY_COUNTRY LE_EFFECTIVE_FROM LE_EFFECTIVE_TO LEDGER_CATEGORY_CODE SEGMENT_VALUE START_DATE END_DATE

Query

SQL_Statement

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'