R12 TEDARİKÇİ BANKA HESAP SORGULARI
Merhaba,
Aşağıdaki iki sorgu tedarikçinin kendisine ve işletme birimlerine ait banka hesaplarını bulmak için kullanabilirsiniz.
Tedarikçi Seviyesi İçin
1 2 3 4 5 6 7 8 9 10 11 12 |
SELECT APS.VENDOR_NAME, IEB.BANK_aCCOUNT_NUM, IEB.IBAN FROM AP_SUPPLIERS APS, HZ_PARTIES HP, IBY_EXTERNAL_PAYEES_ALL IEP, IBY_PMT_INSTR_USES_ALL USES, IBY_EXT_bANK_ACCOUNTS IEB WHERE HP.PARTY_ID = APS.PARTY_ID AND IEP.PAYEE_PARTY_ID = HP.PARTY_ID AND USES.EXT_PMT_PARTY_ID = IEP.EXT_PAYEE_ID AND USES.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID |
Tedarikçi İşletme Birimi Seviyesi İçin
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
SELECT APS.VENDOR_NAME, ASS.VENDOR_SITE_CODE, IEB.BANK_aCCOUNT_NUM, IEB.IBAN FROM AP_SUPPLIERS APS, AP_SUPPLIER_SITES_ALL ASS, HZ_PARTIES HP, IBY_EXTERNAL_PAYEES_ALL IEP, IBY_PMT_INSTR_USES_ALL USES, HZ_PARTY_SITES HPS, IBY_EXT_bANK_ACCOUNTS IEB WHERE APS.VENDOR_ID = ASS.VENDOR_ID AND HP.PARTY_ID = APS.PARTY_ID AND IEP.PAYEE_PARTY_ID = HP.PARTY_ID AND USES.EXT_PMT_PARTY_ID = IEP.EXT_PAYEE_ID AND HP.PARTY_ID = HPS.PARTY_ID AND IEP.PARTY_SITE_ID = HPS.PARTY_SITE_ID AND IEP.SUPPLIER_SITE_ID = ASS.VENDOR_SITE_ID AND USES.INSTRUMENT_ID = IEB.EXT_BANK_ACCOUNT_ID |