[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSD_EVT_PRODUCT_DETAILS_V1 |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  MSD.MSD_EVT_PRODUCT_DETAILS_V1
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This API is a child to the MSD_EVENTS_PRODUCTS_V API. This API holds time frame for which this product promotion is run and the corresponding modification factor. In the case of New Product Introductions, the modifications are based on related products. Additionally, this view holds information for all other optional dimensions that can be used to qualify the promotion event.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row Id | |
| INSTANCE | VARCHAR2 | (40) | Instance | |
| EVENT_ID | NUMBER | Yes | Event Id | |
| SEQ_ID | NUMBER | Yes | Sequence Id | |
| DETAIL_ID | NUMBER | Yes | Detail 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_NAME | VARCHAR2 | (4000) | Product Level Name | |
| PRODUCT_LVL_VAL | VARCHAR2 | (240) | Product Level Value | |
| PRODUCT_LVL_PK | NUMBER | Product Level Primary Key | ||
| SR_PRODUCT_LVL_PK | VARCHAR2 | (240) | Source Product Level Primary Key | |
| QTY_MODIFICATION_TYPE_ID | VARCHAR2 | (1) | Quantity Modification Type Id | |
| PRICE_MODIFICATION_TYPE_ID | VARCHAR2 | (1) | Price Modification Type Id | |
| QTY_MODIFICATION_TYPE | VARCHAR2 | (80) | Quantity Modification Type | |
| PRICE_MODIFICATION_TYPE | VARCHAR2 | (80) | 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_NAME | VARCHAR2 | (4000) | Geography Level Name | |
| GEOGRAPHY_LVL_VAL | VARCHAR2 | (240) | Geography Level Value | |
| GEOGRAPHY_LVL_PK | NUMBER | Geography Level Primary Key | ||
| SR_GEOGRAPHY_LVL_PK | VARCHAR2 | (240) | Source Geography Level Primary Key | |
| SALESCHANNEL_LVL_ID | NUMBER | Saleschannel Level Id | ||
| SALESCHANNEL_LVL_NAME | VARCHAR2 | (4000) | Saleschannel Level Name | |
| SALESCHANNEL_LVL_VAL | VARCHAR2 | (240) | Saleschannel Level Value | |
| SALESCHANNEL_LVL_PK | NUMBER | Saleschannel Level Primary Key | ||
| SR_SALESCHANNEL_LVL_PK | VARCHAR2 | (240) | Source Saleschannel Level Primary Key | |
| SALESREP_LVL_ID | NUMBER | Sales Representative Level Id | ||
| SALESREP_LVL_NAME | VARCHAR2 | (4000) | Sales Representative Level Name | |
| SALESREP_LVL_VAL | VARCHAR2 | (240) | Sales Representative Level Value | |
| SALESREP_LVL_PK | NUMBER | Sales Representative Level Primary Key | ||
| SR_SALESREP_LVL_PK | VARCHAR2 | (240) | Source Sales Representative Level Primary Key | |
| ORGANIZATION_LVL_ID | NUMBER | Organization Level Id | ||
| ORGANIZATION_LVL_NAME | VARCHAR2 | (4000) | Organization Level Name | |
| ORGANIZATION_LVL_VAL | VARCHAR2 | (240) | Organization Level Value | |
| ORGANIZATION_LVL_PK | NUMBER | Organization Level Primary Key | ||
| SR_ORGANIZATION_LVL_PK | VARCHAR2 | (240) | Source Organization Level Primary Key | |
| USER_DEFINED1_LVL_ID | NUMBER | User Defined Level Id | ||
| USER_DEFINED1_LVL_NAME | VARCHAR2 | (4000) | User Defined Level Name | |
| USER_DEFINED1_LVL_VAL | VARCHAR2 | (240) | User Defined Level Value | |
| USER_DEFINED1_LVL_PK | NUMBER | User Defined Level Primary Key | ||
| SR_USER_DEFINED1_LVL_PK | VARCHAR2 | (240) | Source User Defined 1 Level Primary Key | |
| USER_DEFINED2_LVL_ID | NUMBER | User Defined Level Id | ||
| USER_DEFINED2_LVL_NAME | VARCHAR2 | (4000) | User Defined Level Name | |
| USER_DEFINED2_LVL_VAL | VARCHAR2 | (240) | User Defined Level Value | |
| USER_DEFINED2_LVL_PK | NUMBER | User Defined Level Primary Key | ||
| SR_USER_DEFINED2_LVL_PK | VARCHAR2 | (240) | Source User Defined 2 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 | 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 | ||
| DEMAND_CLASS_LVL_ID | NUMBER | Demand Class Level Id | ||
| DEMAND_CLASS_LVL_NAME | VARCHAR2 | (4000) | Demand Class Level Name | |
| DEMAND_CLASS_LVL_VAL | VARCHAR2 | (240) | Demand Class Level Value | |
| DEMAND_CLASS_LVL_PK | NUMBER | Demand Class Level Primary Key | ||
| SR_DEMAND_CLASS_LVL_PK | VARCHAR2 | (240) | Source Sales Representative Level Primary Key | |
| DP_ENABLED_FLAG | NUMBER | Demand Planning Enabled flag |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, INSTANCE
, EVENT_ID
, SEQ_ID
, DETAIL_ID
, TIME_LVL_VAL_FROM
, TIME_LVL_VAL_TO
, PRODUCT_LVL_ID
, PRODUCT_LVL_NAME
, PRODUCT_LVL_VAL
, PRODUCT_LVL_PK
, SR_PRODUCT_LVL_PK
, QTY_MODIFICATION_TYPE_ID
, PRICE_MODIFICATION_TYPE_ID
, QTY_MODIFICATION_TYPE
, PRICE_MODIFICATION_TYPE
, QTY_MODIFICATION_FACTOR
, PRICE_MODIFICATION_FACTOR
, GEOGRAPHY_LVL_ID
, GEOGRAPHY_LVL_NAME
, GEOGRAPHY_LVL_VAL
, GEOGRAPHY_LVL_PK
, SR_GEOGRAPHY_LVL_PK
, SALESCHANNEL_LVL_ID
, SALESCHANNEL_LVL_NAME
, SALESCHANNEL_LVL_VAL
, SALESCHANNEL_LVL_PK
, SR_SALESCHANNEL_LVL_PK
, SALESREP_LVL_ID
, SALESREP_LVL_NAME
, SALESREP_LVL_VAL
, SALESREP_LVL_PK
, SR_SALESREP_LVL_PK
, ORGANIZATION_LVL_ID
, ORGANIZATION_LVL_NAME
, ORGANIZATION_LVL_VAL
, ORGANIZATION_LVL_PK
, SR_ORGANIZATION_LVL_PK
, USER_DEFINED1_LVL_ID
, USER_DEFINED1_LVL_NAME
, USER_DEFINED1_LVL_VAL
, USER_DEFINED1_LVL_PK
, SR_USER_DEFINED1_LVL_PK
, USER_DEFINED2_LVL_ID
, USER_DEFINED2_LVL_NAME
, USER_DEFINED2_LVL_VAL
, USER_DEFINED2_LVL_PK
, SR_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_NAME
, DEMAND_CLASS_LVL_VAL
, DEMAND_CLASS_LVL_PK
, SR_DEMAND_CLASS_LVL_PK
, DP_ENABLED_FLAG
FROM APPS.MSD_EVT_PRODUCT_DETAILS_V1;
APPS
FND_LOOKUP_VALUES_VL
MSD_COMMON_UTILITIES
- show dependent code
MSD_EVENTS
MSD_EVENT_PRODUCTS
MSD_EVT_PRODUCT_DETAILS
APPS.MSD_EVT_PRODUCT_DETAILS_V1 is not referenced by any database object
|
|
|
|