SELECT DISTINCT FP2.GENESIS_ID,JO.ID,SN.STOREBATCH_ID, SC.NAME,SB.NAME,DQ.CODE,JO.ORDNUMBER,PR.CODE FROM PLMJOBORDERSCOMPONENTS JC JOIN PLMJOBORDERSSN SN ON SN.ID = JC.PARENT_ID JOIN PLMJOOUTPUTITEMS OI ON OI.ID = SN.PARENT_ID LEFT JOIN PLMFINISHEDPRODUCTS2 FP2 ON FP2.JOBORDERSSN_ID = SN.ID JOIN PLMJONODES JN ON JN.ID = OI.OWNER_ID JOIN STORECARDS SC ON SC.ID = JN.STORECARD_ID JOIN PLMJOBORDERS JO ON JO.ID = JN.PARENT_ID JOIN STOREBATCHES SB ON SB.ID = SN.STOREBATCH_ID JOIN PERIODS PR ON PR.ID = JO.PERIOD_ID JOIN DOCQUEUES DQ ON DQ.ID = JO.DOCQUEUE_ID WHERE JC.COMPONENT_ID = :StoreBatch_ID
Generated by ABRA Software a.s. 27.10.2021 16:34:49