[Home] [Help]
[Dependency Information]
| 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 |
A public view which may be useful for custom reporting or other data
requirements.
This view provides the integration api with ASCP for Scenarios
| 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 |
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;
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
MSC_FORECAST_RULES_V
MSC_GET_NAME
- show dependent code
MSC_PHUB_FILE_PKG
- show dependent code
MSC_PHUB_PKG
- 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
|
|
|
|