Payment Method Code at Supplier and Supplier Site Level in R12

1) Payment Method Code at Supplier Level
 

 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';

2) Payment Method Code at Supplier Site Level

 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';

 

Thanks Yogesh

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s