Třídová akce

Popis:

Vrátí seznam ID operací požadavku, které nemají dílenský úkon, ale mají ho mít

Kód:

4

Tělo:

  SELECT ReqR.ID, Req.ID
  FROM PLMReqRoutines ReqR
    INNER JOIN PLMReqOutputItems ReqO ON (ReqR.parent_id = ReqO.ID)
    INNER JOIN PLMReqNodes ReqN ON (ReqO.owner_id = ReqN.ID)
    INNER JOIN PLMProduceRequests Req ON (ReqN.parent_id = Req.ID)
    INNER JOIN PLMPQParams PQP ON (Req.docqueue_id = PQP.docqueue_id)
    INNER JOIN Periods P ON (Req.period_id = P.ID)
  WHERE
    Req.canceled = 'N' AND
--    Req.joborder_id is null AND
    Req.releasedat$date = 0 AND
    PQP.Id = :QueueParam_ID AND
    PQP.inplan = 'A' AND
    ReqR.ID not in (SELECT WSI.reqroutine_id FROM PLMWorkScheduleItems WSI)
  ORDER BY Req.schedule$date, P.sequencenumber, Req.ordnumber

Generated by ABRA Software a.s. 27.10.2021 16:34:49