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


TABLE: FA.FA_XLA_EXT_HEADERS_B_GT

Object Details
Object Name: FA_XLA_EXT_HEADERS_B_GT
Object Type: TABLE
Owner: FA
FND Design Data: TableOFA.FA_XLA_EXT_HEADERS_B_GT
Subobject Name:
Status: VALID

Temporary Table Details

FA.FA_XLA_EXT_HEADERS_B_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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
FA_XLA_EXT_HEADERS_B_GT_U1 NORMAL UNIQUE Tablespace ColumnEVENT_ID
Columns
Name Datatype Length Mandatory Comments
EVENT_ID NUMBER (38) Yes
COST_OF_REMOVAL_CLEARING_ACCT VARCHAR2 (25)
COST_OF_REMOVAL_GAIN_ACCT VARCHAR2 (25)
COST_OF_REMOVAL_LOSS_ACCT VARCHAR2 (25)
DEFERRED_DEPRN_EXPENSE_ACCT VARCHAR2 (25)
DEFERRED_DEPRN_RESERVE_ACCT VARCHAR2 (25)
NBV_RETIRED_GAIN_ACCT VARCHAR2 (25)
NBV_RETIRED_LOSS_ACCT VARCHAR2 (25)
PROCEEDS_OF_SALE_CLEARING_ACCT VARCHAR2 (25)
PROCEEDS_OF_SALE_GAIN_ACCT VARCHAR2 (25)
PROCEEDS_OF_SALE_LOSS_ACCT VARCHAR2 (25)
REVAL_RSV_RETIRED_GAIN_ACCT VARCHAR2 (25)
REVAL_RSV_RETIRED_LOSS_ACCT VARCHAR2 (25)
DEPRN_ADJUSTMENT_ACCT VARCHAR2 (25)
DEFAULT_CCID NUMBER (15)
BOOK_TYPE_CODE VARCHAR2 (15)
BOOK_DESCRIPTION VARCHAR2 (30)
AP_INTERCOMPANY_ACCT VARCHAR2 (25)
AR_INTERCOMPANY_ACCT VARCHAR2 (25)
ORG_ID NUMBER (15)
BOOK_CONTROLS_ATTR1 VARCHAR2 (150)
BOOK_CONTROLS_ATTR2 VARCHAR2 (150)
BOOK_CONTROLS_ATTR3 VARCHAR2 (150)
BOOK_CONTROLS_ATTR4 VARCHAR2 (150)
BOOK_CONTROLS_ATTR5 VARCHAR2 (150)
BOOK_CONTROLS_ATTR6 VARCHAR2 (150)
BOOK_CONTROLS_ATTR7 VARCHAR2 (150)
BOOK_CONTROLS_ATTR8 VARCHAR2 (150)
BOOK_CONTROLS_ATTR9 VARCHAR2 (150)
BOOK_CONTROLS_ATTR10 VARCHAR2 (150)
BOOK_CONTROLS_ATTR11 VARCHAR2 (150)
BOOK_CONTROLS_ATTR12 VARCHAR2 (150)
BOOK_CONTROLS_ATTR13 VARCHAR2 (150)
BOOK_CONTROLS_ATTR14 VARCHAR2 (150)
BOOK_CONTROLS_ATTR15 VARCHAR2 (150)
PERIOD_NAME VARCHAR2 (15)
PERIOD_CLOSE_DATE DATE

PERIOD_COUNTER NUMBER (15)
BOOK_CONTROLS_GLOBAL_ATTR1 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR2 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR3 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR4 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR5 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR6 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR7 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR8 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR9 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR10 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR11 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR12 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR13 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR14 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR15 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR16 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR17 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR18 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR19 VARCHAR2 (150)
BOOK_CONTROLS_GLOBAL_ATTR20 VARCHAR2 (150)
TRANSFER_TO_GL_FLAG VARCHAR2 (1)
REVERSAL_FLAG VARCHAR2 (1)
ACCOUNTING_DATE DATE

