[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XLA_AAD_LOADER_DEFNS_T# |
|---|---|
| Object Type: | VIEW |
| Owner: | XLA |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AAD_LOADER_DEFINITION_ID | NUMBER | Yes | ||
| STAGING_AMB_CONTEXT_CODE | VARCHAR2 | (30) | Yes | |
| TABLE_NAME | VARCHAR2 | (30) | Yes | |
| NAME | VARCHAR2 | (80) | ||
| DESCRIPTION | VARCHAR2 | (240) | ||
| ACCOUNTING_ATTRIBUTE_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | (30) | ||
| ACCT_COA_ID_FLEX_STRUCT_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_ENTRY_TYPE_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_LINE_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_METHOD_TYPE_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_METHOD_CODE | VARCHAR2 | (30) | ||
| ACCOUNTING_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| ACTIVE_FLAG | VARCHAR2 | (1) | ||
| ANALYTICAL_CRITERION_CODE | VARCHAR2 | (30) | ||
| ANALYTICAL_CRITERION_TYPE_CODE | VARCHAR2 | (30) | ||
| ANALYTICAL_DETAIL_CODE | VARCHAR2 | (30) | ||
| APPLICATION_SHORT_NAME | VARCHAR2 | (50) | ||
| BALANCING_FLAG | VARCHAR2 | (1) | ||
| BRACKET_LEFT_CODE | VARCHAR2 | (30) | ||
| BRACKET_RIGHT_CODE | VARCHAR2 | (30) | ||
| COMPILE_STATUS_CODE | VARCHAR2 | (30) | ||
| COMPONENT_CODE | VARCHAR2 | (30) | ||
| COMPONENT_TYPE_CODE | VARCHAR2 | (30) | ||
| COMPONENT_OWNER_CODE | VARCHAR2 | (30) | ||
| CONDITION_NUM | NUMBER | |||
| CRITERION_VALUE_CODE | VARCHAR2 | (30) | ||
| DATA_TYPE_CODE | VARCHAR2 | (30) | ||
| DESCRIPTION_CODE | VARCHAR2 | (30) | ||
| DESCRIPTION_TYPE_CODE | VARCHAR2 | (30) | ||
| DISPLAY_DESCRIPTION_FLAG | VARCHAR2 | (1) | ||
| DISPLAY_IN_INQUIRIES_FLAG | VARCHAR2 | (1) | ||
| DISPLAY_ORDER | NUMBER | |||
| EFFECTIVE_DATE_FROM | DATE | |||
| EFFECTIVE_DATE_TO | DATE | |||
| ENABLED_FLAG | VARCHAR2 | (1) | ||
| END_DATE_ACTIVE | DATE | |||
| ENTITY_CODE | VARCHAR2 | (30) | ||
| EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
| EVENT_CLASS_DEFAULT_FLAG | VARCHAR2 | (1) | ||
| EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
| FLEXFIELD_ASSIGN_MODE_CODE | VARCHAR2 | (30) | ||
| FLEXFIELD_SEGMENT_CODE | VARCHAR2 | (30) | ||
| FLEX_VALUE_SET_NAME | VARCHAR2 | (60) | ||
| GL_TRANSFER_MODE_CODE | VARCHAR2 | (30) | ||
| GROUPING_ORDER | NUMBER | |||
| INDEPENDENT_VALUE_CONSTANT | VARCHAR2 | (30) | ||
| INPUT_SOURCE_APP_SHORT_NAME | VARCHAR2 | (50) | ||
| INPUT_SOURCE_CODE | VARCHAR2 | (30) | ||
| INPUT_SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
| INPUT_VALUE_CONSTANT | VARCHAR2 | (240) | ||
| INPUT_VALUE_TYPE_CODE | VARCHAR2 | (30) | ||
| LEAPFROG_FLAG | VARCHAR2 | (1) | ||
| LINE_OPERATOR_CODE | VARCHAR2 | (30) | ||
| LITERAL | VARCHAR2 | (240) | ||
| LOCKING_STATUS_FLAG | VARCHAR2 | (1) | ||
| LOGICAL_OPERATOR_CODE | VARCHAR2 | (30) | ||
| LOOKUP_TYPE | VARCHAR2 | (30) | ||
| MAPPING_SET_CODE | VARCHAR2 | (30) | ||
| MERGE_DUPLICATE_CODE | VARCHAR2 | (30) | ||
| NATURAL_SIDE_CODE | VARCHAR2 | (30) | ||
| ORIG_LAST_UPDATE_DATE | VARCHAR2 | (10) | ||
| OWNER | VARCHAR2 | (4000) | ||
| BASE_VERSION_NUM | NUMBER | |||
| PRIORITY_NUM | NUMBER | |||
| PRODUCT_RULE_CODE | VARCHAR2 | (30) | ||
| PRODUCT_RULE_TYPE_CODE | VARCHAR2 | (30) | ||
| PRODUCT_RULE_VERSION | VARCHAR2 | (30) | ||
| SEGMENT_RULE_CODE | VARCHAR2 | (30) | ||
| SEGMENT_RULE_TYPE_CODE | VARCHAR2 | (30) | ||
| SOURCE_APP_SHORT_NAME | VARCHAR2 | (50) | ||
| SOURCE_CODE | VARCHAR2 | (30) | ||
| SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
| START_DATE_ACTIVE | DATE | |||
| SWITCH_SIDE_FLAG | VARCHAR2 | (1) | ||
| TRANS_COA_ID_FLEX_STRUCT_CODE | VARCHAR2 | (30) | ||
| USER_SEQUENCE | NUMBER | |||
| VALUE_CCID_ID_FLEX_STRUCT_CODE | VARCHAR2 | (30) | ||
| VALUE_CCID_SEGMENT1 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT2 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT3 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT4 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT5 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT6 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT7 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT8 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT9 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT10 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT11 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT12 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT13 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT14 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT15 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT16 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT17 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT18 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT19 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT20 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT21 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT22 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT23 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT24 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT25 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT26 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT27 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT28 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT29 | VARCHAR2 | (25) | ||
| VALUE_CCID_SEGMENT30 | VARCHAR2 | (25) | ||
| VALUE_CONSTANT | VARCHAR2 | (240) | ||
| VALUE_CODE_COMBINATION_ID | NUMBER | |||
| VALUE_FLEXFIELD_SEGMENT_CODE | VARCHAR2 | (30) | ||
| VALUE_MAPPING_SET_CODE | VARCHAR2 | (30) | ||
| VALUE_SOURCE_APP_SHORT_NAME | VARCHAR2 | (50) | ||
| VALUE_SOURCE_CODE | VARCHAR2 | (30) | ||
| VALUE_SOURCE_TYPE_CODE | VARCHAR2 | (30) | ||
| VALUE_TYPE_CODE | VARCHAR2 | (30) | ||
| VERSION_NUM | NUMBER | |||
| VERSION_COMMENT | VARCHAR2 | (240) | ||
| VIEW_APP_SHORT_NAME | VARCHAR2 | (50) | ||
| VIEW_COLUMN_NUM | NUMBER | |||
| YEAR_END_CARRY_FORWARD_CODE | VARCHAR2 | (1) | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | Yes | ||
| PROGRAM_UPDATE_DATE | DATE | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| LINE_DEFINITION_OWNER_CODE | VARCHAR2 | (30) | ||
| LINE_DEFINITION_CODE | VARCHAR2 | (30) | ||
| VALIDATION_STATUS_CODE | VARCHAR2 | (30) | ||
| BUSINESS_METHOD_CODE | VARCHAR2 | (30) | ||
| BUSINESS_CLASS_CODE | VARCHAR2 | (30) | ||
| INHERIT_DESC_FLAG | VARCHAR2 | (1) | ||
| INHERIT_ADR_FLAG | VARCHAR2 | (1) | ||
| ROUNDING_CLASS_CODE | VARCHAR2 | (30) | ||
| SIDE_CODE | VARCHAR2 | (30) | ||
| VALUE_SEGMENT_RULE_APPL_ID | NUMBER | (15) | ||
| VALUE_SEGMENT_RULE_TYPE_CODE | VARCHAR2 | (30) | ||
| VALUE_SEGMENT_RULE_CODE | VARCHAR2 | (30) | ||
| SEGMENT_RULE_APPL_ID | NUMBER | (15) | ||
| ADR_VERSION_NUM | NUMBER | (15) | ||
| VALUE_ADR_VERSION_NUM | NUMBER | (15) | ||
| SEGMENT_RULE_APPL_SN | VARCHAR2 | (50) | ||
| VALUE_SEGMENT_RULE_APPL_SN | VARCHAR2 | (50) | ||
| ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
| BUDGETARY_CONTROL_FLAG | VARCHAR2 | (1) | ||
| MPA_HEADER_DESC_CODE | VARCHAR2 | (30) | ||
| MPA_HEADER_DESC_TYPE_CODE | VARCHAR2 | (30) | ||
| MPA_NUM_JE_CODE | VARCHAR2 | (30) | ||
| MPA_GL_DATES_CODE | VARCHAR2 | (30) | ||
| MPA_PRORATION_CODE | VARCHAR2 | (30) | ||
| MPA_OPTION_CODE | VARCHAR2 | (30) | ||
| MPA_ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | (30) | ||
| MPA_ACCOUNTING_LINE_CODE | VARCHAR2 | (30) | ||
| MPA_INHERIT_AC_FLAG | VARCHAR2 | (1) | ||
| OUTPUT_FLEX_VALUE_SET_NAME | VARCHAR2 | (60) |
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#;
XLA
XLA_AAD_LOADER_DEFNS_T
APPS
XLA_AAD_LOADER_DEFNS_T
|
|
|
|