---------- BMDBATCHREPORT.SQL
            LEFT JOIN DistributorRetailerRegion AS drr ON drr.DistroRetailID = rrs.DistroRetailID
            LEFT JOIN Retailers_V AS cpm ON cpm.RetailerRegionID = rrs.DistroRetailID

---------- DISTRIBUTORREGIONDELETEROW.SQL
    DECLARE @DistroRetailID INT
        SELECT DistroRetailID 
        FETCH csrDistroRetailList INTO @DistroRetailID
            SET @DRCount = @DRCount | dbo.udf_DistroRetailRegionDependencies(@DistroRetailID)
            FETCH csrDistroRetailList INTO @DistroRetailID
            FETCH FIRST FROM csrDistroRetailList INTO @DistroRetailID
                EXEC DistributorRetailerRegionDeleteRow @DistroRetailID
                FETCH csrDistroRetailList INTO @DistroRetailID

---------- DISTRIBUTORRETAILERREGIONADDROW.SQL
    SELECT @FindID = ISNULL(DistroRetailID, 0) 
        WHERE DistroRetailID = @FindID

---------- DISTRIBUTORRETAILERREGIONDELETEROW.SQL
	@DistroRetailID INT
    SET @Count = dbo.udf_DistroRetailRegionDependencies(@DistroRetailID)
            EXEC CustAddressDeleteRow NULL, @DistroRetailID, 'C'
        SET @Count = dbo.udf_DistroRetailRegionDependencies(@DistroRetailID)
        WHERE DistroRetailID = @DistroRetailID
        DELETE FROM DistributorRetailerRegion WHERE DistroRetailID = @DistroRetailID

---------- DISTRIBUTORRETAILERREGIONUPDATEROW.SQL
	@DistroRetailID int,
where DistroRetailID = @DistroRetailID

---------- DISTRORETAILTREEBRANCHPOPULATE.SQL
        NULL AS RetailerStoreState, NULL AS DistroRetailID, 
        NULL AS RetailerStoreState, NULL AS DistroRetailID, 
        DistroRetailID INT NULL,
        DistributorTreeLevel, DistroRetailID, DistributorRegionParentID,
        d.TreeLevel AS DistributorTreeLevel, drr.DistroRetailID, d.DistributorRegionParentID, 
            DistributorTreeLevel, DistroRetailID, DistributorRegionParentID,
            t.DistributorTreeLevel, NULL AS DistroRetailID, t.DistributorRegionParentID, 
            DistributorTreeLevel, DistroRetailID, DistributorRegionParentID,
            d.TreeLevel AS DistributorTreeLevel, NULL AS DistroRetailID, d.DistributorRegionParentID, 
      AND DistroRetailID IS NULL
      AND DistroRetailID IS NULL
        DistroRetailID INT NULL,

---------- DISTRORETAILTREEPOPULATE.SQL
    -- --     DistroRetailID INT NULL,
    --     DistroRetailID INT NULL,
        NULL AS RetailerStoreState, NULL AS DistroRetailID, 
    --     NULL AS RetailerStoreState, NULL AS DistroRetailID, 
    --                 r.RetailerRegionID, r.RetailerStoreState, drr.DistroRetailID,  
    -- --     DistroRetailID INT NULL,
    -- DistroRetailID INT NULL,
    -- --     DistroRetailID INT NULL,

---------- GETALLDISTRIBUTORRETAILERREGIONS.SQL
SELECT	drr.DistroRetailID,

---------- GETDISTRIBUTORRETAILERREGIONBYID.SQL
	@DistroRetailID int
WHERE	drr.DistroRetailID = @DistroRetailID and

---------- GETDISTRIBUTORRETAILERREGIONS.SQL
		DistroRetailID,

---------- GETDISTRIBUTORRETAILERREGIONSBYDISTRO.SQL
		drr.DistroRetailID,

---------- GETDISTRIBUTORRETAILERSALES.SQL
	@DistroRetailID int
WHERE DistroRetailID = @DistroRetailID

---------- GETDISTRIBUTORSFORRETAILERREGION.SQL
	SELECT 	drr.DistroRetailID, 

---------- GETRETAILERREGIONSALES.SQL
rrs.DistroRetailID = drr.DistroRetailID

---------- GETRETAILERREGIONSALESBYDATE.SQL
rrs.DistroRetailID = drr.DistroRetailID and

---------- GETRETAILERREGIONTOTALSALESAMT.SQL
	rrs.DistroRetailID = drr.DistroRetailID and

---------- GETRETAILERREGIONYTDSALESAMT.SQL
	rrs.DistroRetailID = drr.DistroRetailID and

