誤用客供料
OKUMA誤用客供料製令
<SQL> SELECT X.*,MA016,MA002 FROM (SELECT TA001,TA002,TA006,TA034,TA035,TB003 ,TC004,TB004 AS 應領用,TB005 AS 已領用,TA011 AS 製令狀態 FROM MOCTB JOIN MOCTA ON TA001=TB001 AND TA002=TB002 JOIN v_COPTCD ON TA001='5102' AND TA002=TD054 WHERE TB018='Y' AND TA011<>'y' AND TD021='Y' )X JOIN COPMA ON MA001=TC004 WHERE TC004='197B' AND TB003 LIKE '601970%' </SQL>