[Home] [Help] [Dependency Information]

VIEW: APPS.GL_LEDGERS_V

Object Details

Object Name:	GL_LEDGERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLGL.GL_LEDGERS_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

SELECT ROW_ID
,      LEDGER_ID
,      NAME
,      SHORT_NAME
,      CHART_OF_ACCOUNTS_ID
,      CHART_OF_ACCOUNTS_NAME
,      CURRENCY_CODE
,      PERIOD_SET_NAME
,      USER_PERIOD_TYPE
,      ACCOUNTED_PERIOD_TYPE
,      FIRST_LEDGER_PERIOD_NAME
,      RET_EARN_CODE_COMBINATION_ID
,      SUSPENSE_ALLOWED_FLAG
,      SUSPENSE_CCID
,      ALLOW_INTERCOMPANY_POST_FLAG
,      ENABLE_AVGBAL_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
,      AUTOMATICALLY_CREATED_FLAG
,      TRACK_ROUNDING_IMBALANCE_FLAG
,      ALC_LEDGER_TYPE_CODE
,      LE_LEDGER_TYPE_CODE
,      BAL_SEG_VALUE_OPTION_CODE
,      BAL_SEG_COLUMN_NAME
,      BAL_SEG_VALUE_SET_ID
,      MGT_SEG_VALUE_OPTION_CODE
,      MGT_SEG_COLUMN_NAME
,      MGT_SEG_VALUE_SET_ID
,      IMPLICIT_ACCESS_SET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      IMPLICIT_LEDGER_SET_ID
,      DESCRIPTION
,      FUTURE_ENTERABLE_PERIODS_LIMIT
,      LATEST_OPENED_PERIOD_NAME
,      LATEST_ENCUMBRANCE_YEAR
,      CUM_TRANS_CODE_COMBINATION_ID
,      RES_ENCUMB_CODE_COMBINATION_ID
,      NET_INCOME_CODE_COMBINATION_ID
,      BALANCING_SEGMENT
,      ROUNDING_CCID
,      TRANSACTION_CALENDAR_ID
,      TRANSACTION_CALENDAR_NAME
,      DAILY_TRANSLATION_RATE_TYPE
,      DAILY_USER_TRANSLATION_TYPE
,      PERIOD_AVERAGE_RATE_TYPE
,      PERIOD_AVERAGE_USER_RATE_TYPE
,      PERIOD_END_RATE_TYPE
,      PERIOD_END_USER_RATE_TYPE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      NET_CLOSING_BAL_FLAG
,      AUTOMATE_SEC_JRNL_REV_FLAG
FROM APPS.GL_LEDGERS_V;

Dependencies

[top of page]

APPS

FND_ID_FLEX_STRUCTURES_TL

GL_DAILY_CONVERSION_TYPES

GL_LEDGERS

GL_NET_INCOME_ACCOUNTS

GL_PERIOD_TYPES

GL_SUSPENSE_ACCOUNTS

GL_TRANSACTION_CALENDAR

APPS

FV_GTAS_AGENCY_ID_UPGRADE - show dependent code

FV_GTAS_INTERFACE - show dependent code

OKL_REPORT_GENERATOR_PVT - show dependent code

PA_ADJUSTMENTS - show dependent code

XLA_UPDATE_INVAL_CCID - show dependent code