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]

TABLE: MSD.MSD_DP_SCENARIO_ENTRIES

Object Details

Object Name:	MSD_DP_SCENARIO_ENTRIES
Object Type:	TABLE
Owner:	MSD
FND Design Data:	MSD.MSD_DP_SCENARIO_ENTRIES
Subobject Name:
Status:	VALID

This fact table is the child table to MSD_SCENARIOS. This has all the detail scenario entry information. This is the table to which the Demand Planning Express Component writes a scenario once the Sales and Operational Planning process is performed.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSD_DP_SCN_ENTRIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DEMAND_PLAN_ID SCENARIO_ID ENTRY_ID REVISION
MSD_DP_SCN_ENTRIES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEMAND_PLAN_ID SCENARIO_ID REVISION

Columns

Name	Datatype	Length	Mandatory	Comments
DEMAND_PLAN_ID	NUMBER		Yes	Demand Plan Unique ID.
SCENARIO_ID	NUMBER		Yes	Demand Plan Scenario ID.
ENTRY_ID	NUMBER		Yes	Demand Plan Sequence ID.
QUANTITY	NUMBER			Quantity.
AMOUNT	NUMBER			Amount.
BASELINE_QUANTITY	NUMBER			Baseline Quantity.
BASELINE_AMOUNT	NUMBER			Baseline Amount.
TIME_LVL_ID	NUMBER			Time Level ID.
TIME_LVL_VAL_FROM	DATE		Yes	Time Level From.
TIME_LVL_VAL_TO	DATE		Yes	Time Level To.
PRODUCT_LVL_ID	NUMBER			Product Level ID.
PRODUCT_LVL_VAL	VARCHAR2	(240)		Product Level Value.
GEOGRAPHY_LVL_ID	NUMBER			Geography Level ID.
GEOGRAPHY_LVL_VAL	VARCHAR2	(240)		Geography Level Value.
CUSTOMER_LVL_ID	NUMBER			Customer Level ID.
CUSTOMER_LVL_VAL	VARCHAR2	(240)		Customer Level Value.
SALESCHANNEL_LVL_ID	NUMBER			Sales Channel Level ID.
SALESCHANNEL_LVL_VAL	VARCHAR2	(240)		Sales Channel Level Value.
SALES_REP_LVL_ID	NUMBER			Sales Representative Level ID.
SALES_REP_LVL_VAL	VARCHAR2	(240)		Sales Representative Level Value.
ORGANIZATION_LVL_ID	NUMBER			Organization Level ID.
ORGANIZATION_LVL_VAL	VARCHAR2	(240)		Organization Level Value.
USER_DEFINED1_LVL_ID	NUMBER			First User Defined Dimension Level ID.
USER_DEFINED1_LVL_VAL	VARCHAR2	(240)		First User Defined Dimension Level Value.
USER_DEFINED2_LVL_ID	NUMBER			Second User Defined Dimension Level ID.
USER_DEFINED2_LVL_VAL	VARCHAR2	(240)		Second User Defined Dimension Level Value.
PRIORITY	NUMBER			Scenario Entry Priority.
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Concurrent who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent who column
PROGRAM_ID	NUMBER			Concurrent who column
PROGRAM_UPDATE_DATE	DATE			Concurrent who column
PRODUCT_LVL_PK	NUMBER			Product Level Primary Key.
GEOGRAPHY_LVL_PK	NUMBER		Yes	Geography Level Primary Key.
CUSTOMER_LVL_PK	NUMBER			Customer Level Primary Key.
SALESCHANNEL_LVL_PK	NUMBER		Yes	Sales Channel Level Primary Key.
SALES_REP_LVL_PK	NUMBER		Yes	Sales Representative Level Primary Key.
ORGANIZATION_LVL_PK	NUMBER		Yes	Organization Level Primary Key.
USER_DEFINED1_LVL_PK	NUMBER		Yes	First User Defined Dimension Level Primary Key.
USER_DEFINED2_LVL_PK	NUMBER		Yes	Second User Defined Dimension Level Primary Key.
REVISION	VARCHAR2	(40)	Yes	Scenario Revision.
PARENT_REVISION	VARCHAR2	(40)		Scenario Parent Revision.
COMMENTS	VARCHAR2	(240)		Comments.
ADJUSTMENT_REASON	VARCHAR2	(3)		Scenario Entry Adjustment Reason.
DEPENDENT_QUANTITY	NUMBER			Dependent Item Quantity
TOTAL_QUANTITY	NUMBER			Total Quantity
BASELINE_DEPENDENT_QTY	NUMBER			Baseline Dependent Quantity
BASELINE_TOTAL_QTY	NUMBER			Baseline Total Quantity
SR_PRODUCT_LVL_PK	VARCHAR2	(240)		Product source identifier
SR_GEOGRAPHY_LVL_PK	VARCHAR2	(240)		Geography source identifier
SR_CUSTOMER_LVL_PK	VARCHAR2	(240)		Customer source identifier
SR_SALESCHANNEL_LVL_PK	VARCHAR2	(240)		Sales channel source identifier
SR_SALES_REP_LVL_PK	VARCHAR2	(240)		Sales rep source identifier
SR_ORGANIZATION_LVL_PK	VARCHAR2	(240)		Organization source identifier
SR_USER_DEFINED1_LVL_PK	VARCHAR2	(240)		User dimension 1 source identifier
SR_USER_DEFINED2_LVL_PK	VARCHAR2	(240)		User dimension 2 source identifier
INSTANCE	VARCHAR2	(40)		Source instance
FORECAST_PRIORITY	NUMBER			Forecast priority
TOTAL_QUANTITY_UOM	VARCHAR2	(40)		UOM For Quantity
FORECAST_ERROR	NUMBER			Magnitude of Error. This is either MAD or MAPE value depending upon the scenario level ERROR_TYPE value.
DEMAND_CLASS	VARCHAR2	(240)		Demand Class Source PK
DEMAND_CLASS_LVL_ID	NUMBER			Demand Class Level ID
DEMAND_CLASS_LVL_PK	NUMBER		Yes	Demand Class Level Primary Key.
SCENARIO_NAME	VARCHAR2	(240)

