Question:
Date : 18/02/2022
Details :
Environment : Prod and Dev
All DC
We found that order lists in
RF Picking modules have been shown all the order lists even that order was not
belong to the working area selected.
So that make the user
confused.
Please see more details as
attached.
Answer:
Investigation:
To pass in the parameter for the Zone selected
SELECT DOC_ORDER_HEADER.ORDERNO AS @LIST_VIEW@,
BSM_CODE_ML.CODEDESCR AS @LIST_VIEW@,
DATE_FORMAT(DOC_ORDER_HEADER.ADDTIME,'%Y-%m-%d %T') AS @LIST_VIEW@
FROM DOC_ORDER_HEADER
LEFT JOIN BSM_CODE_ML ON DOC_ORDER_HEADER.ORDERTYPE=BSM_CODE_ML.CODEID AND BSM_CODE_ML.LANGUAGEID='#LANGUAGE#'
LEFT JOIN TSK_TASKLISTS ON DOC_ORDER_HEADER.ORDERNO=TSK_TASKLISTS.DOCNO
LEFT JOIN BAS_LOCATION ON TSK_TASKLISTS.FMLOCATION=BAS_LOCATION.LOCATIONID
WHERE DOC_ORDER_HEADER.SOSTATUS<'80'
AND BSM_CODE_ML.CODETYPE='SO_TYP'
AND TSK_TASKLISTS.TASKTYPE='PK' AND TSK_TASKLISTS.TASKPROCESS<='10' AND
(TSK_TASKLISTS.DOCNO='@TXT_ORDERNO_1#ALLOW_EMPTY#@') AND
(TSK_TASKLISTS.GROUPTASKID='@TXT_GROUPTASKID_1#ALLOW_EMPTY#@') AND (BAS_LOCATION.ZONEGROUP='@TXT_AREA_1#ALLOW_EMPTY#@') AND
(BAS_LOCATION.ZONEID='@TXT_ZONE_1#ALLOW_EMPTY#@') AND (BAS_LOCATION.LOCGROUP1='@TXT_LOCGROUP1_1#ALLOW_EMPTY#@') AND (BAS_LOCATION.LOCGROUP2='@TXT_LOCGROUP2_1#ALLOW_EMPTY#@') AND (TSK_TASKLISTS.FMLOCATION>='@TXT_LOCATIONIDFM_1#ALLOW_EMPTY#@') AND (TSK_TASKLISTS.FMLOCATION<='@TXT_LOCATIONIDTO_1#ALLOW_EMPTY#@') AND (TSK_TASKLISTS.HOLDWHO='#USERID#' OR TSK_TASKLISTS.HOLDWHO IS NULL)
AND (DOC_ORDER_HEADER.CUSTOMERID = '#AUTHORIZE_CUSTOMER#')
AND (BAS_LOCATION.WORKINGAREA='@SEL_WORKING_AREA_1@')
AND (BAS_LOCATION.ZONEGROUP='#AREAID#')
GROUP BY DOC_ORDER_HEADER.ORDERNO,DOC_ORDER_HEADER.ADDTIME,BSM_CODE_ML.CODEDESCR LIMIT 0,99
Investigation:
Fix in RF programme to send in "selected area"