21 Jun 2013

Query consulta cuentas bancarias

Posted in Español, GL General Ledger By Javier Huerta Navas On June 21, 2013

Buenas,

Aprovecho para incluir dos queries para obtener las cuentas bancarias de proveedores y clientes:

———————————
— CUENTAS BANCARIAS —
———————————
Select

Ieb.Bank_Name “BANCO”,
Iebb.Bank_Branch_Name “OFICINA”,
Ieb.Bank_number “NUM BANCO”,
Iebb.Branch_Number “NUM SUCURSAL”,
Ieba.Check_Digits “D.C.”,
Ieba.Bank_Account_Num “NUM CUENTA BANCARIA”,
Ieba.Iban “IBAN”,
Ieba.Bank_Account_Name “NOMBRE CUENTA”

FROM apps.iby_ext_bank_accounts ieba,
apps.iby_ext_banks_v ieb,
Apps.Iby_Ext_Bank_Branches_V Iebb

WHERE ieb.bank_party_id = iebb.bank_party_id
and Ieba.Branch_Id = Iebb.Branch_Party_Id
and Ieba.Bank_Id = Ieb.Bank_Party

—————————-
— SUPPPLIER BANK ACCOUNT —
—————————-
SELECT aps.vendor_name “VERDOR NAME”,
apss.vendor_site_code “VENDOR SITE CODE”,
ieb.bank_name “BANK NAME”,
iebb.bank_branch_name “BANK BRANCH NAME”,
iebb.branch_number “BRANCH NUMBER”,
ieba.BANK_ACCOUNT_NUM “BANK ACCOUNT NUMBER”,
ieba.BANK_ACCOUNT_NAME “BANK ACCOUNT NAME”
FROM ap.ap_suppliers aps,
ap.ap_supplier_sites_all apss,
apps.iby_ext_bank_accounts ieba,
apps.iby_account_owners iao,
apps.iby_ext_banks_v ieb,
apps.iby_ext_bank_branches_v iebb
WHERE aps.vendor_id = apss.vendor_id
and iao.account_owner_party_id = aps.party_id
and ieba.ext_bank_account_id = iao.ext_bank_account_id
and ieb.bank_party_id = iebb.bank_party_id
and ieba.branch_id = iebb.branch_party_id
and ieba.bank_id = ieb.bank_party_id;