SELECT
   GOODS_NAME                           AS GOODS_NAME
  ,GOODS_TYPE                           AS GOODS_TYPE
  ,STOCK_MANAGEMENT_TYPE                AS STOCK_MANAGEMENT_TYPE
  ,STD_COST_PRICE                       AS STD_COST_PRICE
  ,SHORT_DESCRIPTION                    AS SHORT_DESCRIPTION
  ,SALE_START_DATE                      AS SALE_START_DATE
  ,COALESCE(SALE_END_DATE,'2024-07-31') AS SALE_END_DATE
  ,VALID_FLG                            AS VALID_FLG
  ,UPDATE_USER_NAME                     AS UPDATE_USER_NAME
  ,USER_UPDATE_DATETIME                 AS USER_UPDATE_DATETIME
FROM GOODS
WHERE VALID_FLG = '0'
;