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

TABLE: FII.FII_GL_SNAP_SUM_F

Object Details
Object Name: FII_GL_SNAP_SUM_F
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_GL_SNAP_SUM_F
Subobject Name:
Status: VALID


This table stores aggregated snapshot data of sysdate from FII_GL_SNAP_F via Financial Category, Company, Cost Center, User Defined 1 dimensions


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_GL_SNAP_SUM_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARENT_COMPANY_DIM_ID
ColumnCOMPANY_DIM_ID
ColumnPARENT_COST_CENTER_DIM_ID
ColumnCOST_CENTER_DIM_ID
ColumnPARENT_FIN_CATEGORY_ID
ColumnFIN_CATEGORY_ID
ColumnPARENT_USER_DIM1_ID
ColumnUSER_DIM1_ID
ColumnUSER_DIM2_ID
Columns
Name Datatype Length Mandatory Comments
COST_CENTER_DIM_ID NUMBER (15)
Cost center dimension identifier
PARENT_COST_CENTER_DIM_ID NUMBER (15)
Parent cost center dimension identifier
COMPANY_DIM_ID NUMBER (15)
Company dimension identifier
PARENT_COMPANY_DIM_ID NUMBER (15)
Parent company dimension identifier
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
PARENT_FIN_CATEGORY_ID NUMBER (15)
Parent financial category identifier
USER_DIM1_ID NUMBER (15)
User dimension1 identifier
PARENT_USER_DIM1_ID NUMBER (15)
Parent user 1 dimension identifier
USER_DIM2_ID NUMBER (15)
User dimension 2 identifier
LEDGER_ID NUMBER (15)
Ledger identifier
ACTUAL_B_CUR_MTD NUMBER

Current month to date actual amount in base currency
ACTUAL_B_CUR_QTD NUMBER

Current quarter to date actual amount in base currency
ACTUAL_B_CUR_YTD NUMBER

Current year to date actual amount in base currency
ACTUAL_B_PRIOR_MTD NUMBER

Prior month to date actual amount in base currency
ACTUAL_B_PRIOR_QTD NUMBER

Prior quarter to date actual amount in base currency
ACTUAL_B_PRIOR_YTD NUMBER

Prior year to date actual amount in base currency
ACTUAL_B_LAST_YEAR_MTD NUMBER

Last year month to date actual amount in base currency
ACTUAL_B_LAST_YEAR_QTD NUMBER

Last year quarter to date actual amount in base currency
ACTUAL_PG_CUR_MTD NUMBER

Current month to date actual amount in primary currency
ACTUAL_PG_CUR_QTD NUMBER

Current quarter to date actual amount in primary currency
ACTUAL_PG_CUR_YTD NUMBER

Current year to date actual amount in primary currency
ACTUAL_PG_PRIOR_MTD NUMBER

Prior month to date actual amount in primary currency
ACTUAL_PG_PRIOR_QTD NUMBER

Prior quarter to date actual amount in primary currency
ACTUAL_PG_PRIOR_YTD NUMBER

Prior year to date actual amount in primary currency
ACTUAL_PG_LAST_YEAR_MTD NUMBER

Last year month to date actual amount in primary currency
ACTUAL_PG_LAST_YEAR_QTD NUMBER

Last year quarter to date actual amount in primary currency
ACTUAL_SG_CUR_MTD NUMBER

Current month to date actual amount in secondary currency
ACTUAL_SG_CUR_QTD NUMBER

Current quarter to date actual amount in secondary currency
ACTUAL_SG_CUR_YTD NUMBER

Current year to date actual amount in secondary currency
ACTUAL_SG_PRIOR_MTD NUMBER

Prior month to date actual amount in secondary currency
ACTUAL_SG_PRIOR_QTD NUMBER

Prior quarter to date actual amount in secondary currency
ACTUAL_SG_PRIOR_YTD NUMBER

Prior year to date actual amount in secondary currency
ACTUAL_SG_LAST_YEAR_MTD NUMBER

Last year month to date actual amount in secondary currency
ACTUAL_SG_LAST_YEAR_QTD NUMBER

Last year quarter to date actual amount in secondary currency
BUDGET_PG_CUR_MTD NUMBER

Current month to date budget amount in primary currency
BUDGET_PG_CUR_QTD NUMBER

