Для получения списка расчетных счетов поставщиков используем следующий запрос
SELECT party_supp.party_name supplier_name ,aps.segment1 supplier_number ,ass.vendor_site_code supplier_site ,ieb.bank_account_num bank_account_num ,ieb.bank_account_name bank_account_name ,party_bank.party_name bank_name ,branch_prof.bank_or_branch_number bank_number ,party_branch.party_name branch_name ,branch_prof.bank_or_branch_number branch_number FROM hz_parties party_supp ,ap_suppliers aps ,hz_party_sites site_supp ,ap_supplier_sites_all ass ,iby_external_payees_all iep ,iby_pmt_instr_uses_all ipi ,iby_ext_bank_accounts ieb ,hz_parties party_bank ,hz_parties party_branch ,hz_organization_profiles bank_prof ,hz_organization_profiles branch_prof WHERE party_supp.party_id = aps.party_id AND party_supp.party_id = site_supp.party_id AND site_supp.party_site_id = ass.party_site_id AND ass.vendor_id = aps.vendor_id AND iep.payee_party_id = party_supp.party_id AND iep.party_site_id = site_supp.party_site_id AND iep.supplier_site_id = ass.vendor_site_id AND iep.ext_payee_id = ipi.ext_pmt_party_id AND ipi.instrument_id = ieb.ext_bank_account_id AND ieb.bank_id = party_bank.party_id AND ieb.branch_id = party_branch.party_id AND party_branch.party_id = branch_prof.party_id AND party_bank.party_id = bank_prof.party_id ORDER BY party_supp.party_name, ass.vendor_site_code;
Последние комментарии