iProcurement Stores

select
icst.store_name,
icsb.store_type,
icst.creation_date,
fu.description created_by,
icst.short_description,
icst.image_location,
icsb.sequence_number,
haout.name hr_org

from
icx_cat_stores_tl icst,
icx_cat_stores_b icsb,
fnd_user fu,
hr_all_organization_units_tl haout,
icx_cat_store_org_assignments icsoa

where
icst.store_id = icsb.store_id
and icst.created_by = fu.user_id
and icsoa.store_id = icst.store_id
and icsoa.org_id = haout.organization_id(+)

order by
icsb.sequence_number;