Current quarter to date budget amount in primary currency
BUDGET_PG_CUR_YTD NUMBER

Current year to date budget amount in primary currency
BUDGET_PG_PRIOR_MTD NUMBER

Prior month to date budget amount in primary currency
BUDGET_PG_PRIOR_QTD NUMBER

Prior quarter to date budget amount in primary currency
BUDGET_PG_PRIOR_YTD NUMBER

Prior year to date budget amount in primary currency
BUDGET_PG_LAST_YEAR_MTD NUMBER

Last year month to date budget amount in primary currency
BUDGET_PG_LAST_YEAR_QTD NUMBER

Last year qurater to date budget amount in primary currency
BUDGET_SG_CUR_MTD NUMBER

Current month to date budget amount in secondary currency
BUDGET_SG_CUR_QTD NUMBER

Current quarter to date budget amount in secondary currency
BUDGET_SG_CUR_YTD NUMBER

Current year to date budget amount in secondary currency
BUDGET_SG_PRIOR_MTD NUMBER

Prior month to date budget amount in secondary currency
BUDGET_SG_PRIOR_QTD NUMBER

Prior quarter to date budget amount in secondary currency
BUDGET_SG_PRIOR_YTD NUMBER

Prior year to date budget amount in secondary currency
BUDGET_SG_LAST_YEAR_MTD NUMBER

Last year month to date budget amount in secondary currency
BUDGET_SG_LAST_YEAR_QTD NUMBER

Last year quarter to date budget amount in secondary currency
FORECAST_PG_CUR_MTD NUMBER

Current month to date forecast amount in primary currency
FORECAST_PG_CUR_QTD NUMBER

Current quarter to date forecast amount in primary currency
FORECAST_PG_CUR_YTD NUMBER

Current year to date forecast amount in primary currency
FORECAST_PG_PRIOR_MTD NUMBER

Prior month to date forecast amount in primary currency
FORECAST_PG_PRIOR_QTD NUMBER

Prior quarter to date forecast amount in primary currency
FORECAST_PG_PRIOR_YTD NUMBER

Prior year to date forecast amount in primary currency
FORECAST_PG_LAST_YEAR_MTD NUMBER

Last year month to date forecast amount in primary currency
FORECAST_PG_LAST_YEAR_QTD NUMBER

Last year quarter to date forecast amount in primary currency
FORECAST_SG_CUR_MTD NUMBER

Current month to date forecast amount in secondary currency
FORECAST_SG_CUR_QTD NUMBER

Current quarter to date forecast amount in secondary currency
FORECAST_SG_CUR_YTD NUMBER

Current year to date forecast amount in secondary currency
FORECAST_SG_PRIOR_MTD NUMBER

Prior month to date forecast amount in secondary currency
FORECAST_SG_PRIOR_QTD NUMBER

Prior quarter to date forecast amount in secondary currency
FORECAST_SG_PRIOR_YTD NUMBER

Prior year to date forecast amount in secondary currency
FORECAST_SG_LAST_YEAR_MTD NUMBER

Last year month to date forecast amount in secondary currency
FORECAST_SG_LAST_YEAR_QTD NUMBER

Last year quarter to date forecast amount in secondary currency
LAST_UPDATE_DATE DATE
Yes Standard who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard who columns
CREATION_DATE DATE
Yes Standard who columns
CREATED_BY NUMBER (15) Yes Standard who columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard who columns
COMMITTED_AMT_PG_CUR_MTD NUMBER

Current month to date committed amount in primary currency
COMMITTED_AMT_PG_CUR_QTD NUMBER

Current quarter to date committed amount in primary currency
COMMITTED_AMT_PG_CUR_YTD NUMBER

Current year to date committed amount in primary currency
COMMITTED_AMT_PG_PRIOR_MTD NUMBER

Prior month to date committed amount in primary currency
COMMITTED_AMT_PG_PRIOR_QTD NUMBER

Prior quarter to date committed amount in primary currency
COMMITTED_AMT_PG_PRIOR_YTD NUMBER

Prior year to date committed amount in primary currency
COMMITTED_AMT_PG_LAST_YEAR_MTD NUMBER

Last year month to date committed amount in primary currency
COMMITTED_AMT_PG_LAST_YEAR_QTD NUMBER

