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_OPPORTUNITY_DATA_V

Object Details

Object Name:	MSD_OPPORTUNITY_DATA_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MSD.MSD_OPPORTUNITY_DATA_V
Subobject Name:
Status:	VALID

View Type

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

This view Specifies the Opportunity History. This is not stripped by demand plan id. The user can write a custom view to actually restrict the data from this view and pass that in as a parameter to a demand plan by entering that view as the view name attribute in the DP parameters table - MSD_DP_PARAMETERS_V.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
INV_ORG	VARCHAR2	(240)	Yes	Inventory organization.
INV_ORG_PK	NUMBER		Yes	Primary key for the inventory organization.
ITEM	VARCHAR2	(240)	Yes	Product dimansion entry- item level, interest type level, primary interest level, secondary interest level.
ITEM_PK	NUMBER		Yes	Primary key for the item.
CUSTOMER	VARCHAR2	(240)	Yes	Customer.
CUSTOMER_PK	NUMBER		Yes	Primary key for the customer.
SALES_CHANNEL	VARCHAR2	(240)	Yes	Sales channel.
SALES_CHANNEL_PK	NUMBER		Yes	Primary key for the sales channel.
SALES_REP	VARCHAR2	(240)	Yes	sales representative.
SALES_REP_PK	NUMBER		Yes	Primary key for the sales representative.
SHIP_TO_LOC	VARCHAR2	(240)	Yes	Ship to location.
SHIP_TO_LOC_PK	NUMBER		Yes	Primary key for the ' ship to location'.
USER_DEFINED1	VARCHAR2	(255)		Value of the first user defined dimension.
USER_DEFINED1_PK	VARCHAR2	(0)		Primary key for the first user defined dimension.
USER_DEFINED2	VARCHAR2	(255)		Value of the second user defined dimension.
USER_DEFINED2_PK	VARCHAR2	(0)		Primary key for the second user defined dimension.
QUANTITY	NUMBER			Item quantity for the sales opportunity.
AMOUNT	NUMBER			The sales opportunity amount in the demand planning server currency.
TIME_LVL_ID	VARCHAR2	(255)		Time Level Id
END_DATE	DATE			Shipping date for the sales opportunity.

Query Text

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


SELECT INV_ORG
,      INV_ORG_PK
,      ITEM
,      ITEM_PK
,      CUSTOMER
,      CUSTOMER_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
,      QUANTITY
,      AMOUNT
,      TIME_LVL_ID
,      END_DATE
FROM APPS.MSD_OPPORTUNITY_DATA_V;

Dependencies

[top of page]

APPS.MSD_OPPORTUNITY_DATA_V references the following:

APPS: MSD_CS_DATA; MSD_CS_DEFINITIONS; MSD_LEVEL_VALUES

APPS.MSD_OPPORTUNITY_DATA_V is not referenced by any database object