VIEW: APPS.XLE_FP_LEDGER_V

Source

View Text - Preformatted

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'
   

View Text - HTML Formatted

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'