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

TABLE: XLA.XLA_AAD_LOADER_DEFNS_T

Object Details
Object Name: XLA_AAD_LOADER_DEFNS_T
Object Type: TABLE
Owner: XLA
FND Design Data: TableXLA.XLA_AAD_LOADER_DEFNS_T
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.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XLA_AAD_LOADER_DEFNS_T_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAAD_LOADER_DEFINITION_ID
XLA_AAD_LOADER_DEFNS_T_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTAGING_AMB_CONTEXT_CODE
ColumnTABLE_NAME
Columns
Name Datatype Length Mandatory Comments
AAD_LOADER_DEFINITION_ID NUMBER
Yes Internal id
STAGING_AMB_CONTEXT_CODE VARCHAR2 (30) Yes AMB Context of the staging area
TABLE_NAME VARCHAR2 (30) Yes The table name of the information of the row belongs to with the exception of XLA_CONDITIONS table, which will be indentified by XLA_DESC_CONDITIONS, XLA_JLT_CONDITIONS, and XLA_ADR_CONDITIONS for the different component type
NAME VARCHAR2 (80)
Name of the component
DESCRIPTION VARCHAR2 (240)
Description of the component
ACCOUNTING_ATTRIBUTE_CODE VARCHAR2 (30)
Accounting attribute
ACCOUNTING_CLASS_CODE VARCHAR2 (30)
Accounting class code
ACCT_COA_ID_FLEX_STRUCT_CODE VARCHAR2 (30)
Id flex structure code of the chart of accounts for which the accounting is created
ACCOUNTING_ENTRY_TYPE_CODE VARCHAR2 (30)
Accounting line type, for example Actual, Encumbrances or Budget
ACCOUNTING_LINE_CODE VARCHAR2 (30)
Accounting line code
ACCOUNTING_LINE_TYPE_CODE VARCHAR2 (30)
Accounting line type code
ACCOUNTING_METHOD_TYPE_CODE VARCHAR2 (30)
Accounting method type code
ACCOUNTING_METHOD_CODE VARCHAR2 (30)
Accounting method code
ACCOUNTING_REQUIRED_FLAG VARCHAR2 (1)
Indicates if accounting is required for this product accounting definition and event class or type
ACTIVE_FLAG VARCHAR2 (1)
Active flag
ANALYTICAL_CRITERION_CODE VARCHAR2 (30)
Analytical criterion code
ANALYTICAL_CRITERION_TYPE_CODE VARCHAR2 (30)
Analytical criterion type code
ANALYTICAL_DETAIL_CODE VARCHAR2 (30)
Analytical criterion detail code
APPLICATION_SHORT_NAME VARCHAR2 (50)
Application short name
BALANCING_FLAG VARCHAR2 (1)
Indicate whether balances should be maintained for the analytical criteria
BRACKET_LEFT_CODE VARCHAR2 (30)
Left bracket code
BRACKET_RIGHT_CODE VARCHAR2 (30)
Right bracket code
COMPILE_STATUS_CODE VARCHAR2 (30)
Indicates the compile status of the application accounting definition
COMPONENT_CODE VARCHAR2 (30)
The component code
COMPONENT_TYPE_CODE VARCHAR2 (30)
The component type code
COMPONENT_OWNER_CODE VARCHAR2 (30)
The component Owner code
CONDITION_NUM NUMBER

Condition number (mapped to xla_conditions.user_sequence)
CRITERION_VALUE_CODE VARCHAR2 (30)
Internal key for analytical criteria
DATA_TYPE_CODE VARCHAR2 (30)
Data type code
DESCRIPTION_CODE VARCHAR2 (30)
Description code
DESCRIPTION_TYPE_CODE VARCHAR2 (30)
Description type code
DISPLAY_DESCRIPTION_FLAG VARCHAR2 (1)
Indicate if the flexfield segment is displayed with a meaning or a description
DISPLAY_IN_INQUIRIES_FLAG VARCHAR2 (1)
Indicate if journal entry lines associated to this analytical criterion is displayed in the inquiries
DISPLAY_ORDER NUMBER

Display order
EFFECTIVE_DATE_FROM DATE

Effective start date
EFFECTIVE_DATE_TO DATE

Effective end date
ENABLED_FLAG VARCHAR2 (1)
Enabled flag
END_DATE_ACTIVE DATE

