XLA_GL_LEDGERS

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name

LEDGER_ID NAME SHORT_NAME DESCRIPTION LEDGER_CATEGORY_CODE ALC_LEDGER_TYPE_CODE OBJECT_TYPE_CODE LE_LEDGER_TYPE_CODE COMPLETION_STATUS_CODE CONFIGURATION_ID CHART_OF_ACCOUNTS_ID CURRENCY_CODE PERIOD_SET_NAME ACCOUNTED_PERIOD_TYPE FIRST_LEDGER_PERIOD_NAME RET_EARN_CODE_COMBINATION_ID SUSPENSE_ALLOWED_FLAG ALLOW_INTERCOMPANY_POST_FLAG TRACK_ROUNDING_IMBALANCE_FLAG ENABLE_AVERAGE_BALANCES_FLAG CUM_TRANS_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID ROUNDING_CODE_COMBINATION_ID ENABLE_BUDGETARY_CONTROL_FLAG REQUIRE_BUDGET_JOURNALS_FLAG ENABLE_JE_APPROVAL_FLAG ENABLE_AUTOMATIC_TAX_FLAG CONSOLIDATION_LEDGER_FLAG TRANSLATE_EOD_FLAG TRANSLATE_QATD_FLAG TRANSLATE_YATD_FLAG TRANSACTION_CALENDAR_ID DAILY_TRANSLATION_RATE_TYPE AUTOMATICALLY_CREATED_FLAG BAL_SEG_VALUE_OPTION_CODE BAL_SEG_COLUMN_NAME MGT_SEG_VALUE_OPTION_CODE MGT_SEG_COLUMN_NAME BAL_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID IMPLICIT_ACCESS_SET_ID CRITERIA_SET_ID FUTURE_ENTERABLE_PERIODS_LIMIT LEDGER_ATTRIBUTES IMPLICIT_LEDGER_SET_ID LATEST_OPENED_PERIOD_NAME LATEST_ENCUMBRANCE_YEAR PERIOD_AVERAGE_RATE_TYPE PERIOD_END_RATE_TYPE BUDGET_PERIOD_AVG_RATE_TYPE BUDGET_PERIOD_END_RATE_TYPE SLA_ACCOUNTING_METHOD_CODE SLA_ACCOUNTING_METHOD_TYPE SLA_DESCRIPTION_LANGUAGE SLA_ENTERED_CUR_BAL_SUS_CCID SLA_SEQUENCING_FLAG SLA_BAL_BY_LEDGER_CURR_FLAG SLA_LEDGER_CUR_BAL_SUS_CCID ENABLE_SECONDARY_TRACK_FLAG ENABLE_REVAL_SS_TRACK_FLAG LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ENABLE_RECONCILIATION_FLAG CREATE_JE_FLAG SLA_LEDGER_CASH_BASIS_FLAG COMPLETE_FLAG OBJECT_VERSION_NUMBER USSGL_OPTION_CODE VALIDATE_JOURNAL_REF_DATE JRNLS_GROUP_BY_DATE_FLAG REVAL_FROM_PRI_LGR_CURR AUTOREV_AFTER_OPEN_PRD_FLAG PRIOR_PRD_NOTIFICATION_FLAG POP_UP_STAT_ACCOUNT_FLAG THRESHOLD_AMOUNT NUMBER_OF_PROCESSORS PROCESSING_UNIT_SIZE RELEASE_UPGRADE_FROM CROSS_LGR_CLR_ACC_CCID INTERCO_GAIN_LOSS_CCID

Query

SQL_Statement

Select LEDGER_ID, NAME, SHORT_NAME, DESCRIPTION, LEDGER_CATEGORY_CODE, ALC_LEDGER_TYPE_CODE, OBJECT_TYPE_CODE, LE_LEDGER_TYPE_CODE, COMPLETION_STATUS_CODE , CONFIGURATION_ID, CHART_OF_ACCOUNTS_ID, CURRENCY_CODE, PERIOD_SET_NAME, ACCOUNTED_PERIOD_TYPE, FIRST_LEDGER_PERIOD_NAME, RET_EARN_CODE_COMBINATION_ID, SUSPENSE_ALLOWED_FLAG, ALLOW_INTERCOMPANY_POST_FLAG, TRACK_ROUNDING_IMBALANCE_FLAG, ENABLE_AVERAGE_BALANCES_FLAG, CUM_TRANS_CODE_COMBINATION_ID, RES_ENCUMB_CODE_COMBINATION_ID , NET_INCOME_CODE_COMBINATION_ID , ROUNDING_CODE_COMBINATION_ID, ENABLE_BUDGETARY_CONTROL_FLAG, REQUIRE_BUDGET_JOURNALS_FLAG, ENABLE_JE_APPROVAL_FLAG, ENABLE_AUTOMATIC_TAX_FLAG, CONSOLIDATION_LEDGER_FLAG, TRANSLATE_EOD_FLAG, TRANSLATE_QATD_FLAG, TRANSLATE_YATD_FLAG, TRANSACTION_CALENDAR_ID, DAILY_TRANSLATION_RATE_TYPE, AUTOMATICALLY_CREATED_FLAG, BAL_SEG_VALUE_OPTION_CODE, BAL_SEG_COLUMN_NAME, MGT_SEG_VALUE_OPTION_CODE, MGT_SEG_COLUMN_NAME, BAL_SEG_VALUE_SET_ID, MGT_SEG_VALUE_SET_ID, IMPLICIT_ACCESS_SET_ID , CRITERIA_SET_ID, FUTURE_ENTERABLE_PERIODS_LIMIT , LEDGER_ATTRIBUTES, IMPLICIT_LEDGER_SET_ID , LATEST_OPENED_PERIOD_NAME, LATEST_ENCUMBRANCE_YEAR, PERIOD_AVERAGE_RATE_TYPE, PERIOD_END_RATE_TYPE, BUDGET_PERIOD_AVG_RATE_TYPE, BUDGET_PERIOD_END_RATE_TYPE, SLA_ACCOUNTING_METHOD_CODE, SLA_ACCOUNTING_METHOD_TYPE, SLA_DESCRIPTION_LANGUAGE, SLA_ENTERED_CUR_BAL_SUS_CCID, SLA_SEQUENCING_FLAG, SLA_BAL_BY_LEDGER_CURR_FLAG, SLA_LEDGER_CUR_BAL_SUS_CCID, ENABLE_SECONDARY_TRACK_FLAG, ENABLE_REVAL_SS_TRACK_FLAG, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ENABLE_RECONCILIATION_FLAG, CREATE_JE_FLAG , SLA_LEDGER_CASH_BASIS_FLAG, COMPLETE_FLAG, OBJECT_VERSION_NUMBER, USSGL_OPTION_CODE, VALIDATE_JOURNAL_REF_DATE, JRNLS_GROUP_BY_DATE_FLAG, REVAL_FROM_PRI_LGR_CURR, AUTOREV_AFTER_OPEN_PRD_FLAG, PRIOR_PRD_NOTIFICATION_FLAG, POP_UP_STAT_ACCOUNT_FLAG, THRESHOLD_AMOUNT, NUMBER_OF_PROCESSORS, PROCESSING_UNIT_SIZE, RELEASE_UPGRADE_FROM, CROSS_LGR_CLR_ACC_CCID , INTERCO_GAIN_LOSS_CCID from GL_LEDGERS