View: GL_ALC_LEDGER_RSHIPS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_ALC_LEDGER_RSHIPS_V

View Text

SELECT SOURCE_LEDGER_ID
, TARGET_LEDGER_ID LEDGER_ID
, TARGET_LEDGER_NAME NAME
, TARGET_LEDGER_SHORT_NAME SHORT_NAME
, TARGET_CURRENCY_CODE CURRENCY_CODE
, RELATIONSHIP_TYPE_CODE
, RELATIONSHIP_ENABLED_FLAG
, PRIMARY_LEDGER_ID
, APPLICATION_ID
, ORG_ID
, ALC_DEFAULT_CONV_RATE_TYPE
FROM GL_LEDGER_RELATIONSHIPS REL
, GL_LEDGERS LGR
WHERE TARGET_LEDGER_CATEGORY_CODE = 'ALC'
AND RELATIONSHIP_TYPE_CODE IN ('JOURNAL'
, 'SUBLEDGER')
AND LGR.LEDGER_ID = REL.TARGET_LEDGER_ID
AND NVL(LGR.COMPLETE_FLAG
, 'Y') = 'Y'

Columns