iProcurement Catalogs Lined to Suppliers Query

select distinct 
haout.NAME hr_org,
ipist.item_source_name catalog_name, 
DECODE(ipis.TYPE,'LOCAL','Local','INFO','Informational') TYPE,
ipist.description cat_description, 
ipis.url catalog_url,
pv.vendor_name linked_supplier  

from 
icx.icx_cat_stores_tl icst,
icx.icx_cat_stores_b icsb, 
applsys.fnd_user fu, 
hr.hr_all_organization_units_tl haout, 
icx.icx_cat_store_org_assignments icsoa, 
icx.icx_cat_store_catalogs icsc, 
icx.icx_por_item_sources ipis, 
icx.icx_por_item_sources_tl ipist, 
icx.icx_cat_item_src_details icisd, 
apps.po_vendors pv  
          
where 
icst.store_id = icsb.store_id  
and icst.created_by = fu.user_id  
and icsoa.store_id = icst.store_id  
and icsc.store_id = icst.store_id  
and icsoa.org_id = haout.organization_id(+)  
and ipist.item_source_id = icsc.item_source_id(+)  
and ipis.item_source_id = ipist.item_source_id  
and ipist.item_source_id = icisd.item_source_id(+)  
and icisd.supplier_id = pv.vendor_id(+)  
and ipis.TYPE IN('INFO', 'LOCAL')  
       
order by
1, 
2, 
pv.vendor_name;