WITH I AS (
  SELECT
    ITEM_CODE AS ITEM,
    ITEM_NAME AS I_NAME
  FROM
    ITEM
  WHERE
    STOCK_MANAGEMENT_TYPE = 1
)
, C AS (
  SELECT
    CL_NAME AS C_NAME
  FROM 
    COLOR_TBL
)
, S AS (
  SELECT
    SIZE_NAME AS S_NAME
  FROM
    SIZE_TBL
)
SELECT
  I.ITEM,
  I.I_NAME,
  C.C_NAME,
  S.S_NAME
FROM
  I
CROSS JOIN
  C
CROSS JOIN
  S
;