iProcurement Catalogs

select
ipist.item_source_name catalog_name,
pv.vendor_name supplier

from
icx_por_item_sources_tl ipist,
icx_cat_item_src_details icisd,
po_vendors pv

where
ipist.item_source_id = icisd.item_source_id
and icisd.supplier_id = pv.vendor_id;