JD Edwards - SQL for Finding all the Releases from Blankets (OB and OHs)

JD Edwards - SQL for Finding all the Releases from Blankets (OB and OHs)

select pddoco OH,pddcto,pdoorn OB,pdlitm,pddsc1,pduorg,
DATEADD(dy, cast(pdtrdj as varchar(10)) % 1000, DATEADD(yy, cast(pdtrdj as varchar(10)) / 1000,-1))  pdtrdj
from proddta.f4311
where pdocto='OB' and pdlttr<>980
and pdoorn in
(16332,16334,17897,17924,17925,17699,18146,18155,18156,18164,18494,18218,18492,18527,18528,18531,18162)
order by pddoco