Warning: include(../connect.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_get_stock_ready.php on line 14

Warning: include() [function.include]: Failed opening '../connect.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_get_stock_ready.php on line 14

Warning: include(../function.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_get_stock_ready.php on line 15

Warning: include() [function.include]: Failed opening '../function.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_get_stock_ready.php on line 15

Warning: include(../connect_mysql.php) [function.include]: failed to open stream: No such file or directory in E:\www\mobile\no\_ps\ps_get_stock_ready.php on line 16

Warning: include() [function.include]: Failed opening '../connect_mysql.php' for inclusion (include_path='.;C:\php5\pear') in E:\www\mobile\no\_ps\ps_get_stock_ready.php on line 16
SELECT l.MRTRNR,l.MRTRDT, RTRIM(l.MRITNO) as ITNO, CONVERT(DECIMAL(10,0),l.MRRPQT) as QTY, h.MGTWLO, l.MRITDS as NO_ITEMNAME, CONVERT(DECIMAL(10,0),l.MRTRQT) as REQ_QTY, CONVERT(DECIMAL(10,0),((l.MRRPQT)/(select max(un.MUCOFA) from MVXJDTA.MITAUN as un where l.MRITNO=un.MUITNO))) as NO_CONVERT_CTN, l.MRTRSH as NO_STATUS FROM MVXJDTA.MGLINE AS l INNER JOIN MVXJDTA.MGHEAD AS h ON l.MRTRNR = h.MGTRNR WHERE (((h.MGTRDT in('20160501','20160502','20160503','20160504') and (h.MGTWLO between '201' and '850')))) and ((l.MRTRSH in('99','29')) and (l.MRRPQT>0)) --Check For Upload / Compare Doc outing ORDER BY h.MGTRDT,h.MGTWLO,l.MRTRNR,l.MRPONR,RTRIM(l.MRITNO)