SELECT COUNT (*)
  FROM TRANSACTION trx, companymember MEMBER, company co, bankaccount ba
 WHERE trx.accountid = ba.bankaccountid
   AND trx.accountid IN
          (-1,
           90040906031374,
           90040906031373,
           90050304036368,
           90050304036366,
           90050304036367
          )
   AND ba.companyid = co.companyid
   AND trx.makerid = MEMBER.user_id
   AND co.parentcompanyid = '20040906017310'
   AND trx.transactionid =
          (SELECT   hist.transactionid
               FROM transactionhistory hist
              WHERE hist.transactionid = trx.transactionid
                AND trx.transactiontype IN
                       ('',
                        '',
                        'STOPCHQ',
                        'INFDTRFSAMECURRO',
                        'INFDTRFSAMECURRT',
                        'INFDTRFDIFFCURRO',
                        'INFDTRFDIFFCURRT',
                        'INFDTRFSAMECURROP',
                        'INFDTRFSAMECURRTP',
                        'INFDTRFSAMECURROP_DSENT',
                        'INFDTRFSAMECURRTP_DSENT',
                        'IBG',
                        'IBGP',
                        'IBGP_DSENT',
                        'BP',
                        'FCFDP',
                        'CO',
                        'TT',
                        'DD'
                       )
                AND trx.status IN
                       ('Entry',
                        'Pending',
                        'P-Signed',
                        'F-Signed',
                        'Sent',
                        'In-Process',
                        'Rejected',
                        'Issued',
                        'Completed',
                        'Void',
                        'ScheduleToSend',
                        'Accepted',
                        'Sent2JMS',
                        'Sent2Host',
                        'Stopped',
                        'StopRequestSent'
                       )
                AND trx.VERSION > 0
                AND hist.timeoccured >= sysdate
                AND hist.fromuid = '20040906054080'
           GROUP BY hist.transactionid)

Operation			Object Name		Rows	Bytes	Cost	Object Node	In/Out	PStart	PStop

SELECT STATEMENT Optimizer Mode=CHOOSE			1  	 	11  	 	      	             	 
  SORT AGGREGATE					1  	77  	 	 	      	             	 
    FILTER		  	 	 	 	      	             	 
      NESTED LOOPS					1  	77  	9  	 	      	             	 
        NESTED LOOPS					1  	69  	9  	 	      	             	 
          NESTED LOOPS					1  	32  	4  	 	      	             	 
            TABLE ACCESS BY INDEX ROWID	 COMPANY	1  	16  	2  	 	      	             	 
              INDEX RANGE SCAN		IDX_COMPANY1	1  	 	1  	 	      	             	 
            TABLE ACCESS BY INDEX ROWID	BANKACCOUNT	6  	96  	2  	 	      	             	 
              INDEX RANGE SCAN		IDX_COMPANYID	2  	 	1  	 	      	             	 
          INLIST ITERATOR		  	 	 	 	      	             	 
            TABLE ACCESS BY INDEX ROWID	TRANSACTION	1  	37  	5  	 	      	             	 
              INDEX RANGE SCAN		IDX_TRX_ACCTID	15  	 	1  	 	      	             	 
        INDEX UNIQUE SCAN		PK_CMPMEMBER	1 K	9 K	 	 	      	             	 
      SORT GROUP BY NOSORT		1  	28  	2  	 	      	             	 
        FILTER		  	 	 	 	      	             	 
          TABLE ACCESS BY INDEX ROWID RANSACTIONHISTORY	1  	28  	2  	 	      	             	 
            INDEX RANGE SCAN	IDX_HISTORY_TRXID	2  	 	1