SQL

SELECT a.wf_state,
       b.oid,
       p.wf_user_id,
       p.error_no,
       1             item_followup,
       p.element_type,
       0             selected,
       p.version_no,
       p.p_description,
       p.s_description,
       p.proc_node_id,
       p.step_node_id,
       p.distr_type,
       f.project     vH8UEDV7G4L8LF69S9MDU361STQ,
       d.reg_period  vFMW6V8C6WMRLM8Q5E7AE9HFH6G,
       d.resource_id v6NJXKK021W7LFC7QVQ7XGXKLF8,
       d.last_update vQRKHFH40C1WLX78GLXPP10CAM4,
       a.used_hrs    vG3K0QF8FT6U4KA2QTCBXVGS0A8
FROM   awfenquiry p,
       atstsehourdet a,
       atstsegldetail c,
       atstseheader d,
       atschargecode e,
       atsproject f,
       atstsehourdetmap b
WHERE  1 = 1
       AND a.tsehourdet_id = b.tsehourdet_id
       AND a.tsegldetail_id = c.tsegldetail_id
       AND c.tseheader_id = d.tseheader_id
       AND c.chargecode_id = e.chargecode_id
       AND c.client = e.client
       AND e.client = f.client
       AND e.project = f.project
       AND ( a.wf_state = N'U'
              OR p.distr_type = N'U' )
       AND p.element_type = N'TS'
       AND a.client = N'GB'
       AND b.oid = p.oid