-- all delivered loads since creation will get scanned here:  

    UNION 
    --Listable Load brendap View: Customer Voucher  SELECT      'd' as
    __dummy,  Load.id Load_Id,  AC.data ConsVoucher,  CVIT.descr cvitype, 
    CVI.amt cviamt,  Load.acct_batch BatchId,  Invoice.timestamp InvoiceDate, 
    (SELECT min(upper(vin)) FROM load_det ld join link_load_det lld on ld.id =
    lld.load_det_id WHERE lld.load_id = Load.id) AS  Vins  FROM load Load  
    join client_profile Destination on Load.dest_id = Destination.id  join
    client_profile Origin on Load.orig_id = Origin.id  left join loadacct_link
    LL on LL.load_id = Load.id left join acct_cache AC on LL.acct_cache_id =
    AC.id  left join load_trx CVI on AC.data = CVI.cmt and CVI.load_id =
    Load.id  left join ref_trx CVIT on CVI.trx_typ = CVIT.id   left join
    loadacct_batch Invoice on Load.acct_batch = Invoice.id   WHERE   ( 
    Load.status  in (?,?,?,?)  )      AND   (    ( ( Load.parent_id is NULL
    AND Load.type is NULL ) OR ( (Load.type='Y' AND Load.id = Load.parent_id)
    ) OR ( (Load.type is NULL AND Load.parent_id IS NOT NULL AND
    Load.alt_parent_id IS NULL) ) )   )  --UNION SET  AND   (   ( 
    Load.carrier_id  in (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)  )  )     ORDER BY
    8 , 3 , 4

Host variables :
   address    type       flags value
   ---------------------------------
   0x0x7a907020 CHAR       0x000 H
   0x0x7a907080 CHAR       0x000 K
   0x0x7a9070e0 CHAR       0x000 F
   0x0x7a907140 CHAR       0x000 D
   0x0x7a9071a0 INT        0x000 506688
   0x0x7a907200 INT        0x000 592922
   0x0x7a907260 INT        0x000 565166
   0x0x7a9072c0 INT        0x000 565153
   0x0x7a907320 INT        0x000 565165
   0x0x7a907380 INT        0x000 583662
   0x0x7a9073e0 INT        0x000 585122
   0x0x7a907440 INT        0x000 583661