eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSD_DP_ASCP_SCN_ENTRIES_V

Object Details

Object Name:	MSD_DP_ASCP_SCN_ENTRIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_DP_ASCP_SCN_ENTRIES_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 scenario entries

[View Source]

Columns

Name	Datatype	Length	Comments
DEMAND_PLAN_ID	NUMBER		Demand Plan id
SCENARIO_ID	NUMBER		Scenario id
DEMAND_ID	NUMBER		Demand id
BUCKET_TYPE	NUMBER		Type of time bucket
START_TIME	DATE		Start time
END_TIME	DATE		End time
QUANTITY	NUMBER		Demand quantity
SR_ORGANIZATION_ID	NUMBER		Source organization id
SR_INSTANCE_ID	NUMBER		Source instance id
SR_INVENTORY_ITEM_ID	NUMBER		Source item id
ERROR_TYPE	VARCHAR2	(30)	Error Type
FORECAST_ERROR	NUMBER		Forecast Error
INVENTORY_ITEM_ID	NUMBER		Inventory Item Id
SR_SHIP_TO_LOC_ID	NUMBER		Ship To Location Id
SR_CUSTOMER_ID	NUMBER		Source Customer Id
SR_ZONE_ID	NUMBER		Source Zone Primay Key
PRIORITY	NUMBER		Priority
DP_UOM_CODE	VARCHAR2	(40)	Demand Planning UOM Code
ASCP_UOM_CODE	VARCHAR2	(10)	ASCP UOM Code
DEMAND_CLASS	VARCHAR2	(240)	Demand Class
UNIT_PRICE	NUMBER		Unit Price
TIME_LVL_ID	NUMBER		Time Level ID
DMD_PRIORITY_SCENARIO_ID	NUMBER		Specifies the corresponding demand priority scenario ID

Query Text

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


SELECT DEMAND_PLAN_ID
,      SCENARIO_ID
,      DEMAND_ID
,      BUCKET_TYPE
,      START_TIME
,      END_TIME
,      QUANTITY
,      SR_ORGANIZATION_ID
,      SR_INSTANCE_ID
,      SR_INVENTORY_ITEM_ID
,      ERROR_TYPE
,      FORECAST_ERROR
,      INVENTORY_ITEM_ID
,      SR_SHIP_TO_LOC_ID
,      SR_CUSTOMER_ID
,      SR_ZONE_ID
,      PRIORITY
,      DP_UOM_CODE
,      ASCP_UOM_CODE
,      DEMAND_CLASS
,      UNIT_PRICE
,      TIME_LVL_ID
,      DMD_PRIORITY_SCENARIO_ID
FROM APPS.MSD_DP_ASCP_SCN_ENTRIES_V;

Dependencies

[top of page]

APPS.MSD_DP_ASCP_SCN_ENTRIES_V references the following:

APPS: MSC_APPS_INSTANCES; MSC_SYSTEM_ITEMS; MSD_COMMON_UTILITIES - show dependent code; MSD_DEMAND_PLANS; MSD_DP_SCENARIOS; MSD_DP_SCENARIO_ENTRIES; MSD_DP_SCENARIO_REVISIONS; MSD_DP_SCN_ENTRIES_DENORM

APPS.MSD_DP_ASCP_SCN_ENTRIES_V is referenced by following:

APPS: MSD_DEM_SCN_ENTRIES_V