Effective end date
ENTITY_CODE VARCHAR2 (30)
Entity code
EVENT_CLASS_CODE VARCHAR2 (30)
Event class code
EVENT_CLASS_DEFAULT_FLAG VARCHAR2 (1)
Event class default flag
EVENT_TYPE_CODE VARCHAR2 (30)
Event type code
FLEXFIELD_ASSIGN_MODE_CODE VARCHAR2 (30)
Indicates whether to account by accounting flexfield or by segment
FLEXFIELD_SEGMENT_CODE VARCHAR2 (30)
Flexfield segment code
FLEX_VALUE_SET_NAME VARCHAR2 (60)
Flex value set code
GL_TRANSFER_MODE_CODE VARCHAR2 (30)
General ledger transfer mode
GROUPING_ORDER NUMBER

INDEPENDENT_VALUE_CONSTANT VARCHAR2 (30)
INPUT_SOURCE_APP_SHORT_NAME VARCHAR2 (50)
Source application short name
INPUT_SOURCE_CODE VARCHAR2 (30)
Source code
INPUT_SOURCE_TYPE_CODE VARCHAR2 (30)
Source type code
INPUT_VALUE_CONSTANT VARCHAR2 (240)
Constant
INPUT_VALUE_TYPE_CODE VARCHAR2 (30)
Value type code
LEAPFROG_FLAG VARCHAR2 (1)
Indicates if the application accounting definition is a leapfrog
LINE_OPERATOR_CODE VARCHAR2 (30)
Line operator code
LITERAL VARCHAR2 (240)
Translated text entered by the user
LOCKING_STATUS_FLAG VARCHAR2 (1)
Indicates the locating status of the application accounting definition
LOGICAL_OPERATOR_CODE VARCHAR2 (30)
Logical operator code
LOOKUP_TYPE VARCHAR2 (30)
Lookup type
MAPPING_SET_CODE VARCHAR2 (30)
Mapping set code
MERGE_DUPLICATE_CODE VARCHAR2 (30)
Indicate how duplicate accounting lines must be merged
NATURAL_SIDE_CODE VARCHAR2 (30)
Natural side for the accounting line type
ORIG_LAST_UPDATE_DATE VARCHAR2 (10)
The original last update date
OWNER VARCHAR2 (4000)
The owner of the record
BASE_VERSION_NUM NUMBER

The base version number of the application accounting definition
PRIORITY_NUM NUMBER

Description priority number (mapped to xla_desc_priorities. user_sequence)
PRODUCT_RULE_CODE VARCHAR2 (30)
Application accounting definition code
PRODUCT_RULE_TYPE_CODE VARCHAR2 (30)
Application accounting definition type code
PRODUCT_RULE_VERSION VARCHAR2 (30)
Application accounting definition version
SEGMENT_RULE_CODE VARCHAR2 (30)
Segment rule code
SEGMENT_RULE_TYPE_CODE VARCHAR2 (30)
Segment rule type code
SOURCE_APP_SHORT_NAME VARCHAR2 (50)
Source application short name
SOURCE_CODE VARCHAR2 (30)
Standard source internal code
SOURCE_TYPE_CODE VARCHAR2 (30)
Indicates whether it is a seeded source of a derived source
START_DATE_ACTIVE DATE

Effective start date
SWITCH_SIDE_FLAG VARCHAR2 (1)
Indicate whether to switch side when amount is negative
TRANS_COA_ID_FLEX_STRUCT_CODE VARCHAR2 (30)
Id flex structure code of the chart of accounts of the transaction
USER_SEQUENCE NUMBER

