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

VIEW: APPS.FII_FC_TYPE_ASSGNS_V

Object Details
Object Name: FII_FC_TYPE_ASSGNS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFII.FII_FC_TYPE_ASSGNS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view is based on table FII_FIN_CAT_TYPE_ASSGNS. It stores Financial Category type assignments.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FIN_CAT_TYPE_CODE VARCHAR2 (30)
Financial category type code
FIN_CATEGORY_ID NUMBER (15)
Financial category dimension value identifier
TOP_NODE_FLAG VARCHAR2 (1)
Flag to identify the top node for each financial category type
Query Text

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


SELECT FIN_CAT_TYPE_CODE
,      FIN_CATEGORY_ID
,      TOP_NODE_FLAG
FROM APPS.FII_FC_TYPE_ASSGNS_V;

Dependencies

[top of page]

APPS.FII_FC_TYPE_ASSGNS_V references the following:

SchemaAPPS
SynonymFII_FINANCIAL_DIMENSIONS
SynonymFII_FIN_CAT_TYPE_ASSGNS
ViewFND_LOOKUP_VALUES_VL

APPS.FII_FC_TYPE_ASSGNS_V is not referenced by any database object