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.

[Home] [Help]

View: MSD_EVENT_DETAILS_V

Product:	MSD - Demand Planning
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MEV.EVENT_ID
, MEV.EVENT_NAME
, MEV.EVENT_DESCRIPTION
, MEV.EVENT_TYPE_ID
, MEV.EVENT_TYPE
, MEV.MODIFICATION_TYPE_ID
, MEV.MODIFICATION
, MEV.PERIOD_TYPE_ID
, MEV.PERIOD_TYPE
, MEV.INTRODUCTION_TYPE_ID
, MEV.INTRODUCTION_TYPE
, MEV.SPREAD_PRODUCT
, MEV.PRODUCT_START_TIME
, MEV.PRODUCT_END_TIME
, MEV.EVENT_PRIORITY
, MED.DETAIL_ID
, MED.UPLIFT_FACTOR
, MED.TIME_LVL_VAL_FROM
, MED.TIME_LVL_VAL_TO
, MED.PRODUCT_LVL_ID
, MED.PRODUCT_LVL_VAL
, MED.GEOGRAPHY_LVL_ID
, MED.GEOGRAPHY_LVL_VAL
, MED.CUSTOMER_LVL_ID
, MED.CUSTOMER_LVL_VAL
, MED.SALESCHANNEL_LVL_ID
, MED.SALESCHANNEL_LVL_VAL
, MED.SALES_REP_LVL_ID
, MED.SALES_REP_LVL_VAL
, MED.ORGANIZATION_LVL_ID
, MED.ORGANIZATION_LVL_VAL
, MED.USER_DEFINED1_LVL_ID
, MED.USER_DEFINED1_LVL_VAL
, MED.USER_DEFINED2_LVL_ID
, MED.USER_DEFINED2_LVL_VAL
FROM MSD_EVENTS_V MEV
, MSD_EVENT_DETAILS MED
WHERE MEV.EVENT_ID = MED.EVENT_ID

Columns

Name
EVENT_ID
EVENT_NAME
EVENT_DESCRIPTION
EVENT_TYPE_ID
EVENT_TYPE
MODIFICATION_TYPE_ID
MODIFICATION
PERIOD_TYPE_ID
PERIOD_TYPE
INTRODUCTION_TYPE_ID
INTRODUCTION_TYPE
SPREAD_PRODUCT
PRODUCT_START_TIME
PRODUCT_END_TIME
EVENT_PRIORITY
DETAIL_ID
UPLIFT_FACTOR
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