VAR REPPERIOD NUMBER
exec :REPPERIOD := 201312

SELECT COUNT(*) FROM (
WITH "T" AS
  (SELECT "T0"."C0" "Claim_Status_Number",
    "T0"."C1" "Inwards___Outwards_Policy",
    "T0"."C2" "Policy_Number",
    "T0"."C3" "Claim_Reference",
    "T0"."C4" "Company_Code",
    "T0"."C5" "Branch_Code",
    "T0"."C6" "LoB_Code",
    "T0"."C7" "Sub_LoB_Code_ID",
    "T0"."C8" "Business_Segment_Code",
    SUM("T0"."C10") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C8", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C9")/NULLIF(SUM("T0"."C11") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C8", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C9"), 0) "AGCS_Share__",
   "T0"."C9" "Original_Currency",
    SUM("T0"."C12") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C8", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C9") "c12",
    SUM("T0"."C13") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C8", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C9") "c13",
    SUM("T0"."C14") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C8", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C9") "c14",
    SUM("T0"."C15") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C8", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C9") "c15",
    "T0"."C16" "Last_Finalised_Date_Year"
  FROM
    (SELECT "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" "C0",
      "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS" "C1",
      "COM_D_POLICY_FR55"."D_POL_POLICYNBR" "C2",
      "COM_D_CLAIM_FR55"."D_CH_CLMREF" "C3",
      "COM_D_OFFICE"."D_TOTAL_COMPANYCODE" "C4",
      "COM_D_OFFICE"."D_BRANCHCODE" "C5",
      "GG_D_LOB"."D_LOB_CODE" "C6",
      "GG_D_LOB"."D_SUBLOB_CODE_NEW" "C7",
      "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE" "C8",
      "GG_F_POLICY_FACTS_FR55"."F_ORIGINAL_CURRENCY" "C9",
      SUM("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT") "C10",
      COUNT("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT") "C11",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_ORIG") "C12",
      SUM(("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_ORIG"/NULLIF("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT", 0))*100) "C13",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_GNET_ORIG") "C14",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_NNET_ORIG") "C15",
      to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY')) "C16"
    FROM "IM_APL_01"."COM_D_CLAIM_FR55" "COM_D_CLAIM_FR55",
      "IM_APL_01"."COM_D_POLICY_FR55" "COM_D_POLICY_FR55",
      "IM_APL_01"."COM_D_OFFICE" "COM_D_OFFICE",
      "IM_APL_01"."GG_D_LOB" "GG_D_LOB",
      "IM_APL_01"."GG_F_POLICY_FACTS_FR55" "GG_F_POLICY_FACTS_FR55"
    WHERE "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" NOT   IN ('17', 'N/A', '54', '14')
    AND "GG_F_POLICY_FACTS_FR55"."F_REPORTINGPERIOD"<=:REPPERIOD
    AND "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS" ='Inwards'
    AND "COM_D_OFFICE"."D_BRANCHCODE"               IN ('FR55')
    AND "GG_D_LOB"."D_LOB_CODE"                     IN ('06')
    AND "COM_D_CLAIM_FR55"."D_CH_CLMREF"            <>'N/A'
    AND NOT "COM_D_CLAIM_FR55"."D_CH_CLMREF"        IS NULL
    AND "COM_D_CLAIM_FR55"."SID_CLAIM"               ="GG_F_POLICY_FACTS_FR55"."SID_CLAIM"
    AND "COM_D_POLICY_FR55"."SID_POLICY"             ="GG_F_POLICY_FACTS_FR55"."SID_POLICY"
    AND "COM_D_OFFICE"."SID_OFFICE"                  ="GG_F_POLICY_FACTS_FR55"."SID_OFFICE"
    AND "GG_D_LOB"."SID_LOB"                         ="GG_F_POLICY_FACTS_FR55"."SID_LOB"
    GROUP BY "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS",
      "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS",
      "COM_D_POLICY_FR55"."D_POL_POLICYNBR",
      "COM_D_CLAIM_FR55"."D_CH_CLMREF",
      "COM_D_OFFICE"."D_TOTAL_COMPANYCODE",
      "COM_D_OFFICE"."D_BRANCHCODE",
      "GG_D_LOB"."D_LOB_CODE",
      "GG_D_LOB"."D_SUBLOB_CODE_NEW",
      "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE",
      "GG_F_POLICY_FACTS_FR55"."F_ORIGINAL_CURRENCY",
      to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY'))
    ) "T0"
  ),
  "T9" AS
  (SELECT "T0"."C0" "Claim_Status_Number",
    "T0"."C1" "Inwards___Outwards_Policy",
    "T0"."C2" "Policy_Number",
    "T0"."C3" "Company_Code",
    "T0"."C4" "Branch_Code",
    "T0"."C5" "LoB_Code",
    "T0"."C6" "Sub_LoB_Code_ID",
    "T0"."C7" "Claim_Reference",
    "T0"."C8" "Claim_Status",
    "T0"."C9" "Business_Segment_Code",
    "T0"."C10" "Original_Currency",
    SUM("T0"."C11") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10")/NULLIF(SUM("T0"."C12") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10"), 0) "AGCS_Share__",
    SUM("T0"."C13") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c13",
    SUM("T0"."C14") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c14",
    SUM("T0"."C15") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c15",
    SUM("T0"."C16") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c16",
    SUM("T0"."C17") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c17",
    SUM("T0"."C18") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c18",
    SUM("T0"."C19") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c19",
    SUM("T0"."C20") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c20",
    SUM("T0"."C21") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c21",
    SUM("T0"."C22") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c22",
    SUM("T0"."C23") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c23",
    SUM("T0"."C24") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c24",
    SUM("T0"."C25") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c25",
    SUM("T0"."C26") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c26",
    SUM("T0"."C27") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c27",
    SUM("T0"."C28") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c28",
    SUM("T0"."C29") over (partition BY "T0"."C0", "T0"."C8", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C10") "c29",
    "T0"."C30" "Last_Finalised_Date_Year"
  FROM
    (SELECT "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" "C0",
      "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS" "C1",
      "COM_D_POLICY_FR55"."D_POL_POLICYNBR" "C2",
      "COM_D_OFFICE"."D_TOTAL_COMPANYCODE" "C3",
      "COM_D_OFFICE"."D_BRANCHCODE" "C4",
      "GG_D_LOB"."D_LOB_CODE" "C5",
      "GG_D_LOB"."D_SUBLOB_CODE_NEW" "C6",
      "COM_D_CLAIM_FR55"."D_CH_CLMREF" "C7",
      "COM_D_CLAIM_FR55"."D_CH_CLMSTATUSDESC" "C8",
      "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE" "C9",
      "GG_F_POLICY_FACTS_FR55"."F_ORIGINAL_CURRENCY" "C10",
      SUM("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT") "C11",
      COUNT("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT") "C12",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_ALAE_PAID_ORIG") "C13",
      SUM(("GG_F_POLICY_FACTS_FR55"."F_BOOKED_ALAE_PAID_ORIG"/NULLIF("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT", 0))*100) "C14",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_PAID_ALAE_GNET_ORIG") "C15",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_PAID_ALAE_NNET_ORIG") "C16",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_IND_PAID_ORIG") "C17",
      SUM(("GG_F_POLICY_FACTS_FR55"."F_BOOKED_IND_PAID_ORIG"/NULLIF("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT", 0))*100) "C18",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_IND_PAID_GNET_ORIG") "C19",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_IND_PAID_NNET_ORIG") "C20",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_REC_PAID_ORIG") "C21",
      SUM(("GG_F_POLICY_FACTS_FR55"."F_BOOKED_REC_PAID_ORIG"/NULLIF("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT", 0))*100) "C22",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_REC_PAID_GNET_ORIG") "C23",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_REC_PAID_NNET_ORIG") "C24",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_PAID_CLM_ORIG") "C25",
      SUM(("GG_F_POLICY_FACTS_FR55"."F_BOOKED_PAID_CLM_ORIG"/NULLIF("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT", 0))*100) "C26",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_PAID_CLM_GNET_ORIG") "C27",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_PAID_CLM_NNET_ORIG") "C28",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_ORIG") "C29",
      to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY')) "C30"
    FROM "IM_APL_01"."COM_D_CLAIM_FR55" "COM_D_CLAIM_FR55",
      "IM_APL_01"."COM_D_POLICY_FR55" "COM_D_POLICY_FR55",
      "IM_APL_01"."COM_D_OFFICE" "COM_D_OFFICE",
      "IM_APL_01"."GG_D_LOB" "GG_D_LOB",
      "IM_APL_01"."GG_F_POLICY_FACTS_FR55" "GG_F_POLICY_FACTS_FR55"
    WHERE "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" NOT               IN ('17', 'N/A', '54', '14')
    AND "GG_F_POLICY_FACTS_FR55"."F_REPORTINGPERIOD"            <=:REPPERIOD
    AND ROUND("GG_F_POLICY_FACTS_FR55"."F_REPORTINGPERIOD"/100,0)=ROUND((2013.12*1.0e0),0)
    AND "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS"             ='Inwards'
    AND "COM_D_OFFICE"."D_BRANCHCODE"                           IN ('FR55')
    AND "GG_D_LOB"."D_LOB_CODE"                                 IN ('06')
    AND "COM_D_CLAIM_FR55"."D_CH_CLMREF"                        <>'N/A'
    AND NOT "COM_D_CLAIM_FR55"."D_CH_CLMREF"                    IS NULL
    AND "COM_D_CLAIM_FR55"."SID_CLAIM"                           ="GG_F_POLICY_FACTS_FR55"."SID_CLAIM"
    AND "COM_D_POLICY_FR55"."SID_POLICY"                         ="GG_F_POLICY_FACTS_FR55"."SID_POLICY"
    AND "COM_D_OFFICE"."SID_OFFICE"                              ="GG_F_POLICY_FACTS_FR55"."SID_OFFICE"
    AND "GG_D_LOB"."SID_LOB"                                     ="GG_F_POLICY_FACTS_FR55"."SID_LOB"
    GROUP BY "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS",
      "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS",
      "COM_D_POLICY_FR55"."D_POL_POLICYNBR",
      "COM_D_OFFICE"."D_TOTAL_COMPANYCODE",
      "COM_D_OFFICE"."D_BRANCHCODE",
      "GG_D_LOB"."D_LOB_CODE",
      "GG_D_LOB"."D_SUBLOB_CODE_NEW",
      "COM_D_CLAIM_FR55"."D_CH_CLMREF",
      "COM_D_CLAIM_FR55"."D_CH_CLMSTATUSDESC",
      "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE",
      "GG_F_POLICY_FACTS_FR55"."F_ORIGINAL_CURRENCY",
      to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY'))
    ) "T0"
  ),
  "List___Claims_Data10" AS
  (SELECT NVL("T"."Policy_Number", "T9"."Policy_Number") "Policy_Number",
    NVL("T"."Sub_LoB_Code_ID", "T9"."Sub_LoB_Code_ID") "Sub_LoB_Code_ID",
    NVL("T"."Claim_Reference", "T9"."Claim_Reference") "Claim_Reference",
    NVL("T"."Original_Currency", "T9"."Original_Currency") "Original_Currency",
    NVL("T"."AGCS_Share__", "T9"."AGCS_Share__") "AGCS_Share__",
    SUM("T"."c12") "c6",
    SUM("T"."c13") "c7",
    SUM("T"."c14") "c8",
    SUM("T"."c15") "c9",
    SUM("T9"."c13") "c10",
    SUM("T9"."c14") "c11",
    SUM("T9"."c15") "c12",
    SUM("T9"."c16") "c13",
    SUM("T9"."c17") "c14",
    SUM("T9"."c18") "c15",
    SUM("T9"."c19") "c16",
    SUM("T9"."c20") "c17",
    SUM("T9"."c21") "c18",
    SUM("T9"."c22") "c19",
    SUM("T9"."c23") "c20",
    SUM("T9"."c24") "c21",
    SUM("T9"."c25") "c22",
    SUM("T9"."c26") "c23",
    SUM("T9"."c27") "c24",
    SUM("T9"."c28") "c25"
  FROM "T"
  FULL OUTER JOIN "T9"
  ON "T"."Policy_Number"     ="T9"."Policy_Number"
  AND "T"."Claim_Reference"  ="T9"."Claim_Reference"
  AND "T"."Original_Currency"="T9"."Original_Currency"
  AND "T"."Sub_LoB_Code_ID"  ="T9"."Sub_LoB_Code_ID"
  GROUP BY NVL("T"."Policy_Number", "T9"."Policy_Number"),
    NVL("T"."Sub_LoB_Code_ID", "T9"."Sub_LoB_Code_ID"),
    NVL("T"."Claim_Reference", "T9"."Claim_Reference"),
    NVL("T"."Original_Currency", "T9"."Original_Currency"),
    NVL("T"."AGCS_Share__", "T9"."AGCS_Share__")
  ),
  "T11" AS
  (SELECT "T0"."C0" "Claim_Status_Number",
    "T0"."C1" "Inwards___Outwards_Policy",
    "T0"."C2" "Policy_Number",
    "T0"."C3" "Claim_Reference",
    "T0"."C4" "Company_Code",
    "T0"."C5" "Branch_Code",
    "T0"."C6" "LoB_Code",
    "T0"."C7" "Sub_LoB_Code_ID",
    "T0"."C8" "Sub_LoB_Description",
    "T0"."C9" "Business_Segment_Code",
    SUM("T0"."C11") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C10")/NULLIF(SUM("T0"."C12") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C10"), 0) "AGCS_Share__",
    "T0"."C10" "Original_Currency",
    SUM("T0"."C13") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C10") "c13",
    SUM("T0"."C14") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C10") "c14",
    SUM("T0"."C15") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C10") "c15",
    SUM("T0"."C16") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C9", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C10") "c16",
    "T0"."C17" "Last_Finalised_Date_Year"
  FROM
    (SELECT "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" "C0",
      "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS" "C1",
      "COM_D_POLICY_FR55"."D_POL_POLICYNBR" "C2",
      "COM_D_CLAIM_FR55"."D_CH_CLMREF" "C3",
      "COM_D_OFFICE"."D_TOTAL_COMPANYCODE" "C4",
      "COM_D_OFFICE"."D_BRANCHCODE" "C5",
      "GG_D_LOB"."D_LOB_CODE" "C6",
      "GG_D_LOB"."D_SUBLOB_CODE_NEW" "C7",
      "GG_D_LOB"."D_SUBLOB_DESC" "C8",
      "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE" "C9",
      "GG_F_POLICY_FACTS_FR55"."F_ORIGINAL_CURRENCY" "C10",
      SUM("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT") "C11",
      COUNT("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT") "C12",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_ORIG") "C13",
      SUM(("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_ORIG"/NULLIF("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT", 0))*100) "C14",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_GNET_ORIG") "C15",
      SUM("GG_F_POLICY_FACTS_FR55"."F_BOOKED_RES_NNET_ORIG") "C16",
      to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY')) "C17"
    FROM "IM_APL_01"."COM_D_CLAIM_FR55" "COM_D_CLAIM_FR55",
      "IM_APL_01"."COM_D_POLICY_FR55" "COM_D_POLICY_FR55",
      "IM_APL_01"."COM_D_OFFICE" "COM_D_OFFICE",
      "IM_APL_01"."GG_D_LOB" "GG_D_LOB",
      "IM_APL_01"."GG_F_POLICY_FACTS_FR55" "GG_F_POLICY_FACTS_FR55"
    WHERE "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" NOT               IN ('17', 'N/A', '54', '14')
    AND "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS"             ='Inwards'
    AND "COM_D_OFFICE"."D_BRANCHCODE"                           IN ('FR55')
    AND "GG_D_LOB"."D_LOB_CODE"                                 IN ('06')
    AND "COM_D_CLAIM_FR55"."D_CH_CLMREF"                        <>'N/A'
    AND NOT "COM_D_CLAIM_FR55"."D_CH_CLMREF"                    IS NULL
    AND ROUND("GG_F_POLICY_FACTS_FR55"."F_REPORTINGPERIOD"/100,0)<ROUND((2013.12*1.0e0),0)
    AND "COM_D_CLAIM_FR55"."SID_CLAIM"                           ="GG_F_POLICY_FACTS_FR55"."SID_CLAIM"
    AND "COM_D_POLICY_FR55"."SID_POLICY"                         ="GG_F_POLICY_FACTS_FR55"."SID_POLICY"
    AND "COM_D_OFFICE"."SID_OFFICE"                              ="GG_F_POLICY_FACTS_FR55"."SID_OFFICE"
    AND "GG_D_LOB"."SID_LOB"                                     ="GG_F_POLICY_FACTS_FR55"."SID_LOB"
    GROUP BY "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS",
      "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS",
      "COM_D_POLICY_FR55"."D_POL_POLICYNBR",
      "COM_D_CLAIM_FR55"."D_CH_CLMREF",
      "COM_D_OFFICE"."D_TOTAL_COMPANYCODE",
      "COM_D_OFFICE"."D_BRANCHCODE",
      "GG_D_LOB"."D_LOB_CODE",
      "GG_D_LOB"."D_SUBLOB_CODE_NEW",
      "GG_D_LOB"."D_SUBLOB_DESC",
      "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE",
      "GG_F_POLICY_FACTS_FR55"."F_ORIGINAL_CURRENCY",
      to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY'))
    ) "T0"
  ),
  "List___Main_Numbers15" AS
  (SELECT NVL("List___Claims_Data10"."Policy_Number", "T11"."Policy_Number") "Policy_Number",
    NVL("List___Claims_Data10"."Claim_Reference", "T11"."Claim_Reference") "Claim_Reference",
    NVL("List___Claims_Data10"."Sub_LoB_Code_ID", "T11"."Sub_LoB_Code_ID") "Sub_LoB_Code_ID",
    NVL("List___Claims_Data10"."Original_Currency", "T11"."Original_Currency") "Original_Currency",
    SUM("List___Claims_Data10"."c10") "c5",
    SUM("List___Claims_Data10"."c11") "c6",
    SUM("List___Claims_Data10"."c12") "c7",
    SUM("List___Claims_Data10"."c13") "c8",
    SUM("List___Claims_Data10"."c6") "c9",
    SUM("List___Claims_Data10"."c7") "c10",
    SUM("List___Claims_Data10"."c8") "c11",
    SUM("List___Claims_Data10"."c9") "c12",
    SUM("List___Claims_Data10"."c14") "c13",
    SUM("List___Claims_Data10"."c15") "c14",
    SUM("List___Claims_Data10"."c16") "c15",
    SUM("List___Claims_Data10"."c17") "c16",
    SUM("List___Claims_Data10"."c18") "c17",
    SUM("List___Claims_Data10"."c19") "c18",
    SUM("List___Claims_Data10"."c20") "c19",
    SUM("List___Claims_Data10"."c21") "c20",
    SUM("T11"."c13") "c21",
    SUM("T11"."c14") "c22",
    SUM("T11"."c15") "c23",
    SUM("T11"."c16") "c24",
    SUM("List___Claims_Data10"."c22") "c25",
    SUM("List___Claims_Data10"."c23") "c26",
    SUM("List___Claims_Data10"."c24") "c27",
    SUM("List___Claims_Data10"."c25") "c28"
  FROM "List___Claims_Data10"
  FULL OUTER JOIN "T11"
  ON "List___Claims_Data10"."Policy_Number"     ="T11"."Policy_Number"
  AND "List___Claims_Data10"."Claim_Reference"  ="T11"."Claim_Reference"
  AND "List___Claims_Data10"."Original_Currency"="T11"."Original_Currency"
  AND "List___Claims_Data10"."Sub_LoB_Code_ID"  ="T11"."Sub_LoB_Code_ID"
  GROUP BY NVL("List___Claims_Data10"."Policy_Number", "T11"."Policy_Number"),
    NVL("List___Claims_Data10"."Claim_Reference", "T11"."Claim_Reference"),
    NVL("List___Claims_Data10"."Sub_LoB_Code_ID", "T11"."Sub_LoB_Code_ID"),
    NVL("List___Claims_Data10"."Original_Currency", "T11"."Original_Currency")
  ),
  "BROKER" AS
  (SELECT *
  FROM "IM_APL_01"."COM_D_PLACING_PARTNER"
  WHERE "COM_D_PLACING_PARTNER"."D_PLACEMENTTYPEID" IN (1, 10)
  ),
  "INSURED" AS
  (SELECT *
  FROM "IM_APL_01"."COM_D_INSURED"
  WHERE "COM_D_INSURED"."D_PLACEMENTTYPEID"=7
  ),
  "T14" AS
  ( SELECT DISTINCT "ORIGINAL_CURRENCY_VARIABLE"."D_RATEGROUPPERIOD" "Currency_Rate_Group_Period",
    "ORIGINAL_CURRENCY_VARIABLE"."D_EXCHANGERATE" "Exchange_Rate",
    "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" "Claim_Status_Number",
    "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS" "Inwards___Outwards_Policy",
    "COM_D_POLICY_FR55"."D_POL_POLICYNBR" "Policy_Number",
    "COM_D_OFFICE"."D_TOTAL_COMPANYCODE" "Company_Code",
    "COM_D_OFFICE"."D_TOTAL_COMPANY_FULLNAME" "Company_Name",
    MIN("COM_D_OFFICE"."D_BRANCH_FULLNAME") over (partition BY "COM_D_OFFICE"."D_TOTAL_COMPANYCODE", "COM_D_OFFICE"."D_BRANCHCODE") "Branch",
    "COM_D_OFFICE"."D_BRANCHCODE" "Branch_Code",
    "GG_D_LOB"."D_LOB_CODE" "LoB_Code",
    "GG_D_LOB"."D_LOB_LDESC" "LoB_Long_Description",
    "GG_D_LOB"."D_SUBLOB_CODE_NEW" "Sub_LoB_Code_ID",
    "GG_D_LOB"."D_SUBLOB_DESC" "Sub_LoB_Description",
    "COM_D_CLAIM_FR55"."D_CH_CLMREF" "Claim_Reference",
    CASE
      WHEN(
        CASE
          WHEN("BROKER"."D_FULLNAME" IS NULL)
          THEN NULL
          ELSE ("BROKER"."D_FULLNAME"
            ||' - ')
        END IS NULL)
      THEN NULL
      ELSE (
        CASE
          WHEN("BROKER"."D_FULLNAME" IS NULL)
          THEN NULL
          ELSE ("BROKER"."D_FULLNAME"
            ||' - ')
        END
        ||"BROKER"."D_NAMECODE")
    END "Broker_Name",
    "BROKER"."D_NAMECODE" "Broker_Name_Code",
   "INSURED"."D_FULLNAME" "Insured_Name",
    "COM_D_POLICY_FR55"."D_POL_POLICYSTATUS_LDESC" "Policy_Status",
    "COM_D_POLICY_FR55"."D_POL_UNDERWRITINGYR" "Policy_Underwriting_Year",
    "COM_D_POLICY_FR55"."D_POL_PLACEMENT_LDESC" "Placement_Long_Description",
    TO_CHAR("COM_D_CLAIM_FR55"."D_CH_INCIDENTDATE", 'YYYY') "Incident_Year",
    "COM_D_CLAIM_FR55"."D_CH_CLMSTATUSDESC" "Claim_Status",
    "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE" "Business_Segment_Code",
    "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_LDESC" "c24",
    "COM_D_CLAIM_FR55"."D_CH_BROKERREF1" "Claim_Header_Broker_Referece_1",
    AVG("GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT") over (partition BY "ORIGINAL_CURRENCY_VARIABLE"."D_PKCCYCODE", "ORIGINAL_CURRENCY_VARIABLE"."D_RATEGROUPPERIOD", "ORIGINAL_CURRENCY_VARIABLE"."D_EXCHANGERATE", "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS", "COM_D_CLAIM_FR55"."D_CH_CLMSTATUSDESC", "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS", "COM_D_POLICY_FR55"."D_POL_POLICYNBR", "COM_D_POLICY_FR55"."D_POL_UNDERWRITINGYR", "COM_D_POLICY_FR55"."D_POL_POLICYSTATUS_LDESC", "COM_D_POLICY_FR55"."D_POL_PLACEMENT_LDESC", "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE", "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_LDESC", "COM_D_OFFICE"."D_TOTAL_COMPANYCODE", "COM_D_OFFICE"."D_TOTAL_COMPANY_FULLNAME", "COM_D_OFFICE"."D_BRANCHCODE", "GG_D_LOB"."D_LOB_CODE", "GG_D_LOB"."D_LOB_LDESC", "GG_D_LOB"."D_SUBLOB_CODE_NEW", "GG_D_LOB"."D_SUBLOB_DESC", "COM_D_CLAIM_FR55"."D_CH_CLMREF", "COM_D_CLAIM_FR55"."D_CH_BROKERREF1", "BROKER"."D_NAMECODE", "INSURED"."D_FULLNAME") "AGCS_Share__",
    to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY')) "Last_Finalised_Date_Year",
    MAX("GG_F_POLICY_FACTS_FR55"."F_LAST_TRANSDATE_FOR_TRMONTH") over (partition BY "ORIGINAL_CURRENCY_VARIABLE"."D_RATEGROUPPERIOD", "ORIGINAL_CURRENCY_VARIABLE"."D_EXCHANGERATE", "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS", "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS", "COM_D_POLICY_FR55"."D_POL_POLICYNBR", "COM_D_OFFICE"."D_TOTAL_COMPANYCODE", "COM_D_OFFICE"."D_TOTAL_COMPANY_FULLNAME", "COM_D_OFFICE"."D_BRANCHCODE", "GG_D_LOB"."D_LOB_CODE", "GG_D_LOB"."D_LOB_LDESC", "GG_D_LOB"."D_SUBLOB_CODE_NEW", "GG_D_LOB"."D_SUBLOB_DESC", "COM_D_CLAIM_FR55"."D_CH_CLMREF",
    CASE
      WHEN(
        CASE
          WHEN("BROKER"."D_FULLNAME" IS NULL)
          THEN NULL
          ELSE ("BROKER"."D_FULLNAME"
            ||' - ')
        END IS NULL)
      THEN NULL
      ELSE (
        CASE
          WHEN("BROKER"."D_FULLNAME" IS NULL)
          THEN NULL
          ELSE ("BROKER"."D_FULLNAME"
            ||' - ')
        END
        ||"BROKER"."D_NAMECODE")
    END, "BROKER"."D_NAMECODE", "INSURED"."D_FULLNAME", "COM_D_POLICY_FR55"."D_POL_POLICYSTATUS_LDESC", "COM_D_POLICY_FR55"."D_POL_UNDERWRITINGYR", "COM_D_POLICY_FR55"."D_POL_PLACEMENT_LDESC", TO_CHAR("COM_D_CLAIM_FR55"."D_CH_INCIDENTDATE", 'YYYY'), "COM_D_CLAIM_FR55"."D_CH_CLMSTATUSDESC", "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_CODE", "COM_D_POLICY_FR55"."D_POL_BUS_SEGM_ANN_PROJ_LDESC", "COM_D_CLAIM_FR55"."D_CH_BROKERREF1", "GG_F_POLICY_FACTS_FR55"."F_SEC_SHAREOFWHOLEPERCENT", to_number(TO_CHAR("COM_D_CLAIM_FR55"."D_CH_LAST_FINALIZED_DATE", 'YYYY')), "ORIGINAL_CURRENCY_VARIABLE"."D_PKCCYCODE") "c28",
    "ORIGINAL_CURRENCY_VARIABLE"."D_PKCCYCODE" "Currency_Code"
  FROM "IM_APL_01"."GG_D_CURRENCY" "ORIGINAL_CURRENCY_VARIABLE",
    "IM_APL_01"."COM_D_CLAIM_FR55" "COM_D_CLAIM_FR55",
    "IM_APL_01"."COM_D_POLICY_FR55" "COM_D_POLICY_FR55",
    "IM_APL_01"."COM_D_OFFICE" "COM_D_OFFICE",
    "IM_APL_01"."GG_D_LOB" "GG_D_LOB",
    "BROKER",
    "INSURED",
    "IM_APL_01"."GG_F_POLICY_FACTS_FR55" "GG_F_POLICY_FACTS_FR55"
  WHERE "COM_D_CLAIM_FR55"."D_CH_CLMSTATUS" NOT      IN ('17', 'N/A', '54', '14')
  AND "COM_D_POLICY_FR55"."D_POL_INWARDS_OUTWARDS"    ='Inwards'
  AND "COM_D_OFFICE"."D_BRANCHCODE"                  IN ('FR55')
  AND "GG_D_LOB"."D_LOB_CODE"                        IN ('06')
  AND "COM_D_CLAIM_FR55"."D_CH_CLMREF"               <>'N/A'
  AND NOT "COM_D_CLAIM_FR55"."D_CH_CLMREF"           IS NULL
  AND "ORIGINAL_CURRENCY_VARIABLE"."D_RATEGROUPPERIOD"=:REPPERIOD
  AND "ORIGINAL_CURRENCY_VARIABLE"."D_PKSRCSYSTEMID"  ="GG_F_POLICY_FACTS_FR55"."F_POL_SRCSYSTEMID"
  AND "ORIGINAL_CURRENCY_VARIABLE"."D_PKCOMPANYCODE"  ="GG_F_POLICY_FACTS_FR55"."F_POL_COMPANYCODE"
  AND "ORIGINAL_CURRENCY_VARIABLE"."D_PKCCYCODE"      ="GG_F_POLICY_FACTS_FR55"."F_ORIGINAL_CURRENCY"
  AND "COM_D_POLICY_FR55"."SID_POLICY"                ="GG_F_POLICY_FACTS_FR55"."SID_POLICY"
  AND "COM_D_CLAIM_FR55"."SID_CLAIM"                  ="GG_F_POLICY_FACTS_FR55"."SID_CLAIM"
  AND "INSURED"."SID_INSURED"                         ="GG_F_POLICY_FACTS_FR55"."SID_INSURED"
  AND "BROKER"."SID_PLACING_PARTNER"                  ="GG_F_POLICY_FACTS_FR55"."SID_BROKER"
  AND "COM_D_OFFICE"."SID_OFFICE"                     ="GG_F_POLICY_FACTS_FR55"."SID_OFFICE"
  AND "GG_D_LOB"."SID_LOB"                            ="GG_F_POLICY_FACTS_FR55"."SID_LOB"
  )
