We have a requirement for fetching all the Attribute5 on the supplier site when we pass the supplier contact email as the only input. Currently we have achieved this using BIP, but looking for API based Approach to do the same.
SQL
-------------------------------------------
select
vs.ATTRIBUTE5 AS Supplier_Site_ID,
vs.VENDOR_SITE_CODE
from
poz_supplier_sites_all_m vs,
POZ_SUPPLIER_CONTACTS_V poc
where 1=1
and vs.VENDOR_SITE_ID = poc.VENDOR_SITE_ID
and vs.ATTRIBUTE5 is not null
and poc.email_address = :p_email
---------------------------------------------
Please check this sql and suggest any solution to do this in API based approach.