This quick report’s subquery that has FETCH FIRST 1 ROWS ONLY to pull the first PO is only returning one row for the entire report; not for each part#:
SA-807 has a qualifying row as well; we should see a Next Supply Qty and Next Supply Date as we ll as SA-811.

1select2ip.contract,3ip.part_no,4ip.type_code_db,5ip.part_product_code as Product_Code,6ip.type_designation,7sp.catalog_group as Sales_Group,8ipp.safety_stock,9ipcp.qty_available as Available_Inventory,10ipp.safety_stock - ipcp.qty_available as Over_Short,111213( SELECT14osd.qty_supply as Next_Supply_Qty15from ORDER_SUPP_DEM_EXT_TMP_VIEW osd16 where osd.contract = ip.contract and osd.part_no = ip.part_no 17 and ( osd.order_supply_demand_type = 'Shop Order' and osd.status_Desc in ('Planned', 'Started', 'Released')18or osd.order_supply_demand_type = 'Purch Order' and osd.status_Desc in ('Planned', 'Released', 'Received') )19 order by osd.date_required20FETCH FIRST 1 ROWS ONLY ) as Next_Supply_Qty,2122( SELECT23osd.date_required as Next_Supply_Date24from ORDER_SUPP_DEM_EXT_TMP_VIEW osd25 where osd.contract = ip.contract and osd.part_no = ip.part_no 26 and ( osd.order_supply_demand_type = 'Shop Order' and osd.status_Desc in ('Planned', 'Started', 'Released')27or osd.order_supply_demand_type = 'Purch Order' and osd.status_Desc in ('Planned', 'Released', 'Received') )28 order by osd.date_required29FETCH FIRST 1 ROWS ONLY ) as Next_Supply_Date3031from INVENTORY_PART ip3233left join SALES_PART sp34 on ip.contract = sp.contract and ip.part_no = sp.part_no3536left join INVENTORY_PART_PLANNING ipp37 on ip.contract = ipp.contract and ip.part_no = ipp.part_no3839left join INV_PART_CONFIG_PROJECT_ALT ipcp40 on ip.contract = ipcp.contract and ip.part_no = ipcp.part_no4142where ip.contract = 'W'43and ip.part_no LIKE 'SA-%'4445order by ip.contract, ip.part_no46