Query Text

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


SELECT DEMAND_PLAN_ID
,      SCENARIO_ID
,      ENTRY_ID
,      QUANTITY
,      AMOUNT
,      BASELINE_QUANTITY
,      BASELINE_AMOUNT
,      TIME_LVL_ID
,      TIME_LVL_VAL_FROM
,      TIME_LVL_VAL_TO
,      PRODUCT_LVL_ID
,      PRODUCT_LVL_VAL
,      GEOGRAPHY_LVL_ID
,      GEOGRAPHY_LVL_VAL
,      CUSTOMER_LVL_ID
,      CUSTOMER_LVL_VAL
,      SALESCHANNEL_LVL_ID
,      SALESCHANNEL_LVL_VAL
,      SALES_REP_LVL_ID
,      SALES_REP_LVL_VAL
,      ORGANIZATION_LVL_ID
,      ORGANIZATION_LVL_VAL
,      USER_DEFINED1_LVL_ID
,      USER_DEFINED1_LVL_VAL
,      USER_DEFINED2_LVL_ID
,      USER_DEFINED2_LVL_VAL
,      PRIORITY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PRODUCT_LVL_PK
,      GEOGRAPHY_LVL_PK
,      CUSTOMER_LVL_PK
,      SALESCHANNEL_LVL_PK
,      SALES_REP_LVL_PK
,      ORGANIZATION_LVL_PK
,      USER_DEFINED1_LVL_PK
,      USER_DEFINED2_LVL_PK
,      REVISION
,      PARENT_REVISION
,      COMMENTS
,      ADJUSTMENT_REASON
,      DEPENDENT_QUANTITY
,      TOTAL_QUANTITY
,      BASELINE_DEPENDENT_QTY
,      BASELINE_TOTAL_QTY
,      SR_PRODUCT_LVL_PK
,      SR_GEOGRAPHY_LVL_PK
,      SR_CUSTOMER_LVL_PK
,      SR_SALESCHANNEL_LVL_PK
,      SR_SALES_REP_LVL_PK
,      SR_ORGANIZATION_LVL_PK
,      SR_USER_DEFINED1_LVL_PK
,      SR_USER_DEFINED2_LVL_PK
,      INSTANCE
,      FORECAST_PRIORITY
,      TOTAL_QUANTITY_UOM
,      FORECAST_ERROR
,      DEMAND_CLASS
,      DEMAND_CLASS_LVL_ID
,      DEMAND_CLASS_LVL_PK
,      SCENARIO_NAME
FROM MSD.MSD_DP_SCENARIO_ENTRIES;

Dependencies

[top of page]

MSD.MSD_DP_SCENARIO_ENTRIES does not reference any database object

MSD.MSD_DP_SCENARIO_ENTRIES is referenced by following:

MSD: MSD_DP_SCENARIO_ENTRIES#