No subselect in explain plan

From: Alex Hillman <alex_hillman_at_physia.com>
Date: Tue, 12 Sep 2000 17:10:59 -0400
Message-Id: <10617.116766@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C01CFD.F3CD1300
Content-Type: text/plain;

        charset="iso-8859-1"

I do not see in explain plan any access to the tables in subselects which I use for columns. Anybody knows why. Oracle 8.1.6.2 on Solaris

Alex Hillman

OPERATIONS                                              OPTIONS
OBJECT_NAME             OBJECT_TYPE
------------------------------------------------------- ---------------
----------------------- ------------------------------
  --SELECT STATEMENT
    --SORT                                              ORDER BY
      --UNION-ALL
        --FILTER


          --NESTED LOOPS

            --TABLE ACCESS                              FULL
INVOICE
            --TABLE ACCESS                              BY INDEX ROWID
PERSON
              --INDEX                                   UNIQUE SCAN
PERSON_PK               UNIQUE
                --INDEX                                 RANGE SCAN
PERSON_ORG_CATEGORY_PK  UNIQUE


          --FILTER

            --TABLE ACCESS                              BY INDEX ROWID
PERSON_ATTRIBUTE
              --INDEX                                   RANGE SCAN
PERATTR_PARENT_ID       NON-UNIQUE
            --TABLE ACCESS                              BY INDEX ROWID
TRANSACTION
              --INDEX                                   UNIQUE SCAN
TRANSACTION_PK          UNIQUE


          --FILTER

            --NESTED LOOPS
              --TABLE ACCESS                            BY INDEX ROWID
INVOICE_BILLING
                --INDEX                                 UNIQUE SCAN
INVOICE_BILLING_PK      UNIQUE
              --TABLE ACCESS                            BY INDEX ROWID
PERSON_ATTRIBUTE
                --INDEX                                 RANGE SCAN
PERATTR_PARENT_ID       NON-UNIQUE
            --NESTED LOOPS
              --TABLE ACCESS                            BY INDEX ROWID
INSURANCE
                --INDEX                                 UNIQUE SCAN
INSURANCE_PK            UNIQUE
              --TABLE ACCESS                            BY INDEX ROWID
INSURANCE
                --INDEX                                 UNIQUE SCAN
INSURANCE_PK            UNIQUE


          --FILTER

            --TABLE ACCESS                              BY INDEX ROWID
PERSON_ATTRIBUTE
              --INDEX                                   RANGE SCAN
PERATTR_PARENT_ID       NON-UNIQUE
            --TABLE ACCESS                              BY INDEX ROWID
TRANSACTION
              --INDEX                                   UNIQUE SCAN
TRANSACTION_PK          UNIQUE


          --TABLE ACCESS                                BY INDEX ROWID

TRANSACTION
            --INDEX                                     RANGE SCAN
TRANS_INVOICE_ID        NON-UNIQUE
        --NESTED LOOPS


          --TABLE ACCESS                                FULL

TRANSACTION


          --TABLE ACCESS                                BY INDEX ROWID

INVOICE                 SELECT
p.person_id,i.invoice_id,i.balance,to_char(i.invoice_date,'MM/DD/YYYY') as invoice_date,

                                        to_number(NULL) as trans_id,NULL as reck_date,to_number(NULL) as reck_id,

					(
						select
min(to_char(e.start_time,'MM/DD/YYYY')) 
						from event e,
event_attribute ea
						where ea.value_text =
p.person_id
						and ea.item_name =
'Appointment' 
						and ea.value_type = 333
						and e.event_id  =
ea.parent_id
						and e.start_time -
to_date(:9,'MM/DD/YYYY') >=0			
					)as appt,

					(SELECT MIN(iia.comments) FROM
invoice_item_adjust iia WHERE parent_id =
					  (SELECT MIN(item_id) FROM
invoice_item ii WHERE ii.parent_id = i.invoice_id AND
					   ii.item_type in (0,1,2) )
					) as description

				FROM 	person p  ,invoice i 
				WHERE	upper(substr(p.name_last,1,1))
between upper(:1) 
				AND	upper(:2)
				AND	i.client_id = p.person_id
				AND	i.balance between (:3) 
				AND	(:4)
				AND	i.invoice_date between
