VIEW: APPS.MSD_PRODUCT_RETURN_DS_V

Source

View Text - Preformatted

SELECT cdd.demand_plan_id, csd.cs_definition_id, csd.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'), csd.creation_date, csd.created_by,csd. last_update_date, csd.last_updated_by, csd.last_update_login, csd.last_refresh_num, csd.created_by_refresh_num, csd.action_code, /* DCS*/ attribute_50, attribute_51, attribute_52, attribute_53 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_PRODUCT_RETURN_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 */ 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')
, CSD.CREATION_DATE
, CSD.CREATED_BY
, CSD. LAST_UPDATE_DATE
, CSD.LAST_UPDATED_BY
, CSD.LAST_UPDATE_LOGIN
, CSD.LAST_REFRESH_NUM
, CSD.CREATED_BY_REFRESH_NUM
, CSD.ACTION_CODE
, /* DCS*/ ATTRIBUTE_50
, ATTRIBUTE_51
, ATTRIBUTE_52
, ATTRIBUTE_53
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_PRODUCT_RETURN_HISTORY')
AND CSD.CS_DATA_ID = CDD.CS_DATA_ID
AND MDS.DEMAND_PLAN_ID = CDD.DEMAND_PLAN_ID