SELECT  LOC_QTI_REC ,LOC_PURP_DESC_REC ,LOC_PROP_REC ,LOC_NAME_REC ,RECLOC_TP ,LOC_PURP_DESC_DEL ,LOC_PROP_DEL ,LOC_NAME_DEL ,ROUTE_CD
,DELLOC_TP ,post_date ,START_DATE ,END_DATE ,MIN(GREATEST(0,quantity_available)) minimum_qty
from 
  (
   SELECT
    cr.loc_1_qti																		loc_qti_rec
  , cr.loc_1_purp_desc																	loc_purp_desc_rec    
  , TO_NUMBER(cr.loc_1_prop)															loc_prop_rec    
  , cr.loc_1_name																		loc_name_rec    
  , (select QLAR.LOC_ATTR_DESCR                                          
       FROM QPTM.PACTRL_LOC_ATTR PLAR
	   JOIN QPTM.QCODE_LOC_ATTR QLAR
       ON PLAR.TSP_NO = QLAR.TSP_NO
       AND PLAR.LOC_ATTR_CD = QLAR.LOC_ATTR_CD
      WHERE PLAR.TSP_NO = cr.TSP_PROP
        AND PLAR.LOC_ID = cr.LOC_1_PROP
        AND PLAR.LOC_ATTR_CD IN ('OFO','OFW')
        AND PLAR.ATTR_TRUE_IND = 1
        AND TO_DATE('2025-09-18', 'yyyy-mm-dd')  BETWEEN PLAR.EFF_DT_FROM AND PLAR.EFF_DT_TO)		RecLoc_TP
  , cr.loc_2_purp_desc																	loc_purp_desc_del       
  , TO_NUMBER(cr.loc_2_prop)															loc_prop_del     
  , cr.loc_2_name																		loc_name_del     
  , (select QLAD.LOC_ATTR_DESCR                                    
       FROM QPTM.PACTRL_LOC_ATTR PLAD
	   JOIN QPTM.QCODE_LOC_ATTR QLAD
	   ON PLAD.TSP_NO = QLAD.TSP_NO
       AND PLAD.LOC_ATTR_CD = QLAD.LOC_ATTR_CD
      WHERE PLAD.TSP_NO = cr.TSP_PROP
        AND PLAD.LOC_ID = cr.LOC_2_PROP
        AND PLAD.LOC_ATTR_CD IN ('OFO','OFW')
        AND PLAD.ATTR_TRUE_IND = 1
        AND TO_DATE('2025-09-18', 'yyyy-mm-dd')  BETWEEN PLAD.EFF_DT_FROM AND PLAD.EFF_DT_TO      
        UNION
        select 'OFF-SYSTEM - OTPL' from dual where cr.route_cd in ('WO','WE')        
        )																				DelLoc_TP
  , cr.loc_2_mask																		loc_2_mask           
  , cr.route_cd																			route_cd             
  , trunc(cr.post_date)																	post_date
  , TO_DATE('2025-09-18', 'yyyy-mm-dd')															START_DATE
  , TO_DATE('2025-09-30', 'yyyy-mm-dd')															END_DATE
  , CR.quantity_available																quantity_available
    FROM   ESUITE_QTR.qpc_unsubscribed_capacity_rpt cr
    
   WHERE 
    (   
      cr.post_date >= trunc(sysdate) AND cr.post_date < trunc(sysdate) + 1 
        AND
      (
        (TO_DATE('2025-09-18', 'yyyy-mm-dd')  BETWEEN TRUNC(cr.avail_cap_eFF_date) AND TRUNC(CR.AVAIL_CAP_END_DATE)
        OR
         TO_DATE('2025-09-30', 'yyyy-mm-dd') BETWEEN TRUNC(cr.avail_cap_eFF_date) AND TRUNC(CR.AVAIL_CAP_END_DATE)
         )
        OR
        ( TO_DATE('2025-09-18', 'yyyy-mm-dd') < TRUNC(CR.AVAIL_CAP_END_DATE)
          AND
          TO_DATE('2025-09-30', 'yyyy-mm-dd') > TRUNC(cr.avail_cap_eFF_date) 
         )
       )
     )
       AND  
       (cr.tsp_prop = 
           (SELECT INITCAP(so.org_id)
              FROM  QPTM.sctrl_org      so
             WHERE  so.org_abbrv = 'MWP'
               AND  so.org_type_cd = 'BUS') 
        )   
       AND EXISTS
       (select 'x' from ESUITE_QTR.qpc_location_map_pair mp
         where mp.tsp_no =  cr.TSP_PROP
           and mp.rec_loc_id = cr.loc_1_prop
           and mp.del_loc_id = cr.loc_2_prop
        )
)
WHERE post_date >= trunc(sysdate) and post_date < trunc(sysdate) + 1
GROUP BY LOC_QTI_REC ,LOC_PURP_DESC_REC ,LOC_PROP_REC ,LOC_NAME_REC ,RECLOC_TP ,LOC_PURP_DESC_DEL
        ,LOC_PROP_DEL ,LOC_NAME_DEL ,DELLOC_TP ,loc_2_mask ,route_cd ,post_date ,START_DATE ,END_DATE            
