-
-
Save thepatrickniyo/091b463c7cb34dd7b989fc26d980b576 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Fetch 1 | |
| 2025-04-14 15:20:28.763 DEBUG 536 --- [nio-8051-exec-1] org.hibernate.SQL : | |
| select | |
| business0_.id as id1_46_0_, | |
| business0_.created_at as created_2_46_0_, | |
| business0_.created_by_audit as created_3_46_0_, | |
| business0_.created_date as created_4_46_0_, | |
| business0_.last_modified_by as last_mod5_46_0_, | |
| business0_.last_modified_date as last_mod6_46_0_, | |
| business0_.state as state7_46_0_, | |
| business0_.updated_at as updated_8_46_0_, | |
| business0_.version as version9_46_0_, | |
| business0_.rra_reference_key as rra_ref10_46_0_, | |
| business0_.abbreviation as abbrevi11_46_0_, | |
| business0_.application_reference_id as applica12_46_0_, | |
| business0_.application_status as applica13_46_0_, | |
| business0_.assigned_approver as assigne43_46_0_, | |
| business0_.assigned_verifier as assigne44_46_0_, | |
| business0_.branch_id as branch_14_46_0_, | |
| business0_.branch_name as branch_15_46_0_, | |
| business0_.certificate_no as certifi16_46_0_, | |
| business0_.company_category as company17_46_0_, | |
| business0_.company_id as company18_46_0_, | |
| business0_.company_name as company19_46_0_, | |
| business0_.company_type as company20_46_0_, | |
| business0_.country_of_tax_residence as country21_46_0_, | |
| business0_.created_by as created45_46_0_, | |
| business0_.enterprise_business_name as enterpr22_46_0_, | |
| business0_.enterprise_name as enterpr23_46_0_, | |
| business0_.has_articles_of_association as has_art24_46_0_, | |
| business0_.holding_company_name as holding25_46_0_, | |
| business0_.holding_company_residence_country as holding26_46_0_, | |
| business0_.is_foreign as is_fore27_46_0_, | |
| business0_.is_multinational as is_mult28_46_0_, | |
| business0_.is_other_currency_allowed as is_othe29_46_0_, | |
| business0_.is_vat_registered as is_vat_30_46_0_, | |
| business0_.issuance_date as issuanc31_46_0_, | |
| business0_.issuance_place as issuanc32_46_0_, | |
| business0_.migrated as migrate33_46_0_, | |
| business0_.parent_company_name as parent_34_46_0_, | |
| business0_.parent_company_residence_country as parent_35_46_0_, | |
| business0_.position as positio36_46_0_, | |
| business0_.registration_no as registr37_46_0_, | |
| business0_.reservation_id as reserva38_46_0_, | |
| business0_.rra_tax_account_status as rra_tax39_46_0_, | |
| business0_.service_id as service46_46_0_, | |
| business0_.tin as tin40_46_0_, | |
| business0_.valid_from as valid_f41_46_0_, | |
| business0_.valid_to as valid_t42_46_0_, | |
| user1_.id as id1_177_1_, | |
| user1_.created_at as created_2_177_1_, | |
| user1_.created_by_audit as created_3_177_1_, | |
| user1_.created_date as created_4_177_1_, | |
| user1_.last_modified_by as last_mod5_177_1_, | |
| user1_.last_modified_date as last_mod6_177_1_, | |
| user1_.state as state7_177_1_, | |
| user1_.updated_at as updated_8_177_1_, | |
| user1_.version as version9_177_1_, | |
| user1_.rra_reference_key as rra_ref10_177_1_, | |
| user1_.created_by as created41_177_1_, | |
| user1_.date_of_birth as date_of11_177_1_, | |
| user1_.department as departm12_177_1_, | |
| user1_.email as email13_177_1_, | |
| user1_.email_verification_code as email_v14_177_1_, | |
| user1_.failed_login_attempts as failed_15_177_1_, | |
| user1_.institution_id as institu42_177_1_, | |
| user1_.first_name as first_n16_177_1_, | |
| user1_.gender as gender17_177_1_, | |
| user1_.is_email_verified as is_emai18_177_1_, | |
| user1_.is_from_nida as is_from19_177_1_, | |
| user1_.is_locked as is_lock20_177_1_, | |
| user1_.is_phone_number_verified as is_phon21_177_1_, | |
| user1_.last_name as last_na22_177_1_, | |
| user1_.nationality as nationa23_177_1_, | |
| user1_.notification_preference as notific24_177_1_, | |
| user1_.password as passwor25_177_1_, | |
| user1_.password_reset_code as passwor26_177_1_, | |
| user1_.password_reset_code_expires_at as passwor27_177_1_, | |
| user1_.person_doc_expiry_date as person_28_177_1_, | |
| user1_.person_doc_issue_date as person_29_177_1_, | |
| user1_.person_doc_issue_place as person_30_177_1_, | |
| user1_.person_doc_no as person_31_177_1_, | |
| user1_.person_ident_type as person_32_177_1_, | |
| user1_.phone_number as phone_n33_177_1_, | |
| user1_.phone_verification_code as phone_v34_177_1_, | |
| user1_.user_category as user_ca35_177_1_, | |
| user1_.user_type as user_ty36_177_1_, | |
| user1_.username as usernam37_177_1_, | |
| user1_.valid_from as valid_f38_177_1_, | |
| user1_.valid_to as valid_t39_177_1_, | |
| user1_.verification_code_expires_at as verific40_177_1_, | |
| financiali2_.id as id1_146_2_, | |
| financiali2_.created_at as created_2_146_2_, | |
| financiali2_.created_by_audit as created_3_146_2_, | |
| financiali2_.created_date as created_4_146_2_, | |
| financiali2_.last_modified_by as last_mod5_146_2_, | |
| financiali2_.last_modified_date as last_mod6_146_2_, | |
| financiali2_.state as state7_146_2_, | |
| financiali2_.updated_at as updated_8_146_2_, | |
| financiali2_.version as version9_146_2_, | |
| financiali2_.rra_reference_key as rra_ref10_146_2_, | |
| financiali2_.financial_institution_address as financi15_146_2_, | |
| financiali2_.institution_type as institu11_146_2_, | |
| financiali2_.name as name12_146_2_, | |
| financiali2_.registration_number as registr13_146_2_, | |
| financiali2_.status as status14_146_2_, | |
| financiali3_.id as id1_147_3_, | |
| financiali3_.created_at as created_2_147_3_, | |
| financiali3_.created_by_audit as created_3_147_3_, | |
| financiali3_.created_date as created_4_147_3_, | |
| financiali3_.last_modified_by as last_mod5_147_3_, | |
| financiali3_.last_modified_date as last_mod6_147_3_, | |
| financiali3_.state as state7_147_3_, | |
| financiali3_.updated_at as updated_8_147_3_, | |
| financiali3_.version as version9_147_3_, | |
| financiali3_.rra_reference_key as rra_ref10_147_3_, | |
| financiali3_.address_str as address11_147_3_, | |
| financiali3_.city as city12_147_3_, | |
| financiali3_.country_of_incorporation as country13_147_3_, | |
| financiali3_.email as email14_147_3_, | |
| financiali3_.financial_institution as financi20_147_3_, | |
| financiali3_.is_email_verified as is_emai15_147_3_, | |
| financiali3_.is_phone_verified as is_phon16_147_3_, | |
| financiali3_.phone_number as phone_n17_147_3_, | |
| financiali3_.street_name as street_18_147_3_, | |
| financiali3_.village_id as village21_147_3_, | |
| financiali3_.zip_code as zip_cod19_147_3_, | |
| village4_.id as id1_171_4_, | |
| village4_.name as name2_171_4_, | |
| village4_.category as category3_171_4_, | |
| village4_.cell_id as cell_id4_171_4_, | |
| cell5_.id as id1_163_5_, | |
| cell5_.name as name2_163_5_, | |
| cell5_.sector_id as sector_i3_163_5_, | |
| sector6_.id as id1_168_6_, | |
| sector6_.name as name2_168_6_, | |
| sector6_.district_id as district3_168_6_, | |
| district7_.id as id1_165_7_, | |
| district7_.name as name2_165_7_, | |
| district7_.province_id as province3_165_7_, | |
| province8_.id as id1_167_8_, | |
| province8_.name as name2_167_8_, | |
| roles9_.user_id as user_id1_175_9_, | |
| role10_.id as role_id2_175_9_, | |
| role10_.id as id1_160_10_, | |
| role10_.created_at as created_2_160_10_, | |
| role10_.created_by_audit as created_3_160_10_, | |
| role10_.created_date as created_4_160_10_, | |
| role10_.last_modified_by as last_mod5_160_10_, | |
| role10_.last_modified_date as last_mod6_160_10_, | |
| role10_.state as state7_160_10_, | |
| role10_.updated_at as updated_8_160_10_, | |
| role10_.version as version9_160_10_, | |
| role10_.department as departm10_160_10_, | |
| role10_.description as descrip11_160_10_, | |
| role10_.role_name as role_na12_160_10_, | |
| user11_.id as id1_177_11_, | |
| user11_.created_at as created_2_177_11_, | |
| user11_.created_by_audit as created_3_177_11_, | |
| user11_.created_date as created_4_177_11_, | |
| user11_.last_modified_by as last_mod5_177_11_, | |
| user11_.last_modified_date as last_mod6_177_11_, | |
| user11_.state as state7_177_11_, | |
| user11_.updated_at as updated_8_177_11_, | |
| user11_.version as version9_177_11_, | |
| user11_.rra_reference_key as rra_ref10_177_11_, | |
| user11_.created_by as created41_177_11_, | |
| user11_.date_of_birth as date_of11_177_11_, | |
| user11_.department as departm12_177_11_, | |
| user11_.email as email13_177_11_, | |
| user11_.email_verification_code as email_v14_177_11_, | |
| user11_.failed_login_attempts as failed_15_177_11_, | |
| user11_.institution_id as institu42_177_11_, | |
| user11_.first_name as first_n16_177_11_, | |
| user11_.gender as gender17_177_11_, | |
| user11_.is_email_verified as is_emai18_177_11_, | |
| user11_.is_from_nida as is_from19_177_11_, | |
| user11_.is_locked as is_lock20_177_11_, | |
| user11_.is_phone_number_verified as is_phon21_177_11_, | |
| user11_.last_name as last_na22_177_11_, | |
| user11_.nationality as nationa23_177_11_, | |
| user11_.notification_preference as notific24_177_11_, | |
| user11_.password as passwor25_177_11_, | |
| user11_.password_reset_code as passwor26_177_11_, | |
| user11_.password_reset_code_expires_at as passwor27_177_11_, | |
| user11_.person_doc_expiry_date as person_28_177_11_, | |
| user11_.person_doc_issue_date as person_29_177_11_, | |
| user11_.person_doc_issue_place as person_30_177_11_, | |
| user11_.person_doc_no as person_31_177_11_, | |
| user11_.person_ident_type as person_32_177_11_, | |
| user11_.phone_number as phone_n33_177_11_, | |
| user11_.phone_verification_code as phone_v34_177_11_, | |
| user11_.user_category as user_ca35_177_11_, | |
| user11_.user_type as user_ty36_177_11_, | |
| user11_.username as usernam37_177_11_, | |
| user11_.valid_from as valid_f38_177_11_, | |
| user11_.valid_to as valid_t39_177_11_, | |
| user11_.verification_code_expires_at as verific40_177_11_, | |
| service12_.id as id1_169_12_, | |
| service12_.created_at as created_2_169_12_, | |
| service12_.created_by_audit as created_3_169_12_, | |
| service12_.created_date as created_4_169_12_, | |
| service12_.last_modified_by as last_mod5_169_12_, | |
| service12_.last_modified_date as last_mod6_169_12_, | |
| service12_.state as state7_169_12_, | |
| service12_.updated_at as updated_8_169_12_, | |
| service12_.version as version9_169_12_, | |
| service12_.rra_reference_key as rra_ref10_169_12_, | |
| service12_.category as categor11_169_12_, | |
| service12_.description as descrip12_169_12_, | |
| service12_.name as name13_169_12_, | |
| service12_.path as path14_169_12_, | |
| service12_.section as section15_169_12_, | |
| service12_.verification_level as verific16_169_12_ | |
| from | |
| bur_business business0_ | |
| left outer join | |
| users user1_ | |
| on business0_.assigned_approver=user1_.id | |
| left outer join | |
| mtg_financial_institution financiali2_ | |
| on user1_.institution_id=financiali2_.id | |
| left outer join | |
| mtg_financial_institution_address financiali3_ | |
| on financiali2_.financial_institution_address=financiali3_.id | |
| left outer join | |
| stc_village village4_ | |
| on financiali3_.village_id=village4_.id | |
| left outer join | |
| stc_cell cell5_ | |
| on village4_.cell_id=cell5_.id | |
| left outer join | |
| stc_sector sector6_ | |
| on cell5_.sector_id=sector6_.id | |
| left outer join | |
| stc_district district7_ | |
| on sector6_.district_id=district7_.id | |
| left outer join | |
| stc_province province8_ | |
| on district7_.province_id=province8_.id | |
| left outer join | |
| user_role roles9_ | |
| on user1_.id=roles9_.user_id | |
| left outer join | |
| role role10_ | |
| on roles9_.role_id=role10_.id | |
| left outer join | |
| users user11_ | |
| on business0_.assigned_verifier=user11_.id | |
| left outer join | |
| stc_service service12_ | |
| on business0_.service_id=service12_.id | |
| where | |
| business0_.id=? | |
| 2025-04-14 15:20:28.763 DEBUG 536 --- [nio-8051-exec-2] org.hibernate.SQL : | |
| select | |
| business0_.id as id1_46_0_, | |
| business0_.created_at as created_2_46_0_, | |
| business0_.created_by_audit as created_3_46_0_, | |
| business0_.created_date as created_4_46_0_, | |
| business0_.last_modified_by as last_mod5_46_0_, | |
| business0_.last_modified_date as last_mod6_46_0_, | |
| business0_.state as state7_46_0_, | |
| business0_.updated_at as updated_8_46_0_, | |
| business0_.version as version9_46_0_, | |
| business0_.rra_reference_key as rra_ref10_46_0_, | |
| business0_.abbreviation as abbrevi11_46_0_, | |
| business0_.application_reference_id as applica12_46_0_, | |
| business0_.application_status as applica13_46_0_, | |
| business0_.assigned_approver as assigne43_46_0_, | |
| business0_.assigned_verifier as assigne44_46_0_, | |
| business0_.branch_id as branch_14_46_0_, | |
| business0_.branch_name as branch_15_46_0_, | |
| business0_.certificate_no as certifi16_46_0_, | |
| business0_.company_category as company17_46_0_, | |
| business0_.company_id as company18_46_0_, | |
| business0_.company_name as company19_46_0_, | |
| business0_.company_type as company20_46_0_, | |
| business0_.country_of_tax_residence as country21_46_0_, | |
| business0_.created_by as created45_46_0_, | |
| business0_.enterprise_business_name as enterpr22_46_0_, | |
| business0_.enterprise_name as enterpr23_46_0_, | |
| business0_.has_articles_of_association as has_art24_46_0_, | |
| business0_.holding_company_name as holding25_46_0_, | |
| business0_.holding_company_residence_country as holding26_46_0_, | |
| business0_.is_foreign as is_fore27_46_0_, | |
| business0_.is_multinational as is_mult28_46_0_, | |
| business0_.is_other_currency_allowed as is_othe29_46_0_, | |
| business0_.is_vat_registered as is_vat_30_46_0_, | |
| business0_.issuance_date as issuanc31_46_0_, | |
| business0_.issuance_place as issuanc32_46_0_, | |
| business0_.migrated as migrate33_46_0_, | |
| business0_.parent_company_name as parent_34_46_0_, | |
| business0_.parent_company_residence_country as parent_35_46_0_, | |
| business0_.position as positio36_46_0_, | |
| business0_.registration_no as registr37_46_0_, | |
| business0_.reservation_id as reserva38_46_0_, | |
| business0_.rra_tax_account_status as rra_tax39_46_0_, | |
| business0_.service_id as service46_46_0_, | |
| business0_.tin as tin40_46_0_, | |
| business0_.valid_from as valid_f41_46_0_, | |
| business0_.valid_to as valid_t42_46_0_, | |
| user1_.id as id1_177_1_, | |
| user1_.created_at as created_2_177_1_, | |
| user1_.created_by_audit as created_3_177_1_, | |
| user1_.created_date as created_4_177_1_, | |
| user1_.last_modified_by as last_mod5_177_1_, | |
| user1_.last_modified_date as last_mod6_177_1_, | |
| user1_.state as state7_177_1_, | |
| user1_.updated_at as updated_8_177_1_, | |
| user1_.version as version9_177_1_, | |
| user1_.rra_reference_key as rra_ref10_177_1_, | |
| user1_.created_by as created41_177_1_, | |
| user1_.date_of_birth as date_of11_177_1_, | |
| user1_.department as departm12_177_1_, | |
| user1_.email as email13_177_1_, | |
| user1_.email_verification_code as email_v14_177_1_, | |
| user1_.failed_login_attempts as failed_15_177_1_, | |
| user1_.institution_id as institu42_177_1_, | |
| user1_.first_name as first_n16_177_1_, | |
| user1_.gender as gender17_177_1_, | |
| user1_.is_email_verified as is_emai18_177_1_, | |
| user1_.is_from_nida as is_from19_177_1_, | |
| user1_.is_locked as is_lock20_177_1_, | |
| user1_.is_phone_number_verified as is_phon21_177_1_, | |
| user1_.last_name as last_na22_177_1_, | |
| user1_.nationality as nationa23_177_1_, | |
| user1_.notification_preference as notific24_177_1_, | |
| user1_.password as passwor25_177_1_, | |
| user1_.password_reset_code as passwor26_177_1_, | |
| user1_.password_reset_code_expires_at as passwor27_177_1_, | |
| user1_.person_doc_expiry_date as person_28_177_1_, | |
| user1_.person_doc_issue_date as person_29_177_1_, | |
| user1_.person_doc_issue_place as person_30_177_1_, | |
| user1_.person_doc_no as person_31_177_1_, | |
| user1_.person_ident_type as person_32_177_1_, | |
| user1_.phone_number as phone_n33_177_1_, | |
| user1_.phone_verification_code as phone_v34_177_1_, | |
| user1_.user_category as user_ca35_177_1_, | |
| user1_.user_type as user_ty36_177_1_, | |
| user1_.username as usernam37_177_1_, | |
| user1_.valid_from as valid_f38_177_1_, | |
| user1_.valid_to as valid_t39_177_1_, | |
| user1_.verification_code_expires_at as verific40_177_1_, | |
| financiali2_.id as id1_146_2_, | |
| financiali2_.created_at as created_2_146_2_, | |
| financiali2_.created_by_audit as created_3_146_2_, | |
| financiali2_.created_date as created_4_146_2_, | |
| financiali2_.last_modified_by as last_mod5_146_2_, | |
| financiali2_.last_modified_date as last_mod6_146_2_, | |
| financiali2_.state as state7_146_2_, | |
| financiali2_.updated_at as updated_8_146_2_, | |
| financiali2_.version as version9_146_2_, | |
| financiali2_.rra_reference_key as rra_ref10_146_2_, | |
| financiali2_.financial_institution_address as financi15_146_2_, | |
| financiali2_.institution_type as institu11_146_2_, | |
| financiali2_.name as name12_146_2_, | |
| financiali2_.registration_number as registr13_146_2_, | |
| financiali2_.status as status14_146_2_, | |
| financiali3_.id as id1_147_3_, | |
| financiali3_.created_at as created_2_147_3_, | |
| financiali3_.created_by_audit as created_3_147_3_, | |
| financiali3_.created_date as created_4_147_3_, | |
| financiali3_.last_modified_by as last_mod5_147_3_, | |
| financiali3_.last_modified_date as last_mod6_147_3_, | |
| financiali3_.state as state7_147_3_, | |
| financiali3_.updated_at as updated_8_147_3_, | |
| financiali3_.version as version9_147_3_, | |
| financiali3_.rra_reference_key as rra_ref10_147_3_, | |
| financiali3_.address_str as address11_147_3_, | |
| financiali3_.city as city12_147_3_, | |
| financiali3_.country_of_incorporation as country13_147_3_, | |
| financiali3_.email as email14_147_3_, | |
| financiali3_.financial_institution as financi20_147_3_, | |
| financiali3_.is_email_verified as is_emai15_147_3_, | |
| financiali3_.is_phone_verified as is_phon16_147_3_, | |
| financiali3_.phone_number as phone_n17_147_3_, | |
| financiali3_.street_name as street_18_147_3_, | |
| financiali3_.village_id as village21_147_3_, | |
| financiali3_.zip_code as zip_cod19_147_3_, | |
| village4_.id as id1_171_4_, | |
| village4_.name as name2_171_4_, | |
| village4_.category as category3_171_4_, | |
| village4_.cell_id as cell_id4_171_4_, | |
| cell5_.id as id1_163_5_, | |
| cell5_.name as name2_163_5_, | |
| cell5_.sector_id as sector_i3_163_5_, | |
| sector6_.id as id1_168_6_, | |
| sector6_.name as name2_168_6_, | |
| sector6_.district_id as district3_168_6_, | |
| district7_.id as id1_165_7_, | |
| district7_.name as name2_165_7_, | |
| district7_.province_id as province3_165_7_, | |
| province8_.id as id1_167_8_, | |
| province8_.name as name2_167_8_, | |
| roles9_.user_id as user_id1_175_9_, | |
| role10_.id as role_id2_175_9_, | |
| role10_.id as id1_160_10_, | |
| role10_.created_at as created_2_160_10_, | |
| role10_.created_by_audit as created_3_160_10_, | |
| role10_.created_date as created_4_160_10_, | |
| role10_.last_modified_by as last_mod5_160_10_, | |
| role10_.last_modified_date as last_mod6_160_10_, | |
| role10_.state as state7_160_10_, | |
| role10_.updated_at as updated_8_160_10_, | |
| role10_.version as version9_160_10_, | |
| role10_.department as departm10_160_10_, | |
| role10_.description as descrip11_160_10_, | |
| role10_.role_name as role_na12_160_10_, | |
| user11_.id as id1_177_11_, | |
| user11_.created_at as created_2_177_11_, | |
| user11_.created_by_audit as created_3_177_11_, | |
| user11_.created_date as created_4_177_11_, | |
| user11_.last_modified_by as last_mod5_177_11_, | |
| user11_.last_modified_date as last_mod6_177_11_, | |
| user11_.state as state7_177_11_, | |
| user11_.updated_at as updated_8_177_11_, | |
| user11_.version as version9_177_11_, | |
| user11_.rra_reference_key as rra_ref10_177_11_, | |
| user11_.created_by as created41_177_11_, | |
| user11_.date_of_birth as date_of11_177_11_, | |
| user11_.department as departm12_177_11_, | |
| user11_.email as email13_177_11_, | |
| user11_.email_verification_code as email_v14_177_11_, | |
| user11_.failed_login_attempts as failed_15_177_11_, | |
| user11_.institution_id as institu42_177_11_, | |
| user11_.first_name as first_n16_177_11_, | |
| user11_.gender as gender17_177_11_, | |
| user11_.is_email_verified as is_emai18_177_11_, | |
| user11_.is_from_nida as is_from19_177_11_, | |
| user11_.is_locked as is_lock20_177_11_, | |
| user11_.is_phone_number_verified as is_phon21_177_11_, | |
| user11_.last_name as last_na22_177_11_, | |
| user11_.nationality as nationa23_177_11_, | |
| user11_.notification_preference as notific24_177_11_, | |
| user11_.password as passwor25_177_11_, | |
| user11_.password_reset_code as passwor26_177_11_, | |
| user11_.password_reset_code_expires_at as passwor27_177_11_, | |
| user11_.person_doc_expiry_date as person_28_177_11_, | |
| user11_.person_doc_issue_date as person_29_177_11_, | |
| user11_.person_doc_issue_place as person_30_177_11_, | |
| user11_.person_doc_no as person_31_177_11_, | |
| user11_.person_ident_type as person_32_177_11_, | |
| user11_.phone_number as phone_n33_177_11_, | |
| user11_.phone_verification_code as phone_v34_177_11_, | |
| user11_.user_category as user_ca35_177_11_, | |
| user11_.user_type as user_ty36_177_11_, | |
| user11_.username as usernam37_177_11_, | |
| user11_.valid_from as valid_f38_177_11_, | |
| user11_.valid_to as valid_t39_177_11_, | |
| user11_.verification_code_expires_at as verific40_177_11_, | |
| service12_.id as id1_169_12_, | |
| service12_.created_at as created_2_169_12_, | |
| service12_.created_by_audit as created_3_169_12_, | |
| service12_.created_date as created_4_169_12_, | |
| service12_.last_modified_by as last_mod5_169_12_, | |
| service12_.last_modified_date as last_mod6_169_12_, | |
| service12_.state as state7_169_12_, | |
| service12_.updated_at as updated_8_169_12_, | |
| service12_.version as version9_169_12_, | |
| service12_.rra_reference_key as rra_ref10_169_12_, | |
| service12_.category as categor11_169_12_, | |
| service12_.description as descrip12_169_12_, | |
| service12_.name as name13_169_12_, | |
| service12_.path as path14_169_12_, | |
| service12_.section as section15_169_12_, | |
| service12_.verification_level as verific16_169_12_ | |
| from | |
| bur_business business0_ | |
| left outer join | |
| users user1_ | |
| on business0_.assigned_approver=user1_.id | |
| left outer join | |
| mtg_financial_institution financiali2_ | |
| on user1_.institution_id=financiali2_.id | |
| left outer join | |
| mtg_financial_institution_address financiali3_ | |
| on financiali2_.financial_institution_address=financiali3_.id | |
| left outer join | |
| stc_village village4_ | |
| on financiali3_.village_id=village4_.id | |
| left outer join | |
| stc_cell cell5_ | |
| on village4_.cell_id=cell5_.id | |
| left outer join | |
| stc_sector sector6_ | |
| on cell5_.sector_id=sector6_.id | |
| left outer join | |
| stc_district district7_ | |
| on sector6_.district_id=district7_.id | |
| left outer join | |
| stc_province province8_ | |
| on district7_.province_id=province8_.id | |
| left outer join | |
| user_role roles9_ | |
| on user1_.id=roles9_.user_id | |
| left outer join | |
| role role10_ | |
| on roles9_.role_id=role10_.id | |
| left outer join | |
| users user11_ | |
| on business0_.assigned_verifier=user11_.id | |
| left outer join | |
| stc_service service12_ | |
| on business0_.service_id=service12_.id | |
| where | |
| business0_.id=? | |
| Hibernate: | |
| select | |
| business0_.id as id1_46_0_, | |
| business0_.created_at as created_2_46_0_, | |
| business0_.created_by_audit as created_3_46_0_, | |
| business0_.created_date as created_4_46_0_, | |
| business0_.last_modified_by as last_mod5_46_0_, | |
| business0_.last_modified_date as last_mod6_46_0_, | |
| business0_.state as state7_46_0_, | |
| business0_.updated_at as updated_8_46_0_, | |
| business0_.version as version9_46_0_, | |
| business0_.rra_reference_key as rra_ref10_46_0_, | |
| business0_.abbreviation as abbrevi11_46_0_, | |
| business0_.application_reference_id as applica12_46_0_, | |
| business0_.application_status as applica13_46_0_, | |
| business0_.assigned_approver as assigne43_46_0_, | |
| business0_.assigned_verifier as assigne44_46_0_, | |
| business0_.branch_id as branch_14_46_0_, | |
| business0_.branch_name as branch_15_46_0_, | |
| business0_.certificate_no as certifi16_46_0_, | |
| business0_.company_category as company17_46_0_, | |
| business0_.company_id as company18_46_0_, | |
| business0_.company_name as company19_46_0_, | |
| business0_.company_type as company20_46_0_, | |
| business0_.country_of_tax_residence as country21_46_0_, | |
| business0_.created_by as created45_46_0_, | |
| business0_.enterprise_business_name as enterpr22_46_0_, | |
| business0_.enterprise_name as enterpr23_46_0_, | |
| business0_.has_articles_of_association as has_art24_46_0_, | |
| business0_.holding_company_name as holding25_46_0_, | |
| business0_.holding_company_residence_country as holding26_46_0_, | |
| business0_.is_foreign as is_fore27_46_0_, | |
| business0_.is_multinational as is_mult28_46_0_, | |
| business0_.is_other_currency_allowed as is_othe29_46_0_, | |
| business0_.is_vat_registered as is_vat_30_46_0_, | |
| business0_.issuance_date as issuanc31_46_0_, | |
| business0_.issuance_place as issuanc32_46_0_, | |
| business0_.migrated as migrate33_46_0_, | |
| business0_.parent_company_name as parent_34_46_0_, | |
| business0_.parent_company_residence_country as parent_35_46_0_, | |
| business0_.position as positio36_46_0_, | |
| business0_.registration_no as registr37_46_0_, | |
| business0_.reservation_id as reserva38_46_0_, | |
| business0_.rra_tax_account_status as rra_tax39_46_0_, | |
| business0_.service_id as service46_46_0_, | |
| business0_.tin as tin40_46_0_, | |
| business0_.valid_from as valid_f41_46_0_, | |
| business0_.valid_to as valid_t42_46_0_, | |
| user1_.id as id1_177_1_, | |
| user1_.created_at as created_2_177_1_, | |
| user1_.created_by_audit as created_3_177_1_, | |
| user1_.created_date as created_4_177_1_, | |
| user1_.last_modified_by as last_mod5_177_1_, | |
| user1_.last_modified_date as last_mod6_177_1_, | |
| user1_.state as state7_177_1_, | |
| user1_.updated_at as updated_8_177_1_, | |
| user1_.version as version9_177_1_, | |
| user1_.rra_reference_key as rra_ref10_177_1_, | |
| user1_.created_by as created41_177_1_, | |
| user1_.date_of_birth as date_of11_177_1_, | |
| user1_.department as departm12_177_1_, | |
| user1_.email as email13_177_1_, | |
| user1_.email_verification_code as email_v14_177_1_, | |
| user1_.failed_login_attempts as failed_15_177_1_, | |
| user1_.institution_id as institu42_177_1_, | |
| user1_.first_name as first_n16_177_1_, | |
| user1_.gender as gender17_177_1_, | |
| user1_.is_email_verified as is_emai18_177_1_, | |
| user1_.is_from_nida as is_from19_177_1_, | |
| user1_.is_locked as is_lock20_177_1_, | |
| user1_.is_phone_number_verified as is_phon21_177_1_, | |
| user1_.last_name as last_na22_177_1_, | |
| user1_.nationality as nationa23_177_1_, | |
| user1_.notification_preference as notific24_177_1_, | |
| user1_.password as passwor25_177_1_, | |
| user1_.password_reset_code as passwor26_177_1_, | |
| user1_.password_reset_code_expires_at as passwor27_177_1_, | |
| user1_.person_doc_expiry_date as person_28_177_1_, | |
| user1_.person_doc_issue_date as person_29_177_1_, | |
| user1_.person_doc_issue_place as person_30_177_1_, | |
| user1_.person_doc_no as person_31_177_1_, | |
| user1_.person_ident_type as person_32_177_1_, | |
| user1_.phone_number as phone_n33_177_1_, | |
| user1_.phone_verification_code as phone_v34_177_1_, | |
| user1_.user_category as user_ca35_177_1_, | |
| user1_.user_type as user_ty36_177_1_, | |
| user1_.username as usernam37_177_1_, | |
| user1_.valid_from as valid_f38_177_1_, | |
| user1_.valid_to as valid_t39_177_1_, | |
| user1_.verification_code_expires_at as verific40_177_1_, | |
| financiali2_.id as id1_146_2_, | |
| financiali2_.created_at as created_2_146_2_, | |
| financiali2_.created_by_audit as created_3_146_2_, | |
| financiali2_.created_date as created_4_146_2_, | |
| financiali2_.last_modified_by as last_mod5_146_2_, | |
| financiali2_.last_modified_date as last_mod6_146_2_, | |
| financiali2_.state as state7_146_2_, | |
| financiali2_.updated_at as updated_8_146_2_, | |
| financiali2_.version as version9_146_2_, | |
| financiali2_.rra_reference_key as rra_ref10_146_2_, | |
| financiali2_.financial_institution_address as financi15_146_2_, | |
| financiali2_.institution_type as institu11_146_2_, | |
| financiali2_.name as name12_146_2_, | |
| financiali2_.registration_number as registr13_146_2_, | |
| financiali2_.status as status14_146_2_, | |
| financiali3_.id as id1_147_3_, | |
| financiali3_.created_at as created_2_147_3_, | |
| financiali3_.created_by_audit as created_3_147_3_, | |
| financiali3_.created_date as created_4_147_3_, | |
| financiali3_.last_modified_by as last_mod5_147_3_, | |
| financiali3_.last_modified_date as last_mod6_147_3_, | |
| financiali3_.state as state7_147_3_, | |
| financiali3_.updated_at as updated_8_147_3_, | |
| financiali3_.version as version9_147_3_, | |
| financiali3_.rra_reference_key as rra_ref10_147_3_, | |
| financiali3_.address_str as address11_147_3_, | |
| financiali3_.city as city12_147_3_, | |
| financiali3_.country_of_incorporation as country13_147_3_, | |
| financiali3_.email as email14_147_3_, | |
| financiali3_.financial_institution as financi20_147_3_, | |
| financiali3_.is_email_verified as is_emai15_147_3_, | |
| financiali3_.is_phone_verified as is_phon16_147_3_, | |
| financiali3_.phone_number as phone_n17_147_3_, | |
| financiali3_.street_name as street_18_147_3_, | |
| financiali3_.village_id as village21_147_3_, | |
| financiali3_.zip_code as zip_cod19_147_3_, | |
| village4_.id as id1_171_4_, | |
| village4_.name as name2_171_4_, | |
| village4_.category as category3_171_4_, | |
| village4_.cell_id as cell_id4_171_4_, | |
| cell5_.id as id1_163_5_, | |
| cell5_.name as name2_163_5_, | |
| cell5_.sector_id as sector_i3_163_5_, | |
| sector6_.id as id1_168_6_, | |
| sector6_.name as name2_168_6_, | |
| sector6_.district_id as district3_168_6_, | |
| district7_.id as id1_165_7_, | |
| district7_.name as name2_165_7_, | |
| district7_.province_id as province3_165_7_, | |
| province8_.id as id1_167_8_, | |
| province8_.name as name2_167_8_, | |
| roles9_.user_id as user_id1_175_9_, | |
| role10_.id as role_id2_175_9_, | |
| role10_.id as id1_160_10_, | |
| role10_.created_at as created_2_160_10_, | |
| role10_.created_by_audit as created_3_160_10_, | |
| role10_.created_date as created_4_160_10_, | |
| role10_.last_modified_by as last_mod5_160_10_, | |
| role10_.last_modified_date as last_mod6_160_10_, | |
| role10_.state as state7_160_10_, | |
| role10_.updated_at as updated_8_160_10_, | |
| role10_.version as version9_160_10_, | |
| role10_.department as departm10_160_10_, | |
| role10_.description as descrip11_160_10_, | |
| role10_.role_name as role_na12_160_10_, | |
| user11_.id as id1_177_11_, | |
| user11_.created_at as created_2_177_11_, | |
| user11_.created_by_audit as created_3_177_11_, | |
| user11_.created_date as created_4_177_11_, | |
| user11_.last_modified_by as last_mod5_177_11_, | |
| user11_.last_modified_date as last_mod6_177_11_, | |
| user11_.state as state7_177_11_, | |
| user11_.updated_at as updated_8_177_11_, | |
| user11_.version as version9_177_11_, | |
| user11_.rra_reference_key as rra_ref10_177_11_, | |
| user11_.created_by as created41_177_11_, | |
| user11_.date_of_birth as date_of11_177_11_, | |
| user11_.department as departm12_177_11_, | |
| user11_.email as email13_177_11_, | |
| user11_.email_verification_code as email_v14_177_11_, | |
| user11_.failed_login_attempts as failed_15_177_11_, | |
| user11_.institution_id as institu42_177_11_, | |
| user11_.first_name as first_n16_177_11_, | |
| user11_.gender as gender17_177_11_, | |
| user11_.is_email_verified as is_emai18_177_11_, | |
| user11_.is_from_nida as is_from19_177_11_, | |
| user11_.is_locked as is_lock20_177_11_, | |
| user11_.is_phone_number_verified as is_phon21_177_11_, | |
| user11_.last_name as last_na22_177_11_, | |
| user11_.nationality as nationa23_177_11_, | |
| user11_.notification_preference as notific24_177_11_, | |
| user11_.password as passwor25_177_11_, | |
| user11_.password_reset_code as passwor26_177_11_, | |
| user11_.password_reset_code_expires_at as passwor27_177_11_, | |
| user11_.person_doc_expiry_date as person_28_177_11_, | |
| user11_.person_doc_issue_date as person_29_177_11_, | |
| user11_.person_doc_issue_place as person_30_177_11_, | |
| user11_.person_doc_no as person_31_177_11_, | |
| user11_.person_ident_type as person_32_177_11_, | |
| user11_.phone_number as phone_n33_177_11_, | |
| user11_.phone_verification_code as phone_v34_177_11_, | |
| user11_.user_category as user_ca35_177_11_, | |
| user11_.user_type as user_ty36_177_11_, | |
| user11_.username as usernam37_177_11_, | |
| user11_.valid_from as valid_f38_177_11_, | |
| user11_.valid_to as valid_t39_177_11_, | |
| user11_.verification_code_expires_at as verific40_177_11_, | |
| service12_.id as id1_169_12_, | |
| service12_.created_at as created_2_169_12_, | |
| service12_.created_by_audit as created_3_169_12_, | |
| service12_.created_date as created_4_169_12_, | |
| service12_.last_modified_by as last_mod5_169_12_, | |
| service12_.last_modified_date as last_mod6_169_12_, | |
| service12_.state as state7_169_12_, | |
| service12_.updated_at as updated_8_169_12_, | |
| service12_.version as version9_169_12_, | |
| service12_.rra_reference_key as rra_ref10_169_12_, | |
| service12_.category as categor11_169_12_, | |
| service12_.description as descrip12_169_12_, | |
| service12_.name as name13_169_12_, | |
| service12_.path as path14_169_12_, | |
| service12_.section as section15_169_12_, | |
| service12_.verification_level as verific16_169_12_ | |
| from | |
| bur_business business0_ | |
| left outer join | |
| users user1_ | |
| on business0_.assigned_approver=user1_.id | |
| left outer join | |
| mtg_financial_institution financiali2_ | |
| on user1_.institution_id=financiali2_.id | |
| left outer join | |
| mtg_financial_institution_address financiali3_ | |
| on financiali2_.financial_institution_address=financiali3_.id | |
| left outer join | |
| stc_village village4_ | |
| on financiali3_.village_id=village4_.id | |
| left outer join | |
| stc_cell cell5_ | |
| on village4_.cell_id=cell5_.id | |
| left outer join | |
| stc_sector sector6_ | |
| on cell5_.sector_id=sector6_.id | |
| left outer join | |
| stc_district district7_ | |
| on sector6_.district_id=district7_.id | |
| left outer join | |
| stc_province province8_ | |
| on district7_.province_id=province8_.id | |
| left outer join | |
| user_role roles9_ | |
| on user1_.id=roles9_.user_id | |
| left outer join | |
| role role10_ | |
| on roles9_.role_id=role10_.id | |
| left outer join | |
| users user11_ | |
| on business0_.assigned_verifier=user11_.id | |
| left outer join | |
| stc_service service12_ | |
| on business0_.service_id=service12_.id | |
| where | |
| business0_.id=? | |
| Hibernate: | |
| select | |
| business0_.id as id1_46_0_, | |
| business0_.created_at as created_2_46_0_, | |
| business0_.created_by_audit as created_3_46_0_, | |
| business0_.created_date as created_4_46_0_, | |
| business0_.last_modified_by as last_mod5_46_0_, | |
| business0_.last_modified_date as last_mod6_46_0_, | |
| business0_.state as state7_46_0_, | |
| business0_.updated_at as updated_8_46_0_, | |
| business0_.version as version9_46_0_, | |
| business0_.rra_reference_key as rra_ref10_46_0_, | |
| business0_.abbreviation as abbrevi11_46_0_, | |
| business0_.application_reference_id as applica12_46_0_, | |
| business0_.application_status as applica13_46_0_, | |
| business0_.assigned_approver as assigne43_46_0_, | |
| business0_.assigned_verifier as assigne44_46_0_, | |
| business0_.branch_id as branch_14_46_0_, | |
| business0_.branch_name as branch_15_46_0_, | |
| business0_.certificate_no as certifi16_46_0_, | |
| business0_.company_category as company17_46_0_, | |
| business0_.company_id as company18_46_0_, | |
| business0_.company_name as company19_46_0_, | |
| business0_.company_type as company20_46_0_, | |
| business0_.country_of_tax_residence as country21_46_0_, | |
| business0_.created_by as created45_46_0_, | |
| business0_.enterprise_business_name as enterpr22_46_0_, | |
| business0_.enterprise_name as enterpr23_46_0_, | |
| business0_.has_articles_of_association as has_art24_46_0_, | |
| business0_.holding_company_name as holding25_46_0_, | |
| business0_.holding_company_residence_country as holding26_46_0_, | |
| business0_.is_foreign as is_fore27_46_0_, | |
| business0_.is_multinational as is_mult28_46_0_, | |
| business0_.is_other_currency_allowed as is_othe29_46_0_, | |
| business0_.is_vat_registered as is_vat_30_46_0_, | |
| business0_.issuance_date as issuanc31_46_0_, | |
| business0_.issuance_place as issuanc32_46_0_, | |
| business0_.migrated as migrate33_46_0_, | |
| business0_.parent_company_name as parent_34_46_0_, | |
| business0_.parent_company_residence_country as parent_35_46_0_, | |
| business0_.position as positio36_46_0_, | |
| business0_.registration_no as registr37_46_0_, | |
| business0_.reservation_id as reserva38_46_0_, | |
| business0_.rra_tax_account_status as rra_tax39_46_0_, | |
| business0_.service_id as service46_46_0_, | |
| business0_.tin as tin40_46_0_, | |
| business0_.valid_from as valid_f41_46_0_, | |
| business0_.valid_to as valid_t42_46_0_, | |
| user1_.id as id1_177_1_, | |
| user1_.created_at as created_2_177_1_, | |
| user1_.created_by_audit as created_3_177_1_, | |
| user1_.created_date as created_4_177_1_, | |
| user1_.last_modified_by as last_mod5_177_1_, | |
| user1_.last_modified_date as last_mod6_177_1_, | |
| user1_.state as state7_177_1_, | |
| user1_.updated_at as updated_8_177_1_, | |
| user1_.version as version9_177_1_, | |
| user1_.rra_reference_key as rra_ref10_177_1_, | |
| user1_.created_by as created41_177_1_, | |
| user1_.date_of_birth as date_of11_177_1_, | |
| user1_.department as departm12_177_1_, | |
| user1_.email as email13_177_1_, | |
| user1_.email_verification_code as email_v14_177_1_, | |
| user1_.failed_login_attempts as failed_15_177_1_, | |
| user1_.institution_id as institu42_177_1_, | |
| user1_.first_name as first_n16_177_1_, | |
| user1_.gender as gender17_177_1_, | |
| user1_.is_email_verified as is_emai18_177_1_, | |
| user1_.is_from_nida as is_from19_177_1_, | |
| user1_.is_locked as is_lock20_177_1_, | |
| user1_.is_phone_number_verified as is_phon21_177_1_, | |
| user1_.last_name as last_na22_177_1_, | |
| user1_.nationality as nationa23_177_1_, | |
| user1_.notification_preference as notific24_177_1_, | |
| user1_.password as passwor25_177_1_, | |
| user1_.password_reset_code as passwor26_177_1_, | |
| user1_.password_reset_code_expires_at as passwor27_177_1_, | |
| user1_.person_doc_expiry_date as person_28_177_1_, | |
| user1_.person_doc_issue_date as person_29_177_1_, | |
| user1_.person_doc_issue_place as person_30_177_1_, | |
| user1_.person_doc_no as person_31_177_1_, | |
| user1_.person_ident_type as person_32_177_1_, | |
| user1_.phone_number as phone_n33_177_1_, | |
| user1_.phone_verification_code as phone_v34_177_1_, | |
| user1_.user_category as user_ca35_177_1_, | |
| user1_.user_type as user_ty36_177_1_, | |
| user1_.username as usernam37_177_1_, | |
| user1_.valid_from as valid_f38_177_1_, | |
| user1_.valid_to as valid_t39_177_1_, | |
| user1_.verification_code_expires_at as verific40_177_1_, | |
| financiali2_.id as id1_146_2_, | |
| financiali2_.created_at as created_2_146_2_, | |
| financiali2_.created_by_audit as created_3_146_2_, | |
| financiali2_.created_date as created_4_146_2_, | |
| financiali2_.last_modified_by as last_mod5_146_2_, | |
| financiali2_.last_modified_date as last_mod6_146_2_, | |
| financiali2_.state as state7_146_2_, | |
| financiali2_.updated_at as updated_8_146_2_, | |
| financiali2_.version as version9_146_2_, | |
| financiali2_.rra_reference_key as rra_ref10_146_2_, | |
| financiali2_.financial_institution_address as financi15_146_2_, | |
| financiali2_.institution_type as institu11_146_2_, | |
| financiali2_.name as name12_146_2_, | |
| financiali2_.registration_number as registr13_146_2_, | |
| financiali2_.status as status14_146_2_, | |
| financiali3_.id as id1_147_3_, | |
| financiali3_.created_at as created_2_147_3_, | |
| financiali3_.created_by_audit as created_3_147_3_, | |
| financiali3_.created_date as created_4_147_3_, | |
| financiali3_.last_modified_by as last_mod5_147_3_, | |
| financiali3_.last_modified_date as last_mod6_147_3_, | |
| financiali3_.state as state7_147_3_, | |
| financiali3_.updated_at as updated_8_147_3_, | |
| financiali3_.version as version9_147_3_, | |
| financiali3_.rra_reference_key as rra_ref10_147_3_, | |
| financiali3_.address_str as address11_147_3_, | |
| financiali3_.city as city12_147_3_, | |
| financiali3_.country_of_incorporation as country13_147_3_, | |
| financiali3_.email as email14_147_3_, | |
| financiali3_.financial_institution as financi20_147_3_, | |
| financiali3_.is_email_verified as is_emai15_147_3_, | |
| financiali3_.is_phone_verified as is_phon16_147_3_, | |
| financiali3_.phone_number as phone_n17_147_3_, | |
| financiali3_.street_name as street_18_147_3_, | |
| financiali3_.village_id as village21_147_3_, | |
| financiali3_.zip_code as zip_cod19_147_3_, | |
| village4_.id as id1_171_4_, | |
| village4_.name as name2_171_4_, | |
| village4_.category as category3_171_4_, | |
| village4_.cell_id as cell_id4_171_4_, | |
| cell5_.id as id1_163_5_, | |
| cell5_.name as name2_163_5_, | |
| cell5_.sector_id as sector_i3_163_5_, | |
| sector6_.id as id1_168_6_, | |
| sector6_.name as name2_168_6_, | |
| sector6_.district_id as district3_168_6_, | |
| district7_.id as id1_165_7_, | |
| district7_.name as name2_165_7_, | |
| district7_.province_id as province3_165_7_, | |
| province8_.id as id1_167_8_, | |
| province8_.name as name2_167_8_, | |
| roles9_.user_id as user_id1_175_9_, | |
| role10_.id as role_id2_175_9_, | |
| role10_.id as id1_160_10_, | |
| role10_.created_at as created_2_160_10_, | |
| role10_.created_by_audit as created_3_160_10_, | |
| role10_.created_date as created_4_160_10_, | |
| role10_.last_modified_by as last_mod5_160_10_, | |
| role10_.last_modified_date as last_mod6_160_10_, | |
| role10_.state as state7_160_10_, | |
| role10_.updated_at as updated_8_160_10_, | |
| role10_.version as version9_160_10_, | |
| role10_.department as departm10_160_10_, | |
| role10_.description as descrip11_160_10_, | |
| role10_.role_name as role_na12_160_10_, | |
| user11_.id as id1_177_11_, | |
| user11_.created_at as created_2_177_11_, | |
| user11_.created_by_audit as created_3_177_11_, | |
| user11_.created_date as created_4_177_11_, | |
| user11_.last_modified_by as last_mod5_177_11_, | |
| user11_.last_modified_date as last_mod6_177_11_, | |
| user11_.state as state7_177_11_, | |
| user11_.updated_at as updated_8_177_11_, | |
| user11_.version as version9_177_11_, | |
| user11_.rra_reference_key as rra_ref10_177_11_, | |
| user11_.created_by as created41_177_11_, | |
| user11_.date_of_birth as date_of11_177_11_, | |
| user11_.department as departm12_177_11_, | |
| user11_.email as email13_177_11_, | |
| user11_.email_verification_code as email_v14_177_11_, | |
| user11_.failed_login_attempts as failed_15_177_11_, | |
| user11_.institution_id as institu42_177_11_, | |
| user11_.first_name as first_n16_177_11_, | |
| user11_.gender as gender17_177_11_, | |
| user11_.is_email_verified as is_emai18_177_11_, | |
| user11_.is_from_nida as is_from19_177_11_, | |
| user11_.is_locked as is_lock20_177_11_, | |
| user11_.is_phone_number_verified as is_phon21_177_11_, | |
| user11_.last_name as last_na22_177_11_, | |
| user11_.nationality as nationa23_177_11_, | |
| user11_.notification_preference as notific24_177_11_, | |
| user11_.password as passwor25_177_11_, | |
| user11_.password_reset_code as passwor26_177_11_, | |
| user11_.password_reset_code_expires_at as passwor27_177_11_, | |
| user11_.person_doc_expiry_date as person_28_177_11_, | |
| user11_.person_doc_issue_date as person_29_177_11_, | |
| user11_.person_doc_issue_place as person_30_177_11_, | |
| user11_.person_doc_no as person_31_177_11_, | |
| user11_.person_ident_type as person_32_177_11_, | |
| user11_.phone_number as phone_n33_177_11_, | |
| user11_.phone_verification_code as phone_v34_177_11_, | |
| user11_.user_category as user_ca35_177_11_, | |
| user11_.user_type as user_ty36_177_11_, | |
| user11_.username as usernam37_177_11_, | |
| user11_.valid_from as valid_f38_177_11_, | |
| user11_.valid_to as valid_t39_177_11_, | |
| user11_.verification_code_expires_at as verific40_177_11_, | |
| service12_.id as id1_169_12_, | |
| service12_.created_at as created_2_169_12_, | |
| service12_.created_by_audit as created_3_169_12_, | |
| service12_.created_date as created_4_169_12_, | |
| service12_.last_modified_by as last_mod5_169_12_, | |
| service12_.last_modified_date as last_mod6_169_12_, | |
| service12_.state as state7_169_12_, | |
| service12_.updated_at as updated_8_169_12_, | |
| service12_.version as version9_169_12_, | |
| service12_.rra_reference_key as rra_ref10_169_12_, | |
| service12_.category as categor11_169_12_, | |
| service12_.description as descrip12_169_12_, | |
| service12_.name as name13_169_12_, | |
| service12_.path as path14_169_12_, | |
| service12_.section as section15_169_12_, | |
| service12_.verification_level as verific16_169_12_ | |
| from | |
| bur_business business0_ | |
| left outer join | |
| users user1_ | |
| on business0_.assigned_approver=user1_.id | |
| left outer join | |
| mtg_financial_institution financiali2_ | |
| on user1_.institution_id=financiali2_.id | |
| left outer join | |
| mtg_financial_institution_address financiali3_ | |
| on financiali2_.financial_institution_address=financiali3_.id | |
| left outer join | |
| stc_village village4_ | |
| on financiali3_.village_id=village4_.id | |
| left outer join | |
| stc_cell cell5_ | |
| on village4_.cell_id=cell5_.id | |
| left outer join | |
| stc_sector sector6_ | |
| on cell5_.sector_id=sector6_.id | |
| left outer join | |
| stc_district district7_ | |
| on sector6_.district_id=district7_.id | |
| left outer join | |
| stc_province province8_ | |
| on district7_.province_id=province8_.id | |
| left outer join | |
| user_role roles9_ | |
| on user1_.id=roles9_.user_id | |
| left outer join | |
| role role10_ | |
| on roles9_.role_id=role10_.id | |
| left outer join | |
| users user11_ | |
| on business0_.assigned_verifier=user11_.id | |
| left outer join | |
| stc_service service12_ | |
| on business0_.service_id=service12_.id | |
| where | |
| business0_.id=? | |
| 2025-04-14 15:20:28.766 TRACE 536 --- [nio-8051-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [05557d90-e15b-4cb9-8300-b0953bb5e7db] | |
| 2025-04-14 15:20:28.766 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [05557d90-e15b-4cb9-8300-b0953bb5e7db] | |
| 2025-04-14 15:20:28.805 DEBUG 536 --- [nio-8051-exec-2] org.hibernate.SQL : | |
| select | |
| business0_.id as col_0_0_, | |
| business0_.company_name as col_1_0_, | |
| business0_.branch_name as col_2_0_, | |
| business0_.enterprise_business_name as col_3_0_, | |
| business0_.enterprise_name as col_4_0_, | |
| business0_.position as col_5_0_, | |
| business0_.has_articles_of_association as col_6_0_, | |
| business0_.is_foreign as col_7_0_, | |
| business0_.company_category as col_8_0_, | |
| business0_.company_type as col_9_0_, | |
| business0_.application_status as col_10_0_, | |
| business0_.service_id as col_11_0_, | |
| business0_.created_at as col_12_0_, | |
| business0_.updated_at as col_13_0_, | |
| business0_.reservation_id as col_14_0_, | |
| business0_.abbreviation as col_15_0_, | |
| business0_.is_other_currency_allowed as col_16_0_, | |
| business0_.tin as col_17_0_, | |
| business0_.application_reference_id as col_18_0_, | |
| business0_.issuance_date as col_19_0_ | |
| from | |
| bur_business business0_ | |
| inner join | |
| stc_service service1_ | |
| on business0_.service_id=service1_.id | |
| where | |
| business0_.id=? | |
| Hibernate: | |
| select | |
| business0_.id as col_0_0_, | |
| business0_.company_name as col_1_0_, | |
| business0_.branch_name as col_2_0_, | |
| business0_.enterprise_business_name as col_3_0_, | |
| business0_.enterprise_name as col_4_0_, | |
| business0_.position as col_5_0_, | |
| business0_.has_articles_of_association as col_6_0_, | |
| business0_.is_foreign as col_7_0_, | |
| business0_.company_category as col_8_0_, | |
| business0_.company_type as col_9_0_, | |
| business0_.application_status as col_10_0_, | |
| business0_.service_id as col_11_0_, | |
| business0_.created_at as col_12_0_, | |
| business0_.updated_at as col_13_0_, | |
| business0_.reservation_id as col_14_0_, | |
| business0_.abbreviation as col_15_0_, | |
| business0_.is_other_currency_allowed as col_16_0_, | |
| business0_.tin as col_17_0_, | |
| business0_.application_reference_id as col_18_0_, | |
| business0_.issuance_date as col_19_0_ | |
| from | |
| bur_business business0_ | |
| inner join | |
| stc_service service1_ | |
| on business0_.service_id=service1_.id | |
| where | |
| business0_.id=? | |
| 2025-04-14 15:20:28.805 TRACE 536 --- [nio-8051-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [05557d90-e15b-4cb9-8300-b0953bb5e7db] | |
| 2025-04-14 15:20:28.807 DEBUG 536 --- [nio-8051-exec-1] org.hibernate.SQL : | |
| select | |
| user0_.id as id1_177_0_, | |
| user0_.created_at as created_2_177_0_, | |
| user0_.created_by_audit as created_3_177_0_, | |
| user0_.created_date as created_4_177_0_, | |
| user0_.last_modified_by as last_mod5_177_0_, | |
| user0_.last_modified_date as last_mod6_177_0_, | |
| user0_.state as state7_177_0_, | |
| user0_.updated_at as updated_8_177_0_, | |
| user0_.version as version9_177_0_, | |
| user0_.rra_reference_key as rra_ref10_177_0_, | |
| user0_.created_by as created41_177_0_, | |
| user0_.date_of_birth as date_of11_177_0_, | |
| user0_.department as departm12_177_0_, | |
| user0_.email as email13_177_0_, | |
| user0_.email_verification_code as email_v14_177_0_, | |
| user0_.failed_login_attempts as failed_15_177_0_, | |
| user0_.institution_id as institu42_177_0_, | |
| user0_.first_name as first_n16_177_0_, | |
| user0_.gender as gender17_177_0_, | |
| user0_.is_email_verified as is_emai18_177_0_, | |
| user0_.is_from_nida as is_from19_177_0_, | |
| user0_.is_locked as is_lock20_177_0_, | |
| user0_.is_phone_number_verified as is_phon21_177_0_, | |
| user0_.last_name as last_na22_177_0_, | |
| user0_.nationality as nationa23_177_0_, | |
| user0_.notification_preference as notific24_177_0_, | |
| user0_.password as passwor25_177_0_, | |
| user0_.password_reset_code as passwor26_177_0_, | |
| user0_.password_reset_code_expires_at as passwor27_177_0_, | |
| user0_.person_doc_expiry_date as person_28_177_0_, | |
| user0_.person_doc_issue_date as person_29_177_0_, | |
| user0_.person_doc_issue_place as person_30_177_0_, | |
| user0_.person_doc_no as person_31_177_0_, | |
| user0_.person_ident_type as person_32_177_0_, | |
| user0_.phone_number as phone_n33_177_0_, | |
| user0_.phone_verification_code as phone_v34_177_0_, | |
| user0_.user_category as user_ca35_177_0_, | |
| user0_.user_type as user_ty36_177_0_, | |
| user0_.username as usernam37_177_0_, | |
| user0_.valid_from as valid_f38_177_0_, | |
| user0_.valid_to as valid_t39_177_0_, | |
| user0_.verification_code_expires_at as verific40_177_0_, | |
| financiali1_.id as id1_146_1_, | |
| financiali1_.created_at as created_2_146_1_, | |
| financiali1_.created_by_audit as created_3_146_1_, | |
| financiali1_.created_date as created_4_146_1_, | |
| financiali1_.last_modified_by as last_mod5_146_1_, | |
| financiali1_.last_modified_date as last_mod6_146_1_, | |
| financiali1_.state as state7_146_1_, | |
| financiali1_.updated_at as updated_8_146_1_, | |
| financiali1_.version as version9_146_1_, | |
| financiali1_.rra_reference_key as rra_ref10_146_1_, | |
| financiali1_.financial_institution_address as financi15_146_1_, | |
| financiali1_.institution_type as institu11_146_1_, | |
| financiali1_.name as name12_146_1_, | |
| financiali1_.registration_number as registr13_146_1_, | |
| financiali1_.status as status14_146_1_, | |
| financiali2_.id as id1_147_2_, | |
| financiali2_.created_at as created_2_147_2_, | |
| financiali2_.created_by_audit as created_3_147_2_, | |
| financiali2_.created_date as created_4_147_2_, | |
| financiali2_.last_modified_by as last_mod5_147_2_, | |
| financiali2_.last_modified_date as last_mod6_147_2_, | |
| financiali2_.state as state7_147_2_, | |
| financiali2_.updated_at as updated_8_147_2_, | |
| financiali2_.version as version9_147_2_, | |
| financiali2_.rra_reference_key as rra_ref10_147_2_, | |
| financiali2_.address_str as address11_147_2_, | |
| financiali2_.city as city12_147_2_, | |
| financiali2_.country_of_incorporation as country13_147_2_, | |
| financiali2_.email as email14_147_2_, | |
| financiali2_.financial_institution as financi20_147_2_, | |
| financiali2_.is_email_verified as is_emai15_147_2_, | |
| financiali2_.is_phone_verified as is_phon16_147_2_, | |
| financiali2_.phone_number as phone_n17_147_2_, | |
| financiali2_.street_name as street_18_147_2_, | |
| financiali2_.village_id as village21_147_2_, | |
| financiali2_.zip_code as zip_cod19_147_2_, | |
| village3_.id as id1_171_3_, | |
| village3_.name as name2_171_3_, | |
| village3_.category as category3_171_3_, | |
| village3_.cell_id as cell_id4_171_3_, | |
| cell4_.id as id1_163_4_, | |
| cell4_.name as name2_163_4_, | |
| cell4_.sector_id as sector_i3_163_4_, | |
| sector5_.id as id1_168_5_, | |
| sector5_.name as name2_168_5_, | |
| sector5_.district_id as district3_168_5_, | |
| district6_.id as id1_165_6_, | |
| district6_.name as name2_165_6_, | |
| district6_.province_id as province3_165_6_, | |
| province7_.id as id1_167_7_, | |
| province7_.name as name2_167_7_, | |
| roles8_.user_id as user_id1_175_8_, | |
| role9_.id as role_id2_175_8_, | |
| role9_.id as id1_160_9_, | |
| role9_.created_at as created_2_160_9_, | |
| role9_.created_by_audit as created_3_160_9_, | |
| role9_.created_date as created_4_160_9_, | |
| role9_.last_modified_by as last_mod5_160_9_, | |
| role9_.last_modified_date as last_mod6_160_9_, | |
| role9_.state as state7_160_9_, | |
| role9_.updated_at as updated_8_160_9_, | |
| role9_.version as version9_160_9_, | |
| role9_.department as departm10_160_9_, | |
| role9_.description as descrip11_160_9_, | |
| role9_.role_name as role_na12_160_9_ | |
| from | |
| users user0_ | |
| left outer join | |
| mtg_financial_institution financiali1_ | |
| on user0_.institution_id=financiali1_.id | |
| left outer join | |
| mtg_financial_institution_address financiali2_ | |
| on financiali1_.financial_institution_address=financiali2_.id | |
| left outer join | |
| stc_village village3_ | |
| on financiali2_.village_id=village3_.id | |
| left outer join | |
| stc_cell cell4_ | |
| on village3_.cell_id=cell4_.id | |
| left outer join | |
| stc_sector sector5_ | |
| on cell4_.sector_id=sector5_.id | |
| left outer join | |
| stc_district district6_ | |
| on sector5_.district_id=district6_.id | |
| left outer join | |
| stc_province province7_ | |
| on district6_.province_id=province7_.id | |
| left outer join | |
| user_role roles8_ | |
| on user0_.id=roles8_.user_id | |
| left outer join | |
| role role9_ | |
| on roles8_.role_id=role9_.id | |
| where | |
| user0_.id=? | |
| Hibernate: | |
| select | |
| user0_.id as id1_177_0_, | |
| user0_.created_at as created_2_177_0_, | |
| user0_.created_by_audit as created_3_177_0_, | |
| user0_.created_date as created_4_177_0_, | |
| user0_.last_modified_by as last_mod5_177_0_, | |
| user0_.last_modified_date as last_mod6_177_0_, | |
| user0_.state as state7_177_0_, | |
| user0_.updated_at as updated_8_177_0_, | |
| user0_.version as version9_177_0_, | |
| user0_.rra_reference_key as rra_ref10_177_0_, | |
| user0_.created_by as created41_177_0_, | |
| user0_.date_of_birth as date_of11_177_0_, | |
| user0_.department as departm12_177_0_, | |
| user0_.email as email13_177_0_, | |
| user0_.email_verification_code as email_v14_177_0_, | |
| user0_.failed_login_attempts as failed_15_177_0_, | |
| user0_.institution_id as institu42_177_0_, | |
| user0_.first_name as first_n16_177_0_, | |
| user0_.gender as gender17_177_0_, | |
| user0_.is_email_verified as is_emai18_177_0_, | |
| user0_.is_from_nida as is_from19_177_0_, | |
| user0_.is_locked as is_lock20_177_0_, | |
| user0_.is_phone_number_verified as is_phon21_177_0_, | |
| user0_.last_name as last_na22_177_0_, | |
| user0_.nationality as nationa23_177_0_, | |
| user0_.notification_preference as notific24_177_0_, | |
| user0_.password as passwor25_177_0_, | |
| user0_.password_reset_code as passwor26_177_0_, | |
| user0_.password_reset_code_expires_at as passwor27_177_0_, | |
| user0_.person_doc_expiry_date as person_28_177_0_, | |
| user0_.person_doc_issue_date as person_29_177_0_, | |
| user0_.person_doc_issue_place as person_30_177_0_, | |
| user0_.person_doc_no as person_31_177_0_, | |
| user0_.person_ident_type as person_32_177_0_, | |
| user0_.phone_number as phone_n33_177_0_, | |
| user0_.phone_verification_code as phone_v34_177_0_, | |
| user0_.user_category as user_ca35_177_0_, | |
| user0_.user_type as user_ty36_177_0_, | |
| user0_.username as usernam37_177_0_, | |
| user0_.valid_from as valid_f38_177_0_, | |
| user0_.valid_to as valid_t39_177_0_, | |
| user0_.verification_code_expires_at as verific40_177_0_, | |
| financiali1_.id as id1_146_1_, | |
| financiali1_.created_at as created_2_146_1_, | |
| financiali1_.created_by_audit as created_3_146_1_, | |
| financiali1_.created_date as created_4_146_1_, | |
| financiali1_.last_modified_by as last_mod5_146_1_, | |
| financiali1_.last_modified_date as last_mod6_146_1_, | |
| financiali1_.state as state7_146_1_, | |
| financiali1_.updated_at as updated_8_146_1_, | |
| financiali1_.version as version9_146_1_, | |
| financiali1_.rra_reference_key as rra_ref10_146_1_, | |
| financiali1_.financial_institution_address as financi15_146_1_, | |
| financiali1_.institution_type as institu11_146_1_, | |
| financiali1_.name as name12_146_1_, | |
| financiali1_.registration_number as registr13_146_1_, | |
| financiali1_.status as status14_146_1_, | |
| financiali2_.id as id1_147_2_, | |
| financiali2_.created_at as created_2_147_2_, | |
| financiali2_.created_by_audit as created_3_147_2_, | |
| financiali2_.created_date as created_4_147_2_, | |
| financiali2_.last_modified_by as last_mod5_147_2_, | |
| financiali2_.last_modified_date as last_mod6_147_2_, | |
| financiali2_.state as state7_147_2_, | |
| financiali2_.updated_at as updated_8_147_2_, | |
| financiali2_.version as version9_147_2_, | |
| financiali2_.rra_reference_key as rra_ref10_147_2_, | |
| financiali2_.address_str as address11_147_2_, | |
| financiali2_.city as city12_147_2_, | |
| financiali2_.country_of_incorporation as country13_147_2_, | |
| financiali2_.email as email14_147_2_, | |
| financiali2_.financial_institution as financi20_147_2_, | |
| financiali2_.is_email_verified as is_emai15_147_2_, | |
| financiali2_.is_phone_verified as is_phon16_147_2_, | |
| financiali2_.phone_number as phone_n17_147_2_, | |
| financiali2_.street_name as street_18_147_2_, | |
| financiali2_.village_id as village21_147_2_, | |
| financiali2_.zip_code as zip_cod19_147_2_, | |
| village3_.id as id1_171_3_, | |
| village3_.name as name2_171_3_, | |
| village3_.category as category3_171_3_, | |
| village3_.cell_id as cell_id4_171_3_, | |
| cell4_.id as id1_163_4_, | |
| cell4_.name as name2_163_4_, | |
| cell4_.sector_id as sector_i3_163_4_, | |
| sector5_.id as id1_168_5_, | |
| sector5_.name as name2_168_5_, | |
| sector5_.district_id as district3_168_5_, | |
| district6_.id as id1_165_6_, | |
| district6_.name as name2_165_6_, | |
| district6_.province_id as province3_165_6_, | |
| province7_.id as id1_167_7_, | |
| province7_.name as name2_167_7_, | |
| roles8_.user_id as user_id1_175_8_, | |
| role9_.id as role_id2_175_8_, | |
| role9_.id as id1_160_9_, | |
| role9_.created_at as created_2_160_9_, | |
| role9_.created_by_audit as created_3_160_9_, | |
| role9_.created_date as created_4_160_9_, | |
| role9_.last_modified_by as last_mod5_160_9_, | |
| role9_.last_modified_date as last_mod6_160_9_, | |
| role9_.state as state7_160_9_, | |
| role9_.updated_at as updated_8_160_9_, | |
| role9_.version as version9_160_9_, | |
| role9_.department as departm10_160_9_, | |
| role9_.description as descrip11_160_9_, | |
| role9_.role_name as role_na12_160_9_ | |
| from | |
| users user0_ | |
| left outer join | |
| mtg_financial_institution financiali1_ | |
| on user0_.institution_id=financiali1_.id | |
| left outer join | |
| mtg_financial_institution_address financiali2_ | |
| on financiali1_.financial_institution_address=financiali2_.id | |
| left outer join | |
| stc_village village3_ | |
| on financiali2_.village_id=village3_.id | |
| left outer join | |
| stc_cell cell4_ | |
| on village3_.cell_id=cell4_.id | |
| left outer join | |
| stc_sector sector5_ | |
| on cell4_.sector_id=sector5_.id | |
| left outer join | |
| stc_district district6_ | |
| on sector5_.district_id=district6_.id | |
| left outer join | |
| stc_province province7_ | |
| on district6_.province_id=province7_.id | |
| left outer join | |
| user_role roles8_ | |
| on user0_.id=roles8_.user_id | |
| left outer join | |
| role role9_ | |
| on roles8_.role_id=role9_.id | |
| where | |
| user0_.id=? | |
| 2025-04-14 15:20:28.808 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [fb8ac724-821b-4c7f-a4b6-d8ddd8cfb396] | |
| 2025-04-14 15:20:28.825 DEBUG 536 --- [nio-8051-exec-2] org.hibernate.SQL : | |
| select | |
| businesste0_.id as id1_57_, | |
| businesste0_.created_at as created_2_57_, | |
| businesste0_.created_by_audit as created_3_57_, | |
| businesste0_.created_date as created_4_57_, | |
| businesste0_.last_modified_by as last_mod5_57_, | |
| businesste0_.last_modified_date as last_mod6_57_, | |
| businesste0_.state as state7_57_, | |
| businesste0_.updated_at as updated_8_57_, | |
| businesste0_.version as version9_57_, | |
| businesste0_.abbreviation as abbrevi10_57_, | |
| businesste0_.application_reference_id as applica11_57_, | |
| businesste0_.application_status as applica12_57_, | |
| businesste0_.branch_id as branch_13_57_, | |
| businesste0_.branch_name as branch_14_57_, | |
| businesste0_.certificate_no as certifi15_57_, | |
| businesste0_.company_category as company16_57_, | |
| businesste0_.company_id as company17_57_, | |
| businesste0_.company_name as company18_57_, | |
| businesste0_.company_type as company19_57_, | |
| businesste0_.country_of_tax_residence as country20_57_, | |
| businesste0_.enterprise_business_name as enterpr21_57_, | |
| businesste0_.enterprise_name as enterpr22_57_, | |
| businesste0_.entity_id as entity_23_57_, | |
| businesste0_.has_articles_of_association as has_art24_57_, | |
| businesste0_.holding_company_name as holding25_57_, | |
| businesste0_.holding_company_residence_country as holding26_57_, | |
| businesste0_.is_foreign as is_fore27_57_, | |
| businesste0_.is_other_currency_allowed as is_othe28_57_, | |
| businesste0_.issuance_date as issuanc29_57_, | |
| businesste0_.issuance_place as issuanc30_57_, | |
| businesste0_.parent_company_name as parent_31_57_, | |
| businesste0_.parent_company_residence_country as parent_32_57_, | |
| businesste0_.position as positio33_57_, | |
| businesste0_.registration_no as registr34_57_, | |
| businesste0_.reservation_id as reserva35_57_, | |
| businesste0_.tin as tin36_57_, | |
| businesste0_.valid_from as valid_f37_57_, | |
| businesste0_.valid_to as valid_t38_57_ | |
| from | |
| bur_business_temp businesste0_ | |
| where | |
| businesste0_.entity_id=? | |
| Hibernate: | |
| select | |
| businesste0_.id as id1_57_, | |
| businesste0_.created_at as created_2_57_, | |
| businesste0_.created_by_audit as created_3_57_, | |
| businesste0_.created_date as created_4_57_, | |
| businesste0_.last_modified_by as last_mod5_57_, | |
| businesste0_.last_modified_date as last_mod6_57_, | |
| businesste0_.state as state7_57_, | |
| businesste0_.updated_at as updated_8_57_, | |
| businesste0_.version as version9_57_, | |
| businesste0_.abbreviation as abbrevi10_57_, | |
| businesste0_.application_reference_id as applica11_57_, | |
| businesste0_.application_status as applica12_57_, | |
| businesste0_.branch_id as branch_13_57_, | |
| businesste0_.branch_name as branch_14_57_, | |
| businesste0_.certificate_no as certifi15_57_, | |
| businesste0_.company_category as company16_57_, | |
| businesste0_.company_id as company17_57_, | |
| businesste0_.company_name as company18_57_, | |
| businesste0_.company_type as company19_57_, | |
| businesste0_.country_of_tax_residence as country20_57_, | |
| businesste0_.enterprise_business_name as enterpr21_57_, | |
| businesste0_.enterprise_name as enterpr22_57_, | |
| businesste0_.entity_id as entity_23_57_, | |
| businesste0_.has_articles_of_association as has_art24_57_, | |
| businesste0_.holding_company_name as holding25_57_, | |
| businesste0_.holding_company_residence_country as holding26_57_, | |
| businesste0_.is_foreign as is_fore27_57_, | |
| businesste0_.is_other_currency_allowed as is_othe28_57_, | |
| businesste0_.issuance_date as issuanc29_57_, | |
| businesste0_.issuance_place as issuanc30_57_, | |
| businesste0_.parent_company_name as parent_31_57_, | |
| businesste0_.parent_company_residence_country as parent_32_57_, | |
| businesste0_.position as positio33_57_, | |
| businesste0_.registration_no as registr34_57_, | |
| businesste0_.reservation_id as reserva35_57_, | |
| businesste0_.tin as tin36_57_, | |
| businesste0_.valid_from as valid_f37_57_, | |
| businesste0_.valid_to as valid_t38_57_ | |
| from | |
| bur_business_temp businesste0_ | |
| where | |
| businesste0_.entity_id=? | |
| 2025-04-14 15:20:28.825 TRACE 536 --- [nio-8051-exec-2] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [05557d90-e15b-4cb9-8300-b0953bb5e7db] | |
| 2025-04-14 15:20:28.841 DEBUG 536 --- [nio-8051-exec-1] org.hibernate.SQL : | |
| select | |
| annualretu0_.id as id1_10_, | |
| annualretu0_.created_at as created_2_10_, | |
| annualretu0_.created_by_audit as created_3_10_, | |
| annualretu0_.created_date as created_4_10_, | |
| annualretu0_.last_modified_by as last_mod5_10_, | |
| annualretu0_.last_modified_date as last_mod6_10_, | |
| annualretu0_.state as state7_10_, | |
| annualretu0_.updated_at as updated_8_10_, | |
| annualretu0_.version as version9_10_, | |
| annualretu0_.rra_reference_key as rra_ref10_10_, | |
| annualretu0_.annual_meeting_date as annual_11_10_, | |
| annualretu0_.application_reference_id as applica12_10_, | |
| annualretu0_.assigned_approver as assigne18_10_, | |
| annualretu0_.assigned_verifier as assigne19_10_, | |
| annualretu0_.business_id as busines20_10_, | |
| annualretu0_.created_by as created21_10_, | |
| annualretu0_.filing_date as filing_13_10_, | |
| annualretu0_.filing_status as filing_14_10_, | |
| annualretu0_.filing_fiscal_year as filing_15_10_, | |
| annualretu0_.good_standing_id as good_st22_10_, | |
| annualretu0_.revised_annual_return_id as revised16_10_, | |
| annualretu0_.type as type17_10_ | |
| from | |
| ar_annual_return annualretu0_ | |
| where | |
| annualretu0_.created_by=? | |
| and ( | |
| annualretu0_.filing_status in ( | |
| ? , ? , ? , ? , ? , ? , ? | |
| ) | |
| ) | |
| and annualretu0_.business_id=? limit ? | |
| Hibernate: | |
| select | |
| annualretu0_.id as id1_10_, | |
| annualretu0_.created_at as created_2_10_, | |
| annualretu0_.created_by_audit as created_3_10_, | |
| annualretu0_.created_date as created_4_10_, | |
| annualretu0_.last_modified_by as last_mod5_10_, | |
| annualretu0_.last_modified_date as last_mod6_10_, | |
| annualretu0_.state as state7_10_, | |
| annualretu0_.updated_at as updated_8_10_, | |
| annualretu0_.version as version9_10_, | |
| annualretu0_.rra_reference_key as rra_ref10_10_, | |
| annualretu0_.annual_meeting_date as annual_11_10_, | |
| annualretu0_.application_reference_id as applica12_10_, | |
| annualretu0_.assigned_approver as assigne18_10_, | |
| annualretu0_.assigned_verifier as assigne19_10_, | |
| annualretu0_.business_id as busines20_10_, | |
| annualretu0_.created_by as created21_10_, | |
| annualretu0_.filing_date as filing_13_10_, | |
| annualretu0_.filing_status as filing_14_10_, | |
| annualretu0_.filing_fiscal_year as filing_15_10_, | |
| annualretu0_.good_standing_id as good_st22_10_, | |
| annualretu0_.revised_annual_return_id as revised16_10_, | |
| annualretu0_.type as type17_10_ | |
| from | |
| ar_annual_return annualretu0_ | |
| where | |
| annualretu0_.created_by=? | |
| and ( | |
| annualretu0_.filing_status in ( | |
| ? , ? , ? , ? , ? , ? , ? | |
| ) | |
| ) | |
| and annualretu0_.business_id=? limit ? | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [fb8ac724-821b-4c7f-a4b6-d8ddd8cfb396] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [2] as [VARCHAR] - [ACTIVE] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [3] as [VARCHAR] - [IN_PROGRESS] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [4] as [VARCHAR] - [ACTION_REQUIRED] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [5] as [VARCHAR] - [REJECTED] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [6] as [VARCHAR] - [SUBMITTED] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [7] as [VARCHAR] - [RESUBMITTED] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [8] as [VARCHAR] - [REVIEWED] | |
| 2025-04-14 15:20:28.842 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [9] as [OTHER] - [05557d90-e15b-4cb9-8300-b0953bb5e7db] | |
| 2025-04-14 15:20:28.851 DEBUG 536 --- [nio-8051-exec-1] org.hibernate.SQL : | |
| select | |
| user0_.id as id1_177_0_, | |
| user0_.created_at as created_2_177_0_, | |
| user0_.created_by_audit as created_3_177_0_, | |
| user0_.created_date as created_4_177_0_, | |
| user0_.last_modified_by as last_mod5_177_0_, | |
| user0_.last_modified_date as last_mod6_177_0_, | |
| user0_.state as state7_177_0_, | |
| user0_.updated_at as updated_8_177_0_, | |
| user0_.version as version9_177_0_, | |
| user0_.rra_reference_key as rra_ref10_177_0_, | |
| user0_.created_by as created41_177_0_, | |
| user0_.date_of_birth as date_of11_177_0_, | |
| user0_.department as departm12_177_0_, | |
| user0_.email as email13_177_0_, | |
| user0_.email_verification_code as email_v14_177_0_, | |
| user0_.failed_login_attempts as failed_15_177_0_, | |
| user0_.institution_id as institu42_177_0_, | |
| user0_.first_name as first_n16_177_0_, | |
| user0_.gender as gender17_177_0_, | |
| user0_.is_email_verified as is_emai18_177_0_, | |
| user0_.is_from_nida as is_from19_177_0_, | |
| user0_.is_locked as is_lock20_177_0_, | |
| user0_.is_phone_number_verified as is_phon21_177_0_, | |
| user0_.last_name as last_na22_177_0_, | |
| user0_.nationality as nationa23_177_0_, | |
| user0_.notification_preference as notific24_177_0_, | |
| user0_.password as passwor25_177_0_, | |
| user0_.password_reset_code as passwor26_177_0_, | |
| user0_.password_reset_code_expires_at as passwor27_177_0_, | |
| user0_.person_doc_expiry_date as person_28_177_0_, | |
| user0_.person_doc_issue_date as person_29_177_0_, | |
| user0_.person_doc_issue_place as person_30_177_0_, | |
| user0_.person_doc_no as person_31_177_0_, | |
| user0_.person_ident_type as person_32_177_0_, | |
| user0_.phone_number as phone_n33_177_0_, | |
| user0_.phone_verification_code as phone_v34_177_0_, | |
| user0_.user_category as user_ca35_177_0_, | |
| user0_.user_type as user_ty36_177_0_, | |
| user0_.username as usernam37_177_0_, | |
| user0_.valid_from as valid_f38_177_0_, | |
| user0_.valid_to as valid_t39_177_0_, | |
| user0_.verification_code_expires_at as verific40_177_0_, | |
| financiali1_.id as id1_146_1_, | |
| financiali1_.created_at as created_2_146_1_, | |
| financiali1_.created_by_audit as created_3_146_1_, | |
| financiali1_.created_date as created_4_146_1_, | |
| financiali1_.last_modified_by as last_mod5_146_1_, | |
| financiali1_.last_modified_date as last_mod6_146_1_, | |
| financiali1_.state as state7_146_1_, | |
| financiali1_.updated_at as updated_8_146_1_, | |
| financiali1_.version as version9_146_1_, | |
| financiali1_.rra_reference_key as rra_ref10_146_1_, | |
| financiali1_.financial_institution_address as financi15_146_1_, | |
| financiali1_.institution_type as institu11_146_1_, | |
| financiali1_.name as name12_146_1_, | |
| financiali1_.registration_number as registr13_146_1_, | |
| financiali1_.status as status14_146_1_, | |
| financiali2_.id as id1_147_2_, | |
| financiali2_.created_at as created_2_147_2_, | |
| financiali2_.created_by_audit as created_3_147_2_, | |
| financiali2_.created_date as created_4_147_2_, | |
| financiali2_.last_modified_by as last_mod5_147_2_, | |
| financiali2_.last_modified_date as last_mod6_147_2_, | |
| financiali2_.state as state7_147_2_, | |
| financiali2_.updated_at as updated_8_147_2_, | |
| financiali2_.version as version9_147_2_, | |
| financiali2_.rra_reference_key as rra_ref10_147_2_, | |
| financiali2_.address_str as address11_147_2_, | |
| financiali2_.city as city12_147_2_, | |
| financiali2_.country_of_incorporation as country13_147_2_, | |
| financiali2_.email as email14_147_2_, | |
| financiali2_.financial_institution as financi20_147_2_, | |
| financiali2_.is_email_verified as is_emai15_147_2_, | |
| financiali2_.is_phone_verified as is_phon16_147_2_, | |
| financiali2_.phone_number as phone_n17_147_2_, | |
| financiali2_.street_name as street_18_147_2_, | |
| financiali2_.village_id as village21_147_2_, | |
| financiali2_.zip_code as zip_cod19_147_2_, | |
| village3_.id as id1_171_3_, | |
| village3_.name as name2_171_3_, | |
| village3_.category as category3_171_3_, | |
| village3_.cell_id as cell_id4_171_3_, | |
| cell4_.id as id1_163_4_, | |
| cell4_.name as name2_163_4_, | |
| cell4_.sector_id as sector_i3_163_4_, | |
| sector5_.id as id1_168_5_, | |
| sector5_.name as name2_168_5_, | |
| sector5_.district_id as district3_168_5_, | |
| district6_.id as id1_165_6_, | |
| district6_.name as name2_165_6_, | |
| district6_.province_id as province3_165_6_, | |
| province7_.id as id1_167_7_, | |
| province7_.name as name2_167_7_, | |
| roles8_.user_id as user_id1_175_8_, | |
| role9_.id as role_id2_175_8_, | |
| role9_.id as id1_160_9_, | |
| role9_.created_at as created_2_160_9_, | |
| role9_.created_by_audit as created_3_160_9_, | |
| role9_.created_date as created_4_160_9_, | |
| role9_.last_modified_by as last_mod5_160_9_, | |
| role9_.last_modified_date as last_mod6_160_9_, | |
| role9_.state as state7_160_9_, | |
| role9_.updated_at as updated_8_160_9_, | |
| role9_.version as version9_160_9_, | |
| role9_.department as departm10_160_9_, | |
| role9_.description as descrip11_160_9_, | |
| role9_.role_name as role_na12_160_9_ | |
| from | |
| users user0_ | |
| left outer join | |
| mtg_financial_institution financiali1_ | |
| on user0_.institution_id=financiali1_.id | |
| left outer join | |
| mtg_financial_institution_address financiali2_ | |
| on financiali1_.financial_institution_address=financiali2_.id | |
| left outer join | |
| stc_village village3_ | |
| on financiali2_.village_id=village3_.id | |
| left outer join | |
| stc_cell cell4_ | |
| on village3_.cell_id=cell4_.id | |
| left outer join | |
| stc_sector sector5_ | |
| on cell4_.sector_id=sector5_.id | |
| left outer join | |
| stc_district district6_ | |
| on sector5_.district_id=district6_.id | |
| left outer join | |
| stc_province province7_ | |
| on district6_.province_id=province7_.id | |
| left outer join | |
| user_role roles8_ | |
| on user0_.id=roles8_.user_id | |
| left outer join | |
| role role9_ | |
| on roles8_.role_id=role9_.id | |
| where | |
| user0_.id=? | |
| Hibernate: | |
| select | |
| user0_.id as id1_177_0_, | |
| user0_.created_at as created_2_177_0_, | |
| user0_.created_by_audit as created_3_177_0_, | |
| user0_.created_date as created_4_177_0_, | |
| user0_.last_modified_by as last_mod5_177_0_, | |
| user0_.last_modified_date as last_mod6_177_0_, | |
| user0_.state as state7_177_0_, | |
| user0_.updated_at as updated_8_177_0_, | |
| user0_.version as version9_177_0_, | |
| user0_.rra_reference_key as rra_ref10_177_0_, | |
| user0_.created_by as created41_177_0_, | |
| user0_.date_of_birth as date_of11_177_0_, | |
| user0_.department as departm12_177_0_, | |
| user0_.email as email13_177_0_, | |
| user0_.email_verification_code as email_v14_177_0_, | |
| user0_.failed_login_attempts as failed_15_177_0_, | |
| user0_.institution_id as institu42_177_0_, | |
| user0_.first_name as first_n16_177_0_, | |
| user0_.gender as gender17_177_0_, | |
| user0_.is_email_verified as is_emai18_177_0_, | |
| user0_.is_from_nida as is_from19_177_0_, | |
| user0_.is_locked as is_lock20_177_0_, | |
| user0_.is_phone_number_verified as is_phon21_177_0_, | |
| user0_.last_name as last_na22_177_0_, | |
| user0_.nationality as nationa23_177_0_, | |
| user0_.notification_preference as notific24_177_0_, | |
| user0_.password as passwor25_177_0_, | |
| user0_.password_reset_code as passwor26_177_0_, | |
| user0_.password_reset_code_expires_at as passwor27_177_0_, | |
| user0_.person_doc_expiry_date as person_28_177_0_, | |
| user0_.person_doc_issue_date as person_29_177_0_, | |
| user0_.person_doc_issue_place as person_30_177_0_, | |
| user0_.person_doc_no as person_31_177_0_, | |
| user0_.person_ident_type as person_32_177_0_, | |
| user0_.phone_number as phone_n33_177_0_, | |
| user0_.phone_verification_code as phone_v34_177_0_, | |
| user0_.user_category as user_ca35_177_0_, | |
| user0_.user_type as user_ty36_177_0_, | |
| user0_.username as usernam37_177_0_, | |
| user0_.valid_from as valid_f38_177_0_, | |
| user0_.valid_to as valid_t39_177_0_, | |
| user0_.verification_code_expires_at as verific40_177_0_, | |
| financiali1_.id as id1_146_1_, | |
| financiali1_.created_at as created_2_146_1_, | |
| financiali1_.created_by_audit as created_3_146_1_, | |
| financiali1_.created_date as created_4_146_1_, | |
| financiali1_.last_modified_by as last_mod5_146_1_, | |
| financiali1_.last_modified_date as last_mod6_146_1_, | |
| financiali1_.state as state7_146_1_, | |
| financiali1_.updated_at as updated_8_146_1_, | |
| financiali1_.version as version9_146_1_, | |
| financiali1_.rra_reference_key as rra_ref10_146_1_, | |
| financiali1_.financial_institution_address as financi15_146_1_, | |
| financiali1_.institution_type as institu11_146_1_, | |
| financiali1_.name as name12_146_1_, | |
| financiali1_.registration_number as registr13_146_1_, | |
| financiali1_.status as status14_146_1_, | |
| financiali2_.id as id1_147_2_, | |
| financiali2_.created_at as created_2_147_2_, | |
| financiali2_.created_by_audit as created_3_147_2_, | |
| financiali2_.created_date as created_4_147_2_, | |
| financiali2_.last_modified_by as last_mod5_147_2_, | |
| financiali2_.last_modified_date as last_mod6_147_2_, | |
| financiali2_.state as state7_147_2_, | |
| financiali2_.updated_at as updated_8_147_2_, | |
| financiali2_.version as version9_147_2_, | |
| financiali2_.rra_reference_key as rra_ref10_147_2_, | |
| financiali2_.address_str as address11_147_2_, | |
| financiali2_.city as city12_147_2_, | |
| financiali2_.country_of_incorporation as country13_147_2_, | |
| financiali2_.email as email14_147_2_, | |
| financiali2_.financial_institution as financi20_147_2_, | |
| financiali2_.is_email_verified as is_emai15_147_2_, | |
| financiali2_.is_phone_verified as is_phon16_147_2_, | |
| financiali2_.phone_number as phone_n17_147_2_, | |
| financiali2_.street_name as street_18_147_2_, | |
| financiali2_.village_id as village21_147_2_, | |
| financiali2_.zip_code as zip_cod19_147_2_, | |
| village3_.id as id1_171_3_, | |
| village3_.name as name2_171_3_, | |
| village3_.category as category3_171_3_, | |
| village3_.cell_id as cell_id4_171_3_, | |
| cell4_.id as id1_163_4_, | |
| cell4_.name as name2_163_4_, | |
| cell4_.sector_id as sector_i3_163_4_, | |
| sector5_.id as id1_168_5_, | |
| sector5_.name as name2_168_5_, | |
| sector5_.district_id as district3_168_5_, | |
| district6_.id as id1_165_6_, | |
| district6_.name as name2_165_6_, | |
| district6_.province_id as province3_165_6_, | |
| province7_.id as id1_167_7_, | |
| province7_.name as name2_167_7_, | |
| roles8_.user_id as user_id1_175_8_, | |
| role9_.id as role_id2_175_8_, | |
| role9_.id as id1_160_9_, | |
| role9_.created_at as created_2_160_9_, | |
| role9_.created_by_audit as created_3_160_9_, | |
| role9_.created_date as created_4_160_9_, | |
| role9_.last_modified_by as last_mod5_160_9_, | |
| role9_.last_modified_date as last_mod6_160_9_, | |
| role9_.state as state7_160_9_, | |
| role9_.updated_at as updated_8_160_9_, | |
| role9_.version as version9_160_9_, | |
| role9_.department as departm10_160_9_, | |
| role9_.description as descrip11_160_9_, | |
| role9_.role_name as role_na12_160_9_ | |
| from | |
| users user0_ | |
| left outer join | |
| mtg_financial_institution financiali1_ | |
| on user0_.institution_id=financiali1_.id | |
| left outer join | |
| mtg_financial_institution_address financiali2_ | |
| on financiali1_.financial_institution_address=financiali2_.id | |
| left outer join | |
| stc_village village3_ | |
| on financiali2_.village_id=village3_.id | |
| left outer join | |
| stc_cell cell4_ | |
| on village3_.cell_id=cell4_.id | |
| left outer join | |
| stc_sector sector5_ | |
| on cell4_.sector_id=sector5_.id | |
| left outer join | |
| stc_district district6_ | |
| on sector5_.district_id=district6_.id | |
| left outer join | |
| stc_province province7_ | |
| on district6_.province_id=province7_.id | |
| left outer join | |
| user_role roles8_ | |
| on user0_.id=roles8_.user_id | |
| left outer join | |
| role role9_ | |
| on roles8_.role_id=role9_.id | |
| where | |
| user0_.id=? | |
| 2025-04-14 15:20:28.851 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [fb8ac724-821b-4c7f-a4b6-d8ddd8cfb396] | |
| 2025-04-14 15:20:28.865 DEBUG 536 --- [nio-8051-exec-1] org.hibernate.SQL : | |
| select | |
| financialp0_.id as id1_17_19_, | |
| financialp0_.created_at as created_2_17_19_, | |
| financialp0_.created_by_audit as created_3_17_19_, | |
| financialp0_.created_date as created_4_17_19_, | |
| financialp0_.last_modified_by as last_mod5_17_19_, | |
| financialp0_.last_modified_date as last_mod6_17_19_, | |
| financialp0_.state as state7_17_19_, | |
| financialp0_.updated_at as updated_8_17_19_, | |
| financialp0_.version as version9_17_19_, | |
| financialp0_.rra_reference_key as rra_ref10_17_19_, | |
| financialp0_.annual_return_id as annual_12_17_19_, | |
| financialp0_.created_by as created13_17_19_, | |
| financialp0_.total_value as total_v11_17_19_, | |
| annualretu1_.id as id1_10_0_, | |
| annualretu1_.created_at as created_2_10_0_, | |
| annualretu1_.created_by_audit as created_3_10_0_, | |
| annualretu1_.created_date as created_4_10_0_, | |
| annualretu1_.last_modified_by as last_mod5_10_0_, | |
| annualretu1_.last_modified_date as last_mod6_10_0_, | |
| annualretu1_.state as state7_10_0_, | |
| annualretu1_.updated_at as updated_8_10_0_, | |
| annualretu1_.version as version9_10_0_, | |
| annualretu1_.rra_reference_key as rra_ref10_10_0_, | |
| annualretu1_.annual_meeting_date as annual_11_10_0_, | |
| annualretu1_.application_reference_id as applica12_10_0_, | |
| annualretu1_.assigned_approver as assigne18_10_0_, | |
| annualretu1_.assigned_verifier as assigne19_10_0_, | |
| annualretu1_.business_id as busines20_10_0_, | |
| annualretu1_.created_by as created21_10_0_, | |
| annualretu1_.filing_date as filing_13_10_0_, | |
| annualretu1_.filing_status as filing_14_10_0_, | |
| annualretu1_.filing_fiscal_year as filing_15_10_0_, | |
| annualretu1_.good_standing_id as good_st22_10_0_, | |
| annualretu1_.revised_annual_return_id as revised16_10_0_, | |
| annualretu1_.type as type17_10_0_, | |
| user2_.id as id1_177_1_, | |
| user2_.created_at as created_2_177_1_, | |
| user2_.created_by_audit as created_3_177_1_, | |
| user2_.created_date as created_4_177_1_, | |
| user2_.last_modified_by as last_mod5_177_1_, | |
| user2_.last_modified_date as last_mod6_177_1_, | |
| user2_.state as state7_177_1_, | |
| user2_.updated_at as updated_8_177_1_, | |
| user2_.version as version9_177_1_, | |
| user2_.rra_reference_key as rra_ref10_177_1_, | |
| user2_.created_by as created41_177_1_, | |
| user2_.date_of_birth as date_of11_177_1_, | |
| user2_.department as departm12_177_1_, | |
| user2_.email as email13_177_1_, | |
| user2_.email_verification_code as email_v14_177_1_, | |
| user2_.failed_login_attempts as failed_15_177_1_, | |
| user2_.institution_id as institu42_177_1_, | |
| user2_.first_name as first_n16_177_1_, | |
| user2_.gender as gender17_177_1_, | |
| user2_.is_email_verified as is_emai18_177_1_, | |
| user2_.is_from_nida as is_from19_177_1_, | |
| user2_.is_locked as is_lock20_177_1_, | |
| user2_.is_phone_number_verified as is_phon21_177_1_, | |
| user2_.last_name as last_na22_177_1_, | |
| user2_.nationality as nationa23_177_1_, | |
| user2_.notification_preference as notific24_177_1_, | |
| user2_.password as passwor25_177_1_, | |
| user2_.password_reset_code as passwor26_177_1_, | |
| user2_.password_reset_code_expires_at as passwor27_177_1_, | |
| user2_.person_doc_expiry_date as person_28_177_1_, | |
| user2_.person_doc_issue_date as person_29_177_1_, | |
| user2_.person_doc_issue_place as person_30_177_1_, | |
| user2_.person_doc_no as person_31_177_1_, | |
| user2_.person_ident_type as person_32_177_1_, | |
| user2_.phone_number as phone_n33_177_1_, | |
| user2_.phone_verification_code as phone_v34_177_1_, | |
| user2_.user_category as user_ca35_177_1_, | |
| user2_.user_type as user_ty36_177_1_, | |
| user2_.username as usernam37_177_1_, | |
| user2_.valid_from as valid_f38_177_1_, | |
| user2_.valid_to as valid_t39_177_1_, | |
| user2_.verification_code_expires_at as verific40_177_1_, | |
| financiali3_.id as id1_146_2_, | |
| financiali3_.created_at as created_2_146_2_, | |
| financiali3_.created_by_audit as created_3_146_2_, | |
| financiali3_.created_date as created_4_146_2_, | |
| financiali3_.last_modified_by as last_mod5_146_2_, | |
| financiali3_.last_modified_date as last_mod6_146_2_, | |
| financiali3_.state as state7_146_2_, | |
| financiali3_.updated_at as updated_8_146_2_, | |
| financiali3_.version as version9_146_2_, | |
| financiali3_.rra_reference_key as rra_ref10_146_2_, | |
| financiali3_.financial_institution_address as financi15_146_2_, | |
| financiali3_.institution_type as institu11_146_2_, | |
| financiali3_.name as name12_146_2_, | |
| financiali3_.registration_number as registr13_146_2_, | |
| financiali3_.status as status14_146_2_, | |
| financiali4_.id as id1_147_3_, | |
| financiali4_.created_at as created_2_147_3_, | |
| financiali4_.created_by_audit as created_3_147_3_, | |
| financiali4_.created_date as created_4_147_3_, | |
| financiali4_.last_modified_by as last_mod5_147_3_, | |
| financiali4_.last_modified_date as last_mod6_147_3_, | |
| financiali4_.state as state7_147_3_, | |
| financiali4_.updated_at as updated_8_147_3_, | |
| financiali4_.version as version9_147_3_, | |
| financiali4_.rra_reference_key as rra_ref10_147_3_, | |
| financiali4_.address_str as address11_147_3_, | |
| financiali4_.city as city12_147_3_, | |
| financiali4_.country_of_incorporation as country13_147_3_, | |
| financiali4_.email as email14_147_3_, | |
| financiali4_.financial_institution as financi20_147_3_, | |
| financiali4_.is_email_verified as is_emai15_147_3_, | |
| financiali4_.is_phone_verified as is_phon16_147_3_, | |
| financiali4_.phone_number as phone_n17_147_3_, | |
| financiali4_.street_name as street_18_147_3_, | |
| financiali4_.village_id as village21_147_3_, | |
| financiali4_.zip_code as zip_cod19_147_3_, | |
| village5_.id as id1_171_4_, | |
| village5_.name as name2_171_4_, | |
| village5_.category as category3_171_4_, | |
| village5_.cell_id as cell_id4_171_4_, | |
| cell6_.id as id1_163_5_, | |
| cell6_.name as name2_163_5_, | |
| cell6_.sector_id as sector_i3_163_5_, | |
| sector7_.id as id1_168_6_, | |
| sector7_.name as name2_168_6_, | |
| sector7_.district_id as district3_168_6_, | |
| district8_.id as id1_165_7_, | |
| district8_.name as name2_165_7_, | |
| district8_.province_id as province3_165_7_, | |
| province9_.id as id1_167_8_, | |
| province9_.name as name2_167_8_, | |
| roles10_.user_id as user_id1_175_21_, | |
| role11_.id as role_id2_175_21_, | |
| role11_.id as id1_160_9_, | |
| role11_.created_at as created_2_160_9_, | |
| role11_.created_by_audit as created_3_160_9_, | |
| role11_.created_date as created_4_160_9_, | |
| role11_.last_modified_by as last_mod5_160_9_, | |
| role11_.last_modified_date as last_mod6_160_9_, | |
| role11_.state as state7_160_9_, | |
| role11_.updated_at as updated_8_160_9_, | |
| role11_.version as version9_160_9_, | |
| role11_.department as departm10_160_9_, | |
| role11_.description as descrip11_160_9_, | |
| role11_.role_name as role_na12_160_9_, | |
| user12_.id as id1_177_10_, | |
| user12_.created_at as created_2_177_10_, | |
| user12_.created_by_audit as created_3_177_10_, | |
| user12_.created_date as created_4_177_10_, | |
| user12_.last_modified_by as last_mod5_177_10_, | |
| user12_.last_modified_date as last_mod6_177_10_, | |
| user12_.state as state7_177_10_, | |
| user12_.updated_at as updated_8_177_10_, | |
| user12_.version as version9_177_10_, | |
| user12_.rra_reference_key as rra_ref10_177_10_, | |
| user12_.created_by as created41_177_10_, | |
| user12_.date_of_birth as date_of11_177_10_, | |
| user12_.department as departm12_177_10_, | |
| user12_.email as email13_177_10_, | |
| user12_.email_verification_code as email_v14_177_10_, | |
| user12_.failed_login_attempts as failed_15_177_10_, | |
| user12_.institution_id as institu42_177_10_, | |
| user12_.first_name as first_n16_177_10_, | |
| user12_.gender as gender17_177_10_, | |
| user12_.is_email_verified as is_emai18_177_10_, | |
| user12_.is_from_nida as is_from19_177_10_, | |
| user12_.is_locked as is_lock20_177_10_, | |
| user12_.is_phone_number_verified as is_phon21_177_10_, | |
| user12_.last_name as last_na22_177_10_, | |
| user12_.nationality as nationa23_177_10_, | |
| user12_.notification_preference as notific24_177_10_, | |
| user12_.password as passwor25_177_10_, | |
| user12_.password_reset_code as passwor26_177_10_, | |
| user12_.password_reset_code_expires_at as passwor27_177_10_, | |
| user12_.person_doc_expiry_date as person_28_177_10_, | |
| user12_.person_doc_issue_date as person_29_177_10_, | |
| user12_.person_doc_issue_place as person_30_177_10_, | |
| user12_.person_doc_no as person_31_177_10_, | |
| user12_.person_ident_type as person_32_177_10_, | |
| user12_.phone_number as phone_n33_177_10_, | |
| user12_.phone_verification_code as phone_v34_177_10_, | |
| user12_.user_category as user_ca35_177_10_, | |
| user12_.user_type as user_ty36_177_10_, | |
| user12_.username as usernam37_177_10_, | |
| user12_.valid_from as valid_f38_177_10_, | |
| user12_.valid_to as valid_t39_177_10_, | |
| user12_.verification_code_expires_at as verific40_177_10_, | |
| user13_.id as id1_177_11_, | |
| user13_.created_at as created_2_177_11_, | |
| user13_.created_by_audit as created_3_177_11_, | |
| user13_.created_date as created_4_177_11_, | |
| user13_.last_modified_by as last_mod5_177_11_, | |
| user13_.last_modified_date as last_mod6_177_11_, | |
| user13_.state as state7_177_11_, | |
| user13_.updated_at as updated_8_177_11_, | |
| user13_.version as version9_177_11_, | |
| user13_.rra_reference_key as rra_ref10_177_11_, | |
| user13_.created_by as created41_177_11_, | |
| user13_.date_of_birth as date_of11_177_11_, | |
| user13_.department as departm12_177_11_, | |
| user13_.email as email13_177_11_, | |
| user13_.email_verification_code as email_v14_177_11_, | |
| user13_.failed_login_attempts as failed_15_177_11_, | |
| user13_.institution_id as institu42_177_11_, | |
| user13_.first_name as first_n16_177_11_, | |
| user13_.gender as gender17_177_11_, | |
| user13_.is_email_verified as is_emai18_177_11_, | |
| user13_.is_from_nida as is_from19_177_11_, | |
| user13_.is_locked as is_lock20_177_11_, | |
| user13_.is_phone_number_verified as is_phon21_177_11_, | |
| user13_.last_name as last_na22_177_11_, | |
| user13_.nationality as nationa23_177_11_, | |
| user13_.notification_preference as notific24_177_11_, | |
| user13_.password as passwor25_177_11_, | |
| user13_.password_reset_code as passwor26_177_11_, | |
| user13_.password_reset_code_expires_at as passwor27_177_11_, | |
| user13_.person_doc_expiry_date as person_28_177_11_, | |
| user13_.person_doc_issue_date as person_29_177_11_, | |
| user13_.person_doc_issue_place as person_30_177_11_, | |
| user13_.person_doc_no as person_31_177_11_, | |
| user13_.person_ident_type as person_32_177_11_, | |
| user13_.phone_number as phone_n33_177_11_, | |
| user13_.phone_verification_code as phone_v34_177_11_, | |
| user13_.user_category as user_ca35_177_11_, | |
| user13_.user_type as user_ty36_177_11_, | |
| user13_.username as usernam37_177_11_, | |
| user13_.valid_from as valid_f38_177_11_, | |
| user13_.valid_to as valid_t39_177_11_, | |
| user13_.verification_code_expires_at as verific40_177_11_, | |
| incomestat14_.id as id1_23_12_, | |
| incomestat14_.created_at as created_2_23_12_, | |
| incomestat14_.created_by_audit as created_3_23_12_, | |
| incomestat14_.created_date as created_4_23_12_, | |
| incomestat14_.last_modified_by as last_mod5_23_12_, | |
| incomestat14_.last_modified_date as last_mod6_23_12_, | |
| incomestat14_.state as state7_23_12_, | |
| incomestat14_.updated_at as updated_8_23_12_, | |
| incomestat14_.version as version9_23_12_, | |
| incomestat14_.rra_reference_key as rra_ref10_23_12_, | |
| incomestat14_.administrative_expenses as adminis11_23_12_, | |
| incomestat14_.annual_return_id as annual_23_23_12_, | |
| incomestat14_.cost_of_sales as cost_of12_23_12_, | |
| incomestat14_.created_by as created24_23_12_, | |
| incomestat14_.finance_costs as finance13_23_12_, | |
| incomestat14_.gross_profit as gross_p14_23_12_, | |
| incomestat14_.income_tax as income_15_23_12_, | |
| incomestat14_.investment_income as investm16_23_12_, | |
| incomestat14_.net_profit_for_the_year as net_pro17_23_12_, | |
| incomestat14_.other_comprehensive_income as other_c18_23_12_, | |
| incomestat14_.other_expenses as other_e19_23_12_, | |
| incomestat14_.profit_before_task as profit_20_23_12_, | |
| incomestat14_.selling_and_distribution_expenses as selling21_23_12_, | |
| incomestat14_.turn_over as turn_ov22_23_12_, | |
| user15_.id as id1_177_13_, | |
| user15_.created_at as created_2_177_13_, | |
| user15_.created_by_audit as created_3_177_13_, | |
| user15_.created_date as created_4_177_13_, | |
| user15_.last_modified_by as last_mod5_177_13_, | |
| user15_.last_modified_date as last_mod6_177_13_, | |
| user15_.state as state7_177_13_, | |
| user15_.updated_at as updated_8_177_13_, | |
| user15_.version as version9_177_13_, | |
| user15_.rra_reference_key as rra_ref10_177_13_, | |
| user15_.created_by as created41_177_13_, | |
| user15_.date_of_birth as date_of11_177_13_, | |
| user15_.department as departm12_177_13_, | |
| user15_.email as email13_177_13_, | |
| user15_.email_verification_code as email_v14_177_13_, | |
| user15_.failed_login_attempts as failed_15_177_13_, | |
| user15_.institution_id as institu42_177_13_, | |
| user15_.first_name as first_n16_177_13_, | |
| user15_.gender as gender17_177_13_, | |
| user15_.is_email_verified as is_emai18_177_13_, | |
| user15_.is_from_nida as is_from19_177_13_, | |
| user15_.is_locked as is_lock20_177_13_, | |
| user15_.is_phone_number_verified as is_phon21_177_13_, | |
| user15_.last_name as last_na22_177_13_, | |
| user15_.nationality as nationa23_177_13_, | |
| user15_.notification_preference as notific24_177_13_, | |
| user15_.password as passwor25_177_13_, | |
| user15_.password_reset_code as passwor26_177_13_, | |
| user15_.password_reset_code_expires_at as passwor27_177_13_, | |
| user15_.person_doc_expiry_date as person_28_177_13_, | |
| user15_.person_doc_issue_date as person_29_177_13_, | |
| user15_.person_doc_issue_place as person_30_177_13_, | |
| user15_.person_doc_no as person_31_177_13_, | |
| user15_.person_ident_type as person_32_177_13_, | |
| user15_.phone_number as phone_n33_177_13_, | |
| user15_.phone_verification_code as phone_v34_177_13_, | |
| user15_.user_category as user_ca35_177_13_, | |
| user15_.user_type as user_ty36_177_13_, | |
| user15_.username as usernam37_177_13_, | |
| user15_.valid_from as valid_f38_177_13_, | |
| user15_.valid_to as valid_t39_177_13_, | |
| user15_.verification_code_expires_at as verific40_177_13_, | |
| user16_.id as id1_177_14_, | |
| user16_.created_at as created_2_177_14_, | |
| user16_.created_by_audit as created_3_177_14_, | |
| user16_.created_date as created_4_177_14_, | |
| user16_.last_modified_by as last_mod5_177_14_, | |
| user16_.last_modified_date as last_mod6_177_14_, | |
| user16_.state as state7_177_14_, | |
| user16_.updated_at as updated_8_177_14_, | |
| user16_.version as version9_177_14_, | |
| user16_.rra_reference_key as rra_ref10_177_14_, | |
| user16_.created_by as created41_177_14_, | |
| user16_.date_of_birth as date_of11_177_14_, | |
| user16_.department as departm12_177_14_, | |
| user16_.email as email13_177_14_, | |
| user16_.email_verification_code as email_v14_177_14_, | |
| user16_.failed_login_attempts as failed_15_177_14_, | |
| user16_.institution_id as institu42_177_14_, | |
| user16_.first_name as first_n16_177_14_, | |
| user16_.gender as gender17_177_14_, | |
| user16_.is_email_verified as is_emai18_177_14_, | |
| user16_.is_from_nida as is_from19_177_14_, | |
| user16_.is_locked as is_lock20_177_14_, | |
| user16_.is_phone_number_verified as is_phon21_177_14_, | |
| user16_.last_name as last_na22_177_14_, | |
| user16_.nationality as nationa23_177_14_, | |
| user16_.notification_preference as notific24_177_14_, | |
| user16_.password as passwor25_177_14_, | |
| user16_.password_reset_code as passwor26_177_14_, | |
| user16_.password_reset_code_expires_at as passwor27_177_14_, | |
| user16_.person_doc_expiry_date as person_28_177_14_, | |
| user16_.person_doc_issue_date as person_29_177_14_, | |
| user16_.person_doc_issue_place as person_30_177_14_, | |
| user16_.person_doc_no as person_31_177_14_, | |
| user16_.person_ident_type as person_32_177_14_, | |
| user16_.phone_number as phone_n33_177_14_, | |
| user16_.phone_verification_code as phone_v34_177_14_, | |
| user16_.user_category as user_ca35_177_14_, | |
| user16_.user_type as user_ty36_177_14_, | |
| user16_.username as usernam37_177_14_, | |
| user16_.valid_from as valid_f38_177_14_, | |
| user16_.valid_to as valid_t39_177_14_, | |
| user16_.verification_code_expires_at as verific40_177_14_, | |
| financials17_.id as id1_12_15_, | |
| financials17_.created_at as created_2_12_15_, | |
| financials17_.created_by_audit as created_3_12_15_, | |
| financials17_.created_date as created_4_12_15_, | |
| financials17_.last_modified_by as last_mod5_12_15_, | |
| financials17_.last_modified_date as last_mod6_12_15_, | |
| financials17_.state as state7_12_15_, | |
| financials17_.updated_at as updated_8_12_15_, | |
| financials17_.version as version9_12_15_, | |
| financials17_.rra_reference_key as rra_ref10_12_15_, | |
| financials17_.bank as bank11_12_15_, | |
| financials17_.biological_assets as biologi12_12_15_, | |
| financials17_.cash as cash13_12_15_, | |
| financials17_.created_by as created24_12_15_, | |
| financials17_.deferred_tax_assets as deferre14_12_15_, | |
| financials17_.financial_position_statement as financi25_12_15_, | |
| financials17_.intangible_assets as intangi15_12_15_, | |
| financials17_.inventory as invento16_12_15_, | |
| financials17_.investment as investm17_12_15_, | |
| financials17_.others as others18_12_15_, | |
| financials17_.property_plant_and_equipment as propert19_12_15_, | |
| financials17_.receivables as receiva20_12_15_, | |
| financials17_.total_assets as total_a21_12_15_, | |
| financials17_.total_current_assets as total_c22_12_15_, | |
| financials17_.total_non_current_assets as total_n23_12_15_, | |
| user18_.id as id1_177_16_, | |
| user18_.created_at as created_2_177_16_, | |
| user18_.created_by_audit as created_3_177_16_, | |
| user18_.created_date as created_4_177_16_, | |
| user18_.last_modified_by as last_mod5_177_16_, | |
| user18_.last_modified_date as last_mod6_177_16_, | |
| user18_.state as state7_177_16_, | |
| user18_.updated_at as updated_8_177_16_, | |
| user18_.version as version9_177_16_, | |
| user18_.rra_reference_key as rra_ref10_177_16_, | |
| user18_.created_by as created41_177_16_, | |
| user18_.date_of_birth as date_of11_177_16_, | |
| user18_.department as departm12_177_16_, | |
| user18_.email as email13_177_16_, | |
| user18_.email_verification_code as email_v14_177_16_, | |
| user18_.failed_login_attempts as failed_15_177_16_, | |
| user18_.institution_id as institu42_177_16_, | |
| user18_.first_name as first_n16_177_16_, | |
| user18_.gender as gender17_177_16_, | |
| user18_.is_email_verified as is_emai18_177_16_, | |
| user18_.is_from_nida as is_from19_177_16_, | |
| user18_.is_locked as is_lock20_177_16_, | |
| user18_.is_phone_number_verified as is_phon21_177_16_, | |
| user18_.last_name as last_na22_177_16_, | |
| user18_.nationality as nationa23_177_16_, | |
| user18_.notification_preference as notific24_177_16_, | |
| user18_.password as passwor25_177_16_, | |
| user18_.password_reset_code as passwor26_177_16_, | |
| user18_.password_reset_code_expires_at as passwor27_177_16_, | |
| user18_.person_doc_expiry_date as person_28_177_16_, | |
| user18_.person_doc_issue_date as person_29_177_16_, | |
| user18_.person_doc_issue_place as person_30_177_16_, | |
| user18_.person_doc_no as person_31_177_16_, | |
| user18_.person_ident_type as person_32_177_16_, | |
| user18_.phone_number as phone_n33_177_16_, | |
| user18_.phone_verification_code as phone_v34_177_16_, | |
| user18_.user_category as user_ca35_177_16_, | |
| user18_.user_type as user_ty36_177_16_, | |
| user18_.username as usernam37_177_16_, | |
| user18_.valid_from as valid_f38_177_16_, | |
| user18_.valid_to as valid_t39_177_16_, | |
| user18_.verification_code_expires_at as verific40_177_16_, | |
| financials19_.id as id1_15_17_, | |
| financials19_.created_at as created_2_15_17_, | |
| financials19_.created_by_audit as created_3_15_17_, | |
| financials19_.created_date as created_4_15_17_, | |
| financials19_.last_modified_by as last_mod5_15_17_, | |
| financials19_.last_modified_date as last_mod6_15_17_, | |
| financials19_.state as state7_15_17_, | |
| financials19_.updated_at as updated_8_15_17_, | |
| financials19_.version as version9_15_17_, | |
| financials19_.rra_reference_key as rra_ref10_15_17_, | |
| financials19_.created_by as created28_15_17_, | |
| financials19_.current_tax_payable as current11_15_17_, | |
| financials19_.deferred_tax_liability as deferre12_15_17_, | |
| financials19_.financial_position_statement as financi29_15_17_, | |
| financials19_.long_term_borrowings as long_te13_15_17_, | |
| financials19_.other_current_liabilities as other_c14_15_17_, | |
| financials19_.other_non_current_liabilities as other_n15_15_17_, | |
| financials19_.payables as payable16_15_17_, | |
| financials19_.reserves as reserve17_15_17_, | |
| financials19_.retained_earnings as retaine18_15_17_, | |
| financials19_.revaluation_reserves as revalua19_15_17_, | |
| financials19_.share_capital as share_c20_15_17_, | |
| financials19_.share_premium as share_p21_15_17_, | |
| financials19_.short_term_borrowings as short_t22_15_17_, | |
| financials19_.total_current_liabilities as total_c23_15_17_, | |
| financials19_.total_equity_and_liabilities as total_e24_15_17_, | |
| financials19_.total_liabilities as total_l25_15_17_, | |
| financials19_.total_long_term_liabilities as total_l26_15_17_, | |
| financials19_.total_shareholder_equity as total_s27_15_17_, | |
| user20_.id as id1_177_18_, | |
| user20_.created_at as created_2_177_18_, | |
| user20_.created_by_audit as created_3_177_18_, | |
| user20_.created_date as created_4_177_18_, | |
| user20_.last_modified_by as last_mod5_177_18_, | |
| user20_.last_modified_date as last_mod6_177_18_, | |
| user20_.state as state7_177_18_, | |
| user20_.updated_at as updated_8_177_18_, | |
| user20_.version as version9_177_18_, | |
| user20_.rra_reference_key as rra_ref10_177_18_, | |
| user20_.created_by as created41_177_18_, | |
| user20_.date_of_birth as date_of11_177_18_, | |
| user20_.department as departm12_177_18_, | |
| user20_.email as email13_177_18_, | |
| user20_.email_verification_code as email_v14_177_18_, | |
| user20_.failed_login_attempts as failed_15_177_18_, | |
| user20_.institution_id as institu42_177_18_, | |
| user20_.first_name as first_n16_177_18_, | |
| user20_.gender as gender17_177_18_, | |
| user20_.is_email_verified as is_emai18_177_18_, | |
| user20_.is_from_nida as is_from19_177_18_, | |
| user20_.is_locked as is_lock20_177_18_, | |
| user20_.is_phone_number_verified as is_phon21_177_18_, | |
| user20_.last_name as last_na22_177_18_, | |
| user20_.nationality as nationa23_177_18_, | |
| user20_.notification_preference as notific24_177_18_, | |
| user20_.password as passwor25_177_18_, | |
| user20_.password_reset_code as passwor26_177_18_, | |
| user20_.password_reset_code_expires_at as passwor27_177_18_, | |
| user20_.person_doc_expiry_date as person_28_177_18_, | |
| user20_.person_doc_issue_date as person_29_177_18_, | |
| user20_.person_doc_issue_place as person_30_177_18_, | |
| user20_.person_doc_no as person_31_177_18_, | |
| user20_.person_ident_type as person_32_177_18_, | |
| user20_.phone_number as phone_n33_177_18_, | |
| user20_.phone_verification_code as phone_v34_177_18_, | |
| user20_.user_category as user_ca35_177_18_, | |
| user20_.user_type as user_ty36_177_18_, | |
| user20_.username as usernam37_177_18_, | |
| user20_.valid_from as valid_f38_177_18_, | |
| user20_.valid_to as valid_t39_177_18_, | |
| user20_.verification_code_expires_at as verific40_177_18_ | |
| from | |
| ar_financial_position_statement financialp0_ | |
| inner join | |
| ar_annual_return annualretu1_ | |
| on financialp0_.annual_return_id=annualretu1_.id | |
| left outer join | |
| users user2_ | |
| on annualretu1_.assigned_approver=user2_.id | |
| left outer join | |
| mtg_financial_institution financiali3_ | |
| on user2_.institution_id=financiali3_.id | |
| left outer join | |
| mtg_financial_institution_address financiali4_ | |
| on financiali3_.financial_institution_address=financiali4_.id | |
| left outer join | |
| stc_village village5_ | |
| on financiali4_.village_id=village5_.id | |
| left outer join | |
| stc_cell cell6_ | |
| on village5_.cell_id=cell6_.id | |
| left outer join | |
| stc_sector sector7_ | |
| on cell6_.sector_id=sector7_.id | |
| left outer join | |
| stc_district district8_ | |
| on sector7_.district_id=district8_.id | |
| left outer join | |
| stc_province province9_ | |
| on district8_.province_id=province9_.id | |
| left outer join | |
| user_role roles10_ | |
| on user2_.id=roles10_.user_id | |
| left outer join | |
| role role11_ | |
| on roles10_.role_id=role11_.id | |
| left outer join | |
| users user12_ | |
| on annualretu1_.assigned_verifier=user12_.id | |
| left outer join | |
| users user13_ | |
| on annualretu1_.created_by=user13_.id | |
| left outer join | |
| ar_income_statement incomestat14_ | |
| on annualretu1_.id=incomestat14_.annual_return_id | |
| left outer join | |
| users user15_ | |
| on incomestat14_.created_by=user15_.id | |
| inner join | |
| users user16_ | |
| on financialp0_.created_by=user16_.id | |
| left outer join | |
| ar_asset_detail financials17_ | |
| on financialp0_.id=financials17_.financial_position_statement | |
| left outer join | |
| users user18_ | |
| on financials17_.created_by=user18_.id | |
| left outer join | |
| ar_equity_and_liabilities financials19_ | |
| on financialp0_.id=financials19_.financial_position_statement | |
| left outer join | |
| users user20_ | |
| on financials19_.created_by=user20_.id | |
| where | |
| financialp0_.annual_return_id=? | |
| Hibernate: | |
| select | |
| financialp0_.id as id1_17_19_, | |
| financialp0_.created_at as created_2_17_19_, | |
| financialp0_.created_by_audit as created_3_17_19_, | |
| financialp0_.created_date as created_4_17_19_, | |
| financialp0_.last_modified_by as last_mod5_17_19_, | |
| financialp0_.last_modified_date as last_mod6_17_19_, | |
| financialp0_.state as state7_17_19_, | |
| financialp0_.updated_at as updated_8_17_19_, | |
| financialp0_.version as version9_17_19_, | |
| financialp0_.rra_reference_key as rra_ref10_17_19_, | |
| financialp0_.annual_return_id as annual_12_17_19_, | |
| financialp0_.created_by as created13_17_19_, | |
| financialp0_.total_value as total_v11_17_19_, | |
| annualretu1_.id as id1_10_0_, | |
| annualretu1_.created_at as created_2_10_0_, | |
| annualretu1_.created_by_audit as created_3_10_0_, | |
| annualretu1_.created_date as created_4_10_0_, | |
| annualretu1_.last_modified_by as last_mod5_10_0_, | |
| annualretu1_.last_modified_date as last_mod6_10_0_, | |
| annualretu1_.state as state7_10_0_, | |
| annualretu1_.updated_at as updated_8_10_0_, | |
| annualretu1_.version as version9_10_0_, | |
| annualretu1_.rra_reference_key as rra_ref10_10_0_, | |
| annualretu1_.annual_meeting_date as annual_11_10_0_, | |
| annualretu1_.application_reference_id as applica12_10_0_, | |
| annualretu1_.assigned_approver as assigne18_10_0_, | |
| annualretu1_.assigned_verifier as assigne19_10_0_, | |
| annualretu1_.business_id as busines20_10_0_, | |
| annualretu1_.created_by as created21_10_0_, | |
| annualretu1_.filing_date as filing_13_10_0_, | |
| annualretu1_.filing_status as filing_14_10_0_, | |
| annualretu1_.filing_fiscal_year as filing_15_10_0_, | |
| annualretu1_.good_standing_id as good_st22_10_0_, | |
| annualretu1_.revised_annual_return_id as revised16_10_0_, | |
| annualretu1_.type as type17_10_0_, | |
| user2_.id as id1_177_1_, | |
| user2_.created_at as created_2_177_1_, | |
| user2_.created_by_audit as created_3_177_1_, | |
| user2_.created_date as created_4_177_1_, | |
| user2_.last_modified_by as last_mod5_177_1_, | |
| user2_.last_modified_date as last_mod6_177_1_, | |
| user2_.state as state7_177_1_, | |
| user2_.updated_at as updated_8_177_1_, | |
| user2_.version as version9_177_1_, | |
| user2_.rra_reference_key as rra_ref10_177_1_, | |
| user2_.created_by as created41_177_1_, | |
| user2_.date_of_birth as date_of11_177_1_, | |
| user2_.department as departm12_177_1_, | |
| user2_.email as email13_177_1_, | |
| user2_.email_verification_code as email_v14_177_1_, | |
| user2_.failed_login_attempts as failed_15_177_1_, | |
| user2_.institution_id as institu42_177_1_, | |
| user2_.first_name as first_n16_177_1_, | |
| user2_.gender as gender17_177_1_, | |
| user2_.is_email_verified as is_emai18_177_1_, | |
| user2_.is_from_nida as is_from19_177_1_, | |
| user2_.is_locked as is_lock20_177_1_, | |
| user2_.is_phone_number_verified as is_phon21_177_1_, | |
| user2_.last_name as last_na22_177_1_, | |
| user2_.nationality as nationa23_177_1_, | |
| user2_.notification_preference as notific24_177_1_, | |
| user2_.password as passwor25_177_1_, | |
| user2_.password_reset_code as passwor26_177_1_, | |
| user2_.password_reset_code_expires_at as passwor27_177_1_, | |
| user2_.person_doc_expiry_date as person_28_177_1_, | |
| user2_.person_doc_issue_date as person_29_177_1_, | |
| user2_.person_doc_issue_place as person_30_177_1_, | |
| user2_.person_doc_no as person_31_177_1_, | |
| user2_.person_ident_type as person_32_177_1_, | |
| user2_.phone_number as phone_n33_177_1_, | |
| user2_.phone_verification_code as phone_v34_177_1_, | |
| user2_.user_category as user_ca35_177_1_, | |
| user2_.user_type as user_ty36_177_1_, | |
| user2_.username as usernam37_177_1_, | |
| user2_.valid_from as valid_f38_177_1_, | |
| user2_.valid_to as valid_t39_177_1_, | |
| user2_.verification_code_expires_at as verific40_177_1_, | |
| financiali3_.id as id1_146_2_, | |
| financiali3_.created_at as created_2_146_2_, | |
| financiali3_.created_by_audit as created_3_146_2_, | |
| financiali3_.created_date as created_4_146_2_, | |
| financiali3_.last_modified_by as last_mod5_146_2_, | |
| financiali3_.last_modified_date as last_mod6_146_2_, | |
| financiali3_.state as state7_146_2_, | |
| financiali3_.updated_at as updated_8_146_2_, | |
| financiali3_.version as version9_146_2_, | |
| financiali3_.rra_reference_key as rra_ref10_146_2_, | |
| financiali3_.financial_institution_address as financi15_146_2_, | |
| financiali3_.institution_type as institu11_146_2_, | |
| financiali3_.name as name12_146_2_, | |
| financiali3_.registration_number as registr13_146_2_, | |
| financiali3_.status as status14_146_2_, | |
| financiali4_.id as id1_147_3_, | |
| financiali4_.created_at as created_2_147_3_, | |
| financiali4_.created_by_audit as created_3_147_3_, | |
| financiali4_.created_date as created_4_147_3_, | |
| financiali4_.last_modified_by as last_mod5_147_3_, | |
| financiali4_.last_modified_date as last_mod6_147_3_, | |
| financiali4_.state as state7_147_3_, | |
| financiali4_.updated_at as updated_8_147_3_, | |
| financiali4_.version as version9_147_3_, | |
| financiali4_.rra_reference_key as rra_ref10_147_3_, | |
| financiali4_.address_str as address11_147_3_, | |
| financiali4_.city as city12_147_3_, | |
| financiali4_.country_of_incorporation as country13_147_3_, | |
| financiali4_.email as email14_147_3_, | |
| financiali4_.financial_institution as financi20_147_3_, | |
| financiali4_.is_email_verified as is_emai15_147_3_, | |
| financiali4_.is_phone_verified as is_phon16_147_3_, | |
| financiali4_.phone_number as phone_n17_147_3_, | |
| financiali4_.street_name as street_18_147_3_, | |
| financiali4_.village_id as village21_147_3_, | |
| financiali4_.zip_code as zip_cod19_147_3_, | |
| village5_.id as id1_171_4_, | |
| village5_.name as name2_171_4_, | |
| village5_.category as category3_171_4_, | |
| village5_.cell_id as cell_id4_171_4_, | |
| cell6_.id as id1_163_5_, | |
| cell6_.name as name2_163_5_, | |
| cell6_.sector_id as sector_i3_163_5_, | |
| sector7_.id as id1_168_6_, | |
| sector7_.name as name2_168_6_, | |
| sector7_.district_id as district3_168_6_, | |
| district8_.id as id1_165_7_, | |
| district8_.name as name2_165_7_, | |
| district8_.province_id as province3_165_7_, | |
| province9_.id as id1_167_8_, | |
| province9_.name as name2_167_8_, | |
| roles10_.user_id as user_id1_175_21_, | |
| role11_.id as role_id2_175_21_, | |
| role11_.id as id1_160_9_, | |
| role11_.created_at as created_2_160_9_, | |
| role11_.created_by_audit as created_3_160_9_, | |
| role11_.created_date as created_4_160_9_, | |
| role11_.last_modified_by as last_mod5_160_9_, | |
| role11_.last_modified_date as last_mod6_160_9_, | |
| role11_.state as state7_160_9_, | |
| role11_.updated_at as updated_8_160_9_, | |
| role11_.version as version9_160_9_, | |
| role11_.department as departm10_160_9_, | |
| role11_.description as descrip11_160_9_, | |
| role11_.role_name as role_na12_160_9_, | |
| user12_.id as id1_177_10_, | |
| user12_.created_at as created_2_177_10_, | |
| user12_.created_by_audit as created_3_177_10_, | |
| user12_.created_date as created_4_177_10_, | |
| user12_.last_modified_by as last_mod5_177_10_, | |
| user12_.last_modified_date as last_mod6_177_10_, | |
| user12_.state as state7_177_10_, | |
| user12_.updated_at as updated_8_177_10_, | |
| user12_.version as version9_177_10_, | |
| user12_.rra_reference_key as rra_ref10_177_10_, | |
| user12_.created_by as created41_177_10_, | |
| user12_.date_of_birth as date_of11_177_10_, | |
| user12_.department as departm12_177_10_, | |
| user12_.email as email13_177_10_, | |
| user12_.email_verification_code as email_v14_177_10_, | |
| user12_.failed_login_attempts as failed_15_177_10_, | |
| user12_.institution_id as institu42_177_10_, | |
| user12_.first_name as first_n16_177_10_, | |
| user12_.gender as gender17_177_10_, | |
| user12_.is_email_verified as is_emai18_177_10_, | |
| user12_.is_from_nida as is_from19_177_10_, | |
| user12_.is_locked as is_lock20_177_10_, | |
| user12_.is_phone_number_verified as is_phon21_177_10_, | |
| user12_.last_name as last_na22_177_10_, | |
| user12_.nationality as nationa23_177_10_, | |
| user12_.notification_preference as notific24_177_10_, | |
| user12_.password as passwor25_177_10_, | |
| user12_.password_reset_code as passwor26_177_10_, | |
| user12_.password_reset_code_expires_at as passwor27_177_10_, | |
| user12_.person_doc_expiry_date as person_28_177_10_, | |
| user12_.person_doc_issue_date as person_29_177_10_, | |
| user12_.person_doc_issue_place as person_30_177_10_, | |
| user12_.person_doc_no as person_31_177_10_, | |
| user12_.person_ident_type as person_32_177_10_, | |
| user12_.phone_number as phone_n33_177_10_, | |
| user12_.phone_verification_code as phone_v34_177_10_, | |
| user12_.user_category as user_ca35_177_10_, | |
| user12_.user_type as user_ty36_177_10_, | |
| user12_.username as usernam37_177_10_, | |
| user12_.valid_from as valid_f38_177_10_, | |
| user12_.valid_to as valid_t39_177_10_, | |
| user12_.verification_code_expires_at as verific40_177_10_, | |
| user13_.id as id1_177_11_, | |
| user13_.created_at as created_2_177_11_, | |
| user13_.created_by_audit as created_3_177_11_, | |
| user13_.created_date as created_4_177_11_, | |
| user13_.last_modified_by as last_mod5_177_11_, | |
| user13_.last_modified_date as last_mod6_177_11_, | |
| user13_.state as state7_177_11_, | |
| user13_.updated_at as updated_8_177_11_, | |
| user13_.version as version9_177_11_, | |
| user13_.rra_reference_key as rra_ref10_177_11_, | |
| user13_.created_by as created41_177_11_, | |
| user13_.date_of_birth as date_of11_177_11_, | |
| user13_.department as departm12_177_11_, | |
| user13_.email as email13_177_11_, | |
| user13_.email_verification_code as email_v14_177_11_, | |
| user13_.failed_login_attempts as failed_15_177_11_, | |
| user13_.institution_id as institu42_177_11_, | |
| user13_.first_name as first_n16_177_11_, | |
| user13_.gender as gender17_177_11_, | |
| user13_.is_email_verified as is_emai18_177_11_, | |
| user13_.is_from_nida as is_from19_177_11_, | |
| user13_.is_locked as is_lock20_177_11_, | |
| user13_.is_phone_number_verified as is_phon21_177_11_, | |
| user13_.last_name as last_na22_177_11_, | |
| user13_.nationality as nationa23_177_11_, | |
| user13_.notification_preference as notific24_177_11_, | |
| user13_.password as passwor25_177_11_, | |
| user13_.password_reset_code as passwor26_177_11_, | |
| user13_.password_reset_code_expires_at as passwor27_177_11_, | |
| user13_.person_doc_expiry_date as person_28_177_11_, | |
| user13_.person_doc_issue_date as person_29_177_11_, | |
| user13_.person_doc_issue_place as person_30_177_11_, | |
| user13_.person_doc_no as person_31_177_11_, | |
| user13_.person_ident_type as person_32_177_11_, | |
| user13_.phone_number as phone_n33_177_11_, | |
| user13_.phone_verification_code as phone_v34_177_11_, | |
| user13_.user_category as user_ca35_177_11_, | |
| user13_.user_type as user_ty36_177_11_, | |
| user13_.username as usernam37_177_11_, | |
| user13_.valid_from as valid_f38_177_11_, | |
| user13_.valid_to as valid_t39_177_11_, | |
| user13_.verification_code_expires_at as verific40_177_11_, | |
| incomestat14_.id as id1_23_12_, | |
| incomestat14_.created_at as created_2_23_12_, | |
| incomestat14_.created_by_audit as created_3_23_12_, | |
| incomestat14_.created_date as created_4_23_12_, | |
| incomestat14_.last_modified_by as last_mod5_23_12_, | |
| incomestat14_.last_modified_date as last_mod6_23_12_, | |
| incomestat14_.state as state7_23_12_, | |
| incomestat14_.updated_at as updated_8_23_12_, | |
| incomestat14_.version as version9_23_12_, | |
| incomestat14_.rra_reference_key as rra_ref10_23_12_, | |
| incomestat14_.administrative_expenses as adminis11_23_12_, | |
| incomestat14_.annual_return_id as annual_23_23_12_, | |
| incomestat14_.cost_of_sales as cost_of12_23_12_, | |
| incomestat14_.created_by as created24_23_12_, | |
| incomestat14_.finance_costs as finance13_23_12_, | |
| incomestat14_.gross_profit as gross_p14_23_12_, | |
| incomestat14_.income_tax as income_15_23_12_, | |
| incomestat14_.investment_income as investm16_23_12_, | |
| incomestat14_.net_profit_for_the_year as net_pro17_23_12_, | |
| incomestat14_.other_comprehensive_income as other_c18_23_12_, | |
| incomestat14_.other_expenses as other_e19_23_12_, | |
| incomestat14_.profit_before_task as profit_20_23_12_, | |
| incomestat14_.selling_and_distribution_expenses as selling21_23_12_, | |
| incomestat14_.turn_over as turn_ov22_23_12_, | |
| user15_.id as id1_177_13_, | |
| user15_.created_at as created_2_177_13_, | |
| user15_.created_by_audit as created_3_177_13_, | |
| user15_.created_date as created_4_177_13_, | |
| user15_.last_modified_by as last_mod5_177_13_, | |
| user15_.last_modified_date as last_mod6_177_13_, | |
| user15_.state as state7_177_13_, | |
| user15_.updated_at as updated_8_177_13_, | |
| user15_.version as version9_177_13_, | |
| user15_.rra_reference_key as rra_ref10_177_13_, | |
| user15_.created_by as created41_177_13_, | |
| user15_.date_of_birth as date_of11_177_13_, | |
| user15_.department as departm12_177_13_, | |
| user15_.email as email13_177_13_, | |
| user15_.email_verification_code as email_v14_177_13_, | |
| user15_.failed_login_attempts as failed_15_177_13_, | |
| user15_.institution_id as institu42_177_13_, | |
| user15_.first_name as first_n16_177_13_, | |
| user15_.gender as gender17_177_13_, | |
| user15_.is_email_verified as is_emai18_177_13_, | |
| user15_.is_from_nida as is_from19_177_13_, | |
| user15_.is_locked as is_lock20_177_13_, | |
| user15_.is_phone_number_verified as is_phon21_177_13_, | |
| user15_.last_name as last_na22_177_13_, | |
| user15_.nationality as nationa23_177_13_, | |
| user15_.notification_preference as notific24_177_13_, | |
| user15_.password as passwor25_177_13_, | |
| user15_.password_reset_code as passwor26_177_13_, | |
| user15_.password_reset_code_expires_at as passwor27_177_13_, | |
| user15_.person_doc_expiry_date as person_28_177_13_, | |
| user15_.person_doc_issue_date as person_29_177_13_, | |
| user15_.person_doc_issue_place as person_30_177_13_, | |
| user15_.person_doc_no as person_31_177_13_, | |
| user15_.person_ident_type as person_32_177_13_, | |
| user15_.phone_number as phone_n33_177_13_, | |
| user15_.phone_verification_code as phone_v34_177_13_, | |
| user15_.user_category as user_ca35_177_13_, | |
| user15_.user_type as user_ty36_177_13_, | |
| user15_.username as usernam37_177_13_, | |
| user15_.valid_from as valid_f38_177_13_, | |
| user15_.valid_to as valid_t39_177_13_, | |
| user15_.verification_code_expires_at as verific40_177_13_, | |
| user16_.id as id1_177_14_, | |
| user16_.created_at as created_2_177_14_, | |
| user16_.created_by_audit as created_3_177_14_, | |
| user16_.created_date as created_4_177_14_, | |
| user16_.last_modified_by as last_mod5_177_14_, | |
| user16_.last_modified_date as last_mod6_177_14_, | |
| user16_.state as state7_177_14_, | |
| user16_.updated_at as updated_8_177_14_, | |
| user16_.version as version9_177_14_, | |
| user16_.rra_reference_key as rra_ref10_177_14_, | |
| user16_.created_by as created41_177_14_, | |
| user16_.date_of_birth as date_of11_177_14_, | |
| user16_.department as departm12_177_14_, | |
| user16_.email as email13_177_14_, | |
| user16_.email_verification_code as email_v14_177_14_, | |
| user16_.failed_login_attempts as failed_15_177_14_, | |
| user16_.institution_id as institu42_177_14_, | |
| user16_.first_name as first_n16_177_14_, | |
| user16_.gender as gender17_177_14_, | |
| user16_.is_email_verified as is_emai18_177_14_, | |
| user16_.is_from_nida as is_from19_177_14_, | |
| user16_.is_locked as is_lock20_177_14_, | |
| user16_.is_phone_number_verified as is_phon21_177_14_, | |
| user16_.last_name as last_na22_177_14_, | |
| user16_.nationality as nationa23_177_14_, | |
| user16_.notification_preference as notific24_177_14_, | |
| user16_.password as passwor25_177_14_, | |
| user16_.password_reset_code as passwor26_177_14_, | |
| user16_.password_reset_code_expires_at as passwor27_177_14_, | |
| user16_.person_doc_expiry_date as person_28_177_14_, | |
| user16_.person_doc_issue_date as person_29_177_14_, | |
| user16_.person_doc_issue_place as person_30_177_14_, | |
| user16_.person_doc_no as person_31_177_14_, | |
| user16_.person_ident_type as person_32_177_14_, | |
| user16_.phone_number as phone_n33_177_14_, | |
| user16_.phone_verification_code as phone_v34_177_14_, | |
| user16_.user_category as user_ca35_177_14_, | |
| user16_.user_type as user_ty36_177_14_, | |
| user16_.username as usernam37_177_14_, | |
| user16_.valid_from as valid_f38_177_14_, | |
| user16_.valid_to as valid_t39_177_14_, | |
| user16_.verification_code_expires_at as verific40_177_14_, | |
| financials17_.id as id1_12_15_, | |
| financials17_.created_at as created_2_12_15_, | |
| financials17_.created_by_audit as created_3_12_15_, | |
| financials17_.created_date as created_4_12_15_, | |
| financials17_.last_modified_by as last_mod5_12_15_, | |
| financials17_.last_modified_date as last_mod6_12_15_, | |
| financials17_.state as state7_12_15_, | |
| financials17_.updated_at as updated_8_12_15_, | |
| financials17_.version as version9_12_15_, | |
| financials17_.rra_reference_key as rra_ref10_12_15_, | |
| financials17_.bank as bank11_12_15_, | |
| financials17_.biological_assets as biologi12_12_15_, | |
| financials17_.cash as cash13_12_15_, | |
| financials17_.created_by as created24_12_15_, | |
| financials17_.deferred_tax_assets as deferre14_12_15_, | |
| financials17_.financial_position_statement as financi25_12_15_, | |
| financials17_.intangible_assets as intangi15_12_15_, | |
| financials17_.inventory as invento16_12_15_, | |
| financials17_.investment as investm17_12_15_, | |
| financials17_.others as others18_12_15_, | |
| financials17_.property_plant_and_equipment as propert19_12_15_, | |
| financials17_.receivables as receiva20_12_15_, | |
| financials17_.total_assets as total_a21_12_15_, | |
| financials17_.total_current_assets as total_c22_12_15_, | |
| financials17_.total_non_current_assets as total_n23_12_15_, | |
| user18_.id as id1_177_16_, | |
| user18_.created_at as created_2_177_16_, | |
| user18_.created_by_audit as created_3_177_16_, | |
| user18_.created_date as created_4_177_16_, | |
| user18_.last_modified_by as last_mod5_177_16_, | |
| user18_.last_modified_date as last_mod6_177_16_, | |
| user18_.state as state7_177_16_, | |
| user18_.updated_at as updated_8_177_16_, | |
| user18_.version as version9_177_16_, | |
| user18_.rra_reference_key as rra_ref10_177_16_, | |
| user18_.created_by as created41_177_16_, | |
| user18_.date_of_birth as date_of11_177_16_, | |
| user18_.department as departm12_177_16_, | |
| user18_.email as email13_177_16_, | |
| user18_.email_verification_code as email_v14_177_16_, | |
| user18_.failed_login_attempts as failed_15_177_16_, | |
| user18_.institution_id as institu42_177_16_, | |
| user18_.first_name as first_n16_177_16_, | |
| user18_.gender as gender17_177_16_, | |
| user18_.is_email_verified as is_emai18_177_16_, | |
| user18_.is_from_nida as is_from19_177_16_, | |
| user18_.is_locked as is_lock20_177_16_, | |
| user18_.is_phone_number_verified as is_phon21_177_16_, | |
| user18_.last_name as last_na22_177_16_, | |
| user18_.nationality as nationa23_177_16_, | |
| user18_.notification_preference as notific24_177_16_, | |
| user18_.password as passwor25_177_16_, | |
| user18_.password_reset_code as passwor26_177_16_, | |
| user18_.password_reset_code_expires_at as passwor27_177_16_, | |
| user18_.person_doc_expiry_date as person_28_177_16_, | |
| user18_.person_doc_issue_date as person_29_177_16_, | |
| user18_.person_doc_issue_place as person_30_177_16_, | |
| user18_.person_doc_no as person_31_177_16_, | |
| user18_.person_ident_type as person_32_177_16_, | |
| user18_.phone_number as phone_n33_177_16_, | |
| user18_.phone_verification_code as phone_v34_177_16_, | |
| user18_.user_category as user_ca35_177_16_, | |
| user18_.user_type as user_ty36_177_16_, | |
| user18_.username as usernam37_177_16_, | |
| user18_.valid_from as valid_f38_177_16_, | |
| user18_.valid_to as valid_t39_177_16_, | |
| user18_.verification_code_expires_at as verific40_177_16_, | |
| financials19_.id as id1_15_17_, | |
| financials19_.created_at as created_2_15_17_, | |
| financials19_.created_by_audit as created_3_15_17_, | |
| financials19_.created_date as created_4_15_17_, | |
| financials19_.last_modified_by as last_mod5_15_17_, | |
| financials19_.last_modified_date as last_mod6_15_17_, | |
| financials19_.state as state7_15_17_, | |
| financials19_.updated_at as updated_8_15_17_, | |
| financials19_.version as version9_15_17_, | |
| financials19_.rra_reference_key as rra_ref10_15_17_, | |
| financials19_.created_by as created28_15_17_, | |
| financials19_.current_tax_payable as current11_15_17_, | |
| financials19_.deferred_tax_liability as deferre12_15_17_, | |
| financials19_.financial_position_statement as financi29_15_17_, | |
| financials19_.long_term_borrowings as long_te13_15_17_, | |
| financials19_.other_current_liabilities as other_c14_15_17_, | |
| financials19_.other_non_current_liabilities as other_n15_15_17_, | |
| financials19_.payables as payable16_15_17_, | |
| financials19_.reserves as reserve17_15_17_, | |
| financials19_.retained_earnings as retaine18_15_17_, | |
| financials19_.revaluation_reserves as revalua19_15_17_, | |
| financials19_.share_capital as share_c20_15_17_, | |
| financials19_.share_premium as share_p21_15_17_, | |
| financials19_.short_term_borrowings as short_t22_15_17_, | |
| financials19_.total_current_liabilities as total_c23_15_17_, | |
| financials19_.total_equity_and_liabilities as total_e24_15_17_, | |
| financials19_.total_liabilities as total_l25_15_17_, | |
| financials19_.total_long_term_liabilities as total_l26_15_17_, | |
| financials19_.total_shareholder_equity as total_s27_15_17_, | |
| user20_.id as id1_177_18_, | |
| user20_.created_at as created_2_177_18_, | |
| user20_.created_by_audit as created_3_177_18_, | |
| user20_.created_date as created_4_177_18_, | |
| user20_.last_modified_by as last_mod5_177_18_, | |
| user20_.last_modified_date as last_mod6_177_18_, | |
| user20_.state as state7_177_18_, | |
| user20_.updated_at as updated_8_177_18_, | |
| user20_.version as version9_177_18_, | |
| user20_.rra_reference_key as rra_ref10_177_18_, | |
| user20_.created_by as created41_177_18_, | |
| user20_.date_of_birth as date_of11_177_18_, | |
| user20_.department as departm12_177_18_, | |
| user20_.email as email13_177_18_, | |
| user20_.email_verification_code as email_v14_177_18_, | |
| user20_.failed_login_attempts as failed_15_177_18_, | |
| user20_.institution_id as institu42_177_18_, | |
| user20_.first_name as first_n16_177_18_, | |
| user20_.gender as gender17_177_18_, | |
| user20_.is_email_verified as is_emai18_177_18_, | |
| user20_.is_from_nida as is_from19_177_18_, | |
| user20_.is_locked as is_lock20_177_18_, | |
| user20_.is_phone_number_verified as is_phon21_177_18_, | |
| user20_.last_name as last_na22_177_18_, | |
| user20_.nationality as nationa23_177_18_, | |
| user20_.notification_preference as notific24_177_18_, | |
| user20_.password as passwor25_177_18_, | |
| user20_.password_reset_code as passwor26_177_18_, | |
| user20_.password_reset_code_expires_at as passwor27_177_18_, | |
| user20_.person_doc_expiry_date as person_28_177_18_, | |
| user20_.person_doc_issue_date as person_29_177_18_, | |
| user20_.person_doc_issue_place as person_30_177_18_, | |
| user20_.person_doc_no as person_31_177_18_, | |
| user20_.person_ident_type as person_32_177_18_, | |
| user20_.phone_number as phone_n33_177_18_, | |
| user20_.phone_verification_code as phone_v34_177_18_, | |
| user20_.user_category as user_ca35_177_18_, | |
| user20_.user_type as user_ty36_177_18_, | |
| user20_.username as usernam37_177_18_, | |
| user20_.valid_from as valid_f38_177_18_, | |
| user20_.valid_to as valid_t39_177_18_, | |
| user20_.verification_code_expires_at as verific40_177_18_ | |
| from | |
| ar_financial_position_statement financialp0_ | |
| inner join | |
| ar_annual_return annualretu1_ | |
| on financialp0_.annual_return_id=annualretu1_.id | |
| left outer join | |
| users user2_ | |
| on annualretu1_.assigned_approver=user2_.id | |
| left outer join | |
| mtg_financial_institution financiali3_ | |
| on user2_.institution_id=financiali3_.id | |
| left outer join | |
| mtg_financial_institution_address financiali4_ | |
| on financiali3_.financial_institution_address=financiali4_.id | |
| left outer join | |
| stc_village village5_ | |
| on financiali4_.village_id=village5_.id | |
| left outer join | |
| stc_cell cell6_ | |
| on village5_.cell_id=cell6_.id | |
| left outer join | |
| stc_sector sector7_ | |
| on cell6_.sector_id=sector7_.id | |
| left outer join | |
| stc_district district8_ | |
| on sector7_.district_id=district8_.id | |
| left outer join | |
| stc_province province9_ | |
| on district8_.province_id=province9_.id | |
| left outer join | |
| user_role roles10_ | |
| on user2_.id=roles10_.user_id | |
| left outer join | |
| role role11_ | |
| on roles10_.role_id=role11_.id | |
| left outer join | |
| users user12_ | |
| on annualretu1_.assigned_verifier=user12_.id | |
| left outer join | |
| users user13_ | |
| on annualretu1_.created_by=user13_.id | |
| left outer join | |
| ar_income_statement incomestat14_ | |
| on annualretu1_.id=incomestat14_.annual_return_id | |
| left outer join | |
| users user15_ | |
| on incomestat14_.created_by=user15_.id | |
| inner join | |
| users user16_ | |
| on financialp0_.created_by=user16_.id | |
| left outer join | |
| ar_asset_detail financials17_ | |
| on financialp0_.id=financials17_.financial_position_statement | |
| left outer join | |
| users user18_ | |
| on financials17_.created_by=user18_.id | |
| left outer join | |
| ar_equity_and_liabilities financials19_ | |
| on financialp0_.id=financials19_.financial_position_statement | |
| left outer join | |
| users user20_ | |
| on financials19_.created_by=user20_.id | |
| where | |
| financialp0_.annual_return_id=? | |
| 2025-04-14 15:20:28.866 TRACE 536 --- [nio-8051-exec-1] o.h.type.descriptor.sql.BasicBinder : binding parameter [1] as [OTHER] - [48b7d495-efd6-4798-a0ca-46a1544d74f5] | |
| 2025-04-14 15:20:28.879 WARN 536 --- [nio-8051-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 0, SQLState: 42883 | |
| 2025-04-14 15:20:28.879 ERROR 536 --- [nio-8051-exec-1] o.h.engine.jdbc.spi.SqlExceptionHelper : ERROR: operator does not exist: character varying = uuid | |
| Hint: No operator matches the given name and argument types. You might need to add explicit type casts. | |
| Position: 23032 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment