●集團每月工單超領退料明細表●－傑佛瑞Blog TIPTOP ERP+ EasyFlow (BPM) + BI 系統整合開發經驗分享

May 05 Thu 2011 16:23
●集團每月工單超領退料明細表●

集團每月工單超領退料明細表●

sql_str += " select '"+para1+"' X1,tlf905 X2,to_char(tlf06,'yyyy/mm/dd') X3,tlf906 X4,tlf62 X5,tlf01 X6,ima02 X7,ima021 X8,(tlf10*tlf907*(-1)) X9, USERNAME X10 ";

sql_str += " from "+para1+".ima_file,"+para1+".tlf_file,"+para1+".sfp_file,ds.STAFF_file ";

sql_str += " where ima01 = tlf01 and tlf13 in ('asfi512','asfi527') and tlf907 <> 0 AND year(tlf06) LIKE '"+para2+"' AND month(tlf06) LIKE '"+para3+"' ";

sql_str += " and tlf905 = sfp01 and sfpuser = USERID(+) order by 2,3 ";