select stageid, mfrid, noSaleReasonId, partnerid, partnertype, autoCaseAmt, autoIncomeAmt, autoWeightAmt, availableDate, opportunityDescription, portionsPerDay, unitsToServe, portionAmtOz, autoCaseAmt, caseAmt, autoIncomeAmt, incomeAmt, autoWeightAmt, weightAmt, OpportunityName, salesPersonUserId from tbl_spl_opportunities where opportunityid = and ownerid = and ownertype =