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


VIEW: APPS.FPA_AW_INV_CRITERIA_INFO_V

Object Details
Object Name: FPA_AW_INV_CRITERIA_INFO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFPA.FPA_AW_INV_CRITERIA_INFO_V
Subobject Name:
Status: ExceptionINVALID

View Type

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


FPA_AW_INV_CRITERIA_INFO_V I s a view containing Strategic Criteria information: hierarchical, level within hierarchy, status and weight.


[View Source]

Columns
Name Datatype Length Mandatory Comments
STRATEGIC_OBJ UNDEFINED (0)
Investment Criteria IDs
STRATEGIC_OBJ_PARENT UNDEFINED (0)
Parent ID for the Investment Criteria
STRATEGIC_OBJ_LEVEL UNDEFINED (0)
Investment Criteria Objective Level : Group/Inidividual/Category/Root
STRATEGIC_OBJ_STATUS UNDEFINED (0)
Flag to determine if its deletable objective
STRATEGIC_OBJ_WEIGHT UNDEFINED (0)
Investment Criteria weights in %
Query Text

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


SELECT STRATEGIC_OBJ
,      STRATEGIC_OBJ_PARENT
,      STRATEGIC_OBJ_LEVEL
,      STRATEGIC_OBJ_STATUS
,      STRATEGIC_OBJ_WEIGHT
FROM APPS.FPA_AW_INV_CRITERIA_INFO_V;

Dependencies

[top of page]

APPS.FPA_AW_INV_CRITERIA_INFO_V references the following:

SchemaAPPS
PL/SQL PackageFPA_UTILITIES_PVT - show dependent code
SchemaPUBLIC
SynonymOLAP_TABLE
APPS.FPA_AW_INV_CRITERIA_INFO_V is referenced by following:

SchemaAPPS
Package BodyFPA_PROCESS_PVT - show dependent code