Třídová akce

Popis:

Pro tvořenou komponentu získá ID kusovníku - 1. přes výdej materiálu, 2. přes shodnou skladovou kartu - nepoužité pozice, 3. i použité pozice

Kód:

5

Tělo:

SELECT 
      MIPLMD.Parent_ID AS InputItem_ID, 1 AS PRIORITY 
   FROM PLMJOBORDERSROUTINES JOR
   JOIN PLMJOROUTINESMAT JORM ON JORM.PARENT_ID = JOR.ID
   JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID  = JOR.PARENT_ID 
   JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
   JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
   JOIN STOREDOCUMENTS2 SD2 ON SD2.PRODUCTIONTASK_ID = JO.PRODUCTIONTASK_ID AND SD2.STORECARD_ID = JORM.STORECARD_ID  AND SD2.FLOWTYPE = 27
   JOIN DOCROWBATCHES DRB ON DRB.PARENT_ID = SD2.ID
   JOIN PLMMIPLMaterialDistrib MIPLMD ON MIPLMD.StoreDocument2_ID = SD2.ID
   WHERE JOR.PARENT_ID = :JOOI_ID
   AND DRB.STOREBATCH_ID = :StoreBatch_ID
   UNION
   SELECT 
   JOII.ID AS InputItem_ID, 2 AS PRIORITY  
   FROM PLMJOBORDERSROUTINES JOR
   JOIN PLMJOROUTINESMAT JORM ON JORM.PARENT_ID = JOR.ID
   JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID  = JOR.PARENT_ID 
   JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
   JOIN PLMJONODES JON2 ON JON2.PARENT_ID = JON.Parent_ID AND JON2.STORECARD_ID = JORM.STORECARD_ID AND JON2.ID <> JON.ID
   JOIN PLMJOINPUTITEMS JOII ON JOII.OWNER_ID = JON2.ID
   JOIN STOREBATCHES SB ON SB.STORECARD_ID = JORM.STORECARD_ID
   LEFT JOIN PLMJOBORDERSCOMPONENTS JOC ON JOC.INPUTITEM_ID = JOII.ID
   WHERE JOR.PARENT_ID = :JOOI_ID 
   AND {UsedInputItemIDs} not like '%' || JOII.ID || '%'
   AND JOC.ID IS NULL
   AND SB.ID = :StoreBatch_ID 
   UNION
   SELECT 
      JOII.ID AS InputItem_ID, 3 AS PRIORITY  
   FROM PLMJOBORDERSROUTINES JOR
   JOIN PLMJOROUTINESMAT JORM ON JORM.PARENT_ID = JOR.ID
   JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID  = JOR.PARENT_ID 
   JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
   JOIN PLMJONODES JON2 ON JON2.PARENT_ID = JON.PARENT_ID AND JON2.STORECARD_ID = JORM.STORECARD_ID AND JON2.ID <> JON.ID
   JOIN PLMJOINPUTITEMS JOII ON JOII.OWNER_ID = JON2.ID
   JOIN STOREBATCHES SB ON SB.STORECARD_ID = JORM.STORECARD_ID
   WHERE JOR.PARENT_ID = :JOOI_ID
   AND SB.ID = :StoreBatch_ID 
   ORDER BY 2

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