檢視 生產入庫單規劃 的原始碼
←
生產入庫單規劃
跳至導覽
跳至搜尋
由於以下原因,您無權編輯此頁面:
您請求的操作只有這個群組的使用者能使用:
使用者
您可以檢視並複製此頁面的原始碼。
==領料是否足夠== <sql> SELECT TB001,TB002,COUNT(TB002) AS UNUSE FROM MOCTB WHERE TB004-TB005<>'0' AND TB011='1' AND TB001='5102' GROUP BY TB002,TB001 </sql> ==是否有未確認的領料單== <sql> SELECT TE011,TE012,COUNT(TE012) AS UCKMOCTE FROM MOCTE WHERE TE003='0001' AND TE011='5102' AND TE019='N' GROUP BY TE012,TE011 </sql> ==是否有未確認的生產入庫單== <sql> SELECT TG014,TG015,COUNT(TG015) AS UCKMOCTG FROM MOCTG WHERE TG014='5102' AND TG022='N' GROUP BY TG014,TG015 </sql> ==是否已有入庫數及需領套數是否足夠== <sql> SELECT TA001,TA002,TA015-TA017 AS MADEAMOUNT,TA015-TA016 AS SETS,TA013,TA011 FROM MOCTA WHERE TA015-TA017<>'0' AND TA001='5102' </sql> ==SQL== <sql> SELECT TA001,TA002,TA015,TA015-TA017 AS MADEAMOUNT,TA015-TA016 AS SETS,ISNULL(UNUSE,'0')AS UNUSE,ISNULL(UNCKMOCTE,'0') AS UNCKMOCTE,TA013,TA011, (SELECT CASE WHEN TA015-TA017>'0' AND TA015-TA016='0' AND UNUSE IS NULL AND UNCKMOCTE IS NULL AND TA013='Y' THEN 'OK' WHEN TA015-TA017='0' AND TA015-TA016='0' AND UNUSE IS NULL AND UNCKMOCTE IS NULL AND TA013='Y' THEN 'DONE' WHEN TA017='0' AND TA016='0' AND UNUSE IS NULL AND UNCKMOCTE IS NULL AND TA011='y' THEN 'DONE' WHEN TA017='0' AND TA016='0' AND UNUSE IS NULL AND UNCKMOCTE IS NULL AND TA013='V' THEN 'DONE' WHEN TA013='N' THEN 'NO' ELSE 'CHECK' END)AS CK FROM MOCTA LEFT JOIN (SELECT TB001,TB002,COUNT(TB002) AS UNUSE FROM MOCTB WHERE TB004-TB005<>'0' AND TB011='1' AND TB001='5102' GROUP BY TB002,TB001) X ON TA001=TB001 AND TA002=TB002 LEFT JOIN (SELECT TE011,TE012,COUNT(TE012) AS UNCKMOCTE FROM MOCTE WHERE TE003='0001' AND TE011='5102' AND TE019='N' GROUP BY TE012,TE011) Y ON TA001=TE011 AND TA002=TE012 LEFT JOIN (SELECT TG014,TG015,COUNT(TG015) AS UNCKMOCTG FROM MOCTG WHERE TG014='5102' AND TG022='N' GROUP BY TG014,TG015) Z ON TA001=TG014 AND TA002=TG015 WHERE TA001='5102' </sql>
返回到「
生產入庫單規劃
」。
導覽選單
個人工具
建立帳號
登入
命名空間
頁面
討論
臺灣正體
視圖
閱讀
檢視原始碼
檢視歷史
更多
搜尋
導覽
首頁
近期變更
隨機頁面
MediaWiki說明
工具
連結至此的頁面
相關變更
特殊頁面
頁面資訊