[Home] [Help]
[Dependency Information]
| Object Name: | XLA_SUBLEDGER_OPTIONS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | XLA.XLA_SUBLEDGER_OPTIONS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| 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 |
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;
APPS
GL_LEDGERS
GL_LEDGER_RELATIONSHIPS
XLA_LAUNCH_OPTIONS
XLA_LEDGER_OPTIONS
XLA_SUBLEDGERS
APPS
ARP_CMERGE
- show dependent code
PA_ADJUSTMENTS
- show dependent code
XLA_ACCOUNTING_CACHE_PKG
- show dependent code
XLA_ACCOUNTING_DUMP_PKG
- show dependent code
XLA_ACCOUNTING_PKG
- show dependent code
XLA_AE_JOURNAL_ENTRY_PKG
- show dependent code
XLA_EVENTS_PKG
- show dependent code
XLA_MULTIPERIOD_ACCOUNTING_PKG
- show dependent code
XLA_RETRIVE_CCID_PKG
- show dependent code
XLA_THIRD_PARTY_MERGE
- show dependent code
|
|
|
|