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

VIEW: APPS.MSD_BOOKING_DATA_ORIG_DS_V

Object Details
Object Name: MSD_BOOKING_DATA_ORIG_DS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


This view to support product substitution in booking data. It is striped by demand plan.


[View Source]

Columns
Name Datatype Length Mandatory Comments
DEMAND_PLAN_ID NUMBER
Yes Demand Plan Id
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 (1)
Product Parent Level Id
PRD_PARENT_LEVEL_VALUE_PK NUMBER

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

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


SELECT DEMAND_PLAN_ID
,      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_DS_V;

Dependencies

[top of page]

APPS.MSD_BOOKING_DATA_ORIG_DS_V references the following:

SchemaAPPS
SynonymMSD_BOOKING_DATA
SynonymMSD_DP_SESSION
SynonymMSD_LEVEL_VALUES_DS

APPS.MSD_BOOKING_DATA_ORIG_DS_V is not referenced by any database object