select
     rdb_log_item.sz_item_ref_no  as "Plu_code",
     rdb_log_item.sz_description  as "Plu_descr",
     rdb_log_item.n2_amount_price  as "Plu_price",
     rdb_log_item.n0_quantity as "Plu_qty",
     0 as "Plu_discount",
     0 as "Plu_voided"
from rdb_log_item where
     rdb_log_item.n0_unique_str_no = SSSS and
     rdb_log_item.n0_terminal_no = TTTT and
     rdb_log_item.n0_xact_no = XXXX  and
     rdb_log_item.dt_time_stamp > date_trunc('day', now())

     order by rdb_log_item.n0_sequence_no