[Home] [Help] [Dependency Information]

TABLE: XLA.XLA_VALIDATION_LINES_GT

Object Details

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

Temporary Table Details

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

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_VALIDATION_LINES_GT_N1	NORMAL	NONUNIQUE		ERROR_FLAG AE_HEADER_ID
XLA_VALIDATION_LINES_GT_N2	NORMAL	NONUNIQUE		AE_HEADER_ID AE_LINE_NUM

Columns

Query Text

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

SELECT EVENT_ID
,      ENTITY_ID
,      AE_HEADER_ID
,      AE_LINE_NUM
,      DISPLAYED_LINE_NUMBER
,      MAX_AE_LINE_NUM
,      MAX_DISPLAYED_LINE_NUMBER
,      ACCOUNTING_BATCH_ID
,      ACCOUNTING_DATE
,      ACCOUNTING_CLASS_CODE
,      BALANCE_TYPE_CODE
,      JE_CATEGORY_NAME
,      BUDGET_VERSION_ID
,      LEDGER_ID
,      LEDGER_CATEGORY_CODE
,      LEDGER_NAME
,      LEDGER_CURRENCY_CODE
,      LEDGER_COA_ID
,      BAL_SEG_COLUMN_NAME
,      MGT_SEG_COLUMN_NAME
,      ALLOW_INTERCOMPANY_POST_FLAG
,      SLA_BAL_BY_LEDGER_CURR_FLAG
,      SLA_LEDGER_CUR_BAL_SUS_CCID
,      SLA_ENTERED_CUR_BAL_SUS_CCID
,      ENTERED_CURRENCY_CODE
,      ENTERED_CURR_ENABLED_FLAG
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      PARTY_TYPE_CODE
,      PARTY_ID
,      PARTY_SITE_ID
,      PARTY_ID_VALID_FLAG
,      PARTY_SITE_ID_VALID_FLAG
,      CODE_COMBINATION_ID
,      BAL_SEG_VALUE
,      MGT_SEG_VALUE
,      CCID_COA_ID
,      CCID_SUMMARY_FLAG
,      CCID_ENABLED_FLAG
,      DETAIL_POSTING_ALLOWED_FLAG
,      DETAIL_BUDGETING_ALLOWED_FLAG
,      CONTROL_ACCOUNT_ENABLED_FLAG
,      BUDGET_CCID_VALID_FLAG
,      ACCESS_SET_SV_VALID_FLAG
,      BAL_SEG_VALID_STATUS
,      MGT_SEG_VALID_STATUS
,      VALIDATE_IND_SEG_VAL_FLAG
,      BALANCING_LINE_TYPE
,      EVENT_TYPE_CODE
,      PRODUCT_RULE_CODE
,      PRODUCT_RULE_TYPE_CODE
,      ERROR_FLAG
,      UNROUNDED_ACCOUNTED_DR
,      UNROUNDED_ACCOUNTED_CR
,      SUBSTITUTED_CCID
,      GAIN_OR_LOSS_FLAG
,      SUBSTITUTED_BY_SUSPENSE_FLAG
,      SUSPENSE_CODE_COMBINATION_ID
,      UNROUNDED_ENTERED_CR
,      UNROUNDED_ENTERED_DR
,      ENTERED_CURRENCY_MAU
,      ENCUMBRANCE_TYPE_ID
,      ACCOUNTING_ENTRY_STATUS_CODE
,      FUNDS_STATUS_CODE
,      PERIOD_NAME
,      COST_CENTER_SEG_VALUE
,      NATURAL_ACCOUNT_SEG_VALUE
FROM XLA.XLA_VALIDATION_LINES_GT;

Dependencies

[top of page]

XLA.XLA_VALIDATION_LINES_GT does not reference any database object

XLA.XLA_VALIDATION_LINES_GT is referenced by following:

APPS

XLA_VALIDATION_LINES_GT