[Home] [Help] [Dependency Information]
Object Name: | FPA_AW_SCE_FIN_METRICS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | FPA.FPA_AW_SCE_FIN_METRICS_V |
Subobject Name: | |
Status: | INVALID |
A public view which may be useful for custom reporting or other data
requirements.
FPA_AW_SCE_FIN_METRICS_V is a view containg Financial Metric data at the Scenario level.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCENARIO | UNDEFINED | (0) | Scenario Identifier | |
PLANNING_CYCLE | UNDEFINED | (0) | Planning Cycle Identifier | |
RECOMMENDED_FLAG | UNDEFINED | (0) | Scenario recommended flag | |
APPROVED_FLAG | UNDEFINED | (0) | Scenario approved flag | |
IS_INITIAL_SCENARIO | UNDEFINED | (0) | Is initial scenario flag | |
IS_WORKING_SCENARIO | UNDEFINED | (0) | Is working scenario flag | |
DISCOUNT_RATE | UNDEFINED | (0) | Discount rate | |
FUNDS_AVAILABLE | UNDEFINED | (0) | Funds available | |
FUNDS_REQUIRED | UNDEFINED | (0) | Funds required | |
FUNDING_VARIANCE | UNDEFINED | (0) | Funding variance | |
PLANNED_BENEFIT | UNDEFINED | (0) | Planned benefit | |
NET_PRESENT_VALUE | UNDEFINED | (0) | Net Present Value | |
INTERNAL_RATE_RETURN | UNDEFINED | (0) | Internal Rate of Return | |
PAYBACK_PERIOD | UNDEFINED | (0) | Payback period | |
RETURN_ON_INV | UNDEFINED | (0) | Return on Investment |
Cut, paste (and edit) the following text to query this object:
SELECT SCENARIO
, PLANNING_CYCLE
, RECOMMENDED_FLAG
, APPROVED_FLAG
, IS_INITIAL_SCENARIO
, IS_WORKING_SCENARIO
, DISCOUNT_RATE
, FUNDS_AVAILABLE
, FUNDS_REQUIRED
, FUNDING_VARIANCE
, PLANNED_BENEFIT
, NET_PRESENT_VALUE
, INTERNAL_RATE_RETURN
, PAYBACK_PERIOD
, RETURN_ON_INV
FROM APPS.FPA_AW_SCE_FIN_METRICS_V;
APPS.FPA_AW_SCE_FIN_METRICS_V is not referenced by any database object
|
|
|