[Home] [Help]
View: GL_LEDGER_LE_BSV_SPECIFIC_V
View Text
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
Columns
Name |
LEDGER_ID |
LEDGER_NAME |
LEDGER_SHORT_NAME |
LEGAL_ENTITY_ID |
LEGAL_ENTITY_NAME |
LEDGER_CATEGORY_CODE |
SEGMENT_VALUE |
START_DATE |
END_DATE |