To find supplier info

select

pov.vendor_id,

pov.vendor_name supplier,

pov.vendor_type_lookup_code,

sl.location_code shipto_location,

bl.location_code billto_location,

pov.customer_num,

pov.ship_via_lookup_code,

pov.fob_lookup_code,

rt.name terms,

pov.set_of_books_id,

pov.credit_status_lookup_code,

pov.credit_limit

from ra_terms rt,

hr_locations bl,

hr_locations sl,

po_vendors pov

where pov.vendor_name like 'AVIVA%'

and pov.ship_to_location_id=sl.location_id(+)

and pov.bill_to_location_id=bl.location_id(+)

and pov.terms_id=rt.term_id(+)

order by 1