VIEW: APPS.MSD_PRODUCT_RETURN_CS_V

Source

View Text - Preformatted

SELECT cs_definition_id, cs_name, /* Instance */ attribute_1, /* PRD*/ attribute_2, attribute_3, attribute_4, attribute_5, /* GEO*/ attribute_6, attribute_7, attribute_8, attribute_9, /* ORG */ attribute_10, attribute_11, attribute_12, attribute_13, /* Dependent Demand */ attribute_14, attribute_15, attribute_16, attribute_17, /* REP */ attribute_18, attribute_19, attribute_20, attribute_21, /* CHN */ attribute_22, attribute_23, attribute_24, attribute_25, /* UD1 */ attribute_26, attribute_27, attribute_28, attribute_29, /* UD2 */ attribute_30, attribute_31, attribute_32, attribute_33, /* TIM */ attribute_34, /* Quantity */ attribute_41 /* Amount */, attribute_42, /* Return Date */ 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, /* DCS*/ attribute_50, attribute_51, attribute_52, attribute_53 from msd_cs_data WHERE cs_definition_id = (select cs_definition_id from msd_cs_definitions where name = 'MSD_PRODUCT_RETURN_HISTORY')

View Text - HTML Formatted

SELECT CS_DEFINITION_ID
, CS_NAME
, /* INSTANCE */ ATTRIBUTE_1
, /* PRD*/ ATTRIBUTE_2
, ATTRIBUTE_3
, ATTRIBUTE_4
, ATTRIBUTE_5
, /* GEO*/ ATTRIBUTE_6
, ATTRIBUTE_7
, ATTRIBUTE_8
, ATTRIBUTE_9
, /* ORG */ ATTRIBUTE_10
, ATTRIBUTE_11
, ATTRIBUTE_12
, ATTRIBUTE_13
, /* DEPENDENT DEMAND */ ATTRIBUTE_14
, ATTRIBUTE_15
, ATTRIBUTE_16
, ATTRIBUTE_17
, /* REP */ ATTRIBUTE_18
, ATTRIBUTE_19
, ATTRIBUTE_20
, ATTRIBUTE_21
, /* CHN */ ATTRIBUTE_22
, ATTRIBUTE_23
, ATTRIBUTE_24
, ATTRIBUTE_25
, /* UD1 */ ATTRIBUTE_26
, ATTRIBUTE_27
, ATTRIBUTE_28
, ATTRIBUTE_29
, /* UD2 */ ATTRIBUTE_30
, ATTRIBUTE_31
, ATTRIBUTE_32
, ATTRIBUTE_33
, /* TIM */ ATTRIBUTE_34
, /* QUANTITY */ ATTRIBUTE_41 /* AMOUNT */
, ATTRIBUTE_42
, /* RETURN DATE */ 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
, /* DCS*/ ATTRIBUTE_50
, ATTRIBUTE_51
, ATTRIBUTE_52
, ATTRIBUTE_53
FROM MSD_CS_DATA
WHERE CS_DEFINITION_ID = (SELECT CS_DEFINITION_ID
FROM MSD_CS_DEFINITIONS
WHERE NAME = 'MSD_PRODUCT_RETURN_HISTORY')