[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: | INVALID |
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 | UNDEFINED | (0) | Class code | |
SCENARIO | UNDEFINED | (0) | Scenario ID | |
FUNDS_AVAILABLE | UNDEFINED | (0) | Funds available | |
FUNDS_REQUIRED | UNDEFINED | (0) | Funds required | |
FUNDING_VARIANCE | UNDEFINED | (0) | Funding variance | |
TOTAL_BENEFIT | UNDEFINED | (0) | Total benefit | |
NET_PRESENT_VALUE | UNDEFINED | (0) | Net Present Value | |
INTERNAL_RATE_RETURN | UNDEFINED | (0) | Internal Rate of Return | |
RETURN_ON_INV | UNDEFINED | (0) | Return on Investment | |
PAYBACK_PERIOD | UNDEFINED | (0) | Payback Period | |
SCE_CLASS_CODE_VALID | UNDEFINED | (0) | 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
|
|
|