PurchaseOrderLines = SQLSelect($"SELECT LINE09,ADVN09,GRNO09,PRUM09,GRNO09,ADVN09,TQTY09,ITEM09,ORDP09,BRCV09,ACRC09,OQTY09,AQTY09,CNVF09,PRCV09,CURN09 " + $"FROM AULT2F3.PMP09 P9 INNER JOIN AULT2F3.PMP02 P2 ON P9.CONO09 = P2.CONO02 AND P9.ORDN09 = P2.ORDN02 WHERE P9.CONO09='{CleanSQLText(CompCode)}' AND " + $"P9.ORDN09 = '{CleanSQLText(OrderNo)}' AND P2.DTLC02='9999999' AND P9.RRYN09='0' AND P9.IPRC09='0' AND P9.GRNO09<>'0' AND P9.RECT09<>'' AND P9.INVN09=''"); return PurchaseOrderLines;