View: XLA_GL_LEDGERS_V

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

View Text

SELECT LEDGER_ID
, /* LEDGER ID */ NAME
, /* LEDGER NAME */ SHORT_NAME
, /* LEDGER SHORT NAME */ DESCRIPTION
, LEDGER_CATEGORY_CODE
, ENABLE_BUDGETARY_CONTROL_FLAG
, /* IF BUDGETARY CONTROL IS USED */ CURRENCY_CODE
, /* LEDGER CURRENCY CODE */ CHART_OF_ACCOUNTS_ID
, /* CHART OF ACCOUNTS ID */ PERIOD_SET_NAME
, /* LEDGER CALENDAR */ COMPLETION_STATUS_CODE
, /* STATUS: COMPLETE
, IN_PROGRESS
, */ /* NOT_STARTED */ LATEST_OPENED_PERIOD_NAME
, SLA_DESCRIPTION_LANGUAGE
, /* DESCRIPTION LANGUAGE */ SLA_ACCOUNTING_METHOD_CODE
, /* ACCOUNTING METHOD CODE */ SLA_ACCOUNTING_METHOD_TYPE
, /* OWNER: [U]SER
, [S]YSTEM */ SLA_ENTERED_CUR_BAL_SUS_CCID
, /* ENTERED CURRENCY BALANCING CC_ID */ BAL_SEG_COLUMN_NAME
, /* COLUMN THAT CONTAINS BSV */ MGT_SEG_COLUMN_NAME /* COLUMN THAT CONTAINS MSV */
, SLA_BAL_BY_LEDGER_CURR_FLAG
, SLA_LEDGER_CUR_BAL_SUS_CCID
, LATEST_ENCUMBRANCE_YEAR
, RES_ENCUMB_CODE_COMBINATION_ID
FROM GL_LEDGERS LED
WHERE OBJECT_TYPE_CODE = 'L' /* ONLY LEDGERS (NOT LEDGER SETS) */
AND LE_LEDGER_TYPE_CODE = 'L' /* ONLY LEGAL LEDGERS */
AND LEDGER_CATEGORY_CODE IN ('PRIMARY'
, 'SECONDARY'
, 'ALC'
, 'NONE')

Columns