VIEW: APPS.MSD_SERVICE_PART_RETURN_CS_V

Source

View Text - Preformatted

SELECT cs_definition_id, cs_name, /* Instance */ attribute_1, /* Product */ attribute_2, attribute_3, attribute_4, attribute_5, /* Geogrpahy */ attribute_6, attribute_7, attribute_8, attribute_9, /* Organization */ attribute_10, attribute_11, attribute_12, attribute_13, /* Dependent Demand */ attribute_14, attribute_15, attribute_16, attribute_17, /* Sales Rep */ attribute_18, attribute_19, attribute_20, attribute_21, /* Sales Channel */ attribute_22, attribute_23, attribute_24, attribute_25, /* User Defined 1 */ attribute_26, attribute_27, attribute_28, attribute_29, /* User Defined 2 */ attribute_30, attribute_31, attribute_32, attribute_33, /* Time Level Id */ attribute_34, /* Quantity */ attribute_41, /* Return Date */ to_date(attribute_43, 'yyyy/mm/dd'), /* WHO Columns */ creation_date, created_by, last_update_date, last_updated_by, last_update_login, /* Net Change */ 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_SRP_RETURN_HISTORY')

View Text - HTML Formatted

SELECT CS_DEFINITION_ID
, CS_NAME
, /* INSTANCE */ ATTRIBUTE_1
, /* PRODUCT */ ATTRIBUTE_2
, ATTRIBUTE_3
, ATTRIBUTE_4
, ATTRIBUTE_5
, /* GEOGRPAHY */ ATTRIBUTE_6
, ATTRIBUTE_7
, ATTRIBUTE_8
, ATTRIBUTE_9
, /* ORGANIZATION */ ATTRIBUTE_10
, ATTRIBUTE_11
, ATTRIBUTE_12
, ATTRIBUTE_13
, /* DEPENDENT DEMAND */ ATTRIBUTE_14
, ATTRIBUTE_15
, ATTRIBUTE_16
, ATTRIBUTE_17
, /* SALES REP */ ATTRIBUTE_18
, ATTRIBUTE_19
, ATTRIBUTE_20
, ATTRIBUTE_21
, /* SALES CHANNEL */ ATTRIBUTE_22
, ATTRIBUTE_23
, ATTRIBUTE_24
, ATTRIBUTE_25
, /* USER DEFINED 1 */ ATTRIBUTE_26
, ATTRIBUTE_27
, ATTRIBUTE_28
, ATTRIBUTE_29
, /* USER DEFINED 2 */ ATTRIBUTE_30
, ATTRIBUTE_31
, ATTRIBUTE_32
, ATTRIBUTE_33
, /* TIME LEVEL ID */ ATTRIBUTE_34
, /* QUANTITY */ ATTRIBUTE_41
, /* RETURN DATE */ TO_DATE(ATTRIBUTE_43
, 'YYYY/MM/DD')
, /* WHO COLUMNS */ CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, /* NET CHANGE */ 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_SRP_RETURN_HISTORY')