VIEW: APPS.MSD_SERVICE_PART_USAGE_DS_V

Source

View Text - Preformatted

SELECT cdd.demand_plan_id, csd.cs_definition_id, csd.cs_name, /* Instance */ csd.attribute_1, /* Product */ csd.attribute_2, csd.attribute_3, csd.attribute_4, csd.attribute_5, /* Geogrpahy */ csd.attribute_6, csd.attribute_7, csd.attribute_8, csd.attribute_9, /* Organization */ csd.attribute_10, csd.attribute_11, csd.attribute_12, csd.attribute_13, /* Dependent Demand */ csd.attribute_14, csd.attribute_15, csd.attribute_16, csd.attribute_17, /* Sales Rep */ csd.attribute_18, csd.attribute_19, csd.attribute_20, csd.attribute_21, /* Sales Channel */ csd.attribute_22, csd.attribute_23, csd.attribute_24, csd.attribute_25, /* User Defined 1 */ csd.attribute_26, csd.attribute_27, csd.attribute_28, csd.attribute_29, /* User Defined 2 */ csd.attribute_30, csd.attribute_31, csd.attribute_32, csd.attribute_33, /* Time Level Id */ csd.attribute_34, /* Quantity */ csd.attribute_41, /* Replacement Date */ to_date( csd.attribute_43, 'yyyy/mm/dd'), /* WHO Columns */ csd.creation_date, csd.created_by, csd.last_update_date, csd.last_updated_by, csd.last_update_login, /* Net Change */ csd.last_refresh_num, csd.created_by_refresh_num, csd.action_code 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_SRP_USAGE_HISTORY') 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
, /* INSTANCE */ CSD.ATTRIBUTE_1
, /* PRODUCT */ CSD.ATTRIBUTE_2
, CSD.ATTRIBUTE_3
, CSD.ATTRIBUTE_4
, CSD.ATTRIBUTE_5
, /* GEOGRPAHY */ CSD.ATTRIBUTE_6
, CSD.ATTRIBUTE_7
, CSD.ATTRIBUTE_8
, CSD.ATTRIBUTE_9
, /* ORGANIZATION */ CSD.ATTRIBUTE_10
, CSD.ATTRIBUTE_11
, CSD.ATTRIBUTE_12
, CSD.ATTRIBUTE_13
, /* DEPENDENT DEMAND */ CSD.ATTRIBUTE_14
, CSD.ATTRIBUTE_15
, CSD.ATTRIBUTE_16
, CSD.ATTRIBUTE_17
, /* SALES REP */ CSD.ATTRIBUTE_18
, CSD.ATTRIBUTE_19
, CSD.ATTRIBUTE_20
, CSD.ATTRIBUTE_21
, /* SALES CHANNEL */ CSD.ATTRIBUTE_22
, CSD.ATTRIBUTE_23
, CSD.ATTRIBUTE_24
, CSD.ATTRIBUTE_25
, /* USER DEFINED 1 */ CSD.ATTRIBUTE_26
, CSD.ATTRIBUTE_27
, CSD.ATTRIBUTE_28
, CSD.ATTRIBUTE_29
, /* USER DEFINED 2 */ CSD.ATTRIBUTE_30
, CSD.ATTRIBUTE_31
, CSD.ATTRIBUTE_32
, CSD.ATTRIBUTE_33
, /* TIME LEVEL ID */ CSD.ATTRIBUTE_34
, /* QUANTITY */ CSD.ATTRIBUTE_41
, /* REPLACEMENT DATE */ TO_DATE( CSD.ATTRIBUTE_43
, 'YYYY/MM/DD')
, /* WHO COLUMNS */ CSD.CREATION_DATE
, CSD.CREATED_BY
, CSD.LAST_UPDATE_DATE
, CSD.LAST_UPDATED_BY
, CSD.LAST_UPDATE_LOGIN
, /* NET CHANGE */ CSD.LAST_REFRESH_NUM
, CSD.CREATED_BY_REFRESH_NUM
, CSD.ACTION_CODE
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_SRP_USAGE_HISTORY')
AND CSD.CS_DATA_ID = CDD.CS_DATA_ID
AND MDS.DEMAND_PLAN_ID = CDD.DEMAND_PLAN_ID