[Home] [Help] [Dependency Information]
Object Name: | FPA_AW_PCLASS_FIN_METRICS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FPA.FPA_AW_PCLASS_FIN_METRICS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.FPA_AW_PCLASS_FIN_METRICS_V is not referenced by any database object
|
|
|