select p.parid, p.partial flag, s.user1 saleverify, p.luc, p.NBHD, p.adrno,
p.adrstr, d.yrblt, d.sfla, to_char(s.saledt,'DD-MON-YY') saledt,
s.price, s.who, to_char(s.wen,'DD-MON-YY') wen,
s.notes comments,
s.saleval, a1.msg valdesc, s.mktvalid, a2.msg mktdesc, s.transno,
s.nopar numpcls, s.oldown, s.own1
from pardat p, sales s, dweldat d, aedit a1, aedit a2, aprval a
where 2020=d.taxyr(+)
and 'Y'=d.cur(+)
and '1'=d.card(+)
and s.parid=d.parid(+)
and s.parid=a.parid
and a.cur='Y'
and a.taxyr=p.taxyr
and p.cur='Y'
and p.taxyr=2020
and substr(p.parid,1,1) IN ('E','Q')
and substr(p.nbhd,1,1) NOT IN ('8','9')
and p.parid=s.parid
and a1.tble='SALES'
and a1.fld='SALEVAL'
and s.saleval=a1.val
and 'SALES'=a2.tble (+)
and 'MKTVALID'=a2.fld (+)
and s.mktvalid=a2.val (+)
and s.saledt between '01-JAN-2019' and '31-DEC-2021'
and s.cur='Y'
and (s.saleval='8' or s.user1 is null or s.user1='N')
and s.price > 0
and p.class in ('R','A')
order by p.parid,p.nbhd