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

VIEW: APPS.FPA_AW_PCLASS_FIN_METRICS_V

Object Details
Object Name: FPA_AW_PCLASS_FIN_METRICS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFPA.FPA_AW_PCLASS_FIN_METRICS_V
Subobject Name:
Status: VALID

View Type

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


FPA_AW_PCLASS_FIN_METRICS_V is a view containing financial metric data at the Scenario and Class Category level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
CLASS_CODE NUMBER

Class code
SCENARIO NUMBER

Scenario ID
FUNDS_AVAILABLE NUMBER

Funds available
FUNDS_REQUIRED NUMBER

Funds required
FUNDING_VARIANCE NUMBER

Funding variance
TOTAL_BENEFIT NUMBER

Total benefit
NET_PRESENT_VALUE NUMBER

Net Present Value
INTERNAL_RATE_RETURN NUMBER

Internal Rate of Return
RETURN_ON_INV NUMBER

Return on Investment
PAYBACK_PERIOD NUMBER

Payback Period
SCE_CLASS_CODE_VALID NUMBER

Valid scenario class code flag
Query Text

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


SELECT CLASS_CODE
,      SCENARIO
,      FUNDS_AVAILABLE
,      FUNDS_REQUIRED
,      FUNDING_VARIANCE
,      TOTAL_BENEFIT
,      NET_PRESENT_VALUE
,      INTERNAL_RATE_RETURN
,      RETURN_ON_INV
,      PAYBACK_PERIOD
,      SCE_CLASS_CODE_VALID
FROM APPS.FPA_AW_PCLASS_FIN_METRICS_V;

Dependencies

[top of page]

APPS.FPA_AW_PCLASS_FIN_METRICS_V references the following:

SchemaAPPS
TYPEFPA_PROJ_CLASS_TBL
PL/SQL PackageFPA_UTILITIES_PVT - show dependent code
SchemaPUBLIC
SynonymOLAP_TABLE

APPS.FPA_AW_PCLASS_FIN_METRICS_V is not referenced by any database object