User sequence (priority)
VALUE_CCID_ID_FLEX_STRUCT_CODE VARCHAR2 (30)
Id flex code of the chart of accounts of the value code combination id
VALUE_CCID_SEGMENT1 VARCHAR2 (25)
Segment 1 of the the value code combination id
VALUE_CCID_SEGMENT2 VARCHAR2 (25)
Segment 2 of the the value code combination id
VALUE_CCID_SEGMENT3 VARCHAR2 (25)
Segment 3 of the the value code combination id
VALUE_CCID_SEGMENT4 VARCHAR2 (25)
Segment 4 of the the value code combination id
VALUE_CCID_SEGMENT5 VARCHAR2 (25)
Segment 5 of the the value code combination id
VALUE_CCID_SEGMENT6 VARCHAR2 (25)
Segment 6 of the the value code combination id
VALUE_CCID_SEGMENT7 VARCHAR2 (25)
Segment 7 of the the value code combination id
VALUE_CCID_SEGMENT8 VARCHAR2 (25)
Segment 8 of the the value code combination id
VALUE_CCID_SEGMENT9 VARCHAR2 (25)
Segment 9 of the the value code combination id
VALUE_CCID_SEGMENT10 VARCHAR2 (25)
Segment 10 of the the value code combination id
VALUE_CCID_SEGMENT11 VARCHAR2 (25)
Segment 11 of the the value code combination id
VALUE_CCID_SEGMENT12 VARCHAR2 (25)
Segment 12 of the the value code combination id
VALUE_CCID_SEGMENT13 VARCHAR2 (25)
Segment 13 of the the value code combination id
VALUE_CCID_SEGMENT14 VARCHAR2 (25)
Segment 14 of the the value code combination id
VALUE_CCID_SEGMENT15 VARCHAR2 (25)
Segment 15 of the the value code combination id
VALUE_CCID_SEGMENT16 VARCHAR2 (25)
Segment 16 of the the value code combination id
VALUE_CCID_SEGMENT17 VARCHAR2 (25)
Segment 17 of the the value code combination id
VALUE_CCID_SEGMENT18 VARCHAR2 (25)
Segment 18 of the the value code combination id
VALUE_CCID_SEGMENT19 VARCHAR2 (25)
Segment 19 of the the value code combination id
VALUE_CCID_SEGMENT20 VARCHAR2 (25)
Segment 20 of the the value code combination id
VALUE_CCID_SEGMENT21 VARCHAR2 (25)
Segment 21 of the the value code combination id
VALUE_CCID_SEGMENT22 VARCHAR2 (25)
Segment 22 of the the value code combination id
VALUE_CCID_SEGMENT23 VARCHAR2 (25)
Segment 23 of the the value code combination id
VALUE_CCID_SEGMENT24 VARCHAR2 (25)
Segment 24 of the the value code combination id
VALUE_CCID_SEGMENT25 VARCHAR2 (25)
Segment. 25 of the the value code combination id
VALUE_CCID_SEGMENT26 VARCHAR2 (25)
Segment 26 of the the value code combination id
VALUE_CCID_SEGMENT27 VARCHAR2 (25)
Segment 27 of the the value code combination id
VALUE_CCID_SEGMENT28 VARCHAR2 (25)
Segment 28 of the the value code combination id
VALUE_CCID_SEGMENT29 VARCHAR2 (25)
Segment 29 of the the value code combination id
VALUE_CCID_SEGMENT30 VARCHAR2 (25)
Segment 30 of the the value code combination id
VALUE_CONSTANT VARCHAR2 (240)
Constant
VALUE_CODE_COMBINATION_ID NUMBER

The value code combination identifier
VALUE_FLEXFIELD_SEGMENT_CODE VARCHAR2 (30)
Value flexfield segment code
VALUE_MAPPING_SET_CODE VARCHAR2 (30)
Mapping set code
VALUE_SOURCE_APP_SHORT_NAME VARCHAR2 (50)
Value source application
VALUE_SOURCE_CODE VARCHAR2 (30)
Value source code
VALUE_SOURCE_TYPE_CODE VARCHAR2 (30)
Value source type code
VALUE_TYPE_CODE VARCHAR2 (30)
Value type code
VERSION_NUM NUMBER

Version number
VERSION_COMMENT VARCHAR2 (240)
Comment entered when the application accounting definition is exported
VIEW_APP_SHORT_NAME VARCHAR2 (50)
View application short name
VIEW_COLUMN_NUM NUMBER

