ws.ordSrChk.sql Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of beige-accandr Show documentation
Show all versions of beige-accandr Show documentation
Beigesoft™ Enterprise Information System is a standalone JEE web application that runs on the embedded A-Jetty for Android.
Web-Store is included for study and tests purposes, and you are also able to make a full DB copy from a cloud version,
and you can make price lists (in different price categories) and export them via CSV files to your customers and POS.
The newest version!
select :TORLN.IID as IID, :TORLN.NME as NME, SRV, OWNR, PRI, TOT, TOTX, UOM114.NME as UOM114NME, UOM114.IID as UOM114IID, DT1, DT2,
case when AVQUAN is null or QUAN>AVQUAN then 0 else QUAN end as QUAN
from :TORLN
left join UOM as UOM114 on :TORLN.UOM=UOM114.IID
left join (select ITM, sum(QUAN) as AVQUAN from :TITPL group by ITM) as ITPL on ITPL.ITM=SRV
where OWNR in (:ORIDS);