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

VIEW: APPS.MSD_EVENTS_V

Object Details
Object Name: MSD_EVENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSD.MSD_EVENTS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This API defines the types of Events and is the header to the MSD_EVENT_PRODUCTS_V API. This is based on top of the MSD_EVENTS table.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
INSTANCE VARCHAR2 (40)
Instance
EVENT_ID NUMBER
Yes Event Id
EVENT_NAME VARCHAR2 (240) Yes Event Name
EVENT_DESCRIPTION VARCHAR2 (240)
Event Description
EVENT_TYPE_ID VARCHAR2 (1) Yes Identifier for the type of event. 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.
EVENT_TYPE VARCHAR2 (80) Yes Event type for the ID mentioned in the previous column.
INTRODUCTION_TYPE_ID VARCHAR2 (1)
Type of introductions. The possible values are- 1. History based, 2. Forecast based.
INTRODUCTION_TYPE VARCHAR2 (80)
Introduction type as in previous column.
EVENT_PRIORITY NUMBER

Event priority.
FORECAST_BASIS_ID VARCHAR2 (1)
Forecast Basis Id
FORECAST_BASIS VARCHAR2 (80)
Forecast Basis
AUTO_UPDATE_SS_FLAG VARCHAR2 (30)
Auto Update Supersession Flag
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

Enhanced 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
Query Text

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


SELECT ROW_ID
,      INSTANCE
,      EVENT_ID
,      EVENT_NAME
,      EVENT_DESCRIPTION
,      EVENT_TYPE_ID
,      EVENT_TYPE
,      INTRODUCTION_TYPE_ID
,      INTRODUCTION_TYPE
,      EVENT_PRIORITY
,      FORECAST_BASIS_ID
,      FORECAST_BASIS
,      AUTO_UPDATE_SS_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.MSD_EVENTS_V;

Dependencies

[top of page]

APPS.MSD_EVENTS_V references the following:

SchemaAPPS
ViewFND_LOOKUP_VALUES_VL
SynonymMSD_EVENTS
APPS.MSD_EVENTS_V is referenced by following:

SchemaAPPS
ViewMSD_DP_EVENTS_V
ViewMSD_DP_SCENARIO_EVENTS_V
Package BodyMSD_VALIDATE_DEMAND_PLAN - show dependent code