SELECT
    XMLELEMENT("Item",
      XMLELEMENT("ItemName",ic.item_name),
      XMLELEMENT("ItemFacilityWMSList",
        XMLELEMENT("ItemFacilityWMS",
          XMLELEMENT("FacilityName",'DTC'),
          XMLELEMENT("ExtendedAttributes", XMLAttributes('slotting' AS "Module"),
            XMLELEMENT("SlotItemStatus", t.status),
            XMLELEMENT("SlotStatusDate", t.statusdate)
            )
          )
        )
      ) AS xml_tags,
    t.*, ifs.*
FROM  item_cbo ic,
      item_facility_slotting ifs,
      ( SELECT 'N' status, '06/09/2019' statusdate FROM dual
        UNION
        SELECT 'D', '12/09/2019' FROM dual  ) t
WHERE ifs.item_id = ic.item_id
  AND ic.volume_uom_id IS NOT NULL
  AND ic.item_id > 5000
ORDER BY ic.item_id;