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

VIEW: APPS.MSD_SHIPMENT_DATA_DS_V

Object Details
Object Name: MSD_SHIPMENT_DATA_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 provides the shipment Data in the planning server and is not restricted by a demand plan. If the Planning Server is used for only one demand plan then we can go directly out of the fact table or this view. However if the planning server t is used for supporting multiple demand plans, then the user needs to write views on top of the fact table or this table, and these views would be attached to the view_name attribute of them demand plan parameters. This view 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 Value Primary Key
GEO_LEVEL_ID NUMBER

Geography Level Id
GEO_LEVEL_VALUE_PK NUMBER
Yes Geography Level Value Primary Key
ORG_LEVEL_ID NUMBER

Org Level Id
ORG_LEVEL_VALUE_PK NUMBER
Yes Org Level Value Primary Key
REP_LEVEL_ID NUMBER

Sales Rep Level Id
REP_LEVEL_VALUE_PK NUMBER
Yes Sales Rep Level Value Primary Key
CHN_LEVEL_ID NUMBER

Sales Chennal Level Id
CHN_LEVEL_VALUE_PK NUMBER
Yes Sales Chennal Level Value Primary Key
UD1_LEVEL_ID VARCHAR2 (0)
User Defined Level Id
UD1_LEVEL_VALUE_PK VARCHAR2 (0)
User Defined Level Value Primary Key
UD2_LEVEL_ID VARCHAR2 (0)
User Defined Level Id
UD2_LEVEL_VALUE_PK VARCHAR2 (0)
User Defined Level Value Primary Key
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

Booked Date
REQUESTED_DATE DATE

Requested Date
PROMISED_DATE DATE

Promised Date
SHIPPED_DATE DATE
Yes Shipped Date
AMOUNT NUMBER

Amount
QUANTITY NUMBER

Quantity Shipped
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_DATE DATE

Scheduled Ship Date
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
,      SHIPPED_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_DATE
,      SCHEDULED_ARRIVAL_DATE
,      DCS_LEVEL_ID
,      DCS_LEVEL_VALUE_PK
FROM APPS.MSD_SHIPMENT_DATA_DS_V;

Dependencies

[top of page]

APPS.MSD_SHIPMENT_DATA_DS_V references the following:

SchemaAPPS
SynonymMSD_DP_SESSION
SynonymMSD_LEVEL_VALUES_DS
SynonymMSD_SHIPMENT_DATA

APPS.MSD_SHIPMENT_DATA_DS_V is not referenced by any database object