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: APPS.OKL_XLA_ACC_DATA_GT

Object Details

Object Name:	OKL_XLA_ACC_DATA_GT
Object Type:	TABLE
Owner:	APPS
FND Design Data:	OKL.OKL_XLA_ACC_DATA_GT
Subobject Name:
Status:	VALID

Temporary Table Details

APPS.OKL_XLA_ACC_DATA_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

Columns

Name	Datatype	Length
TCN_ID	NUMBER
LEGAL_ENTITY_ID	NUMBER
ORG_ID	NUMBER
TRX_NUMBER	VARCHAR2	(30)
REPRESENTATION_CODE	VARCHAR2	(20)
DATE_TRANSACTION_OCCURRED	DATE
TCL_ID	NUMBER
ACCOUNTING_EVENT_CLASS_CODE	VARCHAR2	(30)
ENTITY_CODE	VARCHAR2	(19)
ACCOUNTING_CLASS_CODE	VARCHAR2	(23)
TAD_ID	NUMBER
SET_OF_BOOKS_ID	NUMBER
TYPE_OF_EVENT	VARCHAR2	(7)
LINE_NUM	NUMBER
EVENT_TYPE_CODE	VARCHAR2	(27)
EVENT_DATE	DATE
PERIOD_NAME	VARCHAR2	(45)
GL_TRANSFER_FLAG	VARCHAR2	(3)
JE_CATEGORY_NAME	VARCHAR2	(90)
AEH_DESCRIPTION	VARCHAR2	(720)
AE_HEADER_ID	NUMBER
CODE_COMBINATION_ID	NUMBER
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
GL_SL_LINK_ID	NUMBER
CURRENCY_CODE	VARCHAR2	(3)
CURRENCY_CONVERSION_DATE	DATE
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
AEL_DESCRIPTION	VARCHAR2	(720)
ACCOUNT_OVERLAY_SOURCE_ID	NUMBER

Query Text

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


SELECT TCN_ID
,      LEGAL_ENTITY_ID
,      ORG_ID
,      TRX_NUMBER
,      REPRESENTATION_CODE
,      DATE_TRANSACTION_OCCURRED
,      TCL_ID
,      ACCOUNTING_EVENT_CLASS_CODE
,      ENTITY_CODE
,      ACCOUNTING_CLASS_CODE
,      TAD_ID
,      SET_OF_BOOKS_ID
,      TYPE_OF_EVENT
,      LINE_NUM
,      EVENT_TYPE_CODE
,      EVENT_DATE
,      PERIOD_NAME
,      GL_TRANSFER_FLAG
,      JE_CATEGORY_NAME
,      AEH_DESCRIPTION
,      AE_HEADER_ID
,      CODE_COMBINATION_ID
,      ENTERED_DR
,      ENTERED_CR
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      GL_SL_LINK_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_TYPE
,      AEL_DESCRIPTION
,      ACCOUNT_OVERLAY_SOURCE_ID
FROM APPS.OKL_XLA_ACC_DATA_GT;

Dependencies

[top of page]

APPS.OKL_XLA_ACC_DATA_GT does not reference any database object

APPS.OKL_XLA_ACC_DATA_GT is not referenced by any database object