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

VIEW: APPS.FPA_AW_PROJ_STR_SCORES_V

Object Details
Object Name: FPA_AW_PROJ_STR_SCORES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewFPA.FPA_AW_PROJ_STR_SCORES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


FPA_AW_PROJ_STR_SCORES_V is a view containing strategic scores at the Scenario Project level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT NUMBER

Project Identifier
SCENARIO NUMBER

Scenario Identifier
PLANNING_CYCLE NUMBER

Planning Cycle Identifier
INVESTMENT_CRITERIA NUMBER

Investment Criteria ID
CRITERIA_LEVEL VARCHAR2 (30)
Investment Criteria Level
WEIGHTED_SCORE NUMBER

Weighted scores
NEW_SCORE NUMBER

New Score
SCE_PROJECT_VALID NUMBER

Valid Scenario Project flag
Query Text

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


SELECT PROJECT
,      SCENARIO
,      PLANNING_CYCLE
,      INVESTMENT_CRITERIA
,      CRITERIA_LEVEL
,      WEIGHTED_SCORE
,      NEW_SCORE
,      SCE_PROJECT_VALID
FROM APPS.FPA_AW_PROJ_STR_SCORES_V;

Dependencies

[top of page]

APPS.FPA_AW_PROJ_STR_SCORES_V references the following:

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

SchemaAPPS
Package BodyFPA_SCORECARDS_PVT - show dependent code