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

TABLE: FII.FII_GL_LOCAL_SNAP_F

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


This table stores data in FII_GL_JE_SUMMARY_B by columns.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_GL_LOCAL_SNAP_F_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_CENTER_ID
ColumnCOMPANY_ID
ColumnYEAR_ID
ColumnFIN_CAT_TYPE_CODE
ColumnAMOUNT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
YEAR_ID NUMBER (15)
Year Identifier
COST_CENTER_ID NUMBER (15)
Cost Center Identifier
COMPANY_ID NUMBER (15)
Company Identifier
FIN_CATEGORY_ID NUMBER (15)
Financial Category Identifier
USER_DIM1_ID NUMBER (15)
User Dimension1 Identifier
USER_DIM2_ID NUMBER (15)
User Dimension2 Identifier
LEDGER_ID NUMBER (15)
Ledger Identifier
FIN_CAT_TYPE_CODE VARCHAR2 (30)
Financial Category Type Code
PRIM_G_MONTH1 NUMBER

Amount in primary currency for Ist month
PRIM_G_MONTH2 NUMBER

Amount in primary currency for 2nd month
PRIM_G_MONTH3 NUMBER

Amount in primary currency for 3rd month
PRIM_G_MONTH4 NUMBER

Amount in primary currency for 4th month
PRIM_G_MONTH5 NUMBER

Amount in primary currency for 5th month
PRIM_G_MONTH6 NUMBER

Amount in primary currency for 6th month
PRIM_G_MONTH7 NUMBER

Amount in primary currency for 7th month
PRIM_G_MONTH8 NUMBER

Amount in primary currency for 8th month
PRIM_G_MONTH9 NUMBER

Amount in primary currency for 9th month
PRIM_G_MONTH10 NUMBER

Amount in primary currency for I0th month
PRIM_G_MONTH11 NUMBER

Amount in primary currency for 11th month
PRIM_G_MONTH12 NUMBER

Amount in primary currency for 12th month
PRIM_G_MONTH13 NUMBER

Amount in primary currency for 13th month
PRIM_G_QTR1 NUMBER

Amount in primary currency for Ist Quarter
PRIM_G_QTR2 NUMBER

Amount in primary currency for 2nd Quarter
PRIM_G_QTR3 NUMBER

Amount in primary currency for 3rd Quarter
PRIM_G_QTR4 NUMBER

Amount in primary currency for 4th Quarter
PRIM_G_YEAR NUMBER

Amount in primary currency for year
PRIM_G_MTD NUMBER

Amount in primary currency for month to date
PRIM_G_QTD NUMBER

Amount in primary currency for quarter to date
PRIM_G_YTD NUMBER

Amount in primary currency for year to date
SEC_G_MONTH1 NUMBER

Amount in secondary currency for Ist month
SEC_G_MONTH2 NUMBER

Amount in secondary currency for 2nd month
SEC_G_MONTH3 NUMBER

Amount in secondary currency for 3rd month
SEC_G_MONTH4 NUMBER

Amount in secondary currency for 4th month
SEC_G_MONTH5 NUMBER

Amount in secondary currency for 5th month
SEC_G_MONTH6 NUMBER

Amount in secondary currency for 6th month
SEC_G_MONTH7 NUMBER

Amount in secondary currency for 7th month
SEC_G_MONTH8 NUMBER

Amount in secondary currency for 8th month
SEC_G_MONTH9 NUMBER

Amount in secondary currency for 9th month
SEC_G_MONTH10 NUMBER

Amount in secondary currency for 10th month
SEC_G_MONTH11 NUMBER

Amount in secondary currency for 11th month
SEC_G_MONTH12 NUMBER

Amount in secondary currency for 12th month
SEC_G_MONTH13 NUMBER

Amount in secondary currency for 13th month
SEC_G_QTR1 NUMBER

Amount in secondary currency for Ist Quarter
SEC_G_QTR2 NUMBER

Amount in secondary currency for 2nd Quarter
SEC_G_QTR3 NUMBER

Amount in secondary currency for 3rd Quarter
SEC_G_QTR4 NUMBER

Amount in secondary currency for 4th Quarter
SEC_G_YEAR NUMBER

Amount in secondary currency for year
SEC_G_MTD NUMBER

Amount in secondary currency for month to date
SEC_G_QTD NUMBER

Amount in secondary currency for quarter to date
SEC_G_YTD NUMBER

Amount in secondary currency for year to date
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
AMOUNT_TYPE_CODE VARCHAR2 (2)
Amount Type Code
Query Text

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


SELECT YEAR_ID
,      COST_CENTER_ID
,      COMPANY_ID
,      FIN_CATEGORY_ID
,      USER_DIM1_ID
,      USER_DIM2_ID
,      LEDGER_ID
,      FIN_CAT_TYPE_CODE
,      PRIM_G_MONTH1
,      PRIM_G_MONTH2
,      PRIM_G_MONTH3
,      PRIM_G_MONTH4
,      PRIM_G_MONTH5
,      PRIM_G_MONTH6
,      PRIM_G_MONTH7
,      PRIM_G_MONTH8
,      PRIM_G_MONTH9
,      PRIM_G_MONTH10
,      PRIM_G_MONTH11
,      PRIM_G_MONTH12
,      PRIM_G_MONTH13
,      PRIM_G_QTR1
,      PRIM_G_QTR2
,      PRIM_G_QTR3
,      PRIM_G_QTR4
,      PRIM_G_YEAR
,      PRIM_G_MTD
,      PRIM_G_QTD
,      PRIM_G_YTD
,      SEC_G_MONTH1
,      SEC_G_MONTH2
,      SEC_G_MONTH3
,      SEC_G_MONTH4
,      SEC_G_MONTH5
,      SEC_G_MONTH6
,      SEC_G_MONTH7
,      SEC_G_MONTH8
,      SEC_G_MONTH9
,      SEC_G_MONTH10
,      SEC_G_MONTH11
,      SEC_G_MONTH12
,      SEC_G_MONTH13
,      SEC_G_QTR1
,      SEC_G_QTR2
,      SEC_G_QTR3
,      SEC_G_QTR4
,      SEC_G_YEAR
,      SEC_G_MTD
,      SEC_G_QTD
,      SEC_G_YTD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      AMOUNT_TYPE_CODE
FROM FII.FII_GL_LOCAL_SNAP_F;

Dependencies

[top of page]

FII.FII_GL_LOCAL_SNAP_F does not reference any database object

FII.FII_GL_LOCAL_SNAP_F is referenced by following:

SchemaAPPS
SynonymFII_GL_LOCAL_SNAP_F