select cdr.cdr_dstname, cdr.fsl_dstid, cdr.cdr_dstCompanyType
from tbl_cdr_distributors cdr with (nolock)
where cdr.ownerid =
and cdr.fsl_tablecode =
and cdr.cdr_recordid =
select skuid
from tbl_ofs_brokerskus with (nolock)
where ownerid =
and ownertype =
and skuid in ( )
select qryDistributorSales.*
from qryDistributorSales, qrySyndicatedSkus
where qryDistributorSales.skuid = qrySyndicatedSkus.skuid
select sum( forecast_qty ) forecast_qty, sum( lyForecast_qty ) lyForecast_qty,
sum( forecast_amt ) forecast_amt, sum( lyForecast_amt ) lyForecast_amt
from qryDistributorSales
select skuid
from tbl_ofs_brokerskus with (nolock)
where ownerid =
and ownertype =
and skuid in ( )
select skuid, customersku, customerType
from tbl_prd_customerskus with (nolock)
where ( (customerid = and customertype = 'dst') or
(customerid = and customertype = 'pdst') )
and ownerid =
and fsl_tablecode =
and skuid in ( )
Invoice Data #dateformat(_calendarVars.tyPlanStartDate,"m/d/yy")# - #dateformat(_calendarVars.tyPlanEndDate,"m/d/yy")#, as of #dateformat(_calendarVars.asOfDate,"m/d/yy")#
select skuid
from qrySkusWithDetail
where skuid =
select *
from qryCustomerSkus
where skuid =