View column number
YEAR_END_CARRY_FORWARD_CODE VARCHAR2 (1)
Year end carry forward code
OBJECT_VERSION_NUMBER NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
LINE_DEFINITION_OWNER_CODE VARCHAR2 (30)
Journal lines definition owner code
LINE_DEFINITION_CODE VARCHAR2 (30)
Journal lines definition code
VALIDATION_STATUS_CODE VARCHAR2 (30)
Validation status code
BUSINESS_METHOD_CODE VARCHAR2 (30)
Business flow method code
BUSINESS_CLASS_CODE VARCHAR2 (30)
Business flow class code
INHERIT_DESC_FLAG VARCHAR2 (1)
Indicate if the description is inherited
INHERIT_ADR_FLAG VARCHAR2 (1)
Indicate if the account derivation rule is inherited
ROUNDING_CLASS_CODE VARCHAR2 (30)
Rounding class code
SIDE_CODE VARCHAR2 (30)
Side code
VALUE_SEGMENT_RULE_APPL_ID NUMBER (15)
Attached segment rule application id
VALUE_SEGMENT_RULE_TYPE_CODE VARCHAR2 (30)
Attached segment rule type code
VALUE_SEGMENT_RULE_CODE VARCHAR2 (30)
Attached segment rule code
SEGMENT_RULE_APPL_ID NUMBER (15)
Segment rule application id
ADR_VERSION_NUM NUMBER (15)
Version number of the account derivation rule
VALUE_ADR_VERSION_NUM NUMBER (15)
Version number of the value account derivation rule
SEGMENT_RULE_APPL_SN VARCHAR2 (50)
Application short name of the account derivation rule
VALUE_SEGMENT_RULE_APPL_SN VARCHAR2 (50)
Application short name of the value account derivation rule
ENCUMBRANCE_TYPE VARCHAR2 (30)
Encumbrance type identifier
BUDGETARY_CONTROL_FLAG VARCHAR2 (1)
Indicates if the journal lines definition is used in budgetary control
MPA_HEADER_DESC_CODE VARCHAR2 (30)
Multiperiod header description code
MPA_HEADER_DESC_TYPE_CODE VARCHAR2 (30)
Multiperiod header description owner code
MPA_NUM_JE_CODE VARCHAR2 (30)
The number of multiperiod journal entries to be created
MPA_GL_DATES_CODE VARCHAR2 (30)
Option which denotes how the GL date for the multiperiod journal entries are derived
MPA_PRORATION_CODE VARCHAR2 (30)
Option which denotes how multiperiod journal entries should be prorated
MPA_OPTION_CODE VARCHAR2 (30)
Multiperiod accounting option
MPA_ACCOUNTING_LINE_TYPE_CODE VARCHAR2 (30)
Multiperiod journal line type owner
MPA_ACCOUNTING_LINE_CODE VARCHAR2 (30)
Multiperiod journal line type
MPA_INHERIT_AC_FLAG VARCHAR2 (1)
Indicate if the analytical criteria should be inherited for the multiperiod accounting entries.
OUTPUT_FLEX_VALUE_SET_NAME VARCHAR2 (60)
Query Text

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