to_date(:5,'MM/DD/YYYY')
				AND	to_date(:6,'MM/DD/YYYY')

				AND	i.invoice_status not in (15,16)

				AND EXISTS
				(
					SELECT 	1 
					FROM  	person_org_category poc
					WHERE 	p.person_id = poc.person_id
					AND	poc.org_internal_id = :7

				)
				AND EXISTS
				(
					SELECT 	1
					FROM 	person_attribute
					WHERE	item_name =
'WorkList-Collection-Setup-Org'
					AND	value_text = (select
service_facility_id FROM transaction
								WHERE
trans_id= i.main_transaction)
					AND 	parent_id = :8
					AND	parent_org_id = :7
				)
				AND EXISTS
				(	
					SELECT 	1
					FROM	person_attribute
pa,invoice_billing ib
					WHERE	pa.item_name =
'WorkList-Collection-Setup-Product'
					AND	i.billing_id = ib.bill_id
					AND 	parent_id = :8
					AND	pa.parent_org_id = :7

					AND	(
						ib.bill_party_type IN (0,1)
						OR
						EXISTS
						(
							SELECT 1 
						 	FROM 	insurance
coverage,insurance prod_plan 
						 	WHERE
ib.bill_ins_id = coverage.ins_internal_id
						 	AND
prod_plan.ins_internal_id = coverage.parent_ins_id
						 	AND	
						 	(
	
(prod_plan.ins_internal_id = pa.value_int AND prod_plan.record_type =1)
						 		OR
prod_plan.parent_ins_id = pa.value_int
							)

						 )
						)
				)
				AND EXISTS
				(
					SELECT 	1
					FROM	person_attribute
					WHERE	item_name =
'WorkList-Collection-Setup-Physician'
					AND	value_text = (select
provider_id FROM transaction
								WHERE
trans_id= i.main_transaction)
					AND 	parent_id = :8
					AND	parent_org_id = :7

				)

				AND NOT EXISTS
				(
					SELECT	1 
					FROM	transaction
					WHERE	trans_type = 9520
					AND 	trans_status = 2
					AND 	provider_id = :8
					AND	invoice_id = i.invoice_id

					AND 	invoice_id is not NULL
					AND	billing_facility_id = :7

				)	
				UNION ALL
				SELECT 	t.trans_owner_id as

person_id,i.invoice_id,i.balance,to_char(i.invoice_date,'MM/DD/YYYY') as invoice_date,

					t.trans_id,
					(	SELECT
to_char(trans_begin_stamp,'MM/DD/YYYY') 
						FROM 	transaction 
						WHERE 	trans_owner_id =
t.trans_owner_id
						AND 	trans_type = 9510 
						AND 	provider_id =
t.provider_id	
						AND 	trans_status = 2
					)as  reck_date ,
					(	SELECT 	trans_id 
						FROM 	transaction 
						WHERE 	trans_owner_id =
t.trans_owner_id
						AND 	trans_type = 9510 
						AND 	provider_id =
t.provider_id	
						AND 	trans_status = 2
					)as reck_id,
					(
						select
min(to_char(e.start_time,'MM/DD/YYYY')) as appt
						from event e,
event_attribute ea
						where ea.value_text =
t.trans_owner_id 
						and ea.item_name =
'Appointment' 
						and ea.value_type = 333
						and e.event_id  =
ea.parent_id
						and e.start_time -
to_date(:9,'MM/DD/YYYY') >=0			
					)as appt,
					(SELECT MIN(iia.comments) FROM
invoice_item_adjust iia WHERE parent_id =
					  (SELECT MIN(item_id) FROM
invoice_item ii WHERE ii.parent_id = i.invoice_id AND
					   ii.item_type in (0,1,2) )
					) as description

				FROM 	transaction t ,invoice i
				WHERE 	t.trans_type = 9520
				AND 	t.trans_status = 2
				AND 	t.trans_subtype = 'Owner'
				AND	t.provider_id = :8
				AND	t.invoice_id = i.invoice_id	
				and     t.invoice_id is not null
				AND	t.billing_facility_id = :7
		ORDER BY 2

------_=_NextPart_001_01C01CFD.F3CD1300
Content-Type: text/html;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2448.0">

<TITLE>No subselect in explain plan</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2 FACE=3D"Arial">I do not see in explain plan any = access to the tables in subselects which I use for columns. Anybody = knows why. Oracle 8.1.6.2 on Solaris</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Alex Hillman</FONT>
</P>
<BR>
<BR>

<P><FONT SIZE=3D2 =

FACE=3D"Arial">OPERATIONS       &nbsp=
;           &nbsp=
;           &nbsp=
;           &nbsp=

;&nbsp; OPTIONS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = OBJECT_NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&= nbsp;&nbsp; OBJECT_TYPE</FONT>
<BR><FONT SIZE=3D2 =

FACE=3D"Arial">------------------------------------------------------- =
--------------- ----------------------- =
------------------------------</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; --SELECT STATEMENT</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; =

--SORT           =
            =
            =
           ORDER =

BY</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --UNION-ALL</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --FILTER</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --NESTED LOOPS</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --TABLE =

ACCESS           =
            =
       =

FULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = INVOICE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --TABLE =

ACCESS           =
            =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BY INDEX ROWID&nbsp; PERSON</FONT>

