Symfony Profiler

SELECT
  g0_.id AS id_0,
  g0_.typ AS typ_1,
  g0_.num AS num_2,
  g0_.cpy AS cpy_3,
  g0_.fcy AS fcy_4,
  g0_.jou AS jou_5,
  g0_.fiy AS fiy_6,
  g0_.per AS per_7,
  g0_.accdat AS accdat_8,
  g0_.duddat AS duddat_9,
  g0_.ratdat AS ratdat_10,
  g0_.cat AS cat_11,
  g0_.sta AS sta_12,
  g0_.orimod AS orimod_13,
  g0_.dacdia AS dacdia_14,
  g0_.flgpaz AS flgpaz_15,
  g0_.flggen AS flggen_16,
  g0_.cur AS cur_17,
  g0_.typrat AS typrat_18,
  g0_.led AS led_19,
  g0_.curled AS curled_20,
  g0_.ratmlt AS ratmlt_21,
  g0_.ratdiv AS ratdiv_22,
  g0_.desvcr AS desvcr_23,
  g0_.ref AS ref_24,
  g0_.bprvcr AS bprvcr_25,
  g0_.rvs AS rvs_26,
  g0_.rvsdat AS rvsdat_27,
  g0_.rvsorinum AS rvsorinum_28,
  g0_.xdossier AS xdossier_29,
  g0_.xidfacini AS xidfacini_30,
  g0_.fcz_id_local AS fcz_id_local_31,
  g0_.fcz_id_systeme_cm AS fcz_id_systeme_cm_32,
  g0_.fcz_id_cp AS fcz_id_cp_33,
  g0_.fcz_description_systeme AS fcz_description_systeme_34,
  g0_.fcz_id_tier_piece AS fcz_id_tier_piece_35,
  g0_.fcz_id_site AS fcz_id_site_36,
  g0_.fcz_description_site AS fcz_description_site_37,
  g0_.fcz_description_tier_piece AS fcz_description_tier_piece_38,
  g0_.fcz_id_doc2_asso AS fcz_id_doc2_asso_39,
  g0_.fcz_id_doc1_asso AS fcz_id_doc1_asso_40,
  g0_.fcz_ec_ref AS fcz_ec_ref_41,
  g0_.fcz_factureini AS fcz_factureini_42,
  g0_.fcz_motif_annul AS fcz_motif_annul_43,
  g0_.fcz_autre_information AS fcz_autre_information_44,
  g0_.fcz_type_paiement AS fcz_type_paiement_45,
  g0_.fcz_type_banque AS fcz_type_banque_46,
  g0_.fcz_cheq_num AS fcz_cheq_num_47,
  g0_.fcz_cheq_type AS fcz_cheq_type_48,
  g0_.fcz_cheq_bnq AS fcz_cheq_bnq_49,
  g0_.fcz_montant_initial AS fcz_montant_initial_50,
  g0_.fcz_montant_remise AS fcz_montant_remise_51,
  g0_.fcz_montant_retenu AS fcz_montant_retenu_52,
  g0_.fcz_montant_net AS fcz_montant_net_53,
  g0_.fcz_montant_autre1 AS fcz_montant_autre1_54,
  g0_.fcz_montant_autre2 AS fcz_montant_autre2_55,
  g0_.fcz_cc_max_ref AS fcz_cc_max_ref_56,
  g0_.fcz_cc_max_mt AS fcz_cc_max_mt_57,
  g0_.fcz_flag1 AS fcz_flag1_58,
  g0_.fcz_flag2 AS fcz_flag2_59,
  g0_.fcz_flag3 AS fcz_flag3_60,
  g0_.fcz_flag4 AS fcz_flag4_61,
  g0_.fcz_flag5 AS fcz_flag5_62,
  g0_.fcz_date_interf_cm AS fcz_date_interf_cm_63,
  g0_.fcz_user_name_cm AS fcz_user_name_cm_64,
  g0_.fcz_date_interf_cp AS fcz_date_interf_cp_65,
  g0_.fcz_user_name_cp AS fcz_user_name_cp_66,
  g0_.fcz_id_ad_piece AS fcz_id_ad_piece_67,
  g0_.typ1 AS typ1_68,
  g0_.cpy1 AS cpy1_69,
  g0_.fcy1 AS fcy1_70,
  g0_.cce0 AS cce0_71,
  g0_.numx30 AS numx30_72,
  g0_.updtick0 AS updtick0_73,
  g0_.bprdatvcr0 AS bprdatvcr0_74,
  g0_.expnum0 AS expnum0_75,
  g0_.credat0 AS credat0_76,
  g0_.creusr0 AS creusr0_77,
  g0_.upddat0 AS upddat0_78,
  g0_.updusr0 AS updusr0_79,
  g0_.credattim0 AS credattim0_80,
  g0_.upddattim0 AS upddattim0_81,
  g0_.auuid0 AS auuid0_82,
  g0_.flag_inerfacage AS flag_inerfacage_83,
  g0_.code AS code_84,
  g0_.source AS source_85,
  g0_.fcz_flag6 AS fcz_flag6_86,
  g0_.observation_fcz_flag6 AS observation_fcz_flag6_87,
  g0_.flag_insert_adx AS flag_insert_adx_88
