PPSM06S70: Add moddate
EDITSPRINTJOB: MAX(TO_CHAR(ETRN.MODDATE, ‘yyyy/mm/dd/HH24:MI AM‘)) ACTUAL_SHIPDATE
4.Test Scenario
(1) ：Query sql
@H_301_18@Test DN:8016578337 @H_301_18@SELECT CTRN.TKCTID TRUCK_ID, @H_301_18@ CTRN.TKCTID TKNO, @H_301_18@ MAX(HVSP.CONTAINER_ID) CONTAINER_ID, @H_301_18@ MAX(NVL(HVSP.SEAL_ID, ECTH.CONTSNO)) SEAL_NUMBER, @H_301_18@ MAX(NVL(HVSP.SHIP_MODE, C092.DSCA)) SHIP_MODE, @H_301_18@ MAX(C021.CRTE) CRTE, @H_301_18@ MAX(TO_CHAR(ETRN.MODDATE, ‘yyyy/mm/dd/HH24:MI AM‘)) ACTUAL_SHIPDATE, @H_301_18@ TO_CHAR(SYSDATE, ‘YYYYMMDD‘) CURRENT_DATE, @H_301_18@ MAX(HVSP.SHIP_MODE) SHIP_MODE, @H_301_18@ MAX(TO_CHAR(C021.INVD, ‘YYYYMMDD‘)) INVD, @H_301_18@ MAX(TO_CHAR(CTRN.DATETIME, ‘yyyy/mm/dd HH24:MI:SS‘)) DT, @H_301_18@ MAX(NVL(C021.INCOT1, C071.CDEC)) INCOTERM @H_301_18@ FROM CMPPSTRN CTRN, @H_301_18@ EPPALCTH ECTH, @H_301_18@ CMPPS021 C021, @H_301_18@ CMPPS092 C092, @H_301_18@ HV_SHIPPLAN HVSP, @H_301_18@ CMPPS071 C071, @H_301_18@ EPCARTRN ETRN @H_301_18@ WHERE CTRN.DN = ‘8016578337‘ @H_301_18@ AND CTRN.NCMP = ‘F715‘ @H_301_18@ AND CTRN.CONTNO = ECTH.CONTNO(+) @H_301_18@ AND CTRN.PACKLST = ECTH.PACKLST(+) @H_301_18@ AND C021.PINO = CTRN.DN @H_301_18@ AND C092.NCMP = C021.NCMP @H_301_18@ AND C092.CRTE = C021.CRTE @H_301_18@ AND C071.NCMP = C021.NCMP @H_301_18@ AND C071.ORNO = C021.ORNO @H_301_18@ AND HVSP.NCMP(+) = C021.NCMP @H_301_18@ AND HVSP.ORNO(+) = C021.ORNO @H_301_18@ AND HVSP.INVD(+) = C021.INVD @H_301_18@ AND C021.CORG = ‘1‘ @H_301_18@ AND HVSP.PINO(+) = C021.PINO @H_301_18@ AND CTRN.ncmp = ETRN.ncmp @H_301_18@ AND CTRN.tkctid = ETRN.tkctid @H_301_18@ AND ETRN.STATUS = ‘1‘ @H_301_18@ AND CTRN.DATETIME = ETRN.DATETIME @H_301_18@ GROUP BY CTRN.TKCTID @H_301_18@(2) ：Print Test
PPS -load to truck
@H_301_18@UPDATE EPCARTRN @H_301_18@ SET STATUS = 1, MODDATE = SYSDATE, REMARK = ‘WCQ-3-201810100001‘ @H_301_18@ WHERE STATUS = 0 @H_301_18@ AND TKCTID = ‘YBN9999‘ @H_301_18@ AND TO_CHAR(DATETIME, ‘YYYY/MM/DD‘) = ‘2018/04/17‘ @H_301_18@ AND TO_CHAR(DATETIME, ‘HH24‘) < ‘12‘
AND NCMP = ‘F715‘
ini设置：station 对应cmpps128
运行job前：
select * from cmpps128 where station=‘F715TEST‘ and doc_cat=‘POS‘;
Update Y --N
CMPPSTRN
PROBLEM SUMMARY:
1，语言的设置
2，ini ---PPS stationname JOB stationname /cmpps128
3,字体
4，打印机设置
5，模板
6,获取Ship to date必须要在完成实际打包(epcartrn.status=1)数据才有值，
否则在装车计划时打印cmppstrn没有数据
SELECT DISTINCT NVL(HVSP.INTL_CARRIER, C096.CODM) INTL_CARRIER, NVL(HVSP.SHIP_MODE, C092.DSCA) SHIP_MODE, C021.PINO, C021.MPAK FROM HV_SHIPPLAN HVSP, CMPPS021 C021,CMPPSTRN CTRN, CMPPS096 C096, CMPPS092 C092 WHERE HVSP.NCMP(+) = C021.NCMP AND HVSP.ORNO(+) = C021.ORNO AND HVSP.PINO(+) = C021.PINO AND C021.NCMP = ‘F715‘ AND C021.NCMP = CTRN.NCMP AND C021.PINO = CTRN.DN AND C021.EPS_PAKNO = CTRN.PACKLST AND CTRN.DATETIME = TO_DATE(‘2018/05/15 08:30:00‘,‘yyyy/mm/dd HH24:MI:SS‘) AND CTRN.TKCTID = ‘HDP8301-01‘ AND C021.NCMP = C096.NCMP AND C021.HCUNO = C096.CUNO AND C021.CFRW = C096.CFRW AND C092.NCMP = C021.NCMP AND C092.CRTE = C021.CRTE AND C021.CORG = ‘1‘ ORDER BY INTL_CARRIER