I'mtryingtoturnthecolumn"prtnum" yellow inline, I'm trying to use the PIVOT but I can not already tried it in some ways and it's not right:
Select
Distinct (ORD_LINE.ordnum),
ORD_LINE.prtnum,
Sum (ORD_LINE.ordqty)
From ORD_LINE
Where
ORD_LINE.entdte >= trunc (sysdate, 'MM')
Group By ORD_LINE.ordnum,ORD_LINE.prtnum