SELECT CZ_ITEM_MASTERS.ITEM_TYPE_ID AS ITEM_TYPE_ID , CZ_ITEM_MASTERS.ITEM_ID AS ITEM_ID , TO_NUMBER(NULL) AS PROPERTY_ID , CZ_ITEM_TYPES.NAME AS ITEM_TYPE_NAME , CZ_ITEM_MASTERS.REF_PART_NBR AS ITEM_MASTER_NAME , TO_CHAR(NULL) AS PROPERTY_NAME , CZ_ITEM_MASTERS.REF_PART_NBR AS NAME , CZ_ITEM_MASTERS.DESC_TEXT AS DESC_TEXT , CZ_ITEM_MASTERS.QUOTEABLE_FLAG AS QUOTEABLE_FLAG , CZ_ITEM_MASTERS.PRIMARY_UOM_CODE AS PRIMARY_UOM_CODE FROM CZ_ITEM_MASTERS , CZ_ITEM_TYPES WHERE (CZ_ITEM_TYPES.ITEM_TYPE_ID=CZ_ITEM_MASTERS.ITEM_TYPE_ID) AND NVL (CZ_ITEM_MASTERS.DELETED_FLAG , '0') <> '1' AND NVL (CZ_ITEM_TYPES.DELETED_FLAG , '0') <> '1'