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


VIEW: APPS.XLA_SUBLEDGER_OPTIONS_V

Object Details
Object Name: XLA_SUBLEDGER_OPTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewXLA.XLA_SUBLEDGER_OPTIONS_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
APPLICATION_ID NUMBER (15) Yes
PRIMARY_LEDGER_ID NUMBER (15) Yes
SL_COA_MAPPING_ID NUMBER (15)
NAME VARCHAR2 (30) Yes
SLA_LEDGER_ID NUMBER (15) Yes
RELATIONSHIP_ENABLED_FLAG VARCHAR2 (1) Yes
ALC_DEFAULT_CONV_RATE_TYPE VARCHAR2 (30)
ALC_INHERIT_CONVERSION_TYPE VARCHAR2 (1)
ALC_NO_RATE_ACTION_CODE VARCHAR2 (30)
ALC_MAX_DAYS_ROLL_RATE NUMBER

LEDGER_CATEGORY_CODE VARCHAR2 (30) Yes
SLA_ACCOUNTING_METHOD_CODE VARCHAR2 (30)
SLA_ACCOUNTING_METHOD_TYPE VARCHAR2 (1)
COMPLETION_STATUS_CODE VARCHAR2 (30)
CURRENCY_CODE VARCHAR2 (15) Yes
SHORT_NAME VARCHAR2 (20) Yes
ENABLE_BUDGETARY_CONTROL_FLAG VARCHAR2 (1) Yes
CHART_OF_ACCOUNTS_ID NUMBER (15) Yes
PERIOD_SET_NAME VARCHAR2 (15) Yes
SLA_DESCRIPTION_LANGUAGE VARCHAR2 (15)
SLA_ENTERED_CUR_BAL_SUS_CCID NUMBER (15)
LATEST_ENCUMBRANCE_YEAR NUMBER (15)
SLA_BAL_BY_LEDGER_CURR_FLAG VARCHAR2 (1)
SLA_LEDGER_CUR_BAL_SUS_CCID NUMBER (15)
RES_ENCUMB_CODE_COMBINATION_ID NUMBER (15)
ROUNDING_CODE_COMBINATION_ID NUMBER (15)
BAL_SEG_COLUMN_NAME VARCHAR2 (25) Yes
MGT_SEG_COLUMN_NAME VARCHAR2 (25)
BAL_SEG_VALUE_OPTION_CODE VARCHAR2 (1) Yes
MGT_SEG_VALUE_OPTION_CODE VARCHAR2 (1) Yes
ALLOW_INTERCOMPANY_POST_FLAG VARCHAR2 (1) Yes
ENABLE_AVERAGE_BALANCES_FLAG VARCHAR2 (1) Yes
TRANSACTION_CALENDAR_ID NUMBER (15)
ACCOUNTING_MODE_CODE VARCHAR2 (1)
ACCOUNTING_MODE_OVERRIDE_FLAG VARCHAR2 (1)
SUMMARY_REPORT_FLAG VARCHAR2 (1)
SUMMARY_REPORT_OVERRIDE_FLAG VARCHAR2 (1)
SUBMIT_TRANSFER_TO_GL_FLAG VARCHAR2 (1)
SUBMIT_TRANSFER_OVERRIDE_FLAG VARCHAR2 (1)
SUBMIT_GL_POST_FLAG VARCHAR2 (1)
SUBMIT_GL_POST_OVERRIDE_FLAG VARCHAR2 (1)
ERROR_LIMIT NUMBER

PROCESSES NUMBER

PROCESSING_UNIT_SIZE NUMBER

TRANSFER_TO_GL_MODE_CODE VARCHAR2 (1) Yes
ACCT_REVERSAL_OPTION_CODE VARCHAR2 (30) Yes
ENABLED_FLAG VARCHAR2 (1) Yes
CAPTURE_EVENT_FLAG VARCHAR2 (1) Yes
ROUNDING_RULE_CODE VARCHAR2 (30) Yes
JE_SOURCE_NAME VARCHAR2 (30) Yes
CONTROL_ACCOUNT_TYPE_CODE VARCHAR2 (30) Yes
ALC_ENABLED_FLAG VARCHAR2 (1) Yes
VALUATION_METHOD_FLAG VARCHAR2 (1) Yes
MERGE_ACCT_OPTION_CODE VARCHAR2 (30)
SUSPENSE_ALLOWED_FLAG VARCHAR2 (1) Yes
Query Text

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


