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_BOOKING_DATA_V

Object Details

Object Name:	MSD_BOOKING_DATA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_BOOKING_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 Booking 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 is used for supporting multiple demand plans, then the user needs to write views on top of it, and these views would be attached to the view_name attribute of the demand plan parameter.

[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		Yes	The Booking Date for the Order
REQUESTED_DATE	DATE			Requested Date for the Order
PROMISED_DATE	DATE			Promised Date for the Order
SCHEDULED_DATE	DATE			Scheduled Date for the Order
AMOUNT	NUMBER			Total amount booked/requested/promised/scheduled on the above dates under the given lowest levels.
QTY_ORDERED	NUMBER			Total quantity booked/requested/promised/scheduled on the above dates under the given lowest levels

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
,      SCHEDULED_DATE
,      AMOUNT
,      QTY_ORDERED
FROM APPS.MSD_BOOKING_DATA_V;

Dependencies

[top of page]

APPS.MSD_BOOKING_DATA_V references the following:

APPS: MSD_BOOKING_DATA; MSD_LEVEL_VALUES

APPS.MSD_BOOKING_DATA_V is referenced by following:

APPS: MSD_COMPOSITE_GROUPING - show dependent code