* ROLLS IS LOCAL OR ON A REMOTE FILESYSTEM ?
*  RECCOUNT('ROLLS') = ????

SELECT * FROM ROLLS WHERE UPPER(ALLTRIM(cSTATUS))=="REJECTED" AND ROLLS.cWorkOrderID == SALEORDER_ITEMS.cWorkOrderNo ORDER BY nRoll INTO CURSOR tmpRejected
* SYS(3054,11) = ????
* RECCOUNT'tmpRejected') = ???
* TIME TO EXEC ???

SELECT * FROM ROLLS WHERE UPPER(ALLTRIM(cSTATUS))=="ACCEPTED" AND ROLLS.cWorkOrderID == SALEORDER_ITEMS.cWorkOrderNo ORDER BY nRoll INTO CURSOR tmpAccepted
* SYS(3054,11) = ????
* RECCOUNT'tmpAccepted') = ???
* TIME TO EXEC ???

SELECT nWeight_Roll, ; && <== THIS IS NOT GROUPED , WHY YOU PUT THIS IT IS MAX() OR MIN()???
SUM(nWeight_Roll) AS nWeight_Skid, ;
SUM(nWeight_Roll_Metric) AS nWeight_Skid_Metric, ;
SUM(nUPerRoll) AS nUnits_Skid, ;
SUM(nFootage_Roll) AS nFootage_Skid, ;
cSkidID ;
FROM ROLLS ;
WHERE ROLLS.cWorkOrderID = SALEORDER_ITEMS.cWorkOrderNo ;
GROUP BY 6 ;
ORDER BY 6 ;  && <==== YOU CAN REMOVE THIS
INTO CURSOR tmpSkid

* SYS(3054,11) = ????
* RECCOUNT'tmpAccepted') = ???
* TIME TO EXEC ???