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 STOCK_MANAGEMENT_TYPE = 1
order by ITEM_CODE,
        CL_CODE,
        SIZE_CODE
;