SORP_ENABLED_FLAG VARCHAR2 (1)
Query Text

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


SELECT EVENT_ID
,      COST_OF_REMOVAL_CLEARING_ACCT
,      COST_OF_REMOVAL_GAIN_ACCT
,      COST_OF_REMOVAL_LOSS_ACCT
,      DEFERRED_DEPRN_EXPENSE_ACCT
,      DEFERRED_DEPRN_RESERVE_ACCT
,      NBV_RETIRED_GAIN_ACCT
,      NBV_RETIRED_LOSS_ACCT
,      PROCEEDS_OF_SALE_CLEARING_ACCT
,      PROCEEDS_OF_SALE_GAIN_ACCT
,      PROCEEDS_OF_SALE_LOSS_ACCT
,      REVAL_RSV_RETIRED_GAIN_ACCT
,      REVAL_RSV_RETIRED_LOSS_ACCT
,      DEPRN_ADJUSTMENT_ACCT
,      DEFAULT_CCID
,      BOOK_TYPE_CODE
,      BOOK_DESCRIPTION
,      AP_INTERCOMPANY_ACCT
,      AR_INTERCOMPANY_ACCT
,      ORG_ID
,      BOOK_CONTROLS_ATTR1
,      BOOK_CONTROLS_ATTR2
,      BOOK_CONTROLS_ATTR3
,      BOOK_CONTROLS_ATTR4
,      BOOK_CONTROLS_ATTR5
,      BOOK_CONTROLS_ATTR6
,      BOOK_CONTROLS_ATTR7
,      BOOK_CONTROLS_ATTR8
,      BOOK_CONTROLS_ATTR9
,      BOOK_CONTROLS_ATTR10
,      BOOK_CONTROLS_ATTR11
,      BOOK_CONTROLS_ATTR12
,      BOOK_CONTROLS_ATTR13
,      BOOK_CONTROLS_ATTR14
,      BOOK_CONTROLS_ATTR15
,      PERIOD_NAME
,      PERIOD_CLOSE_DATE
,      PERIOD_COUNTER
,      BOOK_CONTROLS_GLOBAL_ATTR1
,      BOOK_CONTROLS_GLOBAL_ATTR2
,      BOOK_CONTROLS_GLOBAL_ATTR3
,      BOOK_CONTROLS_GLOBAL_ATTR4
,      BOOK_CONTROLS_GLOBAL_ATTR5
,      BOOK_CONTROLS_GLOBAL_ATTR6
,      BOOK_CONTROLS_GLOBAL_ATTR7
,      BOOK_CONTROLS_GLOBAL_ATTR8
,      BOOK_CONTROLS_GLOBAL_ATTR9
,      BOOK_CONTROLS_GLOBAL_ATTR10
,      BOOK_CONTROLS_GLOBAL_ATTR11
,      BOOK_CONTROLS_GLOBAL_ATTR12
,      BOOK_CONTROLS_GLOBAL_ATTR13
,      BOOK_CONTROLS_GLOBAL_ATTR14
,      BOOK_CONTROLS_GLOBAL_ATTR15
,      BOOK_CONTROLS_GLOBAL_ATTR16
,      BOOK_CONTROLS_GLOBAL_ATTR17
,      BOOK_CONTROLS_GLOBAL_ATTR18
,      BOOK_CONTROLS_GLOBAL_ATTR19
,      BOOK_CONTROLS_GLOBAL_ATTR20
,      TRANSFER_TO_GL_FLAG
,      REVERSAL_FLAG
,      ACCOUNTING_DATE
,      SORP_ENABLED_FLAG
FROM FA.FA_XLA_EXT_HEADERS_B_GT;

Dependencies

[top of page]

FA.FA_XLA_EXT_HEADERS_B_GT does not reference any database object

FA.FA_XLA_EXT_HEADERS_B_GT is referenced by following:

SchemaAPPS
SynonymFA_XLA_EXT_HEADERS_B_GT