GL_LEDGER_LE_BSV_SPECIFIC_V

Details

• Schema: FUSION

• Object owner: GL

• Object type: VIEW

Columns

Name
LEDGER_ID LEDGER_NAME LEDGER_SHORT_NAME LEGAL_ENTITY_ID LEGAL_ENTITY_NAME 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 , bsv.LEGAL_ENTITY_ID , le.NAME LEGAL_ENTITY_NAME , lg.LEDGER_CATEGORY_CODE , bsv.SEGMENT_VALUE , bsv.START_DATE , bsv.END_DATE FROM GL_LEDGER_NORM_SEG_VALS bsv , GL_LEDGERS lg , XLE_ENTITY_PROFILES le WHERE bsv.segment_type_code = 'B' AND NVL(bsv.status_code, 'I') <> 'D' AND lg.ledger_id = bsv.ledger_id AND nvl(lg.complete_flag,'Y') = 'Y' AND le.legal_entity_id (+) = bsv.legal_entity_id