Třídová akce

Popis:

Vrátí InputItem ID pro výdej materiálu, která se mají seskupit - BulkIssue = 1

Kód:

4

Tělo:

SELECT JOII2.ID, JOII2.QUANTITY
FROM PLMJOINPUTITEMS JOII
JOIN PLMJONODES JON ON JON.ID = JOII.OWNER_ID
JOIN PLMJONODES JON2 ON JON2.MASTER_ID = JON.MASTER_ID AND JON2.STORECARD_ID = JON.STORECARD_ID
JOIN PLMJOINPUTITEMS JOII2 ON 
	JOII2.OWNER_ID = JON2.ID 
    AND JOII2.QUNIT = JOII.QUNIT 
	AND JOII2.ALLOWMIX = JOII.ALLOWMIX 
	AND JOII2.SUPPOSEDSTORE_ID = JOII.SUPPOSEDSTORE_ID 
	AND JOII2.DONOTMULTIPLY = JOII.DONOTMULTIPLY
        AND JOII2.BulkIssue = 1
WHERE JOII.ID = :AJOIIOID
ORDER BY JOII2.QUANTITY DESC, JOII2.ID 

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