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

TABLE: FII.FII_GL_SNAP_F

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


This table stores snapshot data of sysdate at master value sets level.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_GL_SNAP_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPANY_DIM_ID
ColumnCOST_CENTER_DIM_ID
ColumnFIN_CATEGORY_ID
ColumnLEDGER_ID
ColumnUSER_DIM1_ID
ColumnUSER_DIM2_ID
Columns
Name Datatype Length Mandatory Comments
COST_CENTER_DIM_ID NUMBER (15)
Cost Center Dimension Identifier
COMPANY_DIM_ID NUMBER (15)
Company Dimension Identifier
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
USER_DIM1_ID NUMBER (15)
User Dimension 1 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 yearmonth to date budget amount in primary currency
BUDGET_PG_LAST_YEAR_QTD NUMBER

Last year quarter 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

Prior quarter to date baseline amount in primary currency
BASELINE_AMT_PG_PRIOR_YTD NUMBER

Prior 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
,      COMPANY_DIM_ID
,      FIN_CATEGORY_ID
,      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_F;

Dependencies

[top of page]

FII.FII_GL_SNAP_F does not reference any database object

FII.FII_GL_SNAP_F is referenced by following:

SchemaAPPS
SynonymFII_GL_SNAP_F