BEHOLD: I AM A PIECE OF TRASH

SELECT DECODE (
          o6.NAME_EN,
          NULL, DECODE (
                   o5.NAME_EN,
                   NULL, DECODE (
                            o4.NAME_EN,
                            NULL, DECODE (o3.NAME_EN, NULL, o2.ID, o3.ID),
                            o4.ID),
                   o5.ID),
          o6.ID)
          AS org_id,
       o1.NAME_EN AS fee_type,
       o2.NAME_EN AS force_type,
       DECODE (o4.NAME_EN, NULL, NULL, o3.NAME_EN) AS sub_type,
       DECODE (o5.NAME_EN, NULL, NULL, o4.NAME_EN) AS division,
       DECODE (o6.NAME_EN, NULL, NULL, o5.NAME_EN) AS detachment,
       DECODE (
          o6.NAME_EN,
          NULL, DECODE (o5.NAME_EN,
                        NULL, o3.NAME_EN,
                        o4.NAME_EN, o5.NAME_EN),
          o6.NAME_EN)
          AS org_name,
       DECODE (
          o6.NAME_EN,
          NULL, DECODE (o5.NAME_EN,
                        NULL, o3.PROVINCE_ID,
                        o4.PROVINCE_ID, o5.PROVINCE_ID),
          o6.PROVINCE_ID)
          AS org_province_id,
       DECODE (
          o6.NAME_EN,
          NULL, DECODE (o5.NAME_EN,
                        NULL, o3.COUNTRY_ID,
                        o4.COUNTRY_ID, o5.COUNTRY_ID),
          o6.COUNTRY_ID)
          AS org_country_id,
       DECODE (
          o6.NAME_EN,
          NULL, DECODE (o5.NAME_EN,
                        NULL, o3.ORG_TYPE_ID,
                        o4.ORG_TYPE_ID, o5.ORG_TYPE_ID),
          o6.ORG_TYPE_ID)
          AS org_type_id,
       DECODE (o6.NAME_EN,
               NULL, DECODE (o5.NAME_EN,  NULL, o3.CODE,  o4.CODE, o5.code),
               o6.CODE)
          AS code
  FROM odrcpc.ORGS o1
       LEFT JOIN odrcpc.ORGS o2 ON o2.PARENT_ORG_ID = o1.ID
       LEFT JOIN odrcpc.ORGS o3 ON o3.PARENT_ORG_ID = o2.ID
       LEFT JOIN odrcpc.ORGS o4 ON o4.PARENT_ORG_ID = o3.ID
       LEFT JOIN odrcpc.ORGS o5 ON o5.PARENT_ORG_ID = o4.ID
       LEFT JOIN odrcpc.ORGS o6 ON o6.PARENT_ORG_ID = o5.ID
 WHERE     (   (o1.NAME_EN = 'OGD and International')
            OR (o1.NAME_EN = 'Canadian Police Agencies'))
       AND DECODE (
              o6.NAME_EN,
              NULL, DECODE (
                       o5.NAME_EN,
                       NULL, DECODE (
                                o4.NAME_EN,
                                NULL, DECODE (o3.NAME_EN,
                                              NULL, o2.HAS_USERS,
                                              o3.HAS_USERS),
                                o4.HAS_USERS),
                       o5.HAS_USERS),
              o6.HAS_USERS) = 1