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

VIEW: APPS.FPA_AW_SCE_INFO_V

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

View Type

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


FPA_AW_SCE_INFO_V is a view containing basic information on Scenarios.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SCENARIO NUMBER

Unique Scenario Identifier
PLANNING_CYCLE NUMBER

Planning Cycle Identifier
RECOMMENDED_FLAG NUMBER

Recommended flag
APPROVED_FLAG NUMBER

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
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
FROM APPS.FPA_AW_SCE_INFO_V;

Dependencies

[top of page]

APPS.FPA_AW_SCE_INFO_V references the following:

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

SchemaAPPS
Package BodyFPA_MAIN_PROCESS_PVT - show dependent code
Package BodyFPA_PORTFOLIO_PROJECT_SETS_PVT - show dependent code
PL/SQL PackageFPA_PORTFOLIO_PROJECT_SETS_PVT - show dependent code
Package BodyFPA_PROCESS_PVT - show dependent code
Package BodyFPA_SCENARIO_PVT - show dependent code
Package BodyFPA_SCORECARDS_PVT - show dependent code
Package BodyFPA_UTILS_PVT - show dependent code
Package BodyFPA_VALIDATION_PROCESS_PVT - show dependent code