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.

[Home] [Help]

View: MSD_OPPORTUNITY_DATA_V

Product:	MSD - Demand Planning
Description:	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
Implementation/DBA Data:	APPS.MSD_OPPORTUNITY_DATA_V

View Text

SELECT ORG_LVL.LEVEL_VALUE INV_ORG
, ORG_LVL.LEVEL_PK INV_ORG_PK
, ITM_LVL.LEVEL_VALUE ITEM
, ITM_LVL.LEVEL_PK ITEM_PK
, CUS_LVL.LEVEL_VALUE CUSTOMER
, CUS_LVL.LEVEL_PK CUSTOMER_PK
, CHN_LVL.LEVEL_VALUE SALES_CHANNEL
, CHN_LVL.LEVEL_PK SALES_CHANNEL_PK
, REP_LVL.LEVEL_VALUE SALES_REP
, REP_LVL.LEVEL_PK SALES_REP_PK
, GEO_LVL.LEVEL_VALUE SHIP_TO_LOC
, GEO_LVL.LEVEL_PK SHIP_TO_LOC_PK
, MBD.ATTRIBUTE_28 USER_DEFINED1
, NULL USER_DEFINED1_PK
, MBD.ATTRIBUTE_32 USER_DEFINED2
, NULL USER_DEFINED2_PK
, TO_NUMBER(MBD.ATTRIBUTE_41) QUANTITY
, TO_NUMBER(MBD.ATTRIBUTE_42) AMOUNT
, MBD.ATTRIBUTE_34 TIME_LVL_ID
, TO_DATE(MBD.ATTRIBUTE_43
, 'YYYY/MM/DD') END_DATE
FROM MSD_CS_DATA MBD
, MSD_LEVEL_VALUES ORG_LVL
, MSD_LEVEL_VALUES ITM_LVL
, MSD_LEVEL_VALUES CUS_LVL
, MSD_LEVEL_VALUES CHN_LVL
, MSD_LEVEL_VALUES REP_LVL
, MSD_LEVEL_VALUES GEO_LVL
WHERE MBD.ATTRIBUTE_1 = ORG_LVL.INSTANCE
AND MBD.ATTRIBUTE_10 = ORG_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_11 = ORG_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = ITM_LVL.INSTANCE
AND MBD.ATTRIBUTE_2 = ITM_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_3 = ITM_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = GEO_LVL.INSTANCE
AND MBD.ATTRIBUTE_6 = GEO_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_7 = GEO_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = CHN_LVL.INSTANCE
AND MBD.ATTRIBUTE_22 = CHN_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_23 = CHN_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = REP_LVL.INSTANCE
AND MBD.ATTRIBUTE_18 = REP_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_19 = REP_LVL.SR_LEVEL_PK
AND MBD.ATTRIBUTE_1 = CUS_LVL.INSTANCE
AND MBD.ATTRIBUTE_14 = CUS_LVL.LEVEL_ID
AND MBD.ATTRIBUTE_15 = CUS_LVL.SR_LEVEL_PK
AND MBD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_SALES_OPPORTUNITY')

Columns

Name
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