[Home] [Help] [Dependency Information]

TABLE: XLA.XLA_AE_HEADERS_GT

Object Details

Object Name:	XLA_AE_HEADERS_GT
Object Type:	TABLE
Owner:	XLA
FND Design Data:	XLA.XLA_AE_HEADERS_GT
Subobject Name:
Status:	VALID

Temporary Table Details

XLA.XLA_AE_HEADERS_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.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_AE_HEADERS_GT_U1	NORMAL	UNIQUE		AE_HEADER_ID LEDGER_ID BALANCE_TYPE_CODE HEADER_NUM
XLA_AE_HEADERS_GT_N1	NORMAL	NONUNIQUE		PARENT_HEADER_ID

Columns

Query Text

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

SELECT AE_HEADER_ID
,      LEDGER_ID
,      ENTITY_ID
,      EVENT_ID
,      EVENT_TYPE_CODE
,      ACCOUNTING_DATE
,      PERIOD_NAME
,      JE_CATEGORY_NAME
,      ACCOUNTING_ENTRY_STATUS_CODE
,      ACCOUNTING_ENTRY_TYPE_CODE
,      PRODUCT_RULE_TYPE_CODE
,      PRODUCT_RULE_CODE
,      PRODUCT_RULE_VERSION
,      AMB_CONTEXT_CODE
,      DESCRIPTION
,      BALANCE_TYPE_CODE
,      BUDGET_VERSION_ID
,      ENCUMBRANCE_TYPE_ID
,      DOC_SEQUENCE_ID
,      DOC_SEQUENCE_VALUE
,      DOC_CATEGORY_CODE
,      PERIOD_YEAR
,      PERIOD_CLOSING_STATUS
,      GL_TRANSFER_STATUS_CODE
,      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
,      EVENT_STATUS_CODE
,      EVENT_NUMBER
,      HEADER_NUM
,      PARENT_HEADER_ID
,      PARENT_AE_LINE_NUM
,      ACC_REV_GL_DATE_OPTION
,      FIRST_DAY_NEXT_GL_PERIOD
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      ACCRUAL_REVERSAL_FLAG
,      FUNDS_STATUS_CODE
FROM XLA.XLA_AE_HEADERS_GT;

Dependencies

[top of page]

XLA.XLA_AE_HEADERS_GT does not reference any database object

XLA.XLA_AE_HEADERS_GT is referenced by following:

APPS

XLA_AE_HEADERS_GT