select
  I.ITEM_CODE as "ITEM"
 ,I.ITEM_NAME as "I_NAME"
 ,CT.CL_NAME as "C_NAME"
 ,ST.SIZE_NAME as "S_NAME"
from
  ITEM I
 ,COLOR_TBL CT
 ,SIZE_TBL ST
where
 I.STOCK_MANAGEMENT_TYPE = 1
order by
 I.ITEM_CODE asc, CT.CL_CODE asc, ST.SIZE_CODE
;