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

TABLE: MSD.MSD_EVT_PRODUCT_DETAILS

Object Details
Object Name: MSD_EVT_PRODUCT_DETAILS
Object Type: TABLE
Owner: MSD
FND Design Data: TableMSD.MSD_EVT_PRODUCT_DETAILS
Subobject Name:
Status: VALID


This table is a child to the MSD_EVENT_PRODUCTS. This stores all the detail events information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSD_EVT_PRODUCT_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEVENT_ID
ColumnSEQ_ID
ColumnDETAIL_ID
Columns
Name Datatype Length Mandatory Comments
INSTANCE VARCHAR2 (40)
Instance
EVENT_ID NUMBER
Yes Event ID. This is the Primary Key. This is generated out of MSD_EVENTS_S sequence.
SEQ_ID NUMBER
Yes Sequence Id.
DETAIL_ID NUMBER
Yes Detail Id
RELATION_ID NUMBER

Relation Id
TIME_LVL_ID NUMBER

Time Level Id
TIME_LVL_VAL_FROM DATE

Time Level Value From
TIME_LVL_VAL_TO DATE

Time Level Value To
PRODUCT_LVL_ID NUMBER

Product Level Id
PRODUCT_LVL_VAL VARCHAR2 (240)
Product Level Value
SR_PRODUCT_LVL_PK VARCHAR2 (240)
Source Product Level Primary Key
QTY_MODIFICATION_TYPE VARCHAR2 (1)
Quantity Modification Type
PRICE_MODIFICATION_TYPE VARCHAR2 (1)
Price Modification Type
QTY_MODIFICATION_FACTOR NUMBER

Quantity Modification Factor
PRICE_MODIFICATION_FACTOR NUMBER

Price Modification Factor
GEOGRAPHY_LVL_ID NUMBER

Geography Level Id
GEOGRAPHY_LVL_VAL VARCHAR2 (240)
Geography Level Value
SR_GEOGRAPHY_LVL_PK VARCHAR2 (240)
Source Geography Level Primary Key
SALESCHANNEL_LVL_ID NUMBER

Saleschannel Level Id
SALESCHANNEL_LVL_VAL VARCHAR2 (240)
Saleschannel Level Value
SR_SALESCHANNEL_LVL_PK VARCHAR2 (240)
Source Saleschannel Level Primary Key
SALESREP_LVL_ID NUMBER

Sales Representative Level Id
SALESREP_LVL_VAL VARCHAR2 (240)
Sales Representative Level Value
SR_SALESREP_LVL_PK VARCHAR2 (240)
Source Salesrep Level Primary Key
ORGANIZATION_LVL_ID NUMBER

Organization Level Id
ORGANIZATION_LVL_VAL VARCHAR2 (240)
Organization Level Value
SR_ORGANIZATION_LVL_PK VARCHAR2 (240)
Source Organization Level Primary Key
USER_DEFINED1_LVL_ID NUMBER

User Defined Level Id
USER_DEFINED1_LVL_VAL VARCHAR2 (240)
User Defined Level Value
USER_DEFINED1_LVL_PK NUMBER

User Defined Level Primary Key
USER_DEFINED2_LVL_ID NUMBER

User Defined Level Id
USER_DEFINED2_LVL_VAL VARCHAR2 (240)
User Defined Level Value
USER_DEFINED2_LVL_PK NUMBER

User Defined Level Primary Key
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
DEMAND_CLASS_LVL_ID NUMBER

Demand Class Level ID
DEMAND_CLASS_LVL_VAL VARCHAR2 (240)
Demand Class Level Value
SR_DEMAND_CLASS_LVL_PK VARCHAR2 (240)
Source Demand Class Level Primary Key
SR_USER_DEFINED1_LVL_PK VARCHAR2 (240)
Source User Defined1 Level Primary Key
SR_USER_DEFINED2_LVL_PK VARCHAR2 (240)
Source User Defined2 Level Primary Key
Query Text

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


SELECT INSTANCE
,      EVENT_ID
,      SEQ_ID
,      DETAIL_ID
,      RELATION_ID
,      TIME_LVL_ID
,      TIME_LVL_VAL_FROM
,      TIME_LVL_VAL_TO
,      PRODUCT_LVL_ID
,      PRODUCT_LVL_VAL
,      SR_PRODUCT_LVL_PK
,      QTY_MODIFICATION_TYPE
,      PRICE_MODIFICATION_TYPE
,      QTY_MODIFICATION_FACTOR
,      PRICE_MODIFICATION_FACTOR
,      GEOGRAPHY_LVL_ID
,      GEOGRAPHY_LVL_VAL
,      SR_GEOGRAPHY_LVL_PK
,      SALESCHANNEL_LVL_ID
,      SALESCHANNEL_LVL_VAL
,      SR_SALESCHANNEL_LVL_PK
,      SALESREP_LVL_ID
,      SALESREP_LVL_VAL
,      SR_SALESREP_LVL_PK
,      ORGANIZATION_LVL_ID
,      ORGANIZATION_LVL_VAL
,      SR_ORGANIZATION_LVL_PK
,      USER_DEFINED1_LVL_ID
,      USER_DEFINED1_LVL_VAL
,      USER_DEFINED1_LVL_PK
,      USER_DEFINED2_LVL_ID
,      USER_DEFINED2_LVL_VAL
,      USER_DEFINED2_LVL_PK
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DEMAND_CLASS_LVL_ID
,      DEMAND_CLASS_LVL_VAL
,      SR_DEMAND_CLASS_LVL_PK
,      SR_USER_DEFINED1_LVL_PK
,      SR_USER_DEFINED2_LVL_PK
FROM MSD.MSD_EVT_PRODUCT_DETAILS;

Dependencies

[top of page]

MSD.MSD_EVT_PRODUCT_DETAILS does not reference any database object

MSD.MSD_EVT_PRODUCT_DETAILS is referenced by following:

SchemaMSD
ViewMSD_EVT_PRODUCT_DETAILS#