SELECT AAD_LOADER_DEFINITION_ID
,      STAGING_AMB_CONTEXT_CODE
,      TABLE_NAME
,      NAME
,      DESCRIPTION
,      ACCOUNTING_ATTRIBUTE_CODE
,      ACCOUNTING_CLASS_CODE
,      ACCT_COA_ID_FLEX_STRUCT_CODE
,      ACCOUNTING_ENTRY_TYPE_CODE
,      ACCOUNTING_LINE_CODE
,      ACCOUNTING_LINE_TYPE_CODE
,      ACCOUNTING_METHOD_TYPE_CODE
,      ACCOUNTING_METHOD_CODE
,      ACCOUNTING_REQUIRED_FLAG
,      ACTIVE_FLAG
,      ANALYTICAL_CRITERION_CODE
,      ANALYTICAL_CRITERION_TYPE_CODE
,      ANALYTICAL_DETAIL_CODE
,      APPLICATION_SHORT_NAME
,      BALANCING_FLAG
,      BRACKET_LEFT_CODE
,      BRACKET_RIGHT_CODE
,      COMPILE_STATUS_CODE
,      COMPONENT_CODE
,      COMPONENT_TYPE_CODE
,      COMPONENT_OWNER_CODE
,      CONDITION_NUM
,      CRITERION_VALUE_CODE
,      DATA_TYPE_CODE
,      DESCRIPTION_CODE
,      DESCRIPTION_TYPE_CODE
,      DISPLAY_DESCRIPTION_FLAG
,      DISPLAY_IN_INQUIRIES_FLAG
,      DISPLAY_ORDER
,      EFFECTIVE_DATE_FROM
,      EFFECTIVE_DATE_TO
,      ENABLED_FLAG
,      END_DATE_ACTIVE
,      ENTITY_CODE
,      EVENT_CLASS_CODE
,      EVENT_CLASS_DEFAULT_FLAG
,      EVENT_TYPE_CODE
,      FLEXFIELD_ASSIGN_MODE_CODE
,      FLEXFIELD_SEGMENT_CODE
,      FLEX_VALUE_SET_NAME
,      GL_TRANSFER_MODE_CODE
,      GROUPING_ORDER
,      INDEPENDENT_VALUE_CONSTANT
,      INPUT_SOURCE_APP_SHORT_NAME
,      INPUT_SOURCE_CODE
,      INPUT_SOURCE_TYPE_CODE
,      INPUT_VALUE_CONSTANT
,      INPUT_VALUE_TYPE_CODE
,      LEAPFROG_FLAG
,      LINE_OPERATOR_CODE
,      LITERAL
,      LOCKING_STATUS_FLAG
,      LOGICAL_OPERATOR_CODE
,      LOOKUP_TYPE
,      MAPPING_SET_CODE
,      MERGE_DUPLICATE_CODE
,      NATURAL_SIDE_CODE
,      ORIG_LAST_UPDATE_DATE
,      OWNER
,      BASE_VERSION_NUM
,      PRIORITY_NUM
,      PRODUCT_RULE_CODE
,      PRODUCT_RULE_TYPE_CODE
,      PRODUCT_RULE_VERSION
,      SEGMENT_RULE_CODE
,      SEGMENT_RULE_TYPE_CODE
,      SOURCE_APP_SHORT_NAME
,      SOURCE_CODE
,      SOURCE_TYPE_CODE
,      START_DATE_ACTIVE
,      SWITCH_SIDE_FLAG
,      TRANS_COA_ID_FLEX_STRUCT_CODE
,      USER_SEQUENCE
,      VALUE_CCID_ID_FLEX_STRUCT_CODE
,      VALUE_CCID_SEGMENT1
,      VALUE_CCID_SEGMENT2
,      VALUE_CCID_SEGMENT3
,      VALUE_CCID_SEGMENT4
,      VALUE_CCID_SEGMENT5
,      VALUE_CCID_SEGMENT6
,      VALUE_CCID_SEGMENT7
,      VALUE_CCID_SEGMENT8
,      VALUE_CCID_SEGMENT9
,      VALUE_CCID_SEGMENT10
,      VALUE_CCID_SEGMENT11
,      VALUE_CCID_SEGMENT12
,      VALUE_CCID_SEGMENT13
,      VALUE_CCID_SEGMENT14
,      VALUE_CCID_SEGMENT15
,      VALUE_CCID_SEGMENT16
,      VALUE_CCID_SEGMENT17
,      VALUE_CCID_SEGMENT18
,      VALUE_CCID_SEGMENT19
,      VALUE_CCID_SEGMENT20
,      VALUE_CCID_SEGMENT21
,      VALUE_CCID_SEGMENT22
,      VALUE_CCID_SEGMENT23
,      VALUE_CCID_SEGMENT24
,      VALUE_CCID_SEGMENT25
,      VALUE_CCID_SEGMENT26
,      VALUE_CCID_SEGMENT27
,      VALUE_CCID_SEGMENT28
,      VALUE_CCID_SEGMENT29
,      VALUE_CCID_SEGMENT30
,      VALUE_CONSTANT
,      VALUE_CODE_COMBINATION_ID
,      VALUE_FLEXFIELD_SEGMENT_CODE
,      VALUE_MAPPING_SET_CODE
,      VALUE_SOURCE_APP_SHORT_NAME
,      VALUE_SOURCE_CODE
,      VALUE_SOURCE_TYPE_CODE
,      VALUE_TYPE_CODE
,      VERSION_NUM
,      VERSION_COMMENT
,      VIEW_APP_SHORT_NAME
,      VIEW_COLUMN_NUM
,      YEAR_END_CARRY_FORWARD_CODE
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_UPDATE_DATE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      REQUEST_ID
,      LINE_DEFINITION_OWNER_CODE
,      LINE_DEFINITION_CODE
,      VALIDATION_STATUS_CODE
,      BUSINESS_METHOD_CODE
,      BUSINESS_CLASS_CODE
,      INHERIT_DESC_FLAG
,      INHERIT_ADR_FLAG
,      ROUNDING_CLASS_CODE
,      SIDE_CODE
,      VALUE_SEGMENT_RULE_APPL_ID
,      VALUE_SEGMENT_RULE_TYPE_CODE
,      VALUE_SEGMENT_RULE_CODE
,      SEGMENT_RULE_APPL_ID
,      ADR_VERSION_NUM
,      VALUE_ADR_VERSION_NUM
,      SEGMENT_RULE_APPL_SN
,      VALUE_SEGMENT_RULE_APPL_SN
,      ENCUMBRANCE_TYPE
,      BUDGETARY_CONTROL_FLAG
,      MPA_HEADER_DESC_CODE
,      MPA_HEADER_DESC_TYPE_CODE
,      MPA_NUM_JE_CODE
,      MPA_GL_DATES_CODE
,      MPA_PRORATION_CODE
,      MPA_OPTION_CODE
,      MPA_ACCOUNTING_LINE_TYPE_CODE
,      MPA_ACCOUNTING_LINE_CODE
,      MPA_INHERIT_AC_FLAG
,      OUTPUT_FLEX_VALUE_SET_NAME
FROM XLA.XLA_AAD_LOADER_DEFNS_T;

Dependencies

[top of page]

XLA.XLA_AAD_LOADER_DEFNS_T does not reference any database object

XLA.XLA_AAD_LOADER_DEFNS_T is referenced by following:

SchemaXLA
ViewXLA_AAD_LOADER_DEFNS_T#