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

VIEW: APPS.FPA_AW_PROJ_FIN_METRICS_V

Object Details
Object Name: FPA_AW_PROJ_FIN_METRICS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFPA.FPA_AW_PROJ_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_PROJ_FIN_METRICS_V is a view containing financial information at the Scenario Project level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT NUMBER

Unique identifier for Projects
CLASS_CODE NUMBER

Class Code
SCENARIO NUMBER

Scenario ID
FUNDS_REQUIRED NUMBER

Funds required
TOTAL_BENEFIT NUMBER

Total benefit
SUNK_COST NUMBER

Sunk cost
TOTAL_COST NUMBER

Total cost
USER_RANK NUMBER

User rank
NET_PRESENT_VALUE NUMBER

Net Present Value
INTERNAL_RATE_RETURN NUMBER

Internal Rate of Return
RETURN_ON_INV NUMBER

Return on Investment
FIN_PERCENTILE NUMBER

Financial Percentile
STR_PERCENTILE NUMBER

Strategic Percentile
RISK_PERCENTILE NUMBER

Risk Percentile
INVESTMENT_INDEX NUMBER

Investment Index
PAYBACK_PERIOD NUMBER

Payback Period
RECOMMENDED_FUNDING_STATUS VARCHAR2 (30)
Recommended Funding Status
CURRENT_FUNDING_STATUS VARCHAR2 (30)
Current Funding Status
SCENARIO_PROJECT_VALID NUMBER

Valid Scenario Project combination flag
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PROJECT
,      CLASS_CODE
,      SCENARIO
,      FUNDS_REQUIRED
,      TOTAL_BENEFIT
,      SUNK_COST
,      TOTAL_COST
,      USER_RANK
,      NET_PRESENT_VALUE
,      INTERNAL_RATE_RETURN
,      RETURN_ON_INV
,      FIN_PERCENTILE
,      STR_PERCENTILE
,      RISK_PERCENTILE
,      INVESTMENT_INDEX
,      PAYBACK_PERIOD
,      RECOMMENDED_FUNDING_STATUS
,      CURRENT_FUNDING_STATUS
,      SCENARIO_PROJECT_VALID
FROM APPS.FPA_AW_PROJ_FIN_METRICS_V;

Dependencies

[top of page]

APPS.FPA_AW_PROJ_FIN_METRICS_V references the following:

SchemaAPPS
TYPEFPA_PROJ_METRICS_TBL
PL/SQL PackageFPA_UTILITIES_PVT - show dependent code
SchemaPUBLIC
SynonymOLAP_TABLE

APPS.FPA_AW_PROJ_FIN_METRICS_V is not referenced by any database object