Payment Method Code at Supplier and Supplier Site Level in R12

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

SELECT
    supp.segment1 supplier_num,
    paym.payment_method_code
FROM
    ap_suppliers supp,
    iby_external_payees_all payee,
    iby_ext_party_pmt_mthds paym
WHERE
           supp.party_id = payee.payee_party_id
    AND    payee.ext_payee_id = paym.ext_pmt_party_id
    AND    supp.segment1 =:supplier_num
    AND    supplier_site_id IS NULL
    AND    paym.primary_flag = 'Y';

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

SELECT
    supp.segment1 supplier_num,
    sites.vendor_site_code,
    paym.payment_method_code
FROM
    ap_suppliers supp,
    ap_supplier_sites_all sites,
    iby_external_payees_all payee,
    iby_ext_party_pmt_mthds paym
WHERE
           supp.party_id = payee.payee_party_id
    AND    payee.ext_payee_id = paym.ext_pmt_party_id
    AND    supp.segment1 =:supplier_num
    AND    supp.vendor_id = sites.vendor_id
    AND    sites.vendor_site_id = payee.supplier_site_id
    AND    paym.primary_flag = 'Y';