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: ExceptionINVALID

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 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
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
PL/SQL PackageFPA_UTILITIES_PVT - show dependent code
SchemaPUBLIC
SynonymOLAP_TABLE

APPS.FPA_AW_SCE_FIN_METRICS_V is not referenced by any database object