[Home] [Help] [Dependency Information]
Object Name: | XLA_AE_LINES_GT |
---|---|
Object Type: | TABLE |
Owner: | XLA |
FND Design Data: | XLA.XLA_AE_LINES_GT |
Subobject Name: | |
Status: | VALID |
XLA.XLA_AE_LINES_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XLA_AE_LINES_GT_U1 | NORMAL | UNIQUE |
LEDGER_ID
REF_AE_HEADER_ID TEMP_LINE_NUM AE_HEADER_ID HEADER_NUM EVENT_ID | |
XLA_AE_LINES_GT_N1 | NORMAL | NONUNIQUE | SL_COA_MAPPING_ID | |
XLA_AE_LINES_GT_N2 | NORMAL | NONUNIQUE |
LEDGER_ID
AE_HEADER_ID TEMP_LINE_NUM BALANCE_TYPE_CODE | |
XLA_AE_LINES_GT_N3 | NORMAL | NONUNIQUE |
LEDGER_ID
AE_HEADER_ID GAIN_OR_LOSS_FLAG CALCULATE_G_L_AMTS_FLAG | |
XLA_AE_LINES_GT_N4 | NORMAL | NONUNIQUE |
LEDGER_ID
AE_HEADER_ID BALANCE_TYPE_CODE GAIN_OR_LOSS_REF GAIN_OR_LOSS_FLAG EVENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AE_HEADER_ID | NUMBER | (15) | Yes | |
TEMP_LINE_NUM | NUMBER | (15) | Yes | |
AE_LINE_NUM | NUMBER | (15) | ||
LINE_HASH_NUM | NUMBER | (15) | ||
EVENT_ID | NUMBER | (15) | ||
REF_EVENT_ID | NUMBER | (15) | ||
REF_AE_HEADER_ID | NUMBER | (15) | Yes | |
REF_AE_LINE_NUM | NUMBER | (15) | ||
ACCOUNTING_CLASS_CODE | VARCHAR2 | (30) | ||
EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
EVENT_TYPE_CODE | VARCHAR2 | (30) | ||
LINE_DEFINITION_OWNER_CODE | VARCHAR2 | (30) | ||
LINE_DEFINITION_CODE | VARCHAR2 | (30) | ||
ACCOUNTING_LINE_TYPE_CODE | VARCHAR2 | (1) | ||
ACCOUNTING_LINE_CODE | VARCHAR2 | (30) | ||
ACCOUNTING_LINE_NAME | VARCHAR2 | (80) | ||
CODE_COMBINATION_STATUS_CODE | VARCHAR2 | (30) | ||
CODE_COMBINATION_ID | NUMBER | |||
SL_COA_MAPPING_NAME | VARCHAR2 | (33) | ||
DYNAMIC_INSERT_FLAG | VARCHAR2 | (1) | ||
SWITCH_SIDE_FLAG | VARCHAR2 | (1) | ||
SOURCE_COA_ID | NUMBER | (15) | ||
CCID_COA_ID | NUMBER | (15) | ||
SEGMENT1 | VARCHAR2 | (30) | ||
SEGMENT2 | VARCHAR2 | (30) | ||
SEGMENT3 | VARCHAR2 | (30) | ||
SEGMENT4 | VARCHAR2 | (30) | ||
SEGMENT5 | VARCHAR2 | (30) | ||
SEGMENT6 | VARCHAR2 | (30) | ||
SEGMENT7 | VARCHAR2 | (30) | ||
SEGMENT8 | VARCHAR2 | (30) | ||
SEGMENT9 | VARCHAR2 | (30) | ||
SEGMENT10 | VARCHAR2 | (30) | ||
SEGMENT11 | VARCHAR2 | (30) | ||
SEGMENT12 | VARCHAR2 | (30) | ||
SEGMENT13 | VARCHAR2 | (30) | ||
SEGMENT14 | VARCHAR2 | (30) | ||
SEGMENT15 | VARCHAR2 | (30) | ||
SEGMENT16 | VARCHAR2 | (30) | ||
SEGMENT17 | VARCHAR2 | (30) | ||
SEGMENT18 | VARCHAR2 | (30) | ||
SEGMENT19 | VARCHAR2 | (30) | ||
SEGMENT20 | VARCHAR2 | (30) | ||
SEGMENT21 | VARCHAR2 | (30) | ||
SEGMENT22 | VARCHAR2 | (30) | ||
SEGMENT23 | VARCHAR2 | (30) | ||
SEGMENT24 | VARCHAR2 | (30) | ||
SEGMENT25 | VARCHAR2 | (30) | ||
SEGMENT26 | VARCHAR2 | (30) | ||
SEGMENT27 | VARCHAR2 | (30) | ||
SEGMENT28 | VARCHAR2 | (30) | ||
SEGMENT29 | VARCHAR2 | (30) | ||
SEGMENT30 | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (1996) | ||
GL_TRANSFER_MODE_CODE | VARCHAR2 | (1) | ||
MERGE_DUPLICATE_CODE | VARCHAR2 | (1) | ||
PARTY_ID | NUMBER | (15) | ||
PARTY_SITE_ID | NUMBER | (15) | ||
PARTY_TYPE_CODE | VARCHAR2 | (1) | ||
ENTERED_AMOUNT | NUMBER | |||
LEDGER_AMOUNT | NUMBER | |||
ENTERED_DR | NUMBER | |||
ENTERED_CR | NUMBER | |||
ACCOUNTED_DR | NUMBER | |||
ACCOUNTED_CR | NUMBER | |||
STATISTICAL_AMOUNT | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | ||
CURRENCY_CONVERSION_DATE | DATE | |||
CURRENCY_CONVERSION_RATE | NUMBER | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
JGZZ_RECON_REF | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_1 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_2 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_3 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_4 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_CHAR_5 | VARCHAR2 | (240) | ||
SOURCE_DISTRIBUTION_ID_NUM_1 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_2 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_3 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_4 | NUMBER | |||
SOURCE_DISTRIBUTION_ID_NUM_5 | NUMBER | |||
SOURCE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
TAX_LINE_REF_ID | NUMBER | (15) | ||
TAX_SUMMARY_LINE_REF_ID | NUMBER | (15) | ||
TAX_REC_NREC_DIST_REF_ID | NUMBER | (15) | ||
DEFERRED_INDICATOR | VARCHAR2 | (1) | ||
DEFERRED_START_DATE | DATE | |||
DEFERRED_END_DATE | DATE | |||
DEFERRED_NO_PERIOD | NUMBER | |||
DEFERRED_PERIOD_TYPE | VARCHAR2 | (1) | ||
ANALYTICAL_BALANCE_FLAG | VARCHAR2 | (1) | ||
ANC_ID_1 | VARCHAR2 | (240) | ||
ANC_ID_2 | VARCHAR2 | (240) | ||
ANC_ID_3 | VARCHAR2 | (240) | ||
ANC_ID_4 | VARCHAR2 | (240) | ||
ANC_ID_5 | VARCHAR2 | (240) | ||
ANC_ID_6 | VARCHAR2 | (240) | ||
ANC_ID_7 | VARCHAR2 | (240) | ||
ANC_ID_8 | VARCHAR2 | (240) | ||
ANC_ID_9 | VARCHAR2 | (240) | ||
ANC_ID_10 | VARCHAR2 | (240) | ||
ANC_ID_11 | VARCHAR2 | (240) | ||
ANC_ID_12 | VARCHAR2 | (240) | ||
ANC_ID_13 | VARCHAR2 | (240) | ||
ANC_ID_14 | VARCHAR2 | (240) | ||
ANC_ID_15 | VARCHAR2 | (240) | ||
ANC_ID_16 | VARCHAR2 | (240) | ||
ANC_ID_17 | VARCHAR2 | (240) | ||
ANC_ID_18 | VARCHAR2 | (240) | ||
ANC_ID_19 | VARCHAR2 | (240) | ||
ANC_ID_20 | VARCHAR2 | (240) | ||
ANC_ID_21 | VARCHAR2 | (240) | ||
ANC_ID_22 | VARCHAR2 | (240) | ||
ANC_ID_23 | VARCHAR2 | (240) | ||
ANC_ID_24 | VARCHAR2 | (240) | ||
ANC_ID_25 | VARCHAR2 | (240) | ||
ANC_ID_26 | VARCHAR2 | (240) | ||
ANC_ID_27 | VARCHAR2 | (240) | ||
ANC_ID_28 | VARCHAR2 | (240) | ||
ANC_ID_29 | VARCHAR2 | (240) | ||
ANC_ID_30 | VARCHAR2 | (240) | ||
ANC_ID_31 | VARCHAR2 | (240) | ||
ANC_ID_32 | VARCHAR2 | (240) | ||
ANC_ID_33 | VARCHAR2 | (240) | ||
ANC_ID_34 | VARCHAR2 | (240) | ||
ANC_ID_35 | VARCHAR2 | (240) | ||
ANC_ID_36 | VARCHAR2 | (240) | ||
ANC_ID_37 | VARCHAR2 | (240) | ||
ANC_ID_38 | VARCHAR2 | (240) | ||
ANC_ID_39 | VARCHAR2 | (240) | ||
ANC_ID_40 | VARCHAR2 | (240) | ||
ANC_ID_41 | VARCHAR2 | (240) | ||
ANC_ID_42 | VARCHAR2 | (240) | ||
ANC_ID_43 | VARCHAR2 | (240) | ||
ANC_ID_44 | VARCHAR2 | (240) | ||
ANC_ID_45 | VARCHAR2 | (240) | ||
ANC_ID_46 | VARCHAR2 | (240) | ||
ANC_ID_47 | VARCHAR2 | (240) | ||
ANC_ID_48 | VARCHAR2 | (240) | ||
ANC_ID_49 | VARCHAR2 | (240) | ||
ANC_ID_50 | VARCHAR2 | (240) | ||
ANC_ID_51 | VARCHAR2 | (240) | ||
ANC_ID_52 | VARCHAR2 | (240) | ||
ANC_ID_53 | VARCHAR2 | (240) | ||
ANC_ID_54 | VARCHAR2 | (240) | ||
ANC_ID_55 | VARCHAR2 | (240) | ||
ANC_ID_56 | VARCHAR2 | (240) | ||
ANC_ID_57 | VARCHAR2 | (240) | ||
ANC_ID_58 | VARCHAR2 | (240) | ||
ANC_ID_59 | VARCHAR2 | (240) | ||
ANC_ID_60 | VARCHAR2 | (240) | ||
ANC_ID_61 | VARCHAR2 | (240) | ||
ANC_ID_62 | VARCHAR2 | (240) | ||
ANC_ID_63 | VARCHAR2 | (240) | ||
ANC_ID_64 | VARCHAR2 | (240) | ||
ANC_ID_65 | VARCHAR2 | (240) | ||
ANC_ID_66 | VARCHAR2 | (240) | ||
ANC_ID_67 | VARCHAR2 | (240) | ||
ANC_ID_68 | VARCHAR2 | (240) | ||
ANC_ID_69 | VARCHAR2 | (240) | ||
ANC_ID_70 | VARCHAR2 | (240) | ||
ANC_ID_71 | VARCHAR2 | (240) | ||
ANC_ID_72 | VARCHAR2 | (240) | ||
ANC_ID_73 | VARCHAR2 | (240) | ||
ANC_ID_74 | VARCHAR2 | (240) | ||
ANC_ID_75 | VARCHAR2 | (240) | ||
ANC_ID_76 | VARCHAR2 | (240) | ||
ANC_ID_77 | VARCHAR2 | (240) | ||
ANC_ID_78 | VARCHAR2 | (240) | ||
ANC_ID_79 | VARCHAR2 | (240) | ||
ANC_ID_80 | VARCHAR2 | (240) | ||
ANC_ID_81 | VARCHAR2 | (240) | ||
ANC_ID_82 | VARCHAR2 | (240) | ||
ANC_ID_83 | VARCHAR2 | (240) | ||
ANC_ID_84 | VARCHAR2 | (240) | ||
ANC_ID_85 | VARCHAR2 | (240) | ||
ANC_ID_86 | VARCHAR2 | (240) | ||
ANC_ID_87 | VARCHAR2 | (240) | ||
ANC_ID_88 | VARCHAR2 | (240) | ||
ANC_ID_89 | VARCHAR2 | (240) | ||
ANC_ID_90 | VARCHAR2 | (240) | ||
ANC_ID_91 | VARCHAR2 | (240) | ||
ANC_ID_92 | VARCHAR2 | (240) | ||
ANC_ID_93 | VARCHAR2 | (240) | ||
ANC_ID_94 | VARCHAR2 | (240) | ||
ANC_ID_95 | VARCHAR2 | (240) | ||
ANC_ID_96 | VARCHAR2 | (240) | ||
ANC_ID_97 | VARCHAR2 | (240) | ||
ANC_ID_98 | VARCHAR2 | (240) | ||
ANC_ID_99 | VARCHAR2 | (240) | ||
ANC_ID_100 | VARCHAR2 | (240) | ||
BALANCE_TYPE_CODE | VARCHAR2 | (30) | ||
MERGE_INDEX | NUMBER | (15) | ||
LEDGER_ID | NUMBER | (15) | ||
ENTITY_ID | NUMBER | (15) | ||
REVERSE_DIST_ID_CHAR_1 | VARCHAR2 | (240) | ||
REVERSE_DIST_ID_CHAR_2 | VARCHAR2 | (240) | ||
REVERSE_DIST_ID_CHAR_3 | VARCHAR2 | (240) | ||
REVERSE_DIST_ID_CHAR_4 | VARCHAR2 | (240) | ||
REVERSE_DIST_ID_CHAR_5 | VARCHAR2 | (240) | ||
REVERSE_DIST_ID_NUM_1 | NUMBER | (15) | ||
REVERSE_DIST_ID_NUM_2 | NUMBER | (15) | ||
REVERSE_DIST_ID_NUM_3 | NUMBER | (15) | ||
REVERSE_DIST_ID_NUM_4 | NUMBER | (15) | ||
REVERSE_DIST_ID_NUM_5 | NUMBER | (15) | ||
REVERSE_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
EVENT_NUMBER | NUMBER | (15) | ||
ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | (30) | ||
REVERSAL_CODE | VARCHAR2 | (30) | ||
CALCULATE_ACCTD_AMTS_FLAG | VARCHAR2 | (1) | ||
CALCULATE_G_L_AMTS_FLAG | VARCHAR2 | (1) | ||
GAIN_OR_LOSS_FLAG | VARCHAR2 | (1) | ||
ROUNDING_CLASS_CODE | VARCHAR2 | (30) | ||
DOCUMENT_ROUNDING_LEVEL | VARCHAR2 | (30) | ||
UNROUNDED_ACCOUNTED_DR | NUMBER | |||
UNROUNDED_ACCOUNTED_CR | NUMBER | |||
EXTRACT_LINE_NUM | NUMBER | |||
ALT_CODE_COMBINATION_ID | NUMBER | |||
ALT_SEGMENT1 | VARCHAR2 | (30) | ||
ALT_SEGMENT2 | VARCHAR2 | (30) | ||
ALT_SEGMENT3 | VARCHAR2 | (30) | ||
ALT_SEGMENT4 | VARCHAR2 | (30) | ||
ALT_SEGMENT5 | VARCHAR2 | (30) | ||
ALT_SEGMENT6 | VARCHAR2 | (30) | ||
ALT_SEGMENT7 | VARCHAR2 | (30) | ||
ALT_SEGMENT8 | VARCHAR2 | (30) | ||
ALT_SEGMENT9 | VARCHAR2 | (30) | ||
ALT_SEGMENT10 | VARCHAR2 | (30) | ||
ALT_SEGMENT11 | VARCHAR2 | (30) | ||
ALT_SEGMENT12 | VARCHAR2 | (30) | ||
ALT_SEGMENT13 | VARCHAR2 | (30) | ||
ALT_SEGMENT14 | VARCHAR2 | (30) | ||
ALT_SEGMENT15 | VARCHAR2 | (30) | ||
ALT_SEGMENT16 | VARCHAR2 | (30) | ||
ALT_SEGMENT17 | VARCHAR2 | (30) | ||
ALT_SEGMENT18 | VARCHAR2 | (30) | ||
ALT_SEGMENT19 | VARCHAR2 | (30) | ||
ALT_SEGMENT20 | VARCHAR2 | (30) | ||
ALT_SEGMENT21 | VARCHAR2 | (30) | ||
ALT_SEGMENT22 | VARCHAR2 | (30) | ||
ALT_SEGMENT23 | VARCHAR2 | (30) | ||
ALT_SEGMENT24 | VARCHAR2 | (30) | ||
ALT_SEGMENT25 | VARCHAR2 | (30) | ||
ALT_SEGMENT26 | VARCHAR2 | (30) | ||
ALT_SEGMENT27 | VARCHAR2 | (30) | ||
ALT_SEGMENT28 | VARCHAR2 | (30) | ||
ALT_SEGMENT29 | VARCHAR2 | (30) | ||
ALT_SEGMENT30 | VARCHAR2 | (30) | ||
ALT_CCID_STATUS_CODE | VARCHAR2 | (30) | ||
UNROUNDED_ENTERED_DR | NUMBER | |||
UNROUNDED_ENTERED_CR | NUMBER | |||
DOC_ROUNDING_ENTERED_AMT | NUMBER | |||
DOC_ROUNDING_ACCTD_AMT | NUMBER | |||
ENTERED_CURRENCY_MAU | NUMBER | |||
BUSINESS_METHOD_CODE | VARCHAR2 | (30) | ||
BUSINESS_CLASS_CODE | VARCHAR2 | (30) | ||
INHERIT_DESC_FLAG | VARCHAR2 | (1) | Yes | |
BFLOW_APPLICATION_ID | NUMBER | (15) | ||
BFLOW_ENTITY_CODE | VARCHAR2 | (30) | ||
BFLOW_SOURCE_ID_NUM_1 | NUMBER | (15) | ||
BFLOW_SOURCE_ID_NUM_2 | NUMBER | (15) | ||
BFLOW_SOURCE_ID_NUM_3 | NUMBER | (15) | ||
BFLOW_SOURCE_ID_NUM_4 | NUMBER | (15) | ||
BFLOW_SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | ||
BFLOW_SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | ||
BFLOW_SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | ||
BFLOW_SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | ||
BFLOW_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
BFLOW_DIST_ID_NUM_1 | NUMBER | (15) | ||
BFLOW_DIST_ID_NUM_2 | NUMBER | (15) | ||
BFLOW_DIST_ID_NUM_3 | NUMBER | (15) | ||
BFLOW_DIST_ID_NUM_4 | NUMBER | (15) | ||
BFLOW_DIST_ID_NUM_5 | NUMBER | (15) | ||
BFLOW_DIST_ID_CHAR_1 | VARCHAR2 | (30) | ||
BFLOW_DIST_ID_CHAR_2 | VARCHAR2 | (30) | ||
BFLOW_DIST_ID_CHAR_3 | VARCHAR2 | (30) | ||
BFLOW_DIST_ID_CHAR_4 | VARCHAR2 | (30) | ||
BFLOW_DIST_ID_CHAR_5 | VARCHAR2 | (30) | ||
BFLOW_PRIOR_ENTRY_STATUS_CODE | VARCHAR2 | (30) | ||
SL_COA_MAPPING_ID | NUMBER | |||
NATURAL_SIDE_CODE | VARCHAR2 | (30) | ||
TEMP_CURRENCY_CODE | VARCHAR2 | (15) | ||
TEMP_REF_AE_HEADER_ID | NUMBER | (15) | ||
REF_TEMP_LINE_NUM | NUMBER | (15) | ||
APPLIED_TO_ENTITY_ID | NUMBER | (15) | ||
ALLOC_TO_APPLICATION_ID | NUMBER | (15) | ||
ALLOC_TO_ENTITY_CODE | VARCHAR2 | (30) | ||
ALLOC_TO_SOURCE_ID_NUM_1 | NUMBER | (15) | ||
ALLOC_TO_SOURCE_ID_NUM_2 | NUMBER | (15) | ||
ALLOC_TO_SOURCE_ID_NUM_3 | NUMBER | (15) | ||
ALLOC_TO_SOURCE_ID_NUM_4 | NUMBER | (15) | ||
ALLOC_TO_SOURCE_ID_CHAR_1 | VARCHAR2 | (30) | ||
ALLOC_TO_SOURCE_ID_CHAR_2 | VARCHAR2 | (30) | ||
ALLOC_TO_SOURCE_ID_CHAR_3 | VARCHAR2 | (30) | ||
ALLOC_TO_SOURCE_ID_CHAR_4 | VARCHAR2 | (30) | ||
ALLOC_TO_DISTRIBUTION_TYPE | VARCHAR2 | (30) | ||
ALLOC_TO_DIST_ID_NUM_1 | NUMBER | (15) | ||
ALLOC_TO_DIST_ID_NUM_2 | NUMBER | (15) | ||
ALLOC_TO_DIST_ID_NUM_3 | NUMBER | (15) | ||
ALLOC_TO_DIST_ID_NUM_4 | NUMBER | (15) | ||
ALLOC_TO_DIST_ID_NUM_5 | NUMBER | (15) | ||
ALLOC_TO_DIST_ID_CHAR_1 | VARCHAR2 | (30) | ||
ALLOC_TO_DIST_ID_CHAR_2 | VARCHAR2 | (30) | ||
ALLOC_TO_DIST_ID_CHAR_3 | VARCHAR2 | (30) | ||
ALLOC_TO_DIST_ID_CHAR_4 | VARCHAR2 | (30) | ||
ALLOC_TO_DIST_ID_CHAR_5 | VARCHAR2 | (30) | ||
MPA_ACCRUAL_ENTRY_FLAG | VARCHAR2 | (1) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
HEADER_NUM | NUMBER | (15) | ||
ACCOUNTING_DATE | DATE | |||
MULTIPERIOD_END_DATE | DATE | |||
MULTIPERIOD_START_DATE | DATE | |||
MULTIPERIOD_OPTION_FLAG | VARCHAR2 | (1) | ||
GAIN_OR_LOSS_REF | VARCHAR2 | (30) | Used to group entry lines together when calculating gain/loss. | |
BFLOW_APPLIED_TO_AMOUNT | NUMBER | Used in calculating the accounted amount when foreign exchange is used in business flow. | ||
OVERRIDE_ACCTD_AMT_FLAG | VARCHAR2 | (1) | ||
DERIVED_EXCH_RATE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT AE_HEADER_ID
, TEMP_LINE_NUM
, AE_LINE_NUM
, LINE_HASH_NUM
, EVENT_ID
, REF_EVENT_ID
, REF_AE_HEADER_ID
, REF_AE_LINE_NUM
, ACCOUNTING_CLASS_CODE
, EVENT_CLASS_CODE
, EVENT_TYPE_CODE
, LINE_DEFINITION_OWNER_CODE
, LINE_DEFINITION_CODE
, ACCOUNTING_LINE_TYPE_CODE
, ACCOUNTING_LINE_CODE
, ACCOUNTING_LINE_NAME
, CODE_COMBINATION_STATUS_CODE
, CODE_COMBINATION_ID
, SL_COA_MAPPING_NAME
, DYNAMIC_INSERT_FLAG
, SWITCH_SIDE_FLAG
, SOURCE_COA_ID
, CCID_COA_ID
, SEGMENT1
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, SEGMENT11
, SEGMENT12
, SEGMENT13
, SEGMENT14
, SEGMENT15
, SEGMENT16
, SEGMENT17
, SEGMENT18
, SEGMENT19
, SEGMENT20
, SEGMENT21
, SEGMENT22
, SEGMENT23
, SEGMENT24
, SEGMENT25
, SEGMENT26
, SEGMENT27
, SEGMENT28
, SEGMENT29
, SEGMENT30
, DESCRIPTION
, GL_TRANSFER_MODE_CODE
, MERGE_DUPLICATE_CODE
, PARTY_ID
, PARTY_SITE_ID
, PARTY_TYPE_CODE
, ENTERED_AMOUNT
, LEDGER_AMOUNT
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, STATISTICAL_AMOUNT
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, USSGL_TRANSACTION_CODE
, JGZZ_RECON_REF
, SOURCE_DISTRIBUTION_ID_CHAR_1
, SOURCE_DISTRIBUTION_ID_CHAR_2
, SOURCE_DISTRIBUTION_ID_CHAR_3
, SOURCE_DISTRIBUTION_ID_CHAR_4
, SOURCE_DISTRIBUTION_ID_CHAR_5
, SOURCE_DISTRIBUTION_ID_NUM_1
, SOURCE_DISTRIBUTION_ID_NUM_2
, SOURCE_DISTRIBUTION_ID_NUM_3
, SOURCE_DISTRIBUTION_ID_NUM_4
, SOURCE_DISTRIBUTION_ID_NUM_5
, SOURCE_DISTRIBUTION_TYPE
, TAX_LINE_REF_ID
, TAX_SUMMARY_LINE_REF_ID
, TAX_REC_NREC_DIST_REF_ID
, DEFERRED_INDICATOR
, DEFERRED_START_DATE
, DEFERRED_END_DATE
, DEFERRED_NO_PERIOD
, DEFERRED_PERIOD_TYPE
, ANALYTICAL_BALANCE_FLAG
, ANC_ID_1
, ANC_ID_2
, ANC_ID_3
, ANC_ID_4
, ANC_ID_5
, ANC_ID_6
, ANC_ID_7
, ANC_ID_8
, ANC_ID_9
, ANC_ID_10
, ANC_ID_11
, ANC_ID_12
, ANC_ID_13
, ANC_ID_14
, ANC_ID_15
, ANC_ID_16
, ANC_ID_17
, ANC_ID_18
, ANC_ID_19
, ANC_ID_20
, ANC_ID_21
, ANC_ID_22
, ANC_ID_23
, ANC_ID_24
, ANC_ID_25
, ANC_ID_26
, ANC_ID_27
, ANC_ID_28
, ANC_ID_29
, ANC_ID_30
, ANC_ID_31
, ANC_ID_32
, ANC_ID_33
, ANC_ID_34
, ANC_ID_35
, ANC_ID_36
, ANC_ID_37
, ANC_ID_38
, ANC_ID_39
, ANC_ID_40
, ANC_ID_41
, ANC_ID_42
, ANC_ID_43
, ANC_ID_44
, ANC_ID_45
, ANC_ID_46
, ANC_ID_47
, ANC_ID_48
, ANC_ID_49
, ANC_ID_50
, ANC_ID_51
, ANC_ID_52
, ANC_ID_53
, ANC_ID_54
, ANC_ID_55
, ANC_ID_56
, ANC_ID_57
, ANC_ID_58
, ANC_ID_59
, ANC_ID_60
, ANC_ID_61
, ANC_ID_62
, ANC_ID_63
, ANC_ID_64
, ANC_ID_65
, ANC_ID_66
, ANC_ID_67
, ANC_ID_68
, ANC_ID_69
, ANC_ID_70
, ANC_ID_71
, ANC_ID_72
, ANC_ID_73
, ANC_ID_74
, ANC_ID_75
, ANC_ID_76
, ANC_ID_77
, ANC_ID_78
, ANC_ID_79
, ANC_ID_80
, ANC_ID_81
, ANC_ID_82
, ANC_ID_83
, ANC_ID_84
, ANC_ID_85
, ANC_ID_86
, ANC_ID_87
, ANC_ID_88
, ANC_ID_89
, ANC_ID_90
, ANC_ID_91
, ANC_ID_92
, ANC_ID_93
, ANC_ID_94
, ANC_ID_95
, ANC_ID_96
, ANC_ID_97
, ANC_ID_98
, ANC_ID_99
, ANC_ID_100
, BALANCE_TYPE_CODE
, MERGE_INDEX
, LEDGER_ID
, ENTITY_ID
, REVERSE_DIST_ID_CHAR_1
, REVERSE_DIST_ID_CHAR_2
, REVERSE_DIST_ID_CHAR_3
, REVERSE_DIST_ID_CHAR_4
, REVERSE_DIST_ID_CHAR_5
, REVERSE_DIST_ID_NUM_1
, REVERSE_DIST_ID_NUM_2
, REVERSE_DIST_ID_NUM_3
, REVERSE_DIST_ID_NUM_4
, REVERSE_DIST_ID_NUM_5
, REVERSE_DISTRIBUTION_TYPE
, EVENT_NUMBER
, ACCOUNTING_ENTRY_STATUS_CODE
, REVERSAL_CODE
, CALCULATE_ACCTD_AMTS_FLAG
, CALCULATE_G_L_AMTS_FLAG
, GAIN_OR_LOSS_FLAG
, ROUNDING_CLASS_CODE
, DOCUMENT_ROUNDING_LEVEL
, UNROUNDED_ACCOUNTED_DR
, UNROUNDED_ACCOUNTED_CR
, EXTRACT_LINE_NUM
, ALT_CODE_COMBINATION_ID
, ALT_SEGMENT1
, ALT_SEGMENT2
, ALT_SEGMENT3
, ALT_SEGMENT4
, ALT_SEGMENT5
, ALT_SEGMENT6
, ALT_SEGMENT7
, ALT_SEGMENT8
, ALT_SEGMENT9
, ALT_SEGMENT10
, ALT_SEGMENT11
, ALT_SEGMENT12
, ALT_SEGMENT13
, ALT_SEGMENT14
, ALT_SEGMENT15
, ALT_SEGMENT16
, ALT_SEGMENT17
, ALT_SEGMENT18
, ALT_SEGMENT19
, ALT_SEGMENT20
, ALT_SEGMENT21
, ALT_SEGMENT22
, ALT_SEGMENT23
, ALT_SEGMENT24
, ALT_SEGMENT25
, ALT_SEGMENT26
, ALT_SEGMENT27
, ALT_SEGMENT28
, ALT_SEGMENT29
, ALT_SEGMENT30
, ALT_CCID_STATUS_CODE
, UNROUNDED_ENTERED_DR
, UNROUNDED_ENTERED_CR
, DOC_ROUNDING_ENTERED_AMT
, DOC_ROUNDING_ACCTD_AMT
, ENTERED_CURRENCY_MAU
, BUSINESS_METHOD_CODE
, BUSINESS_CLASS_CODE
, INHERIT_DESC_FLAG
, BFLOW_APPLICATION_ID
, BFLOW_ENTITY_CODE
, BFLOW_SOURCE_ID_NUM_1
, BFLOW_SOURCE_ID_NUM_2
, BFLOW_SOURCE_ID_NUM_3
, BFLOW_SOURCE_ID_NUM_4
, BFLOW_SOURCE_ID_CHAR_1
, BFLOW_SOURCE_ID_CHAR_2
, BFLOW_SOURCE_ID_CHAR_3
, BFLOW_SOURCE_ID_CHAR_4
, BFLOW_DISTRIBUTION_TYPE
, BFLOW_DIST_ID_NUM_1
, BFLOW_DIST_ID_NUM_2
, BFLOW_DIST_ID_NUM_3
, BFLOW_DIST_ID_NUM_4
, BFLOW_DIST_ID_NUM_5
, BFLOW_DIST_ID_CHAR_1
, BFLOW_DIST_ID_CHAR_2
, BFLOW_DIST_ID_CHAR_3
, BFLOW_DIST_ID_CHAR_4
, BFLOW_DIST_ID_CHAR_5
, BFLOW_PRIOR_ENTRY_STATUS_CODE
, SL_COA_MAPPING_ID
, NATURAL_SIDE_CODE
, TEMP_CURRENCY_CODE
, TEMP_REF_AE_HEADER_ID
, REF_TEMP_LINE_NUM
, APPLIED_TO_ENTITY_ID
, ALLOC_TO_APPLICATION_ID
, ALLOC_TO_ENTITY_CODE
, ALLOC_TO_SOURCE_ID_NUM_1
, ALLOC_TO_SOURCE_ID_NUM_2
, ALLOC_TO_SOURCE_ID_NUM_3
, ALLOC_TO_SOURCE_ID_NUM_4
, ALLOC_TO_SOURCE_ID_CHAR_1
, ALLOC_TO_SOURCE_ID_CHAR_2
, ALLOC_TO_SOURCE_ID_CHAR_3
, ALLOC_TO_SOURCE_ID_CHAR_4
, ALLOC_TO_DISTRIBUTION_TYPE
, ALLOC_TO_DIST_ID_NUM_1
, ALLOC_TO_DIST_ID_NUM_2
, ALLOC_TO_DIST_ID_NUM_3
, ALLOC_TO_DIST_ID_NUM_4
, ALLOC_TO_DIST_ID_NUM_5
, ALLOC_TO_DIST_ID_CHAR_1
, ALLOC_TO_DIST_ID_CHAR_2
, ALLOC_TO_DIST_ID_CHAR_3
, ALLOC_TO_DIST_ID_CHAR_4
, ALLOC_TO_DIST_ID_CHAR_5
, MPA_ACCRUAL_ENTRY_FLAG
, ENCUMBRANCE_TYPE_ID
, HEADER_NUM
, ACCOUNTING_DATE
, MULTIPERIOD_END_DATE
, MULTIPERIOD_START_DATE
, MULTIPERIOD_OPTION_FLAG
, GAIN_OR_LOSS_REF
, BFLOW_APPLIED_TO_AMOUNT
, OVERRIDE_ACCTD_AMT_FLAG
, DERIVED_EXCH_RATE
FROM XLA.XLA_AE_LINES_GT;
XLA.XLA_AE_LINES_GT does not reference any database object
XLA.XLA_AE_LINES_GT is referenced by following:
|
|
|