eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.MSD_SHIPMENT_DATA_V

Object Details

Object Name:	MSD_SHIPMENT_DATA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_SHIPMENT_DATA_V
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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INV_ORG	VARCHAR2	(240)	Yes	Inventory Organization
INV_ORG_PK	NUMBER		Yes	Inventory Organization's PK (FK to MSD_LEVEL_VALUES_V)
ITEM	VARCHAR2	(240)	Yes	Item.
ITEM_PK	NUMBER		Yes	Item's PK (FK to MSD_LEVEL_VALUES_V)
SALES_CHANNEL	VARCHAR2	(240)	Yes	Sales Channel.
SALES_CHANNEL_PK	NUMBER		Yes	Sales Channel's PK (FK to MSD_LEVEL_VALUES_V)
SALES_REP	VARCHAR2	(240)	Yes	Sales Representative.
SALES_REP_PK	NUMBER		Yes	Sales Representative's PK (FK to MSD_LEVEL_VALUES_V)
SHIP_TO_LOC	VARCHAR2	(240)	Yes	Ship to Location.
SHIP_TO_LOC_PK	NUMBER		Yes	Ship to Location's PK (FK to MSD_LEVEL_VALUES_V)
USER_DEFINED1	VARCHAR2	(320)		First User Defined Dimension Value.
USER_DEFINED1_PK	VARCHAR2	(0)		The Primary Key for the first user defined dimension.
USER_DEFINED2	VARCHAR2	(320)		Second User Defined Dimension Value.
USER_DEFINED2_PK	VARCHAR2	(0)		The Primary Key for the second user defined dimension.
BOOKED_DATE	DATE			The Booking Date for the Order
REQUESTED_DATE	DATE			Requested Date for the Order
PROMISED_DATE	DATE			Promised Date for the Order
SHIPPED_DATE	DATE		Yes	The Shipping Date for the Order
AMOUNT	NUMBER			Total amount booked/requested/promised/shipped on the above dates under the given lowest levels.
QTY_SHIPPED	NUMBER			Quantity shipped.

Query Text

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


SELECT INV_ORG
,      INV_ORG_PK
,      ITEM
,      ITEM_PK
,      SALES_CHANNEL
,      SALES_CHANNEL_PK
,      SALES_REP
,      SALES_REP_PK
,      SHIP_TO_LOC
,      SHIP_TO_LOC_PK
,      USER_DEFINED1
,      USER_DEFINED1_PK
,      USER_DEFINED2
,      USER_DEFINED2_PK
,      BOOKED_DATE
,      REQUESTED_DATE
,      PROMISED_DATE
,      SHIPPED_DATE
,      AMOUNT
,      QTY_SHIPPED
FROM APPS.MSD_SHIPMENT_DATA_V;

Dependencies

[top of page]

APPS.MSD_SHIPMENT_DATA_V references the following:

APPS: MSD_LEVEL_VALUES; MSD_SHIPMENT_DATA

APPS.MSD_SHIPMENT_DATA_V is referenced by following:

APPS: MSD_COMPOSITE_GROUPING - show dependent code