SELECT A.*,B.PSTGBZ PSJG00 FROM VW_ZS_YZDY00_NEW_HQM A,BQ_YPYZMX b WHERE B.YZMXID(+)=A.YZMXID and A.ZYID00 = 2617928 and A.CLBZ00 = '0'  AND YEXM00 IS NULL   order by CZPC00,QYRQ00,QYSJ00,PXSJ00, A.YZID00, A.YZMXID