VIEW: APPS.GL_LEDGER_LE_BSV_SPECIFIC_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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