Objektová akce

Kód:

4

Tělo:

SELECT sum(ssc.Quantity)
FROM PLMJOInputItems B
JOIN PLMJONodes N ON N.ID = B.Owner_ID
LEFT JOIN STORESUBCARDS SSC on ssc.Storecard_id = N.Storecard_id
WHERE B.id = :OBJID

UNION ALL

SELECT sum(ssc.Quantity)
FROM 
#ORA
Table(
#ALL
GETSTORECARDREPLACEMENTS(
  (SELECT N.STORECARD_ID FROM PLMJOInputItems A JOIN PLMJONodes N ON N.ID = A.Owner_ID WHERE a.id = :OBJID)
)
#ORA
) 
#ALL
a
LEFT JOIN STORESUBCARDS SSC on ssc.Storecard_id = a.id

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