FROM
  gaccentry g0_
WHERE
  g0_.fcz_flag5 = ?
  AND g0_.fcz_flag3 = ?
  AND g0_.fcz_flag6 = ?

SELECT g0_.id AS id_0, g0_.typ AS typ_1, g0_.num AS num_2, g0_.cpy AS cpy_3, g0_.fcy AS fcy_4, g0_.jou AS jou_5, g0_.fiy AS fiy_6, g0_.per AS per_7, g0_.accdat AS accdat_8, g0_.duddat AS duddat_9, g0_.ratdat AS ratdat_10, g0_.cat AS cat_11, g0_.sta AS sta_12, g0_.orimod AS orimod_13, g0_.dacdia AS dacdia_14, g0_.flgpaz AS flgpaz_15, g0_.flggen AS flggen_16, g0_.cur AS cur_17, g0_.typrat AS typrat_18, g0_.led AS led_19, g0_.curled AS curled_20, g0_.ratmlt AS ratmlt_21, g0_.ratdiv AS ratdiv_22, g0_.desvcr AS desvcr_23, g0_.ref AS ref_24, g0_.bprvcr AS bprvcr_25, g0_.rvs AS rvs_26, g0_.rvsdat AS rvsdat_27, g0_.rvsorinum AS rvsorinum_28, g0_.xdossier AS xdossier_29, g0_.xidfacini AS xidfacini_30, g0_.fcz_id_local AS fcz_id_local_31, g0_.fcz_id_systeme_cm AS fcz_id_systeme_cm_32, g0_.fcz_id_cp AS fcz_id_cp_33, g0_.fcz_description_systeme AS fcz_description_systeme_34, g0_.fcz_id_tier_piece AS fcz_id_tier_piece_35, g0_.fcz_id_site AS fcz_id_site_36, g0_.fcz_description_site AS fcz_description_site_37, g0_.fcz_description_tier_piece AS fcz_description_tier_piece_38, g0_.fcz_id_doc2_asso AS fcz_id_doc2_asso_39, g0_.fcz_id_doc1_asso AS fcz_id_doc1_asso_40, g0_.fcz_ec_ref AS fcz_ec_ref_41, g0_.fcz_factureini AS fcz_factureini_42, g0_.fcz_motif_annul AS fcz_motif_annul_43, g0_.fcz_autre_information AS fcz_autre_information_44, g0_.fcz_type_paiement AS fcz_type_paiement_45, g0_.fcz_type_banque AS fcz_type_banque_46, g0_.fcz_cheq_num AS fcz_cheq_num_47, g0_.fcz_cheq_type AS fcz_cheq_type_48, g0_.fcz_cheq_bnq AS fcz_cheq_bnq_49, g0_.fcz_montant_initial AS fcz_montant_initial_50, g0_.fcz_montant_remise AS fcz_montant_remise_51, g0_.fcz_montant_retenu AS fcz_montant_retenu_52, g0_.fcz_montant_net AS fcz_montant_net_53, g0_.fcz_montant_autre1 AS fcz_montant_autre1_54, g0_.fcz_montant_autre2 AS fcz_montant_autre2_55, g0_.fcz_cc_max_ref AS fcz_cc_max_ref_56, g0_.fcz_cc_max_mt AS fcz_cc_max_mt_57, g0_.fcz_flag1 AS fcz_flag1_58, g0_.fcz_flag2 AS fcz_flag2_59, g0_.fcz_flag3 AS fcz_flag3_60, g0_.fcz_flag4 AS fcz_flag4_61, g0_.fcz_flag5 AS fcz_flag5_62, g0_.fcz_date_interf_cm AS fcz_date_interf_cm_63, g0_.fcz_user_name_cm AS fcz_user_name_cm_64, g0_.fcz_date_interf_cp AS fcz_date_interf_cp_65, g0_.fcz_user_name_cp AS fcz_user_name_cp_66, g0_.fcz_id_ad_piece AS fcz_id_ad_piece_67, g0_.typ1 AS typ1_68, g0_.cpy1 AS cpy1_69, g0_.fcy1 AS fcy1_70, g0_.cce0 AS cce0_71, g0_.numx30 AS numx30_72, g0_.updtick0 AS updtick0_73, g0_.bprdatvcr0 AS bprdatvcr0_74, g0_.expnum0 AS expnum0_75, g0_.credat0 AS credat0_76, g0_.creusr0 AS creusr0_77, g0_.upddat0 AS upddat0_78, g0_.updusr0 AS updusr0_79, g0_.credattim0 AS credattim0_80, g0_.upddattim0 AS upddattim0_81, g0_.auuid0 AS auuid0_82, g0_.flag_inerfacage AS flag_inerfacage_83, g0_.code AS code_84, g0_.source AS source_85, g0_.fcz_flag6 AS fcz_flag6_86, g0_.observation_fcz_flag6 AS observation_fcz_flag6_87, g0_.flag_insert_adx AS flag_insert_adx_88 FROM gaccentry g0_ WHERE g0_.fcz_flag5 = 1 AND g0_.fcz_flag3 = 1 AND g0_.fcz_flag6 = 2;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-GBNQ-004462_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-GBNQ-004462_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-001099_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-001099_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000818_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000818_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDE-APCC-002101_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDE-APCC-002101_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEI-GBNQ-004907_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEI-GBNQ-004907_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEI-GBNQ-004906_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEI-GBNQ-004906_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-SHCZ-000112_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-SHCZ-000112_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDI-ELEZ-000535_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDI-ELEZ-000535_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEI-ELEZ-000533_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEI-ELEZ-000533_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-001205_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-001205_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDI-ELEZ-000532_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDI-ELEZ-000532_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000558_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000558_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-SIR-000490_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-SIR-000490_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000793_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000793_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-SHMY-000097_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-SHMY-000097_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-SLAB-000117_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-SLAB-000117_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000783_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000783_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000041_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000041_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CSO-HCZ-069662_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CSO-HCZ-069662_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000032_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000032_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-001197_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-001197_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-SSC-000302_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-SSC-000302_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000577_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000577_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000483_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000483_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-SHCZ-000075_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-SHCZ-000075_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000944_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000944_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000957_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000957_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000592_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000592_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000663_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000663_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-001000_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-001000_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-IPTT-000068_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-IPTT-000068_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000898_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000898_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-SSC-000313_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-SSC-000313_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000490_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000490_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDE-PGRO-001410_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDE-PGRO-001410_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000695_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000695_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000901_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000901_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000579_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000579_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-GBNQ-004717_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-GBNQ-004717_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000653_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000653_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000943_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000943_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000643_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000643_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000416_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000416_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000907_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000907_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-SHMY-000096_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-SHMY-000096_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000039_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000039_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-APCC-002015_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-APCC-002015_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDE-PGRO-000824_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDE-PGRO-000824_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'iFAFE-CAF-DAP-000064_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'iFAFE-CAF-DAP-000064_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDE-SFCZ-001602_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDE-SFCZ-001602_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000586_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000586_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000615_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000615_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000033_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000033_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000501_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000501_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-REU-000105_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-REU-000105_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000036_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000036_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000034_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000034_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000916_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000916_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDE-PGRO-001402_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDE-PGRO-001402_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000042_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000042_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-IPTT-000006_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-IPTT-000006_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000658_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000658_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000473_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000473_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-001196_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-001196_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000381_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000381_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000640_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000640_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000680_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000680_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000938_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000938_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000881_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000881_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000031_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000031_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-SCVP-000003_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-SCVP-000003_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPDE-PIMP-000184_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPDE-PIMP-000184_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000401_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000401_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000799_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000799_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000281_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000281_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000686_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000686_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'MAD-CAS-SLF-001-000087_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'MAD-CAS-SLF-001-000087_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-ISAE-000222_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-ISAE-000222_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'VIRE-CAS-SSD-001-000038_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'VIRE-CAS-SSD-001-000038_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000372_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000372_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CSO-HCZ-069663_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CSO-HCZ-069663_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'VIRE-CAS-SASS-000099_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'VIRE-CAS-SASS-000099_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'VIRE-CER-CRR-000108_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'VIRE-CER-CRR-000108_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CSO-LDM-000399_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CSO-LDM-000399_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CSO-HCZ-069670_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CSO-HCZ-069670_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-IPTT-000421_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-IPTT-000421_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000956_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000956_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000110_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000110_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-PIMP-000003_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-PIMP-000003_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000310_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000310_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-GRSH-001566_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-GRSH-001566_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000498_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000498_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-RCD-000969_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-RCD-000969_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000552_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000552_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000578_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000578_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'CHQE-CAS-DRH-000034_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'CHQE-CAS-DRH-000034_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'OPEE-APUR-000311_24'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'OPEE-APUR-000311_24' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAS-EVF-000117_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAS-EVF-000117_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CAF-DAP-000493_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CAF-DAP-000493_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-APLM-000035_23'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-APLM-000035_23' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CSO-HCZ-069655_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CSO-HCZ-069655_22' ;

SELECT
  REF_0,
  NUM_0
FROM
  HCZ.GACCENTRY
WHERE
  REF_0 = 'FAFE-CSO-HCZ-AM2-000271_22'

SELECT REF_0, NUM_0 FROM HCZ.GACCENTRY WHERE REF_0 = 'FAFE-CSO-HCZ-AM2-000271_22' ;