[Home] [Help] [Dependency Information]
Object Name: | MSD_DP_SCN_REVISIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_DP_SCN_REVISIONS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view to show scenario revisions
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 |
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_V;
|
|
|