Query to find Suppliers/ Sites with 'Receipt' match option.

SELECT

aps.vendor_id,

aps.vendor_name,

DECODE(aps.match_option,’P’,’Purchase Order’,’R’,’Receipt’) match_option_suppiers,

apssa.vendor_site_id,

DECODE(apssa.match_option,’P’,’Purchase Order’,’R’,’Receipt’)
match_option_suppier_sites

FROM

apps.ap_suppliers aps,

apps.ap_supplier_sites_all apssa

WHERE aps.vendor_id = apssa.vendor_id

AND aps.match_option = ‘R’

AND apssa.match_option = ‘R’

AND purchasing_site_flag IS NOT NULL;

Doyensys

A technology service company that provides innovative solutions around the oracle platform With Laser focus on customer delight as the primary success parameter.