Třídová akce

Kód:

9

Tělo:

Select
  A.ID,
  case when A.JORoutine_ID IS NULL then
    (Select 
      (DQ.Code || '-' || CAST(PR.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code || ' ' || RR.Title) as DisplayName 
    From
      PLMReqRoutines RR
      join PLMReqOutputItems ROI on RR.Parent_ID = ROI.ID
      join PLMReqNodes RN on ROI.Owner_ID = RN.ID
      join PLMProduceRequests PR on RN.Parent_ID = PR.ID
      join DocQueues DQ on PR.DocQueue_ID = DQ.ID
      join Periods P on PR.Period_ID = P.ID 
    where 
      RR.ID = A.ReqRoutine_ID)  
  ELSE
    (Select 
      (DQ.Code || '-' || CAST(JO.OrdNumber AS VARCHAR(10)) || '/' ||  P.Code || ' ' || JOR.Title) as DisplayName
    From
      PLMJobOrdersRoutines JOR 
      join PLMJOOutputItems JOI on JOR.Parent_ID = JOI.ID
      join PLMJONodes JON on JOI.Owner_ID = JON.ID
      join PLMJobOrders JO on JON.Parent_ID = JO.ID
      join DocQueues DQ on JO.DocQueue_ID = DQ.ID
      join Periods P on JO.Period_ID = P.ID 
    where 
      JOR.ID = A.JORoutine_ID)            
  END AS Display_Name,
  A.DateFrom$DATE    
From
  PLMWorkScheduleItems A
Where
  (A.Status in (0, 1)) and
  (A.DateFrom$DATE < :CurrentDate) and
  (A.DateFrom$DATE > 0)
order by
  A.DateFrom$DATE

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