<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;            =

UNIQUE SCAN&nbsp;&nbsp;&nbsp;&nbsp; =
PERSON_PK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; UNIQUE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;          RANGE =

SCAN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PERSON_ORG_CATEGORY_PK&nbsp; = UNIQUE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --FILTER</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --TABLE =

ACCESS           =
            =
       BY INDEX ROWID  =

PERSON_ATTRIBUTE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;            =

RANGE SCAN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = PERATTR_PARENT_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NON-UNIQUE</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --TABLE =

ACCESS           =
            =
       BY INDEX ROWID  =

TRANSACTION</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;            =

UNIQUE SCAN&nbsp;&nbsp;&nbsp;&nbsp; =
TRANSACTION_PK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = UNIQUE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --FILTER</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --NESTED LOOPS</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; --TABLE =

ACCESS           =
            =
&nbsp;&nbsp;&nbsp;&nbsp; BY INDEX ROWID&nbsp; INVOICE_BILLING</FONT>

<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;          UNIQUE =

SCAN&nbsp;&nbsp;&nbsp;&nbsp; =
INVOICE_BILLING_PK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; UNIQUE</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; --TABLE =

ACCESS           =
            =
&nbsp;&nbsp;&nbsp;&nbsp; BY INDEX ROWID&nbsp; PERSON_ATTRIBUTE</FONT>

<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;          RANGE =

SCAN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
PERATTR_PARENT_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NON-UNIQUE</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --NESTED LOOPS</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; --TABLE =

ACCESS           =
            =
&nbsp;&nbsp;&nbsp;&nbsp; BY INDEX ROWID&nbsp; INSURANCE</FONT>

<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;          UNIQUE =

SCAN&nbsp;&nbsp;&nbsp;&nbsp; =
INSURANCE_PK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp; UNIQUE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; --TABLE =

ACCESS           =
            =
&nbsp;&nbsp;&nbsp;&nbsp; BY INDEX ROWID&nbsp; INSURANCE</FONT>

<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;          UNIQUE =

SCAN&nbsp;&nbsp;&nbsp;&nbsp; =
INSURANCE_PK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= &nbsp; UNIQUE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --FILTER</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --TABLE =

ACCESS           =
            =
       BY INDEX ROWID  =

PERSON_ATTRIBUTE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;            =

RANGE SCAN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = PERATTR_PARENT_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NON-UNIQUE</FONT> <BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; --TABLE =

ACCESS           =
            =
       BY INDEX ROWID  =

TRANSACTION</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp;&nbsp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;            =

UNIQUE SCAN&nbsp;&nbsp;&nbsp;&nbsp; =
TRANSACTION_PK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = UNIQUE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --TABLE =

ACCESS           =
            =
         BY INDEX ROWID  =

TRANSACTION</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb= sp;&nbsp; =

--INDEX          &nbsp=
;           &nbsp=
;           &nbsp=

;&nbsp; RANGE SCAN&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = TRANS_INVOICE_ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = NON-UNIQUE</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --NESTED = LOOPS</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --TABLE =

ACCESS           =
            =
         =

FULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = TRANSACTION</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = --TABLE =

ACCESS           =
            =
         BY INDEX ROWID  =

INVOICE</FONT>

</P>
<BR>
<BR>
<BR>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 = FACE=3D"Arial">SELECT&nbsp; =
p.person_id,i.invoice_id,i.balance,to_char(i.invoice_date,'MM/DD/YYYY') = as invoice_date,</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">to_number(NULL) as trans_id,NULL as = reck_date,to_number(NULL) as reck_id,</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">select min(to_char(e.start_time,'MM/DD/YYYY')) </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">from event e, event_attribute ea</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">where ea.value_text =3D p.person_id</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and ea.item_name =3D 'Appointment' </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and ea.value_type =3D 333</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and e.event_id&nbsp; =3D ea.parent_id</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and e.start_time - to_date(:9,'MM/DD/YYYY') &gt;=3D0 = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">)as appt,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(SELECT MIN(iia.comments) FROM invoice_item_adjust iia = WHERE parent_id =3D</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp; (SELECT MIN(item_id) FROM invoice_item ii WHERE = ii.parent_id =3D i.invoice_id AND</FONT></P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&nbsp; ii.item_type in (0,1,2) )</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">) as =
description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM &nbsp;&nbsp; person p&nbsp; ,invoice i </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE&nbsp;&nbsp; upper(substr(p.name_last,1,1)) between = upper(:1) </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; upper(:2)</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; i.client_id =3D = p.person_id</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; i.balance between (:3) = </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; (:4)</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; i.invoice_date between = to_date(:5,'MM/DD/YYYY')</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; =

