Upper
obLevel
__env
app
errors
breadcrumbs
paginator
elements
i
col
max
height
width
__currentLoopData
loop
CartService
select * from "dist" where "dist"."dist_no" = 'TZ99' limit 1
SELECT *
LIMIT
ORDER BY
select * from "dist" where "dist"."dist_no" = 'TZ' limit 1
select count(*) as aggregate from "item" inner join "itemwr" on "item"."item_no" = "itemwr"."item_no" where "itemwr"."ware_no" = 'A' and "zdate" is null and "dist_no" in ('TZ99')
select item.*,CASE WHEN itemwr.qty-itemwr.orde_way_qty-itemwr.safe_qty > 0 THEN itemwr.qty-itemwr.orde_way_qty-itemwr.safe_qty ELSE 0 END as orde_qty from "item" inner join "itemwr" on "item"."item_no" = "itemwr"."item_no" where "itemwr"."ware_no" = 'A' and "zdate" is null and "dist_no" in ('TZ99') order by "item_no" asc limit 20 offset 16380