Last year quarter to date committed amount in primary currency
OBLIGATED_AMT_PG_CUR_MTD NUMBER

Current month to date obligated amount in primary currency
OBLIGATED_AMT_PG_CUR_QTD NUMBER

Current quarter to date obligated amount in primary currency
OBLIGATED_AMT_PG_CUR_YTD NUMBER

Current year to date obligated amount in primary currency
OBLIGATED_AMT_PG_PRIOR_MTD NUMBER

Prior month to date obligated amount in primary currency
OBLIGATED_AMT_PG_PRIOR_QTD NUMBER

Prior quarter to date obligated amount in primary currency
OBLIGATED_AMT_PG_PRIOR_YTD NUMBER

Prior year to date obligated amount in primary currency
OBLIGATED_AMT_PG_LAST_YEAR_MTD NUMBER

Last year month to date obligated amount in primary currency
OBLIGATED_AMT_PG_LAST_YEAR_QTD NUMBER

Last year quarter to date obligated amount in primary currency
OTHER_AMT_PG_CUR_MTD NUMBER

Current month to date other amount in primary currency
OTHER_AMT_PG_CUR_QTD NUMBER

Current quarter to date other amount in primary currency
OTHER_AMT_PG_CUR_YTD NUMBER

Current year to date other amount in primary currency
OTHER_AMT_PG_PRIOR_MTD NUMBER

Prior month to date other amount in primary currency
OTHER_AMT_PG_PRIOR_QTD NUMBER

Prior quarter to date other amount in primary currency
OTHER_AMT_PG_PRIOR_YTD NUMBER

Prior year to date other amount in primary currency
OTHER_AMT_PG_LAST_YEAR_MTD NUMBER

Last year month to date other amount in primary currency
OTHER_AMT_PG_LAST_YEAR_QTD NUMBER

Last year quarter to date other amount in primary currency
BASELINE_AMT_PG_CUR_MTD NUMBER

Current month to date baseline amount in primary currency
BASELINE_AMT_PG_CUR_QTD NUMBER

Current quarter to date baseline amount in primary currency
BASELINE_AMT_PG_CUR_YTD NUMBER

Current year to date baseline amount in primary currency
BASELINE_AMT_PG_PRIOR_MTD NUMBER

Prior month to date baseline amount in primary currency
BASELINE_AMT_PG_PRIOR_QTD NUMBER

Current quarter to date baseline amount in primary currency
BASELINE_AMT_PG_PRIOR_YTD NUMBER

Current year to date baseline amount in primary currency
BASELINE_AMT_PG_LAST_YEAR_MTD NUMBER

Last year month to date baseline amount in primary currency
BASELINE_AMT_PG_LAST_YEAR_QTD NUMBER

Last year quarter to date baseline amount in primary currency
POSTED_DATE DATE

Posted date
Query Text

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


