Objektová akce

Popis:

Vrátí data dokončených výrobků

Kód:

3

Tělo:

SELECT FP.JOBORDER_ID,
       FP2.JOBORDERSSN_ID,
       (SELECT SUM(QUANTITY) FROM PLMFINISHEDPRODUCTS2 WHERE GENESIS_ID = :OBJID) AS SumQuantity,
       FP2.QUNIT,
       (SELECT MAX(PRODUCTIONDATE$DATE) FROM PLMFINISHEDPRODUCTS2 WHERE GENESIS_ID = :OBJID) AS ProductionDATE,
       JOO.QUANTITY AS TotalQuantity,
       FP2.CHECKEDAT$DATE,
       FP2.CHECKEDBY_ID,
       JN.STORECARD_ID,
       (SELECT MAX(RO.FIRM_ID) FROM PLMFINISHEDPRODUCTS2 FP2
        JOIN PLMFINISHEDPRODUCTS FP ON FP.ID = FP2.PARENT_ID 
        JOIN PLMJOBORDERS JO ON JO.ID = FP.JOBORDER_ID
        JOIN PLMPRODUCEREQUESTS PR ON JO.ID = PR.JOBORDER_ID
        JOIN RELATIONS R ON PR.ID = R.LEFTSIDE_ID
        JOIN RECEIVEDORDERS RO ON RO.ID = R.RIGHTSIDE_ID  
        WHERE GENESIS_ID = :OBJID AND R.REL_DEF = 1621) AS OrderFirm,
        FP2.JOOutputItem_ID,
        FP2.UnitRate,
        JOO.QUnit, 
        JOO.UnitRate
FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMFINISHEDPRODUCTS FP ON FP.ID = FP2.PARENT_ID 
JOIN PLMJOOUTPUTITEMS JOO ON JOO.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JN ON JOO.OWNER_ID = JN.ID  
WHERE GENESIS_ID = :OBJID 
ORDER BY FP2.CHECKEDAT$DATE DESC

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