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

VIEW: APPS.FPA_AW_SCE_FIN_METRICS_V

Object Details
Object Name: FPA_AW_SCE_FIN_METRICS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFPA.FPA_AW_SCE_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_SCE_FIN_METRICS_V is a view containg Financial Metric data at the Scenario level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SCENARIO NUMBER

Scenario Identifier
PLANNING_CYCLE NUMBER

Planning Cycle Identifier
RECOMMENDED_FLAG NUMBER

Scenario recommended flag
APPROVED_FLAG NUMBER

Scenario approved flag
IS_INITIAL_SCENARIO NUMBER

Is initial scenario flag
IS_WORKING_SCENARIO NUMBER

Is working scenario flag
DISCOUNT_RATE NUMBER

Discount rate
FUNDS_AVAILABLE NUMBER

Funds available
FUNDS_REQUIRED NUMBER

Funds required
FUNDING_VARIANCE NUMBER

Funding variance
PLANNED_BENEFIT NUMBER

Planned benefit
NET_PRESENT_VALUE NUMBER

Net Present Value
INTERNAL_RATE_RETURN NUMBER

Internal Rate of Return
PAYBACK_PERIOD NUMBER

Payback period
RETURN_ON_INV NUMBER

Return on Investment
Query Text

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;

Dependencies

[top of page]

APPS.FPA_AW_SCE_FIN_METRICS_V references the following:

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

SchemaAPPS
Package BodyFPA_UTILS_PVT - show dependent code