求当月实际出货数量的两种方式

一种通过订单line中

OE_ORDER_LINES_ALL.SHIPPED_QUANTITY

一种通过物料交易档

MTL_MATERIAL_TRANSACTIONS.TRANSACTION_QUANTITY

1.

SELECT --OOH.ORDER_NUMBER,
SUM(OOL.SHIPPED_QUANTITY)
FROM OE_ORDER_HEADERS_ALL OOH,
OE_ORDER_LINES_ALL OOL
WHERE OOH.HEADER_ID=OOL.HEADER_ID
AND OOL.INVENTORY_ITEM_ID=8063
AND TO_CHAR(OOL.ACTUAL_SHIPMENT_DATE, 'yyyy-mm') ='2007-09'
AND OOL.OPEN_FLAG='N'
AND OOL.CANCELLED_FLAG='N'
AND OOH.SHIP_FROM_ORG_ID = 104

2.

SELECT SUM(MMT.TRANSACTION_QUANTITY)
FROM MTL_MATERIAL_TRANSACTIONS MMT
WHERE MMT.INVENTORY_ITEM_ID=8063
AND MMT.ORGANIZATION_ID=104
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 2
AND TO_CHAR(MMT.TRANSACTION_DATE,'yyyymm')='200709'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/41594/viewspace-50561/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/41594/viewspace-50561/