SELECT COST_CENTER_DIM_ID
,      PARENT_COST_CENTER_DIM_ID
,      COMPANY_DIM_ID
,      PARENT_COMPANY_DIM_ID
,      FIN_CATEGORY_ID
,      PARENT_FIN_CATEGORY_ID
,      USER_DIM1_ID
,      PARENT_USER_DIM1_ID
,      USER_DIM2_ID
,      LEDGER_ID
,      ACTUAL_B_CUR_MTD
,      ACTUAL_B_CUR_QTD
,      ACTUAL_B_CUR_YTD
,      ACTUAL_B_PRIOR_MTD
,      ACTUAL_B_PRIOR_QTD
,      ACTUAL_B_PRIOR_YTD
,      ACTUAL_B_LAST_YEAR_MTD
,      ACTUAL_B_LAST_YEAR_QTD
,      ACTUAL_PG_CUR_MTD
,      ACTUAL_PG_CUR_QTD
,      ACTUAL_PG_CUR_YTD
,      ACTUAL_PG_PRIOR_MTD
,      ACTUAL_PG_PRIOR_QTD
,      ACTUAL_PG_PRIOR_YTD
,      ACTUAL_PG_LAST_YEAR_MTD
,      ACTUAL_PG_LAST_YEAR_QTD
,      ACTUAL_SG_CUR_MTD
,      ACTUAL_SG_CUR_QTD
,      ACTUAL_SG_CUR_YTD
,      ACTUAL_SG_PRIOR_MTD
,      ACTUAL_SG_PRIOR_QTD
,      ACTUAL_SG_PRIOR_YTD
,      ACTUAL_SG_LAST_YEAR_MTD
,      ACTUAL_SG_LAST_YEAR_QTD
,      BUDGET_PG_CUR_MTD
,      BUDGET_PG_CUR_QTD
,      BUDGET_PG_CUR_YTD
,      BUDGET_PG_PRIOR_MTD
,      BUDGET_PG_PRIOR_QTD
,      BUDGET_PG_PRIOR_YTD
,      BUDGET_PG_LAST_YEAR_MTD
,      BUDGET_PG_LAST_YEAR_QTD
,      BUDGET_SG_CUR_MTD
,      BUDGET_SG_CUR_QTD
,      BUDGET_SG_CUR_YTD
,      BUDGET_SG_PRIOR_MTD
,      BUDGET_SG_PRIOR_QTD
,      BUDGET_SG_PRIOR_YTD
,      BUDGET_SG_LAST_YEAR_MTD
,      BUDGET_SG_LAST_YEAR_QTD
,      FORECAST_PG_CUR_MTD
,      FORECAST_PG_CUR_QTD
,      FORECAST_PG_CUR_YTD
,      FORECAST_PG_PRIOR_MTD
,      FORECAST_PG_PRIOR_QTD
,      FORECAST_PG_PRIOR_YTD
,      FORECAST_PG_LAST_YEAR_MTD
,      FORECAST_PG_LAST_YEAR_QTD
,      FORECAST_SG_CUR_MTD
,      FORECAST_SG_CUR_QTD
,      FORECAST_SG_CUR_YTD
,      FORECAST_SG_PRIOR_MTD
,      FORECAST_SG_PRIOR_QTD
,      FORECAST_SG_PRIOR_YTD
,      FORECAST_SG_LAST_YEAR_MTD
,      FORECAST_SG_LAST_YEAR_QTD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      COMMITTED_AMT_PG_CUR_MTD
,      COMMITTED_AMT_PG_CUR_QTD
,      COMMITTED_AMT_PG_CUR_YTD
,      COMMITTED_AMT_PG_PRIOR_MTD
,      COMMITTED_AMT_PG_PRIOR_QTD
,      COMMITTED_AMT_PG_PRIOR_YTD
,      COMMITTED_AMT_PG_LAST_YEAR_MTD
,      COMMITTED_AMT_PG_LAST_YEAR_QTD
,      OBLIGATED_AMT_PG_CUR_MTD
,      OBLIGATED_AMT_PG_CUR_QTD
,      OBLIGATED_AMT_PG_CUR_YTD
,      OBLIGATED_AMT_PG_PRIOR_MTD
,      OBLIGATED_AMT_PG_PRIOR_QTD
,      OBLIGATED_AMT_PG_PRIOR_YTD
,      OBLIGATED_AMT_PG_LAST_YEAR_MTD
,      OBLIGATED_AMT_PG_LAST_YEAR_QTD
,      OTHER_AMT_PG_CUR_MTD
,      OTHER_AMT_PG_CUR_QTD
,      OTHER_AMT_PG_CUR_YTD
,      OTHER_AMT_PG_PRIOR_MTD
,      OTHER_AMT_PG_PRIOR_QTD
,      OTHER_AMT_PG_PRIOR_YTD
,      OTHER_AMT_PG_LAST_YEAR_MTD
,      OTHER_AMT_PG_LAST_YEAR_QTD
,      BASELINE_AMT_PG_CUR_MTD
,      BASELINE_AMT_PG_CUR_QTD
,      BASELINE_AMT_PG_CUR_YTD
,      BASELINE_AMT_PG_PRIOR_MTD
,      BASELINE_AMT_PG_PRIOR_QTD
,      BASELINE_AMT_PG_PRIOR_YTD
,      BASELINE_AMT_PG_LAST_YEAR_MTD
,      BASELINE_AMT_PG_LAST_YEAR_QTD
,      POSTED_DATE
FROM FII.FII_GL_SNAP_SUM_F;

Dependencies

[top of page]

FII.FII_GL_SNAP_SUM_F does not reference any database object

FII.FII_GL_SNAP_SUM_F is referenced by following:

SchemaAPPS
SynonymFII_GL_SNAP_SUM_F