View: XLA_ALT_CURR_LEDGERS_V

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_ALT_CURR_LEDGERS_V

View Text

SELECT REP.LEDGER_ID
, /* ALTERNATE CURRENCY LEDGER ID */ REP.CURRENCY_CODE
, /* USER KEY */ REP.NAME
, REP.SHORT_NAME
, GLR.PRIMARY_LEDGER_ID
, /* PRIMARY OR SECONDARY LEDGER ID */ GLR.SLA_LEDGER_ID
, GLR.RELATIONSHIP_ENABLED_FLAG ENABLED_FLAG
FROM GL_LEDGERS REP
, GL_LEDGER_RELATIONSHIPS GLR
WHERE GLR.TARGET_LEDGER_ID = REP.LEDGER_ID
AND REP.OBJECT_TYPE_CODE = 'L' /* ONLY LEDGERS (NOT LEDGER SETS) */
AND REP.LE_LEDGER_TYPE_CODE = 'L' /* ONLY LEGAL LEDGERS */
AND REP.LEDGER_CATEGORY_CODE = 'ALC'
AND GLR.APPLICATION_ID = 101
AND GLR.RELATIONSHIP_TYPE_CODE = 'SUBLEDGER'

Columns