VIEW: APPS.XLA_GL_LEDGERS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')