VIEW: APPS.MSD_OPPORTUNITY_DATA_DS_V

Source

View Text - Preformatted

SELECT cdd.demand_plan_id, mbd.CS_DEFINITION_ID, mbd. CS_NAME, mbd.attribute_2, mbd.attribute_5, mbd.attribute_6, mbd.attribute_9, mbd.attribute_10, mbd.attribute_13, mbd.attribute_18, mbd.attribute_21, mbd.attribute_22, mbd.attribute_25, mbd.attribute_26, mbd.attribute_29, mbd.attribute_30, mbd.attribute_33, mbd.attribute_34, mbd.attribute_41, mbd.attribute_42, to_date(mbd.attribute_43, 'YYYY/MM/DD'), mbd.creation_date, mbd.created_by, mbd.last_update_date, mbd.last_updated_by, mbd.last_update_login, mbd.last_refresh_num, created_by_refresh_num, action_code, null, null from msd_cs_data mbd, msd_cs_data_ds cdd, msd_dp_session mds WHERE mbd.cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = 'MSD_SALES_OPPORTUNITY') and mbd.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
, MBD.CS_DEFINITION_ID
, MBD. CS_NAME
, MBD.ATTRIBUTE_2
, MBD.ATTRIBUTE_5
, MBD.ATTRIBUTE_6
, MBD.ATTRIBUTE_9
, MBD.ATTRIBUTE_10
, MBD.ATTRIBUTE_13
, MBD.ATTRIBUTE_18
, MBD.ATTRIBUTE_21
, MBD.ATTRIBUTE_22
, MBD.ATTRIBUTE_25
, MBD.ATTRIBUTE_26
, MBD.ATTRIBUTE_29
, MBD.ATTRIBUTE_30
, MBD.ATTRIBUTE_33
, MBD.ATTRIBUTE_34
, MBD.ATTRIBUTE_41
, MBD.ATTRIBUTE_42
, TO_DATE(MBD.ATTRIBUTE_43
, 'YYYY/MM/DD')
, MBD.CREATION_DATE
, MBD.CREATED_BY
, MBD.LAST_UPDATE_DATE
, MBD.LAST_UPDATED_BY
, MBD.LAST_UPDATE_LOGIN
, MBD.LAST_REFRESH_NUM
, CREATED_BY_REFRESH_NUM
, ACTION_CODE
, NULL
, NULL
FROM MSD_CS_DATA MBD
, MSD_CS_DATA_DS CDD
, MSD_DP_SESSION MDS
WHERE MBD.CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_SALES_OPPORTUNITY')
AND MBD.CS_DATA_ID = CDD.CS_DATA_ID
AND MDS.DEMAND_PLAN_ID = CDD.DEMAND_PLAN_ID