select
  item_code as ITEM
  , item_name as i_name
  , cl_name as C_NAME
  , size_name as S_NAME
from
  item
  cross join color_tbl
  cross join size_tbl
where
  STOCK_MANAGEMENT_TYPE = 1
order by
  item_code
  , cl_code
  , size_code