select psv.vendor_name, psv.segment1 "VendorNumber", ps.END_DATE_ACTIVE "SupplierEndDate", psv.enabled_flag, psv.business_relationship, psv.vendor_type_lookup_code, ps.creation_source, iep.REMIT_ADVICE_EMAIL, pss.vendor_site_code, pss.inactive_date "SiteEndDate"
from poz_suppliers ps,
poz_supplier_sites_all_m pss,
poz_suppliers_v psv,
hz_parties hp,
IBY_EXTERNAL_PAYEES_ALL iep
where hp.party_id = ps.party_id
and hp.party_id = psv.party_id
and ps.vendor_id = pss.vendor_id
and iep.supplier_site_id = pss.vendor_site_id
and iep.REMIT_ADVICE_EMAIL is not null
from poz_suppliers ps,
poz_supplier_sites_all_m pss,
poz_suppliers_v psv,
hz_parties hp,
IBY_EXTERNAL_PAYEES_ALL iep
where hp.party_id = ps.party_id
and hp.party_id = psv.party_id
and ps.vendor_id = pss.vendor_id
and iep.supplier_site_id = pss.vendor_site_id
and iep.REMIT_ADVICE_EMAIL is not null
Comments
Post a Comment