30122020 - CHECK SOTK XUAT KHO AMS.txt
| 1 |
SELECT A.*,D.PRICE_CODE, E.MATERIAL_ID, F.MATERIAL_CODE, F.EXP_ACCTNO, F.INC_ACCTNO FROM MW_OUT_DT A |
|---|---|
| 2 |
INNER JOIN MW_OUT B ON A.OUT_ID = B.OUT_ID |
| 3 |
INNER JOIN MW_MAST_BAL C ON A.MAST_BAL_ID = C.MAST_BAL_ID |
| 4 |
INNER JOIN MW_MAST_PRICE D ON C.PRICE_ID = D.PRICE_ID |
| 5 |
INNER JOIN MW_IN E ON D.MATERIAL_ID = E.IN_ID |
| 6 |
INNER JOIN MW_MATERIAL F ON E.MATERIAL_ID =F.MATERIAL_ID |
| 7 |
AND B.OUT_CODE IN ('069TTXK201230004','069TTXK201230003','069TTXK201230002')
|