How to join a supplier site to a payment reason code

 Hi,

i need to find the payment reason code for a given supplier site.

I am using the belwo queries but this seems to be wrong ,can someone comment.

1.select * from ap_suppliers where vendor_id=456

2.select * from ap_supplier_sites_all where vendor_site_id=result from previous

3.select  PAYMENT_REASON_CODE  from IBY_EXTERNAL_PAYEES_ALL where SUPPLIER_SITE_ID=result from previous