[Home] [Help]
[Dependency Information]
VIEW: APPS.MSD_DP_ASCP_SCENARIOS_V
Object Details
Object Name: | MSD_DP_ASCP_SCENARIOS_V |
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_DP_ASCP_SCENARIOS_V
|
---|
Subobject Name: | |
Status: | VALID |
View Type
A public view which may be useful for custom reporting or other data
requirements.
This view provides the integration api with ASCP for Scenarios
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
DEMAND_PLAN_ID |
NUMBER |
|
|
Demand plan id |
DEMAND_PLAN_NAME |
VARCHAR2 |
(30) |
|
Demand plan name |
SCENARIO_ID |
NUMBER |
|
|
Scenario id |
SCENARIO_NAME |
VARCHAR2 |
(45) |
|
Scenario name |
ORGANIZATION_ID |
NUMBER |
|
|
Organization id |
SR_INSTANCE_ID |
NUMBER |
|
|
Source instance id |
ERROR_TYPE |
VARCHAR2 |
(4000) |
|
Error Type |
CONSUME_FLAG |
VARCHAR2 |
(30) |
|
ASCP Consume Flag |
GLOBAL_SCENARIO_FLAG |
VARCHAR2 |
(4000) |
|
Global Scenario Flag |
LAST_REVISION |
VARCHAR2 |
(40) |
|
Last Revision Published |
RETURN_FORECAST |
NUMBER |
|
|
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT DEMAND_PLAN_ID
, DEMAND_PLAN_NAME
, SCENARIO_ID
, SCENARIO_NAME
, ORGANIZATION_ID
, SR_INSTANCE_ID
, ERROR_TYPE
, CONSUME_FLAG
, GLOBAL_SCENARIO_FLAG
, LAST_REVISION
, RETURN_FORECAST
FROM APPS.MSD_DP_ASCP_SCENARIOS_V;
Dependencies
[top of page]
APPS.MSD_DP_ASCP_SCENARIOS_V references the following:
-
APPS
-
MSD_COMMON_UTILITIES
- show dependent code
-
MSD_DEMAND_PLANS
-
MSD_DEM_TRANSFER_LIST
-
MSD_DEM_TRANSFER_QUERY
-
MSD_DEM_UPLOAD_FORECAST
- show dependent code
-
MSD_DP_SCENARIOS
-
MSD_DP_SCENARIO_OUTPUT_LEVELS
-
MSD_DP_SCENARIO_REVISIONS
APPS.MSD_DP_ASCP_SCENARIOS_V is referenced by following:
-
APPS
-
MSC_DEMANTRA_PKG
- show dependent code
-
MSC_FORECAST_RULES_V
-
MSC_GET_NAME
- show dependent code
-
MSC_PHUB_PKG
- show dependent code
-
MSC_PHUB_UTIL
- show dependent code
-
MSC_PLAN_SCHEDULES_V
-
MSC_PLAN_SCHED_V
-
MSC_SCN_UTILS
- show dependent code
-
MSC_WS_APS_DATA_SERVICES
- show dependent code
-
MSC_WS_ASCP
- show dependent code
-
MSC_WS_COMMON
- show dependent code
-
MSC_WS_DRP
- show dependent code
-
MSC_WS_IO
- show dependent code
-
MSC_WS_SRP
- show dependent code
-
MSD_ASCP_FLOW
- show dependent code