SELECT DISTINCT "T0"."C0" "Exchange_Rate",
  "T0"."C1" "Policy_Number",
  "T0"."C2" "Policy_Underwriting_Year",
  "T0"."C3" "LoB_Long_Description",
  "T0"."C4" "Sub_LoB_Description",
  "T0"."C5" "Claim_Reference",
  "T0"."C6" "Broker_Name",
  "T0"."C7" "Insured_Name",
  "T0"."C8" "Placement_Long_Description",
  "T0"."C9" "Incident_Year",
  "T0"."C10" "c11",
  "T0"."C11" "Claim_Header_Broker_Referece_1",
  "T0"."C12" "Reporting_Period_Start",
  "T0"."C13" "Reporting_Period_End",
  "T0"."C14"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c15",
  "T0"."C16"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c16",
  "T0"."C17"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c17",
  "T0"."C18"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c18",
  "T0"."C19"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c19",
  "T0"."C20"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c20",
  "T0"."C21"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c21",
  "T0"."C22"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c22",
  "T0"."C23"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c23",
  "T0"."C24"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c24",
  "T0"."C25"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c25",
  "T0"."C26"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c26",
  "T0"."C27"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c27",
  "T0"."C28"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c28",
  "T0"."C29"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c29",
  "T0"."C30"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c30",
  "T0"."C31"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c31",
  "T0"."C32"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c32",
  "T0"."C33"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c33",
  "T0"."C34"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c34",
  "T0"."C35"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c35",
  "T0"."C36"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c36",
  "T0"."C37"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c37",
  "T0"."C38"                                                                                                                                                                                                       /NULLIF("T0"."C15", 0) "c38",
  (NVL(SUM("T0"."C39") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) - NVL(SUM("T0"."C41") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0)) - NVL(SUM("T0"."C42") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0".
  "C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")                                                                                                                                     /NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) "Boni___Mali_AGCS_Share",
  "T0"."C43" "Boni___Mali_AGCS_Share_Total",
  (NVL(SUM("T0"."C44") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) - NVL(SUM("T0"."C45") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0)) - NVL(SUM("T0"."C46") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0".
  "C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")                                                                                                                                     /NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) "Boni___Mali_100_",
  (NVL(SUM("T0"."C47") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) - NVL(SUM("T0"."C48") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0)) - NVL(SUM("T0"."C49") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0".
  "C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")                                                                                                                                     /NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) "Boni___Mali_Gross_Net",
  (NVL(SUM("T0"."C50") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) - NVL(SUM("T0"."C51") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")/NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0)) - NVL(SUM("T0"."C52") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0".
  "C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40")                                                                                                                                     /NULLIF(MIN("T0"."C0") over (partition BY "T0"."C0", "T0"."C1", "T0"."C2", "T0"."C3", "T0"."C4", "T0"."C5", "T0"."C6", "T0"."C7", "T0"."C8", "T0"."C9", "T0"."C10", "T0"."C11", "T0"."C12", "T0"."C13", "T0"."C40"), 0), 0) "Boni___Mali_Net_Net",
  'EUR' "Currency",
  "T0"."C40" "Original_Currency",
  "T0"."C14" "c46",
  "T0"."C16" "c47",
  "T0"."C17" "c48",
  "T0"."C18" "c49",
  "T0"."C19" "c50",
  "T0"."C20" "c51",
  "T0"."C21" "c52",
  "T0"."C22" "c53",
  "T0"."C23" "c54",
  "T0"."C24" "c55",
  "T0"."C25" "c56",
  "T0"."C26" "c57",
  "T0"."C27" "c58",
  "T0"."C28" "c59",
  "T0"."C29" "c60",
  "T0"."C30" "c61",
  "T0"."C31" "c62",
  "T0"."C32" "c63",
  "T0"."C33" "c64",
  "T0"."C34" "c65",
  "T0"."C35" "c66",
  "T0"."C36" "c67",
  "T0"."C37" "c68",
  "T0"."C38" "c69",
  (((("T0"."C14"+"T0"."C17")+("T0"."C18"+"T0"."C19"))+(("T0"."C21"+"T0"."C22")+("T0"."C23"+"T0"."C25")))+((("T0"."C26"+"T0"."C27")+("T0"."C29"+"T0"."C30"))+(("T0"."C31"+"T0"."C33")+("T0"."C34"+"T0"."C35"))))+("T0"."C37"+"T0"."C38") "TOTAL",
  "T0"."C53" "c71",
  "T0"."C54" "Boni___Mali_100___Original_",
  "T0"."C55" "c73",
  "T0"."C56" "Boni___Mali_Net_Net__Original_"
