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, pss.vendor_site_code, pss.inactive_date "SiteEndDate", pss.terms_id, at.name "Term"
from poz_suppliers ps,
poz_supplier_sites_all_m pss,
poz_suppliers_v psv,
hz_parties hp
,AP_TERMS_TL at
where hp.party_id = ps.party_id
and hp.party_id = psv.party_id
and ps.vendor_id = pss.vendor_id
and at.term_id(+) = pss.terms_id
and ps.vendor_TYPE_LOOKUP_CODE = 'SUPPLIER'
from poz_suppliers ps,
poz_supplier_sites_all_m pss,
poz_suppliers_v psv,
hz_parties hp
,AP_TERMS_TL at
where hp.party_id = ps.party_id
and hp.party_id = psv.party_id
and ps.vendor_id = pss.vendor_id
and at.term_id(+) = pss.terms_id
and ps.vendor_TYPE_LOOKUP_CODE = 'SUPPLIER'
Comments
Post a Comment