SELECT DISTINCT apss.pay_on_code por_supp_site
,pha.pay_on_code por_po
FROM ap_suppliers aps
,ap_supplier_sites_all apss
,po_headers_all pha
WHERE aps.vendor_id = apss.vendor_id
AND pha.vendor_id = apss.vendor_id
AND pha.vendor_site_id = apss.vendor_site_id
AND pha.segment1 = '1234567890' --- Purchase Order Number/LPO Number
No comments:
Post a Comment