[Home] [Help]
[Dependency Information]
| Object Name: | FA_XLA_EXT_HEADERS_B_GT |
|---|---|
| Object Type: | TABLE |
| Owner: | FA |
| FND Design Data: | OFA.FA_XLA_EXT_HEADERS_B_GT
|
| Subobject Name: | |
| Status: | VALID |
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.
| Tablespace: | ![]() |
|---|---|
| PCT Free: | 10 |
| PCT Used: | 40 |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| FA_XLA_EXT_HEADERS_B_GT_U1 | NORMAL | UNIQUE |
|
EVENT_ID
|
| 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) |
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;
FA.FA_XLA_EXT_HEADERS_B_GT does not reference any database object
FA.FA_XLA_EXT_HEADERS_B_GT is referenced by following:
APPS
FA_XLA_EXT_HEADERS_B_GT
|
|
|
|