| Append (cost=0.00..79.59 rows=4 width=196) |
| -> Subquery Scan on "*SELECT* 1" (cost=0.00..76.99 rows=1 width=124) |
| -> Seq Scan on tbl_purchase_contracts (cost=0.00..76.98 rows=1 width=122) |
| Filter: ((erp_un_settle_amount > '0'::numeric) AND (supplier_id = 431)) |
| -> Result (cost=0.00..0.00 rows=0 width=438) |
| One-Time Filter: false |
| -> Seq Scan on tbl_erp_other_income_tickets (cost=0.00..1.11 rows=1 width=246) |
| Filter: ((status = 2) AND (supplier_id = 431) AND ((amount - settle_amount) > '0'::numeric)) |
| -> Seq Scan on tbl_erp_other_collect_tickets (cost=0.00..1.47 rows=1 width=142) |
| Filter: ((status = 2) AND (supplier_id = 431) AND ((amount - settle_amount) > '0'::numeric)) |