select cdr.cdr_dstname, cdr.fsl_dstid
from tbl_cdr_distributors cdr
where cdr.ownerid =
and cdr.fsl_tablecode =
and cdr.cdr_recordid =
select cdr_territoryid
from tbl_cdr_distributors cdr
where cdr_recordid =
and ownerid =
and fsl_tablecode =
select skuid
from tbl_ofs_brokerskus
where ownerid =
and ownertype =
and skuid in ( )
select qryPurchasingVoids.*
from qryPurchasingVoids, qrySyndicatedSkus
where qryPurchasingVoids.skuid = qrySyndicatedSkus.skuid
select skuId
from tbl_PRD_SKus
where privateLabelType in ( 'OPR','CDR','DST' )
and ownerId =
and fsl_tablecode =
select * from qryPurchasingVoids
where skuId not in ( )
order by forecast_qty desc
select cdr.cdr_recordId, cdr.cdr_dstName, cdr.cdr_dstCode, pcdr.cdr_dstName parent_cdr_dstName, pcdr.cdr_recordId parent_cdr_recordId, cdr.cdr_territoryId
from tbl_CDR_Distributors cdr with (nolock)
left join tbl_DST_Distributors dst with (nolock)
on dst.dstId = cdr.fsl_dstId
and dst.dstParentCo > 0
left outer join tbl_CDR_Distributors pcdr with (nolock)
on pcdr.fsl_dstId = dst.dstParentCo
and pcdr.ownerId = cdr.ownerId
and pcdr.fsl_tablecode = cdr.fsl_tablecode
where cdr.ownerId =
and cdr.fsl_tablecode =
and cdr.cdr_recordId =
Unable to identify parent distributor.
select skuid
from tbl_ofs_brokerskus
where ownerid =
and ownertype =
and skuid in ( )
select qryPurchasingVoids.*
from qryPurchasingVoids, qrySyndicatedSkus
where qryPurchasingVoids.skuid = qrySyndicatedSkus.skuid
select skuId
from tbl_PRD_SKus
where privateLabelType in ( 'OPR','CDR','DST' )
and ownerId =
and fsl_tablecode =
select * from qryPurchasingVoids
where skuId not in ( )
order by forecast_qty desc
select *
from qryPurchasingVoids
where ( sku like or
upper(skuDesc) like )
order by forecast_qty descasc
select skuid
from tbl_ofs_brokerskus
where ownerid =
and ownertype =
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")#