SELECT A.*,D.PRICE_CODE, E.MATERIAL_ID, F.MATERIAL_CODE, F.EXP_ACCTNO, F.INC_ACCTNO FROM MW_OUT_DT A
INNER JOIN MW_OUT B ON A.OUT_ID = B.OUT_ID
INNER JOIN MW_MAST_BAL C ON A.MAST_BAL_ID = C.MAST_BAL_ID
INNER JOIN MW_MAST_PRICE D ON C.PRICE_ID = D.PRICE_ID
INNER JOIN MW_IN E ON D.MATERIAL_ID = E.IN_ID
INNER JOIN MW_MATERIAL F ON E.MATERIAL_ID =F.MATERIAL_ID
AND B.OUT_CODE IN ('069TTXK201230004','069TTXK201230003','069TTXK201230002')