ORDER BY LOC_PROP_REC ,LOC_PROP_DEL ,loc_2_mask ,START_DATE     
		
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Undefined variable $reportType</p>
<p>Filename: controllers/UnsubscribedCapacitySummary.php</p>
<p>Line Number: 78</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\controllers\UnsubscribedCapacitySummary.php<br />
			Line: 78<br />
			Function: _error_handler			</p>

		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\core\Common_Controller.php<br />
			Line: 19<br />
			Function: download			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\index.php<br />
			Line: 314<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Cannot modify header information - headers already sent by (output started at C:\web\mwpipe\system\core\Exceptions.php:272)</p>
<p>Filename: helpers/download_helper.php</p>
<p>Line Number: 137</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\controllers\UnsubscribedCapacitySummary.php<br />
			Line: 98<br />
			Function: force_download			</p>

		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\core\Common_Controller.php<br />
			Line: 19<br />
			Function: download			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\index.php<br />
			Line: 314<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Cannot modify header information - headers already sent by (output started at C:\web\mwpipe\system\core\Exceptions.php:272)</p>
<p>Filename: helpers/download_helper.php</p>
<p>Line Number: 138</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\controllers\UnsubscribedCapacitySummary.php<br />
			Line: 98<br />
			Function: force_download			</p>

		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\core\Common_Controller.php<br />
			Line: 19<br />
			Function: download			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\index.php<br />
			Line: 314<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Cannot modify header information - headers already sent by (output started at C:\web\mwpipe\system\core\Exceptions.php:272)</p>
<p>Filename: helpers/download_helper.php</p>
<p>Line Number: 139</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\controllers\UnsubscribedCapacitySummary.php<br />
			Line: 98<br />
			Function: force_download			</p>

		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\core\Common_Controller.php<br />
			Line: 19<br />
			Function: download			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\index.php<br />
			Line: 314<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Cannot modify header information - headers already sent by (output started at C:\web\mwpipe\system\core\Exceptions.php:272)</p>
<p>Filename: helpers/download_helper.php</p>
<p>Line Number: 140</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\controllers\UnsubscribedCapacitySummary.php<br />
			Line: 98<br />
			Function: force_download			</p>

		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\core\Common_Controller.php<br />
			Line: 19<br />
			Function: download			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\index.php<br />
			Line: 314<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Cannot modify header information - headers already sent by (output started at C:\web\mwpipe\system\core\Exceptions.php:272)</p>
<p>Filename: helpers/download_helper.php</p>
<p>Line Number: 141</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\controllers\UnsubscribedCapacitySummary.php<br />
			Line: 98<br />
			Function: force_download			</p>

		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\core\Common_Controller.php<br />
			Line: 19<br />
			Function: download			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\index.php<br />
			Line: 314<br />
			Function: require_once			</p>

		
	

</div>
<div style="border:1px solid #990000;padding-left:20px;margin:0 0 10px 0;">

<h4>A PHP Error was encountered</h4>

<p>Severity: Warning</p>
<p>Message:  Cannot modify header information - headers already sent by (output started at C:\web\mwpipe\system\core\Exceptions.php:272)</p>
<p>Filename: helpers/download_helper.php</p>
<p>Line Number: 142</p>


	<p>Backtrace:</p>
	
		
	
		
	
		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\controllers\UnsubscribedCapacitySummary.php<br />
			Line: 98<br />
			Function: force_download			</p>

		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\application\core\Common_Controller.php<br />
			Line: 19<br />
			Function: download			</p>

		
	
		
	
		
			<p style="margin-left:10px">
			File: C:\web\mwpipe\index.php<br />
			Line: 314<br />
			Function: require_once			</p>

		
	

</div>"Loc/QTI","Loc Purp Desc","Loc","Loc Name","Rec Loc TP","Loc Purp Desc","Loc","Loc Name","Route Cd","Del Loc TP","Unsub Cap"