use below code
select s.SITE as SITE, s.SFC as SFC, s.QTY as QTY, stat.STATUS as SFC_STATUS,
stat.STATUS_DESCRIPTION as SFC_STATUS_DESCRIPTION, i.ITEM as ITEM, i.REVISION as ITEM_REVISION,
ss.OPERATION_BO, ss.QTY_IN_QUEUE, ss.QTY_IN_WORK, so.SHOP_ORDER as SHOP_ORDER,
sot.DESCRIPTION as SHOP_ORDER_TYPE
from SFC s inner join ITEM i on
s.ITEM_BO = i.HANDLE inner join STATUS stat on s.STATUS_BO = stat.HANDLE
inner join SFC_ROUTING srg on s.HANDLE = srg.SFC_BO
inner join SFC_ROUTER sr on srg.HANDLE = sr.SFC_ROUTING_BO
inner join SFC_STEP ss on sr.HANDLE = ss.SFC_ROUTER_BO
inner join SHOP_ORDER so on s.SHOP_ORDER_BO = so.HANDLE
inner join SHOP_ORDER_TYPE sot on so.SHOP_ORDER_TYPE_BO = sot.HANDLE
where s.SITE = 'PPM' --and i.ITEM = 'ITEM_PANEL' and i.REVISION = 'A'
and sot.ORDER_TYPE = 'PRODUCTION' and stat.STATUS_DESCRIPTION = 'Scrapped'
order by SFC_BO
hope this helps