POS VB

?

PPSM06S70:??Add??moddate?

EDITSPRINTJOB:??MAX(TO_CHAR(ETRN.MODDATE,?‘yyyy/mm/dd/HH24:MI?AM‘))?ACTUAL_SHIPDATE

?

4.Test?Scenario

(1)?：Query?SQL

Test?DN:8016578337

SELECT?CTRN.TKCTID?TRUCK_ID,

???????CTRN.TKCTID?TKNO,

???????MAX(HVSP.CONTAINER_ID)?CONTAINER_ID,

???????MAX(NVL(HVSP.SEAL_ID,?ECTH.CONTSNO))?SEAL_NUMBER,

???????MAX(NVL(HVSP.SHIP_MODE,?C092.DSCA))?SHIP_MODE,

???????MAX(C021.CRTE)?CRTE,

???????MAX(TO_CHAR(ETRN.MODDATE,?‘yyyy/mm/dd/HH24:MI?AM‘))?ACTUAL_SHIPDATE,

???????TO_CHAR(SYSDATE,?‘YYYYMMDD‘)?CURRENT_DATE,

???????MAX(HVSP.SHIP_MODE)?SHIP_MODE,

???????MAX(TO_CHAR(C021.INVD,?‘YYYYMMDD‘))?INVD,

???????MAX(TO_CHAR(CTRN.DATETIME,?‘yyyy/mm/dd?HH24:MI:SS‘))?DT,

???????MAX(NVL(C021.INCOT1,?C071.CDEC))?INCOTERM

??FROM?CMPPSTRN????CTRN,

???????EPPALCTH????ECTH,

???????CMPPS021????C021,

???????CMPPS092????C092,

???????HV_SHIPPLAN?HVSP,

???????CMPPS071????C071,

???????EPCARTRN????ETRN

?WHERE?CTRN.DN?=?‘8016578337‘

???AND?CTRN.NCMP?=?‘F715‘

???AND?CTRN.CONTNO?=?ECTH.CONTNO(+)

???AND?CTRN.PACKLST?=?ECTH.PACKLST(+)

???AND?C021.PINO?=?CTRN.DN

???AND?C092.NCMP?=?C021.NCMP

???AND?C092.CRTE?=?C021.CRTE

???AND?C071.NCMP?=?C021.NCMP

???AND?C071.ORNO?=?C021.ORNO

???AND?HVSP.NCMP(+)?=?C021.NCMP

???AND?HVSP.ORNO(+)?=?C021.ORNO

???AND?HVSP.INVD(+)?=?C021.INVD

???AND?C021.CORG?=?‘1‘

???AND?HVSP.PINO(+)?=?C021.PINO

???AND?CTRN.ncmp?=?ETRN.ncmp

???AND?CTRN.tkctid?=?ETRN.tkctid

???AND?ETRN.STATUS?=?‘1‘

???AND?CTRN.DATETIME?=?ETRN.DATETIME

?GROUP?BY?CTRN.TKCTID

?

(2)?：Print?Test

?

PPS?-load?to?truck?

?

?

UPDATE?EPCARTRN

???SET?STATUS?=?1,?MODDATE?=?SYSDATE,?REMARK?=?‘WCQ-3-201810100001‘

?WHERE?STATUS?=?0

???AND?TKCTID?=?‘YBN9999‘

???AND?TO_CHAR(DATETIME,?‘YYYY/MM/DD‘)?=?‘2018/04/17‘

???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?