SELECT LEDGER_ID
,      APPLICATION_ID
,      PRIMARY_LEDGER_ID
,      SL_COA_MAPPING_ID
,      NAME
,      SLA_LEDGER_ID
,      RELATIONSHIP_ENABLED_FLAG
,      ALC_DEFAULT_CONV_RATE_TYPE
,      ALC_INHERIT_CONVERSION_TYPE
,      ALC_NO_RATE_ACTION_CODE
,      ALC_MAX_DAYS_ROLL_RATE
,      LEDGER_CATEGORY_CODE
,      SLA_ACCOUNTING_METHOD_CODE
,      SLA_ACCOUNTING_METHOD_TYPE
,      COMPLETION_STATUS_CODE
,      CURRENCY_CODE
,      SHORT_NAME
,      ENABLE_BUDGETARY_CONTROL_FLAG
,      CHART_OF_ACCOUNTS_ID
,      PERIOD_SET_NAME
,      SLA_DESCRIPTION_LANGUAGE
,      SLA_ENTERED_CUR_BAL_SUS_CCID
,      LATEST_ENCUMBRANCE_YEAR
,      SLA_BAL_BY_LEDGER_CURR_FLAG
,      SLA_LEDGER_CUR_BAL_SUS_CCID
,      RES_ENCUMB_CODE_COMBINATION_ID
,      ROUNDING_CODE_COMBINATION_ID
,      BAL_SEG_COLUMN_NAME
,      MGT_SEG_COLUMN_NAME
,      BAL_SEG_VALUE_OPTION_CODE
,      MGT_SEG_VALUE_OPTION_CODE
,      ALLOW_INTERCOMPANY_POST_FLAG
,      ENABLE_AVERAGE_BALANCES_FLAG
,      TRANSACTION_CALENDAR_ID
,      ACCOUNTING_MODE_CODE
,      ACCOUNTING_MODE_OVERRIDE_FLAG
,      SUMMARY_REPORT_FLAG
,      SUMMARY_REPORT_OVERRIDE_FLAG
,      SUBMIT_TRANSFER_TO_GL_FLAG
,      SUBMIT_TRANSFER_OVERRIDE_FLAG
,      SUBMIT_GL_POST_FLAG
,      SUBMIT_GL_POST_OVERRIDE_FLAG
,      ERROR_LIMIT
,      PROCESSES
,      PROCESSING_UNIT_SIZE
,      TRANSFER_TO_GL_MODE_CODE
,      ACCT_REVERSAL_OPTION_CODE
,      ENABLED_FLAG
,      CAPTURE_EVENT_FLAG
,      ROUNDING_RULE_CODE
,      JE_SOURCE_NAME
,      CONTROL_ACCOUNT_TYPE_CODE
,      ALC_ENABLED_FLAG
,      VALUATION_METHOD_FLAG
,      MERGE_ACCT_OPTION_CODE
,      SUSPENSE_ALLOWED_FLAG
FROM APPS.XLA_SUBLEDGER_OPTIONS_V;

Dependencies

[top of page]

APPS.XLA_SUBLEDGER_OPTIONS_V references the following:

SchemaAPPS
SynonymGL_LEDGERS
SynonymGL_LEDGER_RELATIONSHIPS
SynonymXLA_LAUNCH_OPTIONS
SynonymXLA_LEDGER_OPTIONS
SynonymXLA_SUBLEDGERS
APPS.XLA_SUBLEDGER_OPTIONS_V is referenced by following:

SchemaAPPS
Package BodyARP_CMERGE - show dependent code
Package BodyPA_ADJUSTMENTS - show dependent code
Package BodyXLA_ACCOUNTING_CACHE_PKG - show dependent code
Package BodyXLA_ACCOUNTING_DUMP_PKG - show dependent code
Package BodyXLA_ACCOUNTING_PKG - show dependent code
Package BodyXLA_AE_JOURNAL_ENTRY_PKG - show dependent code
Package BodyXLA_EVENTS_PKG - show dependent code
Package BodyXLA_MULTIPERIOD_ACCOUNTING_PKG - show dependent code
Package BodyXLA_RETRIVE_CCID_PKG - show dependent code
Package BodyXLA_THIRD_PARTY_MERGE - show dependent code