Wednesday, January 13, 2016

To Get the Suppliers Payment Method

Define Payment methods are available in the following tables:
select * from IBY_APPLICABLE_PMT_MTHDS
where payment_method_code in
(select payment_method_code
 from iby_payment_methods_vl
 where payment_method_name = 'Payment Method Name'
);

To get the payment methods assigned to a certain supplier:
SELECT *
FROM fusion.iby_ext_party_pmt_mthds ieppm
WHERE ieppm.ext_pmt_party_id IN
    (SELECT iep.ext_payee_id
     FROM fusion.iby_external_payees_all iep
     WHERE 1 = 1
     and ieppm.Primary_flag = 'Y'
     AND iep.supplier_site_id IN
                    (SELECT pssa.vendor_site_id
                     FROM fusion.poz_supplier_sites_all_m pssa, fusion.poz_suppliers ps
                     WHERE ps.vendor_id = pssa.vendor_id
                     AND ps.party_id in (select party_id
                                         from hz_parties
                                         where party_name = 'xxxxx'
                                        )
                    )

    )

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect