Epicor Open Jobs Query Generator (Erp.JobHead SQL for BAQ and SSMS)

-- Open released jobs for company EPIC06, plant MfgSys
-- Read-only. Run in SSMS against a non-production copy first.
SELECT
    jh.Company,
    jh.Plant,
    jh.JobNum,
    jh.PartNum,
    jh.PartDescription,
    jh.ProdQty,
    jh.StartDate,
    jh.DueDate,
    jh.JobFirm,
    jh.JobReleased,
    jh.JobComplete,
    jh.JobClosed
FROM Erp.JobHead AS jh
WHERE jh.Company = 'EPIC06'
  AND jh.Plant = 'MfgSys'
  AND jh.JobClosed = 0
  AND jh.JobComplete = 0
  AND jh.JobReleased = 1
  AND jh.DueDate <= '2026-12-31'
  AND jh.PartNum LIKE 'BRK%'
ORDER BY jh.DueDate, jh.JobNum;

-- Firm filter selected: Any
-- If you chose Firm only, add this line to the WHERE clause:
--   AND jh.JobFirm = 1

SELECT jo.JobNum, jo.AssemblySeq, jo.OprSeq, jo.OpCode, jo.OpComplete
FROM Erp.JobOper AS jo
JOIN Erp.JobHead AS jh
  ON jh.Company = jo.Company AND jh.JobNum = jo.JobNum
WHERE jh.Company = 'EPIC06'
  AND jh.JobClosed = 0
  AND jo.OpComplete = 0
ORDER BY jo.JobNum, jo.AssemblySeq, jo.OprSeq;