XLA_GL_LEDGERS_V

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

LEDGER_ID NAME SHORT_NAME DESCRIPTION LEDGER_CATEGORY_CODE ENABLE_BUDGETARY_CONTROL_FLAG CURRENCY_CODE CHART_OF_ACCOUNTS_ID PERIOD_SET_NAME COMPLETION_STATUS_CODE LATEST_OPENED_PERIOD_NAME SLA_DESCRIPTION_LANGUAGE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE SLA_ENTERED_CUR_BAL_SUS_CCID BAL_SEG_COLUMN_NAME MGT_SEG_COLUMN_NAME SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CUR_BAL_SUS_CCID LATEST_ENCUMBRANCE_YEAR RES_ENCUMB_CODE_COMBINATION_ID

Query

SQL_Statement

SELECT ledger_id,NAME,short_name,description,ledger_category_code,enable_budgetary_control_flag,currency_code,chart_of_accounts_id,period_set_name, completion_status_code, latest_opened_period_name,sla_description_language, sla_accounting_method_code,sla_accounting_method_type,sla_entered_cur_bal_sus_ccid, bal_seg_column_name,mgt_seg_column_name,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' and le_ledger_type_code = 'L' and ledger_category_code in ('PRIMARY', 'SECONDARY', 'ALC','NONE')