SELECT SC.ID, SB.ID, JOII.ID, NT.TREELEVEL, 'N' AS ISSUED, 0 AS QUANTITY, 'xx' AS QUNIT, SC.CODE, SC.NAME, SB.NAME
FROM PLMJOOUTPUTITEMS JOOI1
JOIN PLMJONODES JON ON JON.ID = JOOI1.OWNER_ID
LEFT JOIN GetPLMJOChildNodes(JON.ID) NT ON 1=1
JOIN PLMJONODES JON2 ON JON2.MASTER_ID = NT.ID
JOIN PLMJOINPUTITEMS JOII ON JOII.OWNER_ID = jon2.ID
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.OWNER_ID = NT.ID
JOIN PLMJOBORDERSROUTINES JOR ON JOR.PARENT_ID = JOOI.ID
JOIN PLMJOROUTINESMAT JORM ON JORM.PARENT_ID = JOR.ID AND JORM.STORECARD_ID = JON2.STORECARD_ID
JOIN STORECARDS SC ON SC.ID = JORM.STORECARD_ID
JOIN STOREBATCHES SB ON SB.STORECARD_ID = JORM.STORECARD_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
LEFT JOIN STOREDOCUMENTS2 SD2 ON SD2.PRODUCTIONTASK_ID = JO.PRODUCTIONTASK_ID AND SD2.STORECARD_ID = JORM.STORECARD_ID AND SD2.FLOWTYPE = 27
LEFT JOIN DOCROWBATCHES DRB ON DRB.PARENT_ID = SD2.ID AND DRB.STOREBATCH_ID = SB.ID
WHERE
JOOI1.ID = :JOOIOID
AND (:RoutineOID = '0000000000' OR JOR.ID = :RoutineOID)
AND (:TreeLevel = 0 OR NT.TREELEVEL <= :TreeLevel)
AND SB.ExpirationDate$Date >= :DateFrom
AND (DRB.ID IS NOT NULL OR :OnlyIssued = 'N')
AND (SB.SERIALNUMBER = 'N'
OR NOT EXISTS (SELECT 1 FROM PLMJOBORDERSCOMPONENTS WHERE COMPONENT_ID = SB.ID AND (:JobOrdersSN_ID = '0000000000' OR PARENT_ID <> :JobOrdersSN_ID ) )
)
Generated by ABRA Software a.s. 27.10.2021 16:34:49