Query consulta cuentas bancarias
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;
Javier Huerta Navas
@xhuertax
Latest posts by Javier Huerta Navas (see all)
- Oracle webinar with KPMG: Plan and adapt your… - January 20, 2021
- Oracle Spain: Christmas time together thanks to… - December 18, 2020
- The rise of supply chain viability - December 9, 2020
Hola podrias ayudarme.!!
una query de oracle me da un plano cartesiano y no puedo resolverlo me urge por favor me aserco a ti por que eres un experto en oracle