SELECT
    goods_code,
    goods_name,
    goods_type,
    stock_management_type,
    std_cost_price,
    SHORT_DESCRIPTION,
    SALE_START_DATE,
    coalesce(sale_end_date,'2024-07-31') AS sale_end_date,
    valid_flg,
    UPDATE_USER_NAME,
    USER_UPDATE_DATETIME
FROM
    goods
WHERE
    valid_flg = '0'
    AND sale_end_date IS NULL;