FROM
  (SELECT "T14"."Exchange_Rate" "C0",
    "T14"."Policy_Number" "C1",
    "T14"."Policy_Underwriting_Year" "C2",
    "T14"."LoB_Long_Description" "C3",
    "T14"."Sub_LoB_Description" "C4",
    "T14"."Claim_Reference" "C5",
    "T14"."Broker_Name" "C6",
    "T14"."Insured_Name" "C7",
    "T14"."Placement_Long_Description" "C8",
    "T14"."Incident_Year" "C9",
    "T14"."c24" "C10",
    "T14"."Claim_Header_Broker_Referece_1" "C11",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END "C12",
    "T14"."Currency_Rate_Group_Period" "C13",
    SUM("List___Main_Numbers15"."c5") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
     ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C14",
    MIN("T14"."Exchange_Rate") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C15",
    SUM("List___Main_Numbers15"."c6") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C16",
    SUM("List___Main_Numbers15"."c7") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C17",
    SUM("List___Main_Numbers15"."c8") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C18",
    SUM("List___Main_Numbers15"."c9") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C19",
    SUM("List___Main_Numbers15"."c10") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C20",
    SUM("List___Main_Numbers15"."c11") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C21",
    SUM("List___Main_Numbers15"."c12") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C22",
    SUM("List___Main_Numbers15"."c13") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C23",
    SUM("List___Main_Numbers15"."c14") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C24",
    SUM("List___Main_Numbers15"."c15") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C25",
    SUM("List___Main_Numbers15"."c16") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C26",
    SUM("List___Main_Numbers15"."c17") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C27",
    SUM("List___Main_Numbers15"."c18") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C28",
    SUM("List___Main_Numbers15"."c19") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C29",
    SUM("List___Main_Numbers15"."c20") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C30",
    SUM("List___Main_Numbers15"."c21") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C31",
    SUM("List___Main_Numbers15"."c22") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C32",
    SUM("List___Main_Numbers15"."c23") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C33",
    SUM("List___Main_Numbers15"."c24") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C34",
    SUM("List___Main_Numbers15"."c25") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C35",
    SUM("List___Main_Numbers15"."c26") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C36",
    SUM("List___Main_Numbers15"."c27") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C37",
    SUM("List___Main_Numbers15"."c28") over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C38",
    "List___Main_Numbers15"."c21" "C39",
    "List___Main_Numbers15"."Original_Currency" "C40",
    "List___Main_Numbers15"."c9" "C41",
    "List___Main_Numbers15"."c25" "C42",
    SUM((NVL("List___Main_Numbers15"."c21"/NULLIF("T14"."Exchange_Rate", 0), 0) - NVL("List___Main_Numbers15"."c9"/NULLIF("T14"."Exchange_Rate", 0), 0)) - NVL("List___Main_Numbers15"."c25"/NULLIF("T14"."Exchange_Rate", 0), 0)) over (partition BY "T14"."Policy_Number", "T14"."Claim_Reference") "C43",
    "List___Main_Numbers15"."c22" "C44",
    "List___Main_Numbers15"."c10" "C45",
    "List___Main_Numbers15"."c26" "C46",
    "List___Main_Numbers15"."c23" "C47",
    "List___Main_Numbers15"."c11" "C48",
    "List___Main_Numbers15"."c27" "C49",
    "List___Main_Numbers15"."c24" "C50",
    "List___Main_Numbers15"."c12" "C51",
    "List___Main_Numbers15"."c28" "C52",
    SUM((NVL("List___Main_Numbers15"."c21", 0) - NVL("List___Main_Numbers15"."c9", 0)) - NVL("List___Main_Numbers15"."c25", 0)) over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C53",
    SUM((NVL("List___Main_Numbers15"."c22", 0) - NVL("List___Main_Numbers15"."c10", 0)) - NVL("List___Main_Numbers15"."c26", 0)) over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C54",
    SUM((NVL("List___Main_Numbers15"."c23", 0) - NVL("List___Main_Numbers15"."c11", 0)) - NVL("List___Main_Numbers15"."c27", 0)) over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C55",
    SUM((NVL("List___Main_Numbers15"."c24", 0) - NVL("List___Main_Numbers15"."c12", 0)) - NVL("List___Main_Numbers15"."c28", 0)) over (partition BY "T14"."Exchange_Rate", "T14"."Policy_Number", "T14"."Policy_Underwriting_Year", "T14"."LoB_Long_Description", "T14"."Sub_LoB_Description", "T14"."Claim_Reference", "T14"."Broker_Name", "T14"."Insured_Name", "T14"."Placement_Long_Description", "T14"."Incident_Year", "T14"."c24", "T14"."Claim_Header_Broker_Referece_1",
    CASE
      WHEN(rpad("T14"."Currency_Rate_Group_Period", 4) IS NULL)
      THEN NULL
      ELSE (rpad("T14"."Currency_Rate_Group_Period", 4)
        ||'01')
    END, "T14"."Currency_Rate_Group_Period", "List___Main_Numbers15"."Original_Currency") "C56"
  FROM "List___Main_Numbers15"
  LEFT OUTER JOIN "T14"
  ON "List___Main_Numbers15"."Policy_Number"     ="T14"."Policy_Number"
  AND "List___Main_Numbers15"."Claim_Reference"  ="T14"."Claim_Reference"
  AND "List___Main_Numbers15"."Sub_LoB_Code_ID"  ="T14"."Sub_LoB_Code_ID"
  AND "List___Main_Numbers15"."Original_Currency"="T14"."Currency_Code"
  ) "T0"
WHERE "T0"."C43">=0
or "T0"."C43"   <=0);