"某料號" 在 "某期間內" 對 "各倉庫" 的 "WIP 交易數量"

在 Oracle ERP 中, 可以利用 MMT, 來取得 ""某料號" 在 "某期間內" 對 "各倉庫" 的 "WIP 交易數量"",

語法, 如下 :
 語法
SELECT MSI.SECONDARY_INVENTORY_NAME
, NVL(SUM(MMT.PRIMARY_QUANTITY), 0)
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_SECONDARY_INVENTORIES MSI
WHERE MMT.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MMT.SUBINVENTORY_CODE = MSI.SECONDARY_INVENTORY_NAME
AND MMT.ORGANIZATION_ID = &ORGANIZATION_ID
AND MMT.INVENTORY_ITEM_ID = &INVENTORY_ITEM_ID
AND MMT.TRANSACTION_DATE BETWEEN TO_DATE('&START_DATE','YYYYMMDD') and (TO_DATE('&END_DATE','YYYYMMDD')+ 1)
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
AND MMT.TRANSACTION_ACTION_ID = &ACTION_ID -- 1 (領料)
-- 27 (退料)
-- 33 (拆解工單領料)
-- 34 (拆解工單退料)
-- 31 (成品繳庫)
-- 32 (成品退回)
GROUP BY MSI.SECONDARY_INVENTORY_NAME;
天聖經:神的心不僅在神的聖言當中,也在神所創造的萬物之中,天涯海角每一處都有神的心
Related Posts Plugin for WordPress, Blogger...