[Home] [Help] [Dependency Information]

TABLE: FII.EDW_GL_BOOK_M_TEMP

Object Details

Temporary Table Details

FII.EDW_GL_BOOK_M_TEMP 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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT SOBL_BOOK_PK_KEY
,      ALL_ALL_PK_KEY
,      FABK_FA_BOOK_PK_KEY
,      SOBL_ACCT_PERIOD_TYPE
,      SOBL_BOOK_PK
,      SOBL_CHART_OF_ACCTS_ID
,      SOBL_CURRENCY_CODE
,      SOBL_GL_BOOK
,      SOBL_INSTANCE
,      SOBL_MRC_SOB_TYPE_CODE
,      SOBL_NAME
,      SOBL_PERIOD_SET_NAME
,      SOBL_TRX_CALENDAR
,      SOBL_USER_ATTRIBUTE1
,      SOBL_USER_ATTRIBUTE2
,      SOBL_USER_ATTRIBUTE3
,      SOBL_USER_ATTRIBUTE4
,      SOBL_USER_ATTRIBUTE5
,      ALL_ALL_PK
,      ALL_NAME
,      FABK_BOOK_TYPE_NAME
,      FABK_CURRENCY_CODE
,      FABK_DEPRE_CALANDAR
,      FABK_FA_BOOK
,      FABK_FA_BOOK_PK
,      FABK_INSTANCE
,      FABK_NAME
,      FABK_PRORATE_CALENDAR
,      FABK_USER_ATTRIBUTE1
,      FABK_USER_ATTRIBUTE2
,      FABK_USER_ATTRIBUTE3
,      FABK_USER_ATTRIBUTE4
,      FABK_USER_ATTRIBUTE5
,      ROW_ID1
,      ROW_ID2
,      OPERATION_CODE1
,      OPERATION_CODE2
FROM FII.EDW_GL_BOOK_M_TEMP;

Dependencies

[top of page]

FII.EDW_GL_BOOK_M_TEMP does not reference any database object

FII.EDW_GL_BOOK_M_TEMP is referenced by following:

APPS

EDW_GL_BOOK_M_TEMP