View: MSD_SALES_FCST_BESTCASE_CS_V

Product:	MSD - Demand Planning
Description:	This view is used by express to download data which is received from CRM Sales Online best case amount and releated dimensions data to DP
Implementation/DBA Data:	APPS.MSD_SALES_FCST_BESTCASE_CS_V

View Text

SELECT CS_DEFINITION_ID
, CS_NAME
, ATTRIBUTE_1
, ATTRIBUTE_2
, ATTRIBUTE_3
, ATTRIBUTE_4
, ATTRIBUTE_5
, ATTRIBUTE_6
, ATTRIBUTE_7
, ATTRIBUTE_8
, ATTRIBUTE_9
, ATTRIBUTE_10
, ATTRIBUTE_11
, ATTRIBUTE_12
, ATTRIBUTE_13
, ATTRIBUTE_14
, ATTRIBUTE_15
, ATTRIBUTE_16
, ATTRIBUTE_17
, ATTRIBUTE_18
, ATTRIBUTE_19
, ATTRIBUTE_20
, ATTRIBUTE_21
, ATTRIBUTE_22
, ATTRIBUTE_23
, ATTRIBUTE_24
, ATTRIBUTE_25
, ATTRIBUTE_26
, ATTRIBUTE_27
, ATTRIBUTE_28
, ATTRIBUTE_29
, ATTRIBUTE_30
, ATTRIBUTE_31
, ATTRIBUTE_32
, ATTRIBUTE_33
, ATTRIBUTE_34
, TO_NUMBER(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
WHERE CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_SALES_FCST_BESTCASE')

Columns