SELECT  AL_LIST.OPERATING_NAME Op_Name, +
                 Dom_Arr_Cur_Yr.WEIGHT Dom_Arr_Cur_Yr, +
                 Int_Arr_Cur_Yr.WEIGHT  Int_Arr_Cur_Yr, +
                 NVL(Dom_Arr_Cur_Yr.WEIGHT,0) + NVL(Int_Arr_Cur_Yr.WEIGHT,0)   Total_Cur_Yr, +
                 Dom_Arr_Prev_Yr.WEIGHT  Dom_Arr_Prev_Yr, +
                 Int_Arr_Prev_Yr.WEIGHT Int_Arr_Prev_Yr, +
                 NVL(Dom_Arr_Prev_Yr.WEIGHT,0)  + NVL(Int_Arr_Prev_Yr.WEIGHT,0)   Total_Prev_Yr +
 FROM +
 (SELECT DISTINCT C.COMPANY_NAME, +
                                   NVL(ONAME.OPERATING_NAME,C.COMPANY_NAME) OPERATING_NAME, +
                                   H.AIRLINE_ID, +
                                   A.AL_DC1 AS SIG_STATUS, +
                                   A.AL_DC2 AS CARRIER_TYPE +
   FROM CO_COMPANY  C JOIN ST_AIRLINES A ON A.COMPANY_NUMBER=C.COMPANY_NUMBER
  +$P{V_LIMIT_AL} +
             LEFT JOIN ST_AIRLINE_AGREEMENTS AA ON A.AIRLINE_ID = AA.AIRLINE_ID +
             LEFT JOIN AGREEMENTS AGT ON AA.AGREEMENT_NUMBER = AGT.AGREEMENT_NUMBER +
             LEFT JOIN CO_OPERATING_NAMES ONAME ON AGT.COMPANY_NUMBER = ONAME.COMPANY_NUMBER AND AGT.OPERATING_NAME_ID = ONAME.OPERATING_NAME_ID +
             JOIN ST_REPORT_HEADER H ON H.AIRLINE_ID = A.AIRLINE_ID +
             JOIN ST_STATISTICS S ON H.REPORT_ID = S.REPORT_ID AND S.STATISTICS_ID=2 AND NVL(S.STAT_VALUE,0) <> 0
            +$P{V_LIMIT_BY_AL_TYPE} +
   WHERE H.REPORT_DATE BETWEEN  $P{beginDate}  AND  $P{endDate} +
                 OR H.REPORT_DATE BETWEEN ADD_MONTHS( $P{beginDate} ,-12) AND ADD_MONTHS( $P{endDate} ,-12) +
   ) AL_LIST +
   LEFT JOIN  (SELECT AIRLINE_ID, SUM(STAT_VALUE) AS LANDINGS, SUM(STAT_VALUE * STAT_MULT_COL/1000)  AS WEIGHT +
     FROM ST_REPORT_HEADER H JOIN ST_STATISTICS S ON  H.REPORT_ID = S.REPORT_ID
    +$P{V_LIMIT_BY_AL_TYPE} +
     AND S.STATISTICS_ID=2  AND S.STAT_DC2=/'Domestic/' +
     AND  H.REPORT_DATE BETWEEN  $P{beginDate}  AND  $P{endDate} +
     GROUP BY H.AIRLINE_ID) Dom_Arr_Cur_Yr +
  ON AL_LIST.AIRLINE_ID = Dom_Arr_Cur_Yr.AIRLINE_ID +
 LEFT JOIN(SELECT AIRLINE_ID,  SUM(STAT_VALUE) AS LANDINGS, SUM(STAT_VALUE * STAT_MULT_COL/1000)  AS WEIGHT +
     FROM ST_REPORT_HEADER H JOIN ST_STATISTICS S ON H.REPORT_ID = S.REPORT_ID
    +$P{V_LIMIT_BY_AL_TYPE}+
     AND S.STATISTICS_ID=2    AND S.STAT_DC2=/'Domestic/' +
     AND  H.REPORT_DATE BETWEEN ADD_MONTHS( $P{beginDate} ,-12)  AND ADD_MONTHS( $P{endDate} ,-12) +
     GROUP BY H.AIRLINE_ID) Dom_Arr_Prev_Yr +
  ON AL_LIST.AIRLINE_ID = Dom_Arr_Prev_Yr.AIRLINE_ID +
 LEFT JOIN (SELECT AIRLINE_ID, SUM(STAT_VALUE) AS LANDINGS, SUM(STAT_VALUE * STAT_MULT_COL/1000)  AS WEIGHT +
 FROM ST_REPORT_HEADER H JOIN ST_STATISTICS S ON H.REPORT_ID = S.REPORT_ID
    +$P{V_LIMIT_BY_AL_TYPE} +
    AND S.STATISTICS_ID=2   AND S.STAT_DC2 IN (/'Pre-Cleared/',/'International/') +
    AND  H.REPORT_DATE BETWEEN   $P{beginDate}   AND  $P{endDate} +
    GROUP BY H.AIRLINE_ID) Int_Arr_Cur_Yr +
  ON AL_LIST.AIRLINE_ID = Int_Arr_Cur_Yr.AIRLINE_ID +
 LEFT JOIN(SELECT AIRLINE_ID,  SUM(STAT_VALUE) AS LANDINGS, SUM(STAT_VALUE * STAT_MULT_COL/1000)  AS WEIGHT +
     FROM ST_REPORT_HEADER H JOIN ST_STATISTICS S ON H.REPORT_ID = S.REPORT_ID
    +$P{V_LIMIT_BY_AL_TYPE}+
     AND S.STATISTICS_ID=2      AND S.STAT_DC2  IN (/'Pre-Cleared/',/'International/') +
     AND  H.REPORT_DATE BETWEEN ADD_MONTHS( $P{beginDate} ,-12)    AND ADD_MONTHS( $P{endDate} ,-12) +
     GROUP BY H.AIRLINE_ID) Int_Arr_Prev_Yr +
  ON AL_LIST.AIRLINE_ID = Int_Arr_Prev_Yr.AIRLINE_ID +
 ORDER BY 4 DESC, 7 DESC