Objektová akce

Kód:

14

Tělo:

 /* veškeré skladové doklady VMV, PHV, VRM */
SELECT 
  DISTINCT sd.DocumentType, sd.ID
FROM
  PLMJobOrders A
  JOIN StoreDocuments2 sd2 on sd2.ProductionTask_ID = a.ProductionTask_ID
  JOIN StoreDocuments sd on sd.ID = sd2.Parent_ID
WHERE
  A.ID = :OBJID
  
UNION ALL

 /* požadavky na výrobu */
SELECT 
  cast('PQ' as VARCHAR(2)), A.ID
FROM
  PLMProduceRequests A
WHERE
  A.JOBORDER_ID = :OBJID

UNION ALL
  
 /* KOOPERACE */
SELECT 
  cast('CO' as VARCHAR(2)), A.ID
FROM
  PLMCooperations A
WHERE
  A.JOBORDER_ID = :OBJID
  
UNION ALL

 /* AWT */
SELECT 
  cast('WT' as VARCHAR(2)), A.AGGREGATEWORKTICKET_ID
FROM
  PLMOperations A
  JOIN PLMJobOrdersRoutines R ON (A.JobOrdersRoutines_ID = R.ID)
  JOIN PLMJOOutputItems O ON (R.Parent_ID = O.ID)
  JOIN PLMJONodes N ON (O.Owner_ID = N.ID)
WHERE
  N.Parent_ID = :OBJID
  AND not A.AGGREGATEWORKTICKET_ID is null
GROUP BY
  A.AGGREGATEWORKTICKET_ID

UNION ALL

 /* VRV */
SELECT 
  cast('BP' as VARCHAR(2)), A.ID
FROM
  PLMBALANCEINPROCESSPRODUCES A
WHERE
  A.JOBORDER_ID = :OBJID  
UNION ALL

/* FP */
SELECT 
  cast('FP' as VARCHAR(2)), A.ID
FROM
  PLMFinishedProducts A
WHERE
  A.JobOrder_ID = :OBJID  
  
  

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