/*
Name:		sql2.

Date:		April 13 2005.

Purpose:	Illustrate real world problem. 

*/
SELECT
    count(*)
FROM
    docs d,
    tasks tk,
    workflow wf,
    trans t
WHERE
    TK.TK_status IN(2,16)
    AND TK.TK_activity = 'APPROVE'
    AND TK.tk_wfid = wf.wf_id
    AND wf.wf_status IN(2,4)
    AND wf.wf_docid = d.docid
    AND TO_CHAR(t.transno) = d.doc_transno
    AND t.company = 'C1'
    AND t.line# = d.doc_line#
    AND t.treatment_code = '7'
    AND d.doc_extref = 'C1;7;'||d.doc_transno||';'||TO_CHAR(d.doc_line#)
/