[Home] [Help] [Dependency Information]
Object Name: | FEM_INTG_BPI_CURR_GT |
---|---|
Object Type: | TABLE |
Owner: | FEM |
FND Design Data: | FEM.FEM_INTG_BPI_CURR_GT |
Subobject Name: | |
Status: | VALID |
FEM.FEM_INTG_BPI_CURR_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 |
---|---|---|---|---|
FEM_INTG_BPI_CURR_GT_N1 | NORMAL | NONUNIQUE |
DATASET_CODE
CAL_PERIOD_ID CODE_COMBINATION_ID FINANCIAL_ELEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DATASET_CODE | NUMBER | Yes | Dataset code | |
CAL_PERIOD_ID | NUMBER | Yes | Calendar Period Identifier | |
CODE_COMBINATION_ID | NUMBER | Code combination Identifier from General Ledger | ||
FINANCIAL_ELEM_ID | NUMBER | Financial Element Identifier | ||
DELTA_RUN_ID | NUMBER | Incremental Run Identifier from General Ledger | ||
XTD_BALANCE_F_SUM | NUMBER | Aggregated Periodic Balance | ||
QTD_BALANCE_F_SUM | NUMBER | Aggregated Quarterly Balance | ||
YTD_BALANCE_F_SUM | NUMBER | Aggregated Yearly Balance |
Cut, paste (and edit) the following text to query this object:
SELECT DATASET_CODE
, CAL_PERIOD_ID
, CODE_COMBINATION_ID
, FINANCIAL_ELEM_ID
, DELTA_RUN_ID
, XTD_BALANCE_F_SUM
, QTD_BALANCE_F_SUM
, YTD_BALANCE_F_SUM
FROM FEM.FEM_INTG_BPI_CURR_GT;
FEM.FEM_INTG_BPI_CURR_GT does not reference any database object
FEM.FEM_INTG_BPI_CURR_GT is referenced by following:
|
|
|