Infor XA ERP运维常用SQL
来源:互联网 发布:hadoop数据目录配置 编辑:程序博客网 时间:2024/04/30 15:50
记录Infor XA ERP工作用SQL
1、绿屏shipment操作不正常退出,造成shipment状态异常,无法继续任何操作;解锁SQL
--绿屏异常退出,shipment异常UPDATE 环境库.MBADRES0 SET ADIIST = '50' WHERE ADIIST = '99' AND ADHFCD = '50'; UPDATE 环境库.MBADRES0 SET ADIIST = '00' WHERE ADIIST = '99' and ADHFCD = '20';UPDATE 环境库.MBKJREP SET KJABTM = 121212 WHERE KJABTM = 999999; UPDATE 环境库.MBDHREP SET DHABTM = 121212 WHERE DHABTM = 999999;
10、无工艺序最早订单、Forcast明细
--建议工艺完成日期、CO交货承若日期、CO号码、CO成品、成品下阶、项目说明、项目长描述、项目长规格、项目类型、项目类别、生产部门SELECT DISTINCT CASEWHEN itemF.itcls = 'A001' THEN TO_CHAR(to_date(char(CO.coDate+19000000),'YYYYMMDD') - 35 days,'YYYYMMDD')-19000000WHEN itemF.itcls LIKE 'A00%' AND itemF.itcls != 'A001' THEN TO_CHAR(to_date(char(CO.coDate+19000000),'YYYYMMDD') - 42 days,'YYYYMMDD')-19000000WHEN itemF.itcls LIKE 'J%' THEN TO_CHAR(to_date(char(CO.coDate+19000000),'YYYYMMDD') - 56 days,'YYYYMMDD')-19000000ELSE TO_CHAR(to_date(char(CO.coDate+19000000),'YYYYMMDD') - 49 days,'YYYYMMDD')-19000000 END adviceDate, CO.coDate,CO.coNum,CO.fItem, lvBom.pitm,itemF.itdsc, itemZ.LDESP, itemZ.SDESP,itemF.ittyp,itemF.itcls,itemF.dptno FROM (SELECT concat('CO',coLineRe.ADCVNB) coNum,coLineRe.ADBIDT coDate,coLineRe.ADAITX fItem FROM AMFLIBF.MBADREP coLineRe WHERE coLineRe.ADHFCD != '50' AND coLineRe.ADAGNV > 0 AND coLineRe.ADBIDT = (SELECT min(minCoLineRe.ADBIDT) FROM AMFLIBF.MBADREP minCoLineRe WHERE minCoLineRe.ADAITX = coLineRe.ADAITX AND minCoLineRe.ADHFCD != '50' AND minCoLineRe.ADAGNV > 0 )unionSELECT 'FORECAST' coNum,forecast.RQDUD coDate,forecast.RQCOM fItem FROM AMFLIBF.REQMTS forecast WHERE forecast.RQSOR = '6' AND forecast.RQDUD = (SELECT min(minForecast.rqdud) FROM AMFLIBF.REQMTS minForecast WHERE minForecast.RQCOM = forecast.RQCOM AND minForecast.RQSOR = '6' )) CO JOIN MWLIBF.BOMLVLPF lvBom ON lvBom.fitm = CO.fItem JOIN MWLIBF.ZITMEXT itemZ ON itemZ.itnbr = lvBom.pitm JOIN AMFLIBF.ITMRVA itemF ON itemF.itnbr = lvBom.pitm AND itemF.CFST != 'STOP' AND itemF.ittyp in ('1','2') WHERE not EXISTS (select 1 from AMFLIBF.RTGOPR routOpr WHERE routOpr.rtid = lvBom.pitm AND routOpr.wkctr != 'QC' ) ORDER BY CO.coDate,CO.fItem,lvBom.pitm
0 0
- Infor XA ERP运维常用SQL
- 使用java发送Infor XA ERP SystemLink请求
- 使用java解析Infor XA ERP SystemLink请求响应报文
- erp常用sql
- ERP系统常用SQL集锦
- TIPTOP ERP 常用SQL总结
- 国外ERP软件公司的一些数据(SAP,Oracle,Infor,Sage,Microsoft)
- XA
- XA
- XA
- XA
- java.sql.SQLException: XA error: XAER_RMFAIL
- SQL Server的分布式XA事务
- ERP常用词汇
- ERP常用简称
- SAP ERP 常用数据表
- 【Oracle】运维常用SQL
- 运维常用的SQL
- 关于android studio运行出现Session 'app':Error Installing apk错误
- 张朝权博客 - 使用主机公园免费虚拟主机搭建WordPress个人独立博客
- mybatis自动生成工具-MBG
- java中String的详细解析
- 有哪些对树莓派 (Raspberry Pi) 的有趣改造、扩展应用?
- Infor XA ERP运维常用SQL
- 初学安卓路之CheckBox与RadioGroup
- APK瘦身记,如何实现高达53%的压缩效果
- linux 内存清理/释放命令
- Freemaker初接触(五)导入公共ftl文件
- 此应用程序当前处于脱机状态
- MATLIB 多个子文件夹批量创造测试文件
- 李彦宏笑对“百度是做外卖的”质疑:外卖的技术含量是不低的
- linux下SVN服务器搭建