[Home] [Help] [Dependency Information]
Object Name: | MSD_BOOKING_DATA_ORIG_CS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MSD.MSD_BOOKING_DATA_ORIG_CS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view to support product substitution in booking data
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PRD_LEVEL_ID | NUMBER | Product Level Id | ||
PRD_LEVEL_VALUE_PK | NUMBER | Yes | Product Level Pk | |
GEO_LEVEL_ID | NUMBER | Geography Level Id | ||
GEO_LEVEL_VALUE_PK | NUMBER | Yes | Geography Level Pk | |
ORG_LEVEL_ID | NUMBER | Organization Level Id | ||
ORG_LEVEL_VALUE_PK | NUMBER | Yes | Organization Level Pk | |
REP_LEVEL_ID | NUMBER | Sales Rep Level Id | ||
REP_LEVEL_VALUE_PK | NUMBER | Yes | Sales Rep Level Pk | |
CHN_LEVEL_ID | NUMBER | Sales Channel Level Id | ||
CHN_LEVEL_VALUE_PK | NUMBER | Yes | Sales Channel Level Pk | |
UD1_LEVEL_ID | VARCHAR2 | (0) | User Defined Level Id | |
UD1_LEVEL_VALUE_PK | VARCHAR2 | (0) | User Defined Level Pk | |
UD2_LEVEL_ID | VARCHAR2 | (0) | User Defined Level Id | |
UD2_LEVEL_VALUE_PK | VARCHAR2 | (0) | User Defined Level Pk | |
PRD_PARENT_LEVEL_ID | VARCHAR2 | (0) | Product Parent Level Id | |
PRD_PARENT_LEVEL_VALUE_PK | VARCHAR2 | (0) | Product Parent Level value Pk | |
TIME_LEVEL_ID | NUMBER | Time Level Id | ||
BOOKED_DATE | DATE | Yes | Booked Date | |
REQUESTED_DATE | DATE | Requested Date | ||
PROMISED_DATE | DATE | Promised Date | ||
SCHEDULED_DATE | DATE | Scheduled Date | ||
AMOUNT | NUMBER | Amount | ||
QUANTITY | NUMBER | Quantity | ||
CREATION_DATE | DATE | Yes | Who columns | |
CREATED_BY | NUMBER | Yes | Who columns | |
LAST_UPDATE_DATE | DATE | Yes | Who columns | |
LAST_UPDATED_BY | NUMBER | Yes | Who columns | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Who columns | |
LAST_REFRESH_NUM | NUMBER | last refresh number | ||
CREATED_BY_REFRESH_NUM | NUMBER | created by refresh number | ||
ACTION_CODE | VARCHAR2 | (30) | DML action code | |
SCHEDULED_ARRIVAL_DATE | DATE | Scheduled Arrival Date | ||
DCS_LEVEL_ID | NUMBER | Product Level Id | ||
DCS_LEVEL_VALUE_PK | NUMBER | Prd Level Value |
Cut, paste (and edit) the following text to query this object:
SELECT PRD_LEVEL_ID
, PRD_LEVEL_VALUE_PK
, GEO_LEVEL_ID
, GEO_LEVEL_VALUE_PK
, ORG_LEVEL_ID
, ORG_LEVEL_VALUE_PK
, REP_LEVEL_ID
, REP_LEVEL_VALUE_PK
, CHN_LEVEL_ID
, CHN_LEVEL_VALUE_PK
, UD1_LEVEL_ID
, UD1_LEVEL_VALUE_PK
, UD2_LEVEL_ID
, UD2_LEVEL_VALUE_PK
, PRD_PARENT_LEVEL_ID
, PRD_PARENT_LEVEL_VALUE_PK
, TIME_LEVEL_ID
, BOOKED_DATE
, REQUESTED_DATE
, PROMISED_DATE
, SCHEDULED_DATE
, AMOUNT
, QUANTITY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, SCHEDULED_ARRIVAL_DATE
, DCS_LEVEL_ID
, DCS_LEVEL_VALUE_PK
FROM APPS.MSD_BOOKING_DATA_ORIG_CS_V;
APPS.MSD_BOOKING_DATA_ORIG_CS_V is not referenced by any database object
|
|
|