VIEW: APPS.MSD_SALES_FCST_PIPELINE_DS_V

Source

View Text - Preformatted

SELECT cdd.demand_plan_id, csd.cs_definition_id, csd.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'), csd.creation_date, csd.created_by, csd.last_update_date, csd.last_updated_by, csd.last_update_login,csd.last_refresh_num, created_by_refresh_num, action_code, to_number(null), to_number(null) from msd_cs_data csd, msd_cs_data_ds cdd, msd_dp_session mds WHERE csd.cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = 'MSD_SALES_FCST_PIPELINE') and csd.cs_data_id = cdd.cs_data_id and mds.demand_plan_id = cdd.demand_plan_id

View Text - HTML Formatted

SELECT CDD.DEMAND_PLAN_ID
, CSD.CS_DEFINITION_ID
, CSD.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')
, CSD.CREATION_DATE
, CSD.CREATED_BY
, CSD.LAST_UPDATE_DATE
, CSD.LAST_UPDATED_BY
, CSD.LAST_UPDATE_LOGIN
, CSD.LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MSD_CS_DATA CSD
, MSD_CS_DATA_DS CDD
, MSD_DP_SESSION MDS
WHERE CSD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_SALES_FCST_PIPELINE')
AND CSD.CS_DATA_ID = CDD.CS_DATA_ID
AND MDS.DEMAND_PLAN_ID = CDD.DEMAND_PLAN_ID