---------- GETRETAILERSFORDISTRIBUTORREGION.SQL
	SELECT 	drr.DistroRetailID, 

---------- REPORTEXECRETAILERACCRUAL.SQL
            LEFT JOIN DistributorRetailerRegion AS drr ON drr.DistroRetailID = rrs.DistroRetailID

---------- REPORTEXECRETAILERACCRUAL_NEWPARENTCHILD.SQL
            LEFT JOIN DistributorRetailerRegion AS drr ON drr.DistroRetailID = rrs.DistroRetailID

---------- REPORTEXECRETAILERMILLACCRUALS.SQL
--             LEFT JOIN dbo.DistributorRetailerRegion AS drr ON drr.DistroRetailID = rrs.DistroRetailID

---------- REPORTEXECRETAILERMILLPAYMENTS.SQL
--             LEFT JOIN dbo.DistributorRetailerRegion AS drr ON drr.DistroRetailID = rrs.DistroRetailID

---------- REPORTEXECRETAILERSALES.SQL
        LEFT JOIN RetailerRegionSales AS rrs ON drr.DistroRetailID = rrs.DistroRetailID

---------- REPORTEXECRETAILERSALES_NEWPARENTCHILD.SQL
        LEFT JOIN RetailerRegionSales AS rrs ON drr.DistroRetailID = rrs.DistroRetailID

---------- REPORTRETAILERACCRUALSALES.SQL
     LEFT JOIN DistributorRetailerRegion AS dr ON dr.DistroRetailID = s.DistroRetailID 
      AND dr.DistroRetailID IN 
      SELECT DISTINCT DistroRetailID 

---------- REPORTRETAILERLISTSUB.SQL
    INNER JOIN DistributorRetailerRegion AS drr ON rrs.DistroRetailID = drr.DistroRetailID
        INNER JOIN RetailerRegionSales AS rrs ON drr.DistroRetailID = rrs.DistroRetailID

---------- RETAILERCOPYORMOVECHILD.SQL
    INNER JOIN DistributorRetailerRegion AS drr ON drr.DistroRetailID = rrs.DistroRetailID

---------- RETAILERREBATEPSEUDOPOST.SQL
        INNER JOIN RetailerRegionSales AS rrs ON rrs.DistroRetailID = drr.DistroRetailID 

---------- RETAILERREGIONDELETEROW.SQL
    DECLARE @DistroRetailID INT
        SELECT DistroRetailID 
        FETCH csrDistroList INTO @DistroRetailID
            SET @DRCount = @DRCount | dbo.udf_DistroRetailRegionDependencies(@DistroRetailID)
            FETCH csrDistroList INTO @DistroRetailID
            FETCH FIRST FROM csrDistroList INTO @DistroRetailID
                EXEC DistributorRetailerRegionDeleteRow @DistroRetailID
                FETCH csrDistroList INTO @DistroRetailID

---------- RETAILERREGIONSALESADDROW.SQL
	@DistroRetailID int,
	DistroRetailID,
	@DistroRetailID,
    WHERE drr.DistroRetailID = rrs.DistroRetailID

---------- RETAILERREGIONSALESUPDATEROW.SQL
	@DistroRetailID int,
		DistroRetailID = @DistroRetailID
		DistroRetailID = @DistroRetailID
WHERE drr.DistroRetailID = rrs.DistroRetailID

---------- RETAILERSALESIMPORTCHECKSUMS.SQL
    left join distributorretailerregion as dr on dr.distroretailid = s.distroretailid
          left join distributorretailerregion as dr on dr.distroretailid = s.distroretailid

---------- RETAILERSALESSUMMARYREPORT.SQL
INNER JOIN RetailerRegion AS rr ON rc.RetailerRegionID = rr.RetailerRegionID) ON drr.RetailerRegionID = rr.RetailerRegionID) ON rrs.DistroRetailID = drr.DistroRetailID) 

---------- UDF_DISTRORETAILREGIONDEPENDENCIES.SQL
    IF 0 <> (SELECT COUNT(*) FROM RetailerRegionSales WHERE DistroRetailID = @drID)

---------- UDF_RETAILERREGIONDEPENDENCIES.SQL
    IF 0 <> (SELECT COUNT(*) FROM RetailerRegionSales WHERE DistroRetailID IN (
        SELECT DistroRetailID FROM DistributorRetailerRegion WHERE RetailerRegionID = @RetailerRegionID))

---------- UPDATEBMDSALESDISTRORETAIL.SQL
	DistroRetailID,
	drr.DistroRetailID,

---------- UPDATEBMDSHIPTODISTRORETAIL.SQL
