I tried different changes, and have got different errors:
Let Pickdate = Date(Today(),'YYYYMMDD');
SQL
SELECT
T1.PRUSER AS PKMS_USER,
T1.PRCASN AS CASE#,
T1.PRTLOC AS TO_LOCATION,
T1.PRMNOP AS MENU_OPTION_NAME,
T1.PRFLOC AS FROM_LOCATION,
T1.PRUNTS AS UNITS#,
T1.PRSTYL AS STYLE,
T1.PHPKTN AS PICKTICKET#,
T1.PHSVIA AS PLANNED_SHIP_VIA,
T1.PHTCT AS TOTAL_NO_OF_CARTONS,
T1.PHSHCN AS SHIP_TO_COUNTRY,
T1.PRDCR AS DATE_STRING,
T1.PRTCR AS TIME_STRING,
T2.PRUSER AS PKMS_USERS,
T3.CECASN AS CONTAINER
FROM
(
(SQL SELECT
DISTINCT PHPICK00.PHPKTN,
PHPICK00.PHSHCN,
PHPICK00.PHSVIA,
PHPICK00.PHTCT,
PRTRAN00.PRUSER,
PRTRAN00.PRCASN,
PRTRAN00.PRTLOC,
PRTRAN00.PRMNOP,
PRTRAN00.PRFLOC,
PRTRAN00.PRSTYL,
PRTRAN00.PRUNTS,
PRTRAN00.PRDCR,
PRTRAN00.PRTCR
FROM
CAPM01.WM0272PRDD.PHPICK00 PHPICK00,
CAPM01.WM0272PRDD.PRTRAN00 PRTRAN00
WHERE
PHPICK00.PHPCTL = PRTRAN00.PRPCTL AND
PRTRAN00.PRTXTP = '500' AND
PRTRAN00.PRTXCD = '002' AND
PRTRAN00.PRWHSE='FG3' AND
PRTRAN00.PRDIV='08' AND
PHPICK00.PHWHSE='FG3' AND
PHPICK00.PHDIV='08' AND
(PRTRAN00.PRMNOP='Pick/Pack' OR PRTRAN00.PRMNOP = ' ' OR PRTRAN00.PRMNOP = 'Pick to PLT') AND
PRTRAN00.PRCASN IS NOT NULL AND
PRTRAN00.PRFLOC Like ' %M2%' AND
PRTRAN00.PRDCR = '$(Pickdate)' T1
LEFT JOIN
SELECT
PRTRAN00.PRCASN,
PRDLOG00.PRUSER
FROM
CAPM01.WM0272CSPD.PRDLOG00 PRDLOG00
CAPM01.WM0272PRDD.PRTRAN00 PRTRAN00
WHERE
PRTRAN00.PRCASN = PRDLOG00.PRCASN AND
PRTRAN00.PRTXTP='500' AND
PRTRAN00.PRTXCD='002' AND
PRTRAN00.PRWHSE='FG3' AND
PRDLOG00.PRWHSE='FG3' AND
PRTRAN00.PRDIV='08' AND
PRTRAN00.PRDCR='$(Pickdate)' AND
(PRTRAN00.PRMNOP='Pick/Pack' OR PRTRAN00.PRMNOP = ' ' OR PRTRAN00.PRMNOP = 'Pick to PLT') AND
PRTRAN00.PRCASN IS NOT NULL AND
PRTRAN00.PRFLOC Like '%M2%' AND
PRDLOG00.PRERRDS='Crtn Scanned OK' T2
ON T1.PRCASN=T2.PRCASN
)
LEFT JOIN
SELECT
DISTINCT CECVIF00.CECASN
FROM
CAPM01.WM0272PRDD.CECVIF00 CECVIF00,
CAPM01.WM0272PRDD.PRTRAN00 PRTRAN00
WHERE
PRTRAN00.PRCASN = CECVIF00.CECASN AND
PRTRAN00.PRTXTP='500' AND
PRTRAN00.PRTXCD='002' AND
PRTRAN00.PRWHSE='FG3' AND
PRTRAN00.PRDIV='08' AND
PRTRAN00.PRDCR='$(Pickdate)' AND
(PRTRAN00.PRMNOP='Pick/Pack' OR
PRTRAN00.PRMNOP = ' ' OR
PRTRAN00.PRMNOP = 'Pick to PLT') AND
PRTRAN00.PRCASN IS NOT NULL AND
PRTRAN00.PRFLOC Like '%M2%' AND
CECVIF00.CEWHSE='FG3' AND
CECVIF00.CEDIV='08' AND
CECVIF00.CEDCR='$(Pickdate)' T3
ON T1.PRCASN=T3.CECASN
);
