SELECT I.ITEM_CODE ITEM
      ,I.ITEM_NAME I_NAME
      ,C.CL_NAME C_NAME
      ,S.SIZE_NAME S_NAME
  FROM ITEM I
      ,COLOR_TBL C
      ,SIZE_TBL S
 WHERE I.STOCK_MANAGEMENT_TYPE = '1'
 ORDER BY I.ITEM_CODE,C.CL_CODE,S.SIZE_CODE
;