[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#;
|
|
|