eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: XLA.XLA_VALIDATION_HDRS_GT

Object Details

Object Name:	XLA_VALIDATION_HDRS_GT
Object Type:	TABLE
Owner:	XLA
Subobject Name:
Status:	VALID

Temporary Table Details

XLA.XLA_VALIDATION_HDRS_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_VALIDATION_HDRS_GT_U1	NORMAL	UNIQUE		AE_HEADER_ID
XLA_VALIDATION_HDRS_GT_N1	NORMAL	NONUNIQUE		ERROR_FLAG AE_HEADER_ID

Columns

Name	Datatype	Length	Mandatory
APPLICATION_ID	NUMBER	(15)	Yes
EVENT_ID	NUMBER	(15)	Yes
ENTITY_ID	NUMBER	(15)	Yes
LEDGER_ID	NUMBER	(15)	Yes
LEDGER_CATEGORY_CODE	VARCHAR2	(30)
AE_HEADER_ID	NUMBER	(15)	Yes
ACCOUNTING_BATCH_ID	NUMBER	(15)
BALANCE_TYPE_CODE	VARCHAR2	(1)	Yes
BUDGET_VERSION_ID	NUMBER	(15)
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
ACCOUNTING_DATE	DATE		Yes
REFERENCE_DATE	DATE
JE_CATEGORY_NAME	VARCHAR2	(25)
LEDGER_NAME	VARCHAR2	(30)	Yes
LEDGER_CURRENCY_CODE	VARCHAR2	(15)	Yes
LEDGER_COA_ID	NUMBER	(15)	Yes
BAL_SEG_COLUMN_NAME	VARCHAR2	(25)
MGT_SEG_COLUMN_NAME	VARCHAR2	(25)
ALLOW_INTERCOMPANY_POST_FLAG	VARCHAR2	(1)
BAL_SEG_VALUE_OPTION_CODE	VARCHAR2	(1)
MGT_SEG_VALUE_OPTION_CODE	VARCHAR2	(1)
GL_DATE_VALID_FLAG	VARCHAR2	(1)
REFERENCE_DATE_VALID_FLAG	VARCHAR2	(1)
BUDGET_VERSION_STATUS	VARCHAR2	(1)
ENCUM_TYPE_ENABLED_FLAG	VARCHAR2	(1)
BUDGET_PERIOD_VALID_FLAG	VARCHAR2	(1)
ENCUM_PERIOD_VALID_FLAG	VARCHAR2	(1)
SLA_BAL_BY_LEDGER_CURR_FLAG	VARCHAR2	(1)
SLA_LEDGER_CUR_BAL_SUS_CCID	NUMBER	(15)
SLA_ENTERED_CUR_BAL_SUS_CCID	NUMBER	(15)
DOC_SEQUENCE_ID_VALID_FLAG	VARCHAR2	(1)
DOC_CATEGORY_CODE_VALID_FLAG	VARCHAR2	(1)
DOC_SEQUENCE_ID	NUMBER	(15)
DOC_CATEGORY_CODE	VARCHAR2	(30)
EVENT_TYPE_CODE	VARCHAR2	(30)
PRODUCT_RULE_CODE	VARCHAR2	(30)
PRODUCT_RULE_TYPE_CODE	VARCHAR2	(1)
ERROR_FLAG	VARCHAR2	(1)

Query Text

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


SELECT APPLICATION_ID
,      EVENT_ID
,      ENTITY_ID
,      LEDGER_ID
,      LEDGER_CATEGORY_CODE
,      AE_HEADER_ID
,      ACCOUNTING_BATCH_ID
,      BALANCE_TYPE_CODE
,      BUDGET_VERSION_ID
,      ENCUMBRANCE_TYPE_ID
,      ACCOUNTING_DATE
,      REFERENCE_DATE
,      JE_CATEGORY_NAME
,      LEDGER_NAME
,      LEDGER_CURRENCY_CODE
,      LEDGER_COA_ID
,      BAL_SEG_COLUMN_NAME
,      MGT_SEG_COLUMN_NAME
,      ALLOW_INTERCOMPANY_POST_FLAG
,      BAL_SEG_VALUE_OPTION_CODE
,      MGT_SEG_VALUE_OPTION_CODE
,      GL_DATE_VALID_FLAG
,      REFERENCE_DATE_VALID_FLAG
,      BUDGET_VERSION_STATUS
,      ENCUM_TYPE_ENABLED_FLAG
,      BUDGET_PERIOD_VALID_FLAG
,      ENCUM_PERIOD_VALID_FLAG
,      SLA_BAL_BY_LEDGER_CURR_FLAG
,      SLA_LEDGER_CUR_BAL_SUS_CCID
,      SLA_ENTERED_CUR_BAL_SUS_CCID
,      DOC_SEQUENCE_ID_VALID_FLAG
,      DOC_CATEGORY_CODE_VALID_FLAG
,      DOC_SEQUENCE_ID
,      DOC_CATEGORY_CODE
,      EVENT_TYPE_CODE
,      PRODUCT_RULE_CODE
,      PRODUCT_RULE_TYPE_CODE
,      ERROR_FLAG
FROM XLA.XLA_VALIDATION_HDRS_GT;

Dependencies

[top of page]

XLA.XLA_VALIDATION_HDRS_GT does not reference any database object

XLA.XLA_VALIDATION_HDRS_GT is referenced by following:

APPS: XLA_VALIDATION_HDRS_GT