SELECT
AA.PRODUCT_CNAME,
AA.PRODUCT_ID,
AA.PRODUCT_CODE,
AA.MODEL,
AA.MASTER_UNIT,
AA.OTHER_UNIT,
AA.PACKAGE_RATIO,
AA.CUSTOMER,
SUM(QTY_OUT_TODAY) AS QTY_OUT_TODAY,
QTY_TODAY,SUM(QTY_IN_TODAY) AS QTY_IN_TODAY,
SUM(QTY_OUT) AS QTY_OUT,
SUM(QTY_IN) AS QTY_IN
FROM (SELECT CUSTOMER,
PRODUCT_CNAME,PRODUCT_ID,
PRODUCT_CODE,MODEL,
MASTER_UNIT,
OTHER_UNIT,
PACKAGE_RATIO,
CASE WHEN WMS_OUT_CONFIRM_DATE <= TO_DATE(TO_CHAR(SYSDATE,'yyyy-MM-dd HH24:mi:ss') ,'yyyy-MM-dd HH24:mi:ss')
AND WMS_OUT_CONFIRM_DATE >SYSDATE
AND BIZ_SOURCE ='2'
THEN MASTER_UNIT_QTY
ELSE 0
END AS QTY_OUT_TODAY,
CASE WHEN CONFIRM_DATE <= TO_DATE(TO_CHAR(SYSDATE,'yyyy-MM-dd HH24:mi:ss') ,'yyyy-MM-dd HH24:mi:ss')
AND CONFIRM_DATE >SYSDATE
AND BIZ_SOURCE ='0'
THEN MASTER_UNIT_QTY
ELSE 0
END AS QTY_IN_TODAY,
(SELECT SUM(MASTER_UNIT_QTY) from wms_inventory where wms_inventory.
WMS仓储管理系统实现"收发存日报表"数据查询功能Sql语句--Oracle
最新推荐文章于 2024-07-10 21:42:23 发布
本文介绍了如何使用Oracle数据库通过SQL语句实现仓储管理系统中的收发存日报表数据查询功能,重点关注GROUP BY和ORDER BY子句的应用。
摘要由CSDN通过智能技术生成