View: GL_LEDGER_LE_BSV_SPECIFIC_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.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