Upper
obLevel
__env
app
errors
breadcrumbs
paginator
elements
i
col
max
height
width
__currentLoopData
item
loop
file
image
CartService
select * from "dist" where "dist"."dist_no" = 'DE04' limit 1
SELECT *
LIMIT
ORDER BY
select * from "dist" where "dist"."dist_no" = 'DE' 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 ('DE04')
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 ('DE04') order by "item_no" asc limit 20 offset 40
