Infor M3 SQL Query Generator for Items, Balances and Open Orders

SELECT MMCONO, MMITNO, MMITDS, MMITTY, MMITGR, MMUNMS, MMSTAT
FROM MITMAS
WHERE MMCONO = 100
  AND MMITNO LIKE 'AB%'
  AND MMSTAT = '20'
ORDER BY MMITNO;

SELECT MBCONO, MBWHLO, MBITNO, MBSTQT, MBALQT, MBREOP, MBSSQT
FROM MITBAL
WHERE MBCONO = 100
  AND MBWHLO = 'A01'
  AND MBITNO LIKE 'AB%'
ORDER BY MBITNO;

SELECT H.OAORNO, H.OACUNO, L.OBPONR, L.OBPOSX, L.OBITNO, L.OBORQT, L.OBORST, L.OBDWDT
FROM OOLINE L
JOIN OOHEAD H
  ON H.OACONO = L.OBCONO
 AND H.OAORNO = L.OBORNO
WHERE L.OBCONO = 100
  AND L.OBWHLO = 'A01'
  AND L.OBORST < '44'
  AND L.OBDWDT <= 20261231
ORDER BY L.OBDWDT, H.OAORNO, L.OBPONR;

SELECT H.IAPUNO, H.IASUNO, L.IBPNLI, L.IBPNLS, L.IBITNO, L.IBPUSL
FROM MPLINE L
JOIN MPHEAD H
  ON H.IACONO = L.IBCONO
 AND H.IAPUNO = L.IBPUNO
WHERE L.IBCONO = 100
  AND H.IASUNO = 'SUP001'
  AND L.IBPUSL < '75'
ORDER BY H.IAPUNO, L.IBPNLI;