to_date(:6,'MM/DD/YYYY')&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; i.invoice_status not in = (15,16) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND EXISTS</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">SELECT&nbsp; 1 </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM&nbsp; &nbsp; person_org_category poc</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE &nbsp; p.person_id =3D poc.person_id</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; poc.org_internal_id =3D = :7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND EXISTS</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">SELECT&nbsp; 1</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM &nbsp;&nbsp; person_attribute</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE&nbsp;&nbsp; item_name =3D = 'WorkList-Collection-Setup-Org'</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; value_text =3D (select = service_facility_id FROM transaction</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE trans_id=3D i.main_transaction)</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; parent_id =3D :8</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; parent_org_id =3D :7</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND EXISTS</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">SELECT&nbsp; 1</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM&nbsp;&nbsp;&nbsp; person_attribute = pa,invoice_billing ib</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE&nbsp;&nbsp; pa.item_name =3D = 'WorkList-Collection-Setup-Product'</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; i.billing_id =3D = ib.bill_id</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; parent_id =3D :8</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; pa.parent_org_id =3D = :7&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; (</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">ib.bill_party_type IN (0,1)</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">OR</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">EXISTS</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">SELECT 1 </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM &nbsp;&nbsp; = insurance coverage,insurance prod_plan </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE&nbsp;&nbsp; = ib.bill_ins_id =3D coverage.ins_internal_id</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = AND&nbsp;&nbsp;&nbsp;&nbsp; prod_plan.ins_internal_id =3D = coverage.parent_ins_id</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = AND&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (prod_plan.ins_internal_id = =3D pa.value_int AND prod_plan.record_type =3D1)</FONT></P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR prod_plan.parent_ins_id = =3D pa.value_int</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
         =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =

FACE=3D"Arial"> )</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
            &nbsp=

;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 = FACE=3D"Arial">)</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND EXISTS</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">SELECT&nbsp; 1</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM&nbsp;&nbsp;&nbsp; person_attribute</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE&nbsp;&nbsp; item_name =3D = 'WorkList-Collection-Setup-Physician'</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; value_text =3D (select = provider_id FROM transaction</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE trans_id=3D i.main_transaction)</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; parent_id =3D :8</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; parent_org_id =3D = :7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND NOT EXISTS</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp; <FONT SIZE=3D2 FACE=3D"Arial">(</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">SELECT&nbsp; 1 </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM&nbsp;&nbsp;&nbsp; transaction</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE&nbsp;&nbsp; trans_type =3D 9520</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; trans_status =3D 2</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; provider_id =3D :8</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; invoice_id =3D = i.invoice_id&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; invoice_id is not NULL</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND&nbsp;&nbsp;&nbsp;&nbsp; billing_facility_id =3D = :7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">UNION ALL</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">SELECT&nbsp; t.trans_owner_id as = person_id,i.invoice_id,i.balance,to_char(i.invoice_date,'MM/DD/YYYY') = as invoice_date,</FONT></P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">t.trans_id,</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT&nbsp; = to_char(trans_begin_stamp,'MM/DD/YYYY') </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&=

nbsp;           =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM &nbsp;&nbsp; transaction </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE &nbsp; trans_owner_id =3D t.trans_owner_id</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; trans_type =3D 9510 </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; provider_id =3D = t.provider_id&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; trans_status =3D 2</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)as&nbsp; reck_date ,</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT&nbsp; = trans_id </FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM &nbsp;&nbsp; transaction </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE &nbsp; trans_owner_id =3D t.trans_owner_id</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; trans_type =3D 9510 </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; provider_id =3D = t.provider_id&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; trans_status =3D 2</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp= ;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 = FACE=3D"Arial">)as reck_id,</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">select min(to_char(e.start_time,'MM/DD/YYYY')) as = appt</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">from event e, event_attribute ea</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">where ea.value_text =3D t.trans_owner_id </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and ea.item_name =3D 'Appointment' </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and ea.value_type =3D 333</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and e.event_id&nbsp; =3D ea.parent_id</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">and e.start_time - to_date(:9,'MM/DD/YYYY') &gt;=3D0 = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">)as appt,</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">(SELECT MIN(iia.comments) FROM invoice_item_adjust iia = WHERE parent_id =3D</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp; (SELECT MIN(item_id) FROM invoice_item ii WHERE = ii.parent_id =3D i.invoice_id AND</FONT></P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">&nbsp;&nbsp; ii.item_type in (0,1,2) )</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">) as =
description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">FROM &nbsp;&nbsp; transaction t ,invoice i</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">WHERE &nbsp; t.trans_type =3D 9520</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; t.trans_status =3D 2</FONT> <BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =

        =
        =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

FACE=3D"Arial">AND &nbsp;&nbsp;&nbsp; t.trans_subtype =3D = 'Owner'</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = Received on Tue Sep 12 2000 - 16:10:59 CDT