Třídová akce

Popis:

Vrátí data materiálů s komponentami

Kód:

8

Tělo:

SELECT CODE,NAME,MIN(QUANTITY),QUNIT,MAX(SBNAME) FROM (
	SELECT SC.CODE,SC.NAME, JC.QUANTITY, RM.QUNIT, SB.NAME AS SBNAME FROM PLMJOROUTINESMAT RM
	JOIN STORECARDS SC ON SC.ID = RM.STORECARD_ID
	JOIN PLMJOBORDERSROUTINES JR ON JR.ID = RM.PARENT_ID
	JOIN PLMJOOUTPUTITEMS OI ON OI.ID = JR.PARENT_ID JOIN PLMJOBORDERSSN SN ON SN.PARENT_ID = OI.ID
	JOIN PLMJOBORDERSCOMPONENTS JC ON JC.PARENT_ID = SN.ID  
	JOIN STOREBATCHES SB ON SB.ID = JC.COMPONENT_ID
	WHERE RM.PARENT_ID = :RoutineID AND SB.STORECARD_ID = SC.ID 
	UNION
	SELECT SC.CODE,SC.NAME, Rm.QUANTITY, RM.QUNIT,NULL as SERIALNUMBER FROM PLMJOROUTINESMAT RM
	JOIN STORECARDS SC ON SC.ID = RM.STORECARD_ID
	WHERE RM.PARENT_ID = :RoutineID 
) A
GROUP BY CODE,NAME,QUNIT

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