Public feed
#725766
-- 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