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

VIEW: APPS.MSD_DP_SCN_REVISIONS_LB_V

Object Details
Object Name: MSD_DP_SCN_REVISIONS_LB_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view to show scenario revisions


[View Source]

Columns
Name Datatype Length Mandatory Comments
REVISION VARCHAR2 (40) Yes Revision
REVISION_NAME VARCHAR2 (100)
Revision Name
INPUT_SCENARIO_ID NUMBER
Yes Input Scenario Id
INPUT_SCENARIO_NAME VARCHAR2 (45) Yes Input Scenario Name
INPUT_DEMAND_PLAN_ID NUMBER
Yes Input Demand Plan Id
INPUT_DEMAND_PLAN_NAME VARCHAR2 (30) Yes Input Demand Plan Name
PARAMETER_NAME VARCHAR2 (177)
Parameter Name
PLAN_TYPE VARCHAR2 (15)
Indicates the Plan Tpe from which the scenario has been published
Query Text

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


SELECT REVISION
,      REVISION_NAME
,      INPUT_SCENARIO_ID
,      INPUT_SCENARIO_NAME
,      INPUT_DEMAND_PLAN_ID
,      INPUT_DEMAND_PLAN_NAME
,      PARAMETER_NAME
,      PLAN_TYPE
FROM APPS.MSD_DP_SCN_REVISIONS_LB_V;

Dependencies

[top of page]

APPS.MSD_DP_SCN_REVISIONS_LB_V references the following:

SchemaAPPS
SynonymMSD_DEMAND_PLANS
SynonymMSD_DP_SCENARIOS
SynonymMSD_DP_SCENARIO_REVISIONS

APPS.MSD_DP_SCN_REVISIONS_LB_V is not referenced by any database object