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

TABLE: FII.FII_FC_TYPE_NORM_ASSIGN

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


Contains Financial Category type assignments for the Financial Category dimension values. The Financial Category types are Revenue, Operating Expense, Travel and Entertainment, Cost of Good Sold, and Product Expenses.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_FC_TYPE_NORM_ASSIGN_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFIN_CAT_TYPE_CODE
FII_FC_TYPE_NORM_ASSIGN_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFIN_CATEGORY_ID
ColumnFIN_CAT_TYPE_CODE
Columns
Name Datatype Length Mandatory Comments
FIN_CATEGORY_ID NUMBER (15) Yes Flexfield segment value identifier for Financial category dimension value
FIN_CATEGORY VARCHAR2 (150) Yes Financial category dimension value
FIN_CAT_TYPE_CODE VARCHAR2 (30) Yes Financial category type code (Revenue, Operating Expense, Travel and Entertainment, Cost of Goods Sold, Product Expenses)
SUMMARY_FLAG VARCHAR2 (1) Yes Parent dimension value flag
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT FIN_CATEGORY_ID
,      FIN_CATEGORY
,      FIN_CAT_TYPE_CODE
,      SUMMARY_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM FII.FII_FC_TYPE_NORM_ASSIGN;

Dependencies

[top of page]

FII.FII_FC_TYPE_NORM_ASSIGN does not reference any database object

FII.FII_FC_TYPE_NORM_ASSIGN is referenced by following:

SchemaAPPS
SynonymFII_FC_TYPE_NORM_ASSIGN