[Home] [Help] [Dependency Information]
Object Name: | FII_FC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FII.FII_FC_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is based on tables FII_FIN_ITEM_LEAF_HIERS and FND_FLEX_VALUES_TL. It will contain information about Financial Category Hierarchy.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_ID | NUMBER | (15) | Parent Financial Category Identifier | |
ID | NUMBER | (15) | Financial Category Identifier | |
VALUE | VARCHAR2 | (240) | Value of Financial Category Identifier | |
TYPE | VARCHAR2 | (30) | Yes | Financial Category type of Financial Category Identifier |
TOP_NODE_FLAG | VARCHAR2 | (1) | Flag to identify the top node for each financial category type |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_ID
, ID
, VALUE
, TYPE
, TOP_NODE_FLAG
FROM APPS.FII_FC_V;
APPS.FII_FC_V is not referenced by any database object
|
|
|