--JO
SELECT JO.ID, DQ.DOCUMENTTYPE, DQ.CODE, JO.PERIOD_ID, JO.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
JOIN DOCQUEUES DQ ON DQ.ID = JO.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--PQ
SELECT PQ.ID, DQ.DOCUMENTTYPE, DQ.CODE, PQ.PERIOD_ID, PQ.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
JOIN PLMPRODUCEREQUESTS PQ ON PQ.JOBORDER_ID = JO.ID
JOIN DOCQUEUES DQ ON DQ.ID = PQ.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--příjem hotových výrobků
SELECT SD.ID, DQ.DOCUMENTTYPE, DQ.CODE, SD.PERIOD_ID, SD.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOBORDERSSN SN ON SN.ID = FP2.JOBORDERSSN_ID
JOIN DOCROWBATCHES DRB ON DRB.STOREBATCH_ID = SN.STOREBATCH_ID
JOIN STOREDOCUMENTS2 SD2 ON SD2.ID = DRB.PARENT_ID
JOIN STOREDOCUMENTS SD ON SD.DOCUMENTTYPE = '28' AND SD.ID = SD2.PARENT_ID
JOIN DOCQUEUES DQ ON DQ.ID = SD.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--výdej materiálu do výroby
SELECT SD.ID, DQ.DOCUMENTTYPE, DQ.CODE, SD.PERIOD_ID, SD.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
JOIN STOREDOCUMENTS2 SD2 ON SD2.PRODUCTIONTASK_ID = JO.PRODUCTIONTASK_ID
JOIN STOREDOCUMENTS SD ON SD.DOCUMENTTYPE = '27' AND SD.ID = SD2.PARENT_ID
JOIN DOCQUEUES DQ ON DQ.ID = SD.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--vrácení materiálu z výroby
SELECT SD.ID, DQ.DOCUMENTTYPE, DQ.CODE, SD.PERIOD_ID, SD.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
JOIN STOREDOCUMENTS2 SD2 ON SD2.PRODUCTIONTASK_ID = JO.PRODUCTIONTASK_ID
JOIN STOREDOCUMENTS SD ON SD.DOCUMENTTYPE = '29' AND SD.ID = SD2.PARENT_ID
JOIN DOCQUEUES DQ ON DQ.ID = SD.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--Aktivity k výrobním příkazům
SELECT ACT.ID, 'AC' AS DOCUMENTTYPE, 'ACT' AS CODE, ACT.PERIOD_ID, ACT.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
JOIN RELATIONS REL ON REL.REL_DEF = 1257 AND REL.RIGHTSIDE_ID = JO.ID
JOIN CRMACTIVITIES ACT ON ACT.ID = REL.LEFTSIDE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--převodky výdeje
SELECT SD.ID, DQ.DOCUMENTTYPE, DQ.CODE, SD.PERIOD_ID, SD.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJOBORDERSSN SN ON SN.ID = FP2.JOBORDERSSN_ID
JOIN STOREBATCHES SB ON SB.ID = SN.STOREBATCH_ID
JOIN DOCROWBATCHES DRB ON DRB.STOREBATCH_ID = SB.ID
JOIN STOREDOCUMENTS2 SD2 ON SD2.ID = DRB.PARENT_ID
JOIN STOREDOCUMENTS SD ON SD.ID = SD2.PARENT_ID AND SD.DOCUMENTTYPE = '22'
JOIN DOCQUEUES DQ ON DQ.ID = SD.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--převodky příjmy
SELECT SD.ID, DQ.DOCUMENTTYPE, DQ.CODE, SD.PERIOD_ID, SD.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJOBORDERSSN SN ON SN.ID = FP2.JOBORDERSSN_ID
JOIN STOREBATCHES SB ON SB.ID = SN.STOREBATCH_ID
JOIN DOCROWBATCHES DRB ON DRB.STOREBATCH_ID = SB.ID
JOIN STOREDOCUMENTS2 SD2 ON SD2.ID = DRB.PARENT_ID
JOIN STOREDOCUMENTS SD ON SD.ID = SD2.PARENT_ID AND SD.DOCUMENTTYPE = '24'
JOIN DOCQUEUES DQ ON DQ.ID = SD.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--Objednávky přijaté
SELECT RO.ID, 'RO' AS DOCUMENTTYPE, 'OP' AS CODE, RO.PERIOD_ID, RO.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
JOIN PLMPRODUCEREQUESTS PQ ON PQ.JOBORDER_ID = JO.ID
JOIN RELATIONS REL ON REL.REL_DEF = 1620 AND REL.RIGHTSIDE_ID = PQ.ID
JOIN RECEIVEDORDERS RO ON RO.ID = REL.LEFTSIDE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--Nabídky vydané
SELECT ISOF.ID, 'IF' AS DOCUMENTTYPE, 'NV' AS CODE, ISOF.PERIOD_ID, ISOF.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJONODES JON ON JON.ID = JOOI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JON.PARENT_ID
JOIN PLMPRODUCEREQUESTS PQ ON PQ.JOBORDER_ID = JO.ID
JOIN RELATIONS REL ON REL.REL_DEF = 1620 AND REL.RIGHTSIDE_ID = PQ.ID
JOIN RECEIVEDORDERS RO ON RO.ID = REL.LEFTSIDE_ID
JOIN RECEIVEDORDERS2 RO2 ON RO2.PARENT_ID = RO.ID
JOIN ISSUEDOFFERS ISOF ON ISOF.ID = RO2.PROVIDE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--dodací listy
SELECT SD.ID, DQ.DOCUMENTTYPE, DQ.CODE, SD.PERIOD_ID, SD.ORDNUMBER FROM PLMFINISHEDPRODUCTS2 FP2
JOIN PLMJOOUTPUTITEMS JOOI ON JOOI.ID = FP2.JOOUTPUTITEM_ID
JOIN PLMJOBORDERSSN SN ON SN.ID = FP2.JOBORDERSSN_ID
JOIN STOREBATCHES SB ON SB.ID = SN.STOREBATCH_ID
JOIN DOCROWBATCHES DRB ON DRB.STOREBATCH_ID = SB.ID
JOIN STOREDOCUMENTS2 SD2 ON SD2.ID = DRB.PARENT_ID
JOIN STOREDOCUMENTS SD ON SD.ID = SD2.PARENT_ID AND SD.DOCUMENTTYPE = '21'
JOIN DOCQUEUES DQ ON DQ.ID = SD.DOCQUEUE_ID
WHERE :ParameterType = 1 AND FP2.GENESIS_ID = :OBJID
UNION
--JO
SELECT JO.ID, DQ.DOCUMENTTYPE, DQ.CODE, JO.PERIOD_ID, JO.ORDNUMBER FROM PLMJOBORDERS JO
JOIN DOCQUEUES DQ ON DQ.ID = JO.DOCQUEUE_ID
WHERE :ParameterType = 2 AND JO.ID = :JOOID
UNION
--PQ
SELECT PQ.ID, DQ.DOCUMENTTYPE, DQ.CODE, PQ.PERIOD_ID, PQ.ORDNUMBER FROM PLMJOBORDERS JO
JOIN PLMPRODUCEREQUESTS PQ ON PQ.JOBORDER_ID = JO.ID
JOIN DOCQUEUES DQ ON DQ.ID = PQ.DOCQUEUE_ID
WHERE :ParameterType = 2 AND JO.ID = :JOOID Generated by ABRA Software a.s. 27.10.2021 16:34:49