ORA-00905: missing keyword

Dear all expert,

Good day!

I'm facing the ORA-00905: missing keyword error prompt when I paste the following SQL code in BI Publisher, but this error doesn't come out in Oracle SQL Developer Application.

Any keyword I missing from the following code? Kindly assist.

Select
M.IXITM  AS "Child_ShortItemNo"
,M.IXLITM AS "Child_2ndItemNo"
,(M.IXQNTY/10000) as "Quantity Per"

FROM SMDTA.F4311 A
LEFT JOIN SMDTA.F3411 L on L.MMPMPN =  A.PDPMPN AND  L.MMITM = A.PDITM AND L.MMLNID = A.PDLNID --MPS Answer Message Table

--Retrieved BOM F3002 table.
LEFT JOIN (select Z.IXITM, Z.IXLITM, Z.IXAITM, Z.IXCMCU, SUM(Z.IXQNTY) as "IXQNTY",Z.IXUM