[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSD_EVENTS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSD |
| FND Design Data: |  MSD.MSD_EVENTS
|
| Subobject Name: | |
| Status: | VALID |
This table stores the Marketing Events. This defines the types of Events and is the header to the MSD_EVENT_PRODUCTS table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSD_EVENTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 EVENT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EVENT_ID | NUMBER | Yes | Event ID is the primary key. | |
| EVENT_NAME | VARCHAR2 | (240) | Yes | Event Name |
| DESCRIPTION | VARCHAR2 | (240) | ||
| EVENT_TYPE | VARCHAR2 | (1) | Yes | Event Type. This is based on the MSD_EVENT_TYPE lookup. The possible values are: 1. Competitive Promotion, 2. Compulsory Promotion, 3. New Product Introduction, 4. Product Phase Out, 5. Competitive Cannibalization, 6. Compulsory Cannibalization, 7. Competitive Other, 8. Compulsory Other |
| MODIFICATION_TYPE | VARCHAR2 | (1) | ||
| PERIOD_TYPE | NUMBER | |||
| INTRODUCTION_TYPE | VARCHAR2 | (1) | Introduction Type. This is based on the MSD_INTRODUCTION_TYPE lookup. The possible values are: 1. History Based, 2. Forecast Based | |
| SPREAD_PRODUCT | VARCHAR2 | (240) | ||
| PRODUCT_START_TIME | DATE | |||
| PRODUCT_END_TIME | DATE | |||
| PRIORITY | NUMBER | |||
| PRODUCT_LVL_ID | NUMBER | |||
| PRODUCT_LVL_VAL | VARCHAR2 | (240) | ||
| GEOGRAPHY_LVL_ID | NUMBER | |||
| GEOGRAPHY_LVL_VAL | VARCHAR2 | (240) | ||
| CUSTOMER_LVL_ID | NUMBER | |||
| CUSTOMER_LVL_VAL | VARCHAR2 | (240) | ||
| SALESCHANNEL_LVL_ID | NUMBER | |||
| SALESCHANNEL_LVL_VAL | VARCHAR2 | (240) | ||
| SALES_REP_LVL_ID | NUMBER | |||
| SALES_REP_LVL_VAL | VARCHAR2 | (240) | ||
| ORGANIZATION_LVL_ID | NUMBER | |||
| ORGANIZATION_LVL_VAL | VARCHAR2 | (240) | ||
| USER_DEFINED1_LVL_ID | NUMBER | |||
| USER_DEFINED1_LVL_VAL | VARCHAR2 | (240) | ||
| USER_DEFINED2_LVL_ID | NUMBER | |||
| USER_DEFINED2_LVL_VAL | VARCHAR2 | (240) | ||
| 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 | Enhanced who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Enhanced who column | ||
| PROGRAM_ID | NUMBER | Enhanced who column | ||
| PROGRAM_UPDATE_DATE | DATE | Enhanced who column | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| INSTANCE | VARCHAR2 | (40) | Instance | |
| SPREAD_PRODUCT_LVL_ID | NUMBER | |||
| SPREAD_PRODUCT_LVL_VAL | VARCHAR2 | (240) | ||
| SR_SPREAD_PRODUCT_LVL_PK | VARCHAR2 | (240) | ||
| SR_PRODUCT_LVL_PK | VARCHAR2 | (240) | ||
| SR_GEOGRAPHY_LVL_PK | VARCHAR2 | (240) | ||
| SR_CUSTOMER_LVL_PK | VARCHAR2 | (240) | ||
| SR_SALESCHANNEL_LVL_PK | VARCHAR2 | (240) | ||
| SR_SALES_REP_LVL_PK | VARCHAR2 | (240) | ||
| SR_ORGANIZATION_LVL_PK | VARCHAR2 | (240) | ||
| SR_USER_DEFINED1_LVL_PK | VARCHAR2 | (240) | ||
| SR_USER_DEFINED2_LVL_PK | VARCHAR2 | (240) | ||
| EVENT_DESCRIPTION | VARCHAR2 | (240) | Event Description. | |
| EVENT_PRIORITY | NUMBER | Event priority | ||
| FORECAST_BASIS | VARCHAR2 | (1) | Forecast Basis LOV values | |
| AUTO_UPDATE_SS_FLAG | VARCHAR2 | (30) | Auto Update Supersession Flag |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, EVENT_NAME
, DESCRIPTION
, EVENT_TYPE
, MODIFICATION_TYPE
, PERIOD_TYPE
, INTRODUCTION_TYPE
, SPREAD_PRODUCT
, PRODUCT_START_TIME
, PRODUCT_END_TIME
, PRIORITY
, 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
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, INSTANCE
, SPREAD_PRODUCT_LVL_ID
, SPREAD_PRODUCT_LVL_VAL
, SR_SPREAD_PRODUCT_LVL_PK
, 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
, EVENT_DESCRIPTION
, EVENT_PRIORITY
, FORECAST_BASIS
, AUTO_UPDATE_SS_FLAG
FROM MSD.MSD_EVENTS;
MSD.MSD_EVENTS does not reference any database object
MSD.MSD_EVENTS is referenced by following:
MSD
MSD_EVENTS#
|
|
|
|