SQL Multiple Joins Query-Error while executing : I am trying to execute the below query having multiple joins between tables. However, I am getting an error "%s: Invalid Identifier" in SQL Developer.

The below column throws an error:
"GCCCOND.ID_COND", invalid identifier

I validated the query online and I couldn't understand what am I missing in this one.
Any insights regarding this would be really helpful.

Here is the query--

    SELECT
      gcibjdnf.danfe,
      gcibjdnf.bjd_situacao,
      gcibjdnf.obs_rejeicao,
      gcibjdnf.bjd_tipo_cobranca,
      gcibjdnf.bjd_data_vencto_cbs,
      gcibjdnf.bjd_liberacao_valor,
      gcibjdnf.bjd_liberacao_data,
      gcibjdnf.cd_rejeicao,
      gcibjdnf.id_cond,
      gcibjdnf.bjd_sit_interna,
      gcibjdnf.dh_carga_nf,
      gcibjdnf.dt_expira,
      gcibjdnf.cd_emp,
      gcibjdnf.cd_und,
      gcibjdnf.sg_mod,
      gcibjdnf.cd_cli,
      gcibjdnf.nr_ctr,
      gcibjdnf.nr_adl,
      gcibjdnf.planta,
      gcibjdnf.nf_data,
      gcibjdnf.nf_numero,
      gcibjdnf.dealer_sap,
      gcibjdnf.baan_fatura,
      gcibjdnf.sap_titulo,
      gcibjdnf.nf_valor_total,
      gcibjdnf.nf_fdd,
      gcibjdnf.nf_data_gravacao,
      gcibjdnf.nf_tipo_produto,
      gcibjdnf.pedido_cotacao,
      gcibjdnf.jdb_situacao_normal,
      gcibjdnf.jdb_situacao_proc,
      gcibjdnf.cd_liberada,
      SUM(gcinfitens.item_valor_contratar) AS nf_vl_contratar,
      Max(gcrcontitens.id_contgrupo) AS id_contgrupo,
      MIN(gmin.nu_interv) AS nu_min_prz,
      MAX(gmax.nu_interv) AS nu_max_prz,
      priper.vl_taxa AS nu_taxa,
      priper.cd_tp_taxa,
      priper.cd_indicador,
      gcccond.nm_cond,
      gcccond.cd_tp_ctr,
      priper.sg_mod AS sg_mod_cond,
      gcccond.dt_validade,
      gcccond.cd_sit AS cd_sit_cond,
      gcccond.nu_car_prz,
      gcccond.cd_base_carencia,
      gcccond.nu_car_desc,
      apcconc.cd_loja,
      apcconc.cd_concess,
      apcconc.cd_conc_mat,
      apcconc.nm_conc,
      apcconc.nm_apelido,
      apcconc.cd_tp_mercado,
      dnccontrfundo.dt_emis_ctr
    FROM
      gcibjdnf
      LEFT JOIN gcinfitens ON gcinfitens.danfe = gcibjdnf.danfe
      LEFT JOIN gcrcontitens ON gcrcontitens.danfe = gcibjdnf.danfe
      LEFT JOIN gcrcondper gmin ON gmin.id_cond = gcccond.id_cond
      LEFT JOIN gcrcondper gmax ON gmax.id_cond = gcccond.id_cond
      LEFT JOIN apcconc ON TO_CHAR(apcconc.cd_sap_dealer) = gcibjdnf.dealer_sap
      LEFT JOIN gcccond ON gcccond.id_cond = gcibjdnf.id_cond
      LEFT JOIN dnccontrfundo ON dnccontrfundo.danfe = gcibjdnf.danfe
      AND dnccontrfundo.cd_sit NOT IN ('CA', 'RE')
      LEFT JOIN gcrcondper priper ON priper.id_cond = gcccond.id_cond
      AND priper.sq_per = 1
    WHERE
      (
        (
          apcconc.cd_concess = '1586297'
          OR apcconc.cd_conc_mat = '1586297'
        )
        AND gcibjdnf.bjd_situacao = 'I'
        AND bjd_sit_interna IN ('NO', 'SD')
      )
    ORDER BY
      apcconc.nm_apelido,
      danfe

