DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.XLA_GL_LEDGERS_V

Object Details
Object Name: XLA_GL_LEDGERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXLA.XLA_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
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER (15) Yes
NAME VARCHAR2 (30) Yes
SHORT_NAME VARCHAR2 (20) Yes
DESCRIPTION VARCHAR2 (240)
LEDGER_CATEGORY_CODE VARCHAR2 (30) Yes
ENABLE_BUDGETARY_CONTROL_FLAG VARCHAR2 (1) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes
PERIOD_SET_NAME VARCHAR2 (15) Yes
COMPLETION_STATUS_CODE VARCHAR2 (30)
LATEST_OPENED_PERIOD_NAME VARCHAR2 (15)
SLA_DESCRIPTION_LANGUAGE VARCHAR2 (15)
SLA_ACCOUNTING_METHOD_CODE VARCHAR2 (30)
SLA_ACCOUNTING_METHOD_TYPE VARCHAR2 (1)
SLA_ENTERED_CUR_BAL_SUS_CCID NUMBER (15)
BAL_SEG_COLUMN_NAME VARCHAR2 (25) Yes
MGT_SEG_COLUMN_NAME VARCHAR2 (25)
SLA_BAL_BY_LEDGER_CURR_FLAG VARCHAR2 (1)
SLA_LEDGER_CUR_BAL_SUS_CCID NUMBER (15)
LATEST_ENCUMBRANCE_YEAR NUMBER (15)
RES_ENCUMB_CODE_COMBINATION_ID NUMBER (15)
Query Text

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


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 APPS.XLA_GL_LEDGERS_V;

Dependencies

[top of page]

APPS.XLA_GL_LEDGERS_V references the following:

SchemaAPPS
SynonymGL_LEDGERS
APPS.XLA_GL_LEDGERS_V is referenced by following:

SchemaAPPS
Package BodyCST_ACCRUALWRITEOFFREPORT_PVT - show dependent code
Package BodyCST_APPOACCRUALREPORT_PVT - show dependent code
Package BodyXLA_ACCOUNTING_PKG - show dependent code
Package BodyXLA_ACCTG_METHODS_PKG - show dependent code
Package BodyXLA_ACCT_SETUP_PKG - show dependent code
Package BodyXLA_AE_LINES_PKG - show dependent code
Package BodyXLA_BALANCES_PKG - show dependent code
Package BodyXLA_DATAFIXES_PUB - show dependent code
Package BodyXLA_FSAH_INT_PVT - show dependent code
Package BodyXLA_JOURNAL_ENTRIES_PUB_PKG - show dependent code
Package BodyXLA_XLAABACR_XMLP_PKG - show dependent code