Třídová akce

Popis:

Vrátí hodnoty pro spočítání dostupnosti množství dané šarže pro výrobní příkaz

Kód:

8

Tělo:

SELECT 'SK', Sum(SB.Quantity) FROM STORESUBBATCHES SB
WHERE SB.STOREBATCH_ID = :SBID
UNION ALL
SELECT 'VJ', Sum(S2.Quantity) FROM STOREDOCUMENTS2 S2
JOIN DocRowBatches RB ON RB.PARENT_ID=S2.id
JOIN PLMMIPLMaterialDistrib MD ON MD.STOREDOCUMENT2_ID=S2.id
JOIN PLMJOInputItems II ON II.ID = MD.PARENT_ID
JOIN PLMJONODES NI ON NI.ID=II.OWNER_ID
WHERE (S2.FLOWTYPE='27')
  AND RB.STOREBATCH_ID = :SBID
  AND NI.PARENT_ID <> :JOID
UNION ALL
SELECT 'RJ', Sum(S2.Quantity) FROM STOREDOCUMENTS2 S2
JOIN DocRowBatches RB ON RB.PARENT_ID=S2.id
JOIN PLMMIPLMaterialDistrib MD ON MD.STOREDOCUMENT2_ID=S2.id
JOIN PLMJOInputItems II ON II.ID = MD.PARENT_ID
JOIN PLMJONODES NI ON NI.ID=II.OWNER_ID
WHERE (S2.FLOWTYPE='29')
  AND RB.STOREBATCH_ID = :SBID
  AND NI.PARENT_ID <> :JOID
UNION ALL
SELECT 'KJ', Sum(C.Quantity) FROM PLMJOBORDERSCOMPONENTS C
JOIN PLMJOBORDERSSN JOSN ON JOSN.ID=C.PARENT_ID
WHERE C.COMPONENT_ID = :SBID
  AND JOSN.PARENT_ID <> :JOID
UNION ALL
SELECT 'VP', Sum(S2.Quantity) FROM STOREDOCUMENTS2 S2
JOIN DocRowBatches RB ON RB.PARENT_ID=S2.id
JOIN PLMMIPLMaterialDistrib MD ON MD.STOREDOCUMENT2_ID=S2.id
JOIN PLMJOInputItems II ON II.ID = MD.PARENT_ID
JOIN PLMJONODES NI ON NI.ID=II.OWNER_ID
WHERE S2.FLOWTYPE='27'
  AND RB.STOREBATCH_ID=:SBID
  AND NI.PARENT_ID = :JOID
UNION ALL
SELECT 'RP', Sum(S2.Quantity) FROM STOREDOCUMENTS2 S2
JOIN DocRowBatches RB ON RB.PARENT_ID=S2.id
JOIN PLMMIPLMaterialDistrib MD ON MD.STOREDOCUMENT2_ID=S2.id
JOIN PLMJOInputItems II ON II.ID = MD.PARENT_ID
JOIN PLMJONODES NI ON NI.ID=II.OWNER_ID
WHERE S2.FLOWTYPE='29'
  AND RB.STOREBATCH_ID=:SBID
  AND NI.PARENT_ID = :JOID
UNION ALL
SELECT 'KP', Sum(C.Quantity) FROM PLMJOBORDERSCOMPONENTS C
JOIN PLMJOBORDERSSN JOSN ON JOSN.ID=C.PARENT_ID
WHERE C.COMPONENT_ID = :SBID
  AND JOSN.PARENT_ID = :JOID
UNION ALL
SELECT 'DV', Sum(FP.QUANTITY) FROM PLMFINISHEDPRODUCTS2 FP
JOIN PLMJOBORDERSSN JOSN ON JOSN.ID = FP.JOBORDERSSN_ID
WHERE FP.StoreDoc2_ID IS NULL
  AND JOSN.STOREBATCH_ID = :SBID

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