PO_ALL:
SELECT MPL.IBCONO COMPANY_NO, MPL.IBFACI FACILITY, MPL.IBITNO ITEM_NUMBER,
(SELECT MAX(MO.AHATAV)
FROM M3EDBPRD.MOATTR MO
WHERE MO.AHATNR = MPL.IBATNR AND MO.AHCONO = MPL.IBCONO
AND IBCONO = '500' AND IBPUSL BETWEEN '15' AND '49'
And IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')) PUT_AWAY_CODE,
MPD.PMMTNO PRODUCT,
MPD.PMCNQT QUANTITY,
ROUND((SUM(CASE WHEN MPL.IBCFQA = 0 THEN MPL.IBORQA ELSE MPL.IBCFQA END - MPL.IBRVQA)) * (MPD.PMCNQT/(SELECT SUM(MPDM.PMCNQT) FROM M3EDBPRD.MPDMAT MPDM WHERE MPDM.PMCONO = MPL.IBCONO AND MPDM.PMFACI = MPL.IBFACI
AND MPDM.PMPRNO = MPL.IBITNO)),2) WIP
FROM M3EDBPRD.MPLINE MPL
LEFT OUTER JOIN M3EDBPRD.MPDMAT MPD
ON MPL.IBCONO = MPD.PMCONO AND MPL.IBFACI = MPD.PMFACI
AND MPL.IBITNO = MPD.PMPRNO
WHERE MPL.IBCONO = '500'
AND MPL.IBPUSL BETWEEN '15' AND '49'
AND MPL.IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')
GROUP BY MPL.IBCONO, MPL.IBFACI, MPL.IBITNO,
(SELECT MAX(MO.AHATAV)
FROM M3EDBPRD.MOATTR MO
WHERE MO.AHATNR = MPL.IBATNR AND MO.AHCONO = MPL.IBCONO
AND IBCONO = '500' AND IBPUSL BETWEEN '15' AND '49'
And IBFACI Not In ('A1', 'G2', 'G3', 'G4', 'G5', 'G6', 'G7', 'G8', 'G9')),
MPD.PMMTNO, MPD.PMCNQT
