SELECT 
    GOODS_CODE,
    GOODS_NAME,
    GOODS_TYPE,
    STOCK_MANAGEMENT_TYPE,
    STD_COST_PRICE,
    SHORT_DESCRIPTION,
    SALE_START_DATE,
    CASE WHEN VALID_FLG = '0' AND SALE_END_DATE IS NULL THEN
      '2024-07-31' 
    ELSE 
      SALE_END_DATE
    END AS SALE_END_DATE,
    VALID_FLG,
    UPDATE_USER_NAME,
    USER_UPDATE_DATETIME
    from GOODS
    ORDER BY GOODS_CODE