SELECT a.*,
  b.*
FROM
  (SELECT wo.plan_start_time,
    wo.description,
    bt.first_name|| ' '|| bt.last_name AS customer,
    L.SHORT_NAME,
    l.street_name,
    l.street_nr,
    L.CITY,
    BT.PHONE,
    bt.msisdn
  FROM work_order wo, mfc_customer c, business_tier bt, location l
  WHERE wo.mfc_customer_id=c.mfc_customer_id(+)
  AND c.business_tier_id=bt.business_tier_id(+)
  AND wo.location_id=l.location_id(+)
  AND wo.work_order_id =
   ( SELECT work_order_id FROM form WHERE form_id = 99975)
  ) b
LEFT OUTER JOIN
  (SELECT
   ( SELECT creation_date FROM form  WHERE form_id = 99975
    )AS creation_date,
    ( SELECT SUBMIT_DATE FROM form  WHERE form_id = 99975
    ) AS submit_date,
    (SELECT (SELECT field_data
    FROM form_data
    WHERE FORM_TYPE_FIELD_ID= 2209
    AND form_id             = 99975)
    FROM dual
    ) AS work_done_boolean,
    (SELECT b.first_name|| ' '|| b.last_name AS mw_name
    FROM form f
    LEFT OUTER JOIN mw_event me
    ON F.MW_EVENT_ID = ME.MW_EVENT_ID
    LEFT OUTER JOIN mfc_mobile_worker mw
    ON ME.MFC_MOBILE_WORKER_ID = MW.MFC_MOBILE_WORKER_ID
    LEFT OUTER JOIN business_tier b
    ON MW.BUSINESS_TIER_ID = B.BUSINESS_TIER_ID
    WHERE f.form_id        = 99975
    ) AS mw_name,
    ( SELECT COUNT (1)
    FROM attached_doc
    WHERE LOWER(name) LIKE '%picture%'
    AND form_id = 99975
    ) picture_count,
    (SELECT attach_doc_id
    FROM attached_doc
    WHERE LOWER(name)  LIKE '%signature%'
    AND form_id = 99975
    ) AS signature,
    (SELECT field_data
    FROM form_data
    WHERE FORM_TYPE_FIELD_ID= 2235
    AND form_id             = 99975
    ) AS OTNumber,
    (SELECT (SELECT field_data
    FROM form_data
    WHERE FORM_TYPE_FIELD_ID= 2234
    AND form_id             = 99975)
    FROM dual
    ) AS TimePassed,
    ( SELECT (SELECT field_data
    FROM form_data
    WHERE FORM_TYPE_FIELD_ID= 2207
    AND form_id             = 99975)
    FROM dual
    ) AS identification,
    (SELECT (SELECT field_data
    FROM form_data
    WHERE FORM_TYPE_FIELD_ID= 2208
    AND form_id             = 99975)
    FROM dual
    ) AS data_limite,
    (SELECT (SELECT field_data
    FROM form_data
    WHERE FORM_TYPE_FIELD_ID= 2205
    AND form_id             = 99975)
    FROM dual
    ) AS work_done,
    (SELECT REGEXP_SUBSTR(field_data, '[^;]*', 1, 1)FROM dual) AS Material,
    RTRIM ( REGEXP_SUBSTR(field_data, '[^;]*;', 1, 2), ';') Unit,
    REGEXP_SUBSTR(field_data
    || ';', '[^;]+', 1, 3) Quantity
  FROM form_data
WHERE lnnvl(FORM_TYPE_FIELD_ID=2206)
AND form_id= 99975
  ) a
  ON 1 = 1;