Epicor Open Sales Order Releases SQL Query Generator (Backlog and Past Due)

SELECT oh.OrderNum,
       od.OrderLine,
       orl.OrderRelNum,
       c.CustID,
       c.Name AS CustomerName,
       od.PartNum,
       od.LineDesc,
       orl.ReqDate,
       orl.OurReqQty,
       od.UnitPrice,
       (orl.OurReqQty * od.UnitPrice) AS ReleaseValue,
       CASE WHEN orl.ReqDate < CAST(GETDATE() AS date) THEN 'PAST DUE' ELSE 'OPEN' END AS DueStatus
FROM Erp.OrderHed oh
INNER JOIN Erp.OrderDtl od
        ON od.Company = oh.Company
       AND od.OrderNum = oh.OrderNum
INNER JOIN Erp.OrderRel orl
        ON orl.Company = od.Company
       AND orl.OrderNum = od.OrderNum
       AND orl.OrderLine = od.OrderLine
INNER JOIN Erp.Customer c
        ON c.Company = oh.Company
       AND c.CustNum = oh.CustNum
WHERE oh.Company = 'EPIC06'
  AND oh.OpenOrder = 1
  AND od.OpenLine = 1
  AND orl.OpenRelease = 1
  AND orl.ReqDate BETWEEN '2026-10-01' AND '2026-12-31'
  AND ('[Customer id (blank for all)]' = '' OR c.CustID = '[Customer id (blank for all)]')
ORDER BY orl.ReqDate, oh.OrderNum, od.OrderLine, orl.OrderRelNum;