iProcurement Catalogs Linked to Stores

select   
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, 
icst.store_name linked_to_store  
    
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  
   
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(+)  

order by 
haout.name, 
icst.store_name, 
icsb.sequence_number