select t.trade_date_time, t.product_id, t.book_id, t.quantity, pb.bond_name, t.cpty_id,
t.accrual
from trade t
left join product_bond pb on pb.product_id = t.product_id
where trade_date_time > to_date('2010-JAN-01 00:00:00', 'YYYY-MON-DD HH24:MI:SS')
and trade_status = 'FULLY_ALLOCATED' or trade_status = 'ALLOCATED'