Product: | MSD - Demand Planning |
---|---|
Description: | This view Specifies the Opportunity History. This view is based on Flexible data stream entity MSD_CS_DATA. |
Implementation/DBA Data: | APPS.MSD_OPPORTUNITY_DATA_CS_V |
SELECT CS_DEFINITION_ID
, CS_NAME
, ATTRIBUTE_2
, ATTRIBUTE_5
, ATTRIBUTE_6
, ATTRIBUTE_9
, ATTRIBUTE_10
, ATTRIBUTE_13
, ATTRIBUTE_18
, ATTRIBUTE_21
, ATTRIBUTE_22
, ATTRIBUTE_25
, ATTRIBUTE_26
, ATTRIBUTE_29
, ATTRIBUTE_30
, ATTRIBUTE_33
, ATTRIBUTE_34
, ATTRIBUTE_41
, ATTRIBUTE_42
, TO_DATE(ATTRIBUTE_43
, 'YYYY/MM/DD')
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
FROM MSD_CS_DATA MBD
WHERE MBD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_SALES_OPPORTUNITY')