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" = 'E' limit 1
SELECT *
LIMIT
ORDER BY
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 ('E', 'EA', 'EA08', 'EA07', 'EA06', 'EA05', 'EA04', 'EA01', 'EA02', 'EA03', 'EA99', 'EB', 'EB04', 'EB01', 'EB05', 'EB03', 'EB02')
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 ('E', 'EA', 'EA08', 'EA07', 'EA06', 'EA05', 'EA04', 'EA01', 'EA02', 'EA03', 'EA99', 'EB', 'EB04', 'EB01', 'EB05', 'EB03', 'EB02') order by "item_no" asc limit 20 offset 6520
