SELECT o.CompanyName, o.dbaName, o.MFRCustNum, o.independentYN , o.Address, o.Address2, o.City, o.State, o.ZipCode, o.CountryID, c.Country , o.OPRType, o.OPRSegment, o.OPRFormat, o.AreaCode, o.Phone, o.FSL_ChoID , o.PhoneExt, o.FaxAreaCode, o.FaxNumber, o.URL, o.catering, a.attrDescription AS cateringValue , o.Comments, o.Comments2, o.Distrib1, o.FSL_dstid_1, o.recordSource , COALESCE(o.TerritoryID, 0) AS TerritoryID, COALESCE(o.mfr_bsr_id, 0) AS BrokerSalesRepID, COALESCE(o.SetMethod, 1) AS SetMethod , a2.attrDescription as oprFormat_desc , o.oprcompanytype, o.oprparentco, o.unitid, o.stocksymbol, o.annualsales , o.num_units_lastYr, o.num_units_thisYr, o.num_units_nextYr , o.tradeclass, o.menulink, o.menucycle, o.menuplandate, o.chain_distr_notes , o.reqBusinessPlan, o.FMarginBase, o.MarginRate_TY, o.MarginRate_LY , o2.CompanyName AS parentco , o.mfrAE, o.mfrTechRep, o.mfrCustRep ,(SELECT FirstName + ' ' + LastName AS Name FROM tbl_FSPro_Members WHERE FSPro_UserID = o.mfrAE) AS mfrAE_name ,(SELECT FirstName + ' ' + LastName AS Name FROM tbl_FSPro_Members WHERE FSPro_UserID = o.mfrTechRep) AS mfrTechRep_name ,(SELECT FirstName + ' ' + LastName AS Name FROM tbl_FSPro_Members WHERE FSPro_UserID = o.mfrCustRep) AS mfrCustRep_name ,(SELECT cdr_dstName FROM tbl_CDR_Distributors WHERE cdr_recordID = o.fsl_dstid_1) AS PrimaryDistrib FROM tbl_OPR_ClientOperators o , tbl_UT_Countries c , tbl_OPR_Attributes a, tbl_OPR_Attributes a2 , tbl_OPR_ClientOperators o2 WHERE o.OperatorID = AND o.OwnerID = AND o.FSLTableCode = AND o.CountryID *= c.CountryID AND o.catering *= a.attrid AND a.attrtypeid = AND o.oprFormat *= a2.attrID AND a2.attrTypeID = AND o.oprparentco *= o2.OperatorID caller.variables.CompanyName = trim(qmd_dispOperator.CompanyName); caller.variables.dbaName = trim(qmd_dispOperator.dbaName); caller.variables.MFRCustNum = trim(qmd_dispOperator.MFRCustNum); caller.variables.independentYN = qmd_dispOperator.independentYN; caller.variables.recordcount = 1; caller.variables.Address = trim(qmd_dispOperator.Address); caller.variables.Address2 = trim(qmd_dispOperator.Address2); caller.variables.City = trim(qmd_dispOperator.City); caller.variables.State = trim(qmd_dispOperator.State); caller.variables.ZipCode = trim(qmd_dispOperator.ZipCode); caller.variables.CountryID = qmd_dispOperator.CountryID; caller.variables.Country = trim(qmd_dispOperator.Country); caller.variables.OPRType = trim(qmd_dispOperator.OPRType); caller.variables.oprSegment = qmd_dispOperator.oprSegment; caller.variables.oprFormat = qmd_dispOperator.oprFormat; caller.variables.AreaCode = trim(qmd_dispOperator.AreaCode); caller.variables.Phone = trim(qmd_dispOperator.Phone); caller.variables.PhoneExt = trim(qmd_dispOperator.PhoneExt); caller.variables.FaxAreaCode = trim(qmd_dispOperator.FaxAreaCode); caller.variables.FaxNumber = trim(qmd_dispOperator.FaxNumber); caller.variables.URL = trim(qmd_dispOperator.URL); caller.variables.catering = qmd_dispOperator.catering; caller.variables.cateringValue = trim(qmd_dispOperator.cateringValue); caller.variables.Comments = trim(qmd_dispOperator.Comments); caller.variables.Comments2 = trim(qmd_dispOperator.Comments2); caller.variables.Distrib1 = val(qmd_dispOperator.Distrib1); caller.variables.FSL_dstid_1 = qmd_dispOperator.FSL_dstid_1; caller.variables.oprFormat_desc = trim(qmd_dispOperator.oprFormat_desc); caller.variables.FSL_ChoID = val(qmd_dispOperator.FSL_ChoID); caller.variables.recordSource = trim(qmd_dispOperator.recordSource); caller.variables.TerritoryID = val(qmd_dispOperator.TerritoryID); caller.variables.BrokerSalesRepID = val(qmd_dispOperator.BrokerSalesRepID); caller.variables.SetMethod = val(qmd_dispOperator.SetMethod); caller.variables.mfrAE = qmd_dispOperator.mfrAE; caller.variables.mfrTechRep = qmd_dispOperator.mfrTechRep; caller.variables.mfrCustRep = qmd_dispOperator.mfrCustRep; caller.variables.mfrAE_name = trim(qmd_dispOperator.mfrAE_name); caller.variables.mfrTechRep_name = trim(qmd_dispOperator.mfrTechRep_name); caller.variables.mfrCustRep_name = trim(qmd_dispOperator.mfrCustRep_name); caller.variables.PrimaryDistrib = trim(qmd_dispOperator.PrimaryDistrib); caller.variables.oprcompanytype = qmd_dispOperator.oprcompanytype; caller.variables.oprparentco = qmd_dispOperator.oprparentco; caller.variables.unitid = trim(qmd_dispOperator.unitid); caller.variables.stocksymbol = trim(qmd_dispOperator.stocksymbol); caller.variables.annualsales = trim(qmd_dispOperator.annualsales); caller.variables.num_units_lastYr = trim(qmd_dispOperator.num_units_lastYr); caller.variables.num_units_thisYr = trim(qmd_dispOperator.num_units_thisYr); caller.variables.num_units_nextYr = trim(qmd_dispOperator.num_units_nextYr); caller.variables.tradeclass = trim(qmd_dispOperator.tradeclass); caller.variables.menulink = trim(qmd_dispOperator.menulink); caller.variables.menucycle = trim(qmd_dispOperator.menucycle); caller.variables.menuplandate = trim(qmd_dispOperator.menuplandate); caller.variables.chain_distr_notes = trim(qmd_dispOperator.chain_distr_notes); caller.variables.BusinessPlan = trim(qmd_dispOperator.ReqBusinessPlan); caller.variables.FMarginBase = qmd_dispOperator.FMarginBase; caller.variables.MarginRate_TY = qmd_dispOperator.MarginRate_TY; caller.variables.MarginRate_LY = qmd_dispOperator.MarginRate_LY; caller.variables.recordcount = 1; caller.variables.CompanyName = ""; caller.variables.dbaName = ""; caller.variables.independentYN = "1"; caller.variables.Address = ""; caller.variables.Address2 = ""; caller.variables.City = ""; caller.variables.State = ""; caller.variables.ZipCode = ""; caller.variables.CountryID = ""; caller.variables.Country = ""; caller.variables.OPRType = ""; caller.variables.oprSegment = ""; caller.variables.oprFormat = ""; caller.variables.AreaCode = ""; caller.variables.Phone = ""; caller.variables.PhoneExt = ""; caller.variables.FaxAreaCode = ""; caller.variables.FaxNumber = ""; caller.variables.URL = ""; caller.variables.catering = ""; caller.variables.cateringValue = ""; caller.variables.Comments = ""; caller.variables.Comments2 = ""; caller.variables.Distrib1 = ""; caller.variables.FSL_dstid_1 = ""; caller.variables.oprFormat_desc = ""; caller.variables.BroStaff1_name = ""; caller.variables.BroStaff2_name = ""; caller.variables.mfrAE = ""; caller.variables.mfrTechRep = ""; caller.variables.mfrCustRep = ""; caller.variables.mfrAE_name = ""; caller.variables.mfrTechRep_name = ""; caller.variables.mfrCustRep_name = ""; caller.variables.PrimaryDistrib = ""; caller.variables.oprcompanytype = ""; caller.variables.oprparentco = 0; caller.variables.unitid = ""; caller.variables.stocksymbol = ""; caller.variables.annualsales = ""; caller.variables.num_units_lastYr = ""; caller.variables.num_units_thisYr = ""; caller.variables.num_units_nextYr = ""; caller.variables.tradeclass = ""; caller.variables.menulink = ""; caller.variables.menucycle = ""; caller.variables.menuplandate = ""; caller.variables.chain_distr_notes = ""; caller.variables.parentco = ""; caller.variables.BusinessPlan = ""; caller.variables.FMarginBase = ""; caller.variables.MarginRate_TY = ""; caller.variables.MarginRate_LY = ""; caller.variables.recordSource = ""; caller.variables.FSL_ChoID = 0; caller.variables.recordcount = 0; caller.variables.TerritoryID = 0; caller.variables.BrokerSalesRepID = 0; caller.variables.SetMethod = 0; caller.variables.MFRCustNum = "";