1. Tables and Views for Financials
  2. GL_LEDGERS_PUBLIC_V

GL_LEDGERS_PUBLIC_V

Details

  • Schema: FUSION

  • Object owner: GL

  • Object type: VIEW

Columns

Name

LEDGER_ID

NAME

CHART_OF_ACCOUNTS_ID

CURRENCY_CODE

PERIOD_SET_NAME

ACCOUNTED_PERIOD_TYPE

SUSPENSE_ALLOWED_FLAG

ALLOW_INTERCOMPANY_POST_FLAG

TRACK_ROUNDING_IMBALANCE_FLAG

ENABLE_AVERAGE_BALANCES_FLAG

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

MRC_LEDGER_TYPE_CODE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

FUTURE_ENTERABLE_PERIODS_LIMIT

LATEST_OPENED_PERIOD_NAME

LATEST_ENCUMBRANCE_YEAR

RET_EARN_CODE_COMBINATION_ID

CUM_TRANS_CODE_COMBINATION_ID

RES_ENCUMB_CODE_COMBINATION_ID

NET_INCOME_CODE_COMBINATION_ID

ROUNDING_CCID

TRANSACTION_CALENDAR_ID

DAILY_TRANSLATION_RATE_TYPE

PERIOD_AVERAGE_RATE_TYPE

PERIOD_END_RATE_TYPE

BAL_SEG_VALUE_OPTION_CODE

MGT_SEG_VALUE_OPTION_CODE

BAL_SEG_VALUE_SET_ID

MGT_SEG_VALUE_SET_ID

BAL_SEG_COLUMN_NAME

MGT_SEG_COLUMN_NAME

IMPLICIT_ACCESS_SET_ID

IMPLICIT_LEDGER_SET_ID

FIRST_LEDGER_PERIOD_NAME

DESCRIPTION

LEDGER_CATEGORY_CODE

CONFIGURATION_ID

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE_CATEGORY

SHORT_NAME

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

SEQUENCING_MODE_CODE

DOC_SEQUENCING_OPTION_CODE

AR_DOC_SEQUENCING_OPTION_FLAG

AP_DOC_SEQUENCING_OPTION_FLAG

ENF_SEQ_DATE_CORRELATION_CODE

NET_CLOSING_BAL_FLAG

AUTOMATE_SEC_JRNL_REV_FLAG

Query

SQL_Statement

SELECT

lgr.LEDGER_ID LEDGER_ID,

lgr.NAME NAME,

lgr.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID,

lgr.CURRENCY_CODE CURRENCY_CODE,

lgr.PERIOD_SET_NAME PERIOD_SET_NAME,

lgr.ACCOUNTED_PERIOD_TYPE ACCOUNTED_PERIOD_TYPE,

lgr.SUSPENSE_ALLOWED_FLAG SUSPENSE_ALLOWED_FLAG,

lgr.ALLOW_INTERCOMPANY_POST_FLAG ALLOW_INTERCOMPANY_POST_FLAG,

lgr.TRACK_ROUNDING_IMBALANCE_FLAG TRACK_ROUNDING_IMBALANCE_FLAG,

lgr.ENABLE_AVERAGE_BALANCES_FLAG ENABLE_AVERAGE_BALANCES_FLAG,

lgr.ENABLE_BUDGETARY_CONTROL_FLAG ENABLE_BUDGETARY_CONTROL_FLAG,

lgr.REQUIRE_BUDGET_JOURNALS_FLAG REQUIRE_BUDGET_JOURNALS_FLAG,

lgr.ENABLE_JE_APPROVAL_FLAG ENABLE_JE_APPROVAL_FLAG,

lgr.ENABLE_AUTOMATIC_TAX_FLAG ENABLE_AUTOMATIC_TAX_FLAG,

lgr.CONSOLIDATION_LEDGER_FLAG CONSOLIDATION_LEDGER_FLAG,

lgr.TRANSLATE_EOD_FLAG TRANSLATE_EOD_FLAG,

lgr.TRANSLATE_QATD_FLAG TRANSLATE_QATD_FLAG,

lgr.TRANSLATE_YATD_FLAG TRANSLATE_YATD_FLAG,

DECODE(lgr.ALC_LEDGER_TYPE_CODE, 'SOURCE', 'P', 'TARGET', 'R', 'N') MRC_LEDGER_TYPE_CODE,

lgr.LAST_UPDATE_DATE LAST_UPDATE_DATE,

lgr.LAST_UPDATED_BY LAST_UPDATED_BY,

lgr.CREATION_DATE CREATION_DATE,

lgr.CREATED_BY CREATED_BY,

lgr.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

lgr.FUTURE_ENTERABLE_PERIODS_LIMIT FUTURE_ENTERABLE_PERIODS_LIMIT,

lgr.LATEST_OPENED_PERIOD_NAME LATEST_OPENED_PERIOD_NAME,

lgr.LATEST_ENCUMBRANCE_YEAR LATEST_ENCUMBRANCE_YEAR,

lgr.RET_EARN_CODE_COMBINATION_ID RET_EARN_CODE_COMBINATION_ID,

lgr.CUM_TRANS_CODE_COMBINATION_ID CUM_TRANS_CODE_COMBINATION_ID,

lgr.RES_ENCUMB_CODE_COMBINATION_ID RES_ENCUMB_CODE_COMBINATION_ID,

lgr.NET_INCOME_CODE_COMBINATION_ID NET_INCOME_CODE_COMBINATION_ID,

lgr.ROUNDING_CODE_COMBINATION_ID ROUNDING_CCID,

lgr.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID,

lgr.DAILY_TRANSLATION_RATE_TYPE DAILY_TRANSLATION_RATE_TYPE,

lgr.PERIOD_AVERAGE_RATE_TYPE PERIOD_AVERAGE_RATE_TYPE,

lgr.PERIOD_END_RATE_TYPE PERIOD_END_RATE_TYPE,

lgr.BAL_SEG_VALUE_OPTION_CODE BAL_SEG_VALUE_OPTION_CODE,

lgr.MGT_SEG_VALUE_OPTION_CODE MGT_SEG_VALUE_OPTION_CODE,

lgr.BAL_SEG_VALUE_SET_ID BAL_SEG_VALUE_SET_ID,

lgr.MGT_SEG_VALUE_SET_ID MGT_SEG_VALUE_SET_ID,

lgr.BAL_SEG_COLUMN_NAME BAL_SEG_COLUMN_NAME,

lgr.MGT_SEG_COLUMN_NAME MGT_SEG_COLUMN_NAME,

lgr.IMPLICIT_ACCESS_SET_ID IMPLICIT_ACCESS_SET_ID,

lgr.IMPLICIT_LEDGER_SET_ID IMPLICIT_LEDGER_SET_ID,

lgr.FIRST_LEDGER_PERIOD_NAME FIRST_LEDGER_PERIOD_NAME,

lgr.DESCRIPTION DESCRIPTION,

lgr.LEDGER_CATEGORY_CODE LEDGER_CATEGORY_CODE,

lgr.CONFIGURATION_ID CONFIGURATION_ID,

lgr.ATTRIBUTE1 ATTRIBUTE1,

lgr.ATTRIBUTE2 ATTRIBUTE2,

lgr.ATTRIBUTE3 ATTRIBUTE3,

lgr.ATTRIBUTE4 ATTRIBUTE4,

lgr.ATTRIBUTE5 ATTRIBUTE5,

lgr.ATTRIBUTE6 ATTRIBUTE6,

lgr.ATTRIBUTE7 ATTRIBUTE7,

lgr.ATTRIBUTE8 ATTRIBUTE8,

lgr.ATTRIBUTE9 ATTRIBUTE9,

lgr.ATTRIBUTE10 ATTRIBUTE10,

lgr.ATTRIBUTE11 ATTRIBUTE11,

lgr.ATTRIBUTE12 ATTRIBUTE12,

lgr.ATTRIBUTE13 ATTRIBUTE13,

lgr.ATTRIBUTE14 ATTRIBUTE14,

lgr.ATTRIBUTE15 ATTRIBUTE15,

lgr.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

null SHORT_NAME,

lgr.ATTRIBUTE_NUMBER1,

lgr.ATTRIBUTE_NUMBER2,

lgr.ATTRIBUTE_NUMBER3,

lgr.ATTRIBUTE_NUMBER4,

lgr.ATTRIBUTE_NUMBER5,

lgr.ATTRIBUTE_DATE1,

lgr.ATTRIBUTE_DATE2,

lgr.ATTRIBUTE_DATE3,

lgr.ATTRIBUTE_DATE4,

lgr.ATTRIBUTE_DATE5,

lgr.SEQUENCING_MODE_CODE SEQUENCING_MODE_CODE,

lgr.DOC_SEQUENCING_OPTION_CODE DOC_SEQUENCING_OPTION_CODE,

lgr.AR_DOC_SEQUENCING_OPTION_FLAG AR_DOC_SEQUENCING_OPTION_FLAG,

lgr.AP_DOC_SEQUENCING_OPTION_FLAG AP_DOC_SEQUENCING_OPTION_FLAG,

lgr.ENF_SEQ_DATE_CORRELATION_CODE ENF_SEQ_DATE_CORRELATION_CODE,

lgr.NET_CLOSING_BAL_FLAG NET_CLOSING_BAL_FLAG,

lgr.AUTOMATE_SEC_JRNL_REV_FLAG AUTOMATE_SEC_JRNL_REV_FLAG

FROM

GL_LEDGERS lgr

WHERE

OBJECT_TYPE_CODE = 'L' AND NVL(COMPLETE_FLAG, 'Y') = 'Y'