Třídová akce

Popis:

Pro ID dokladu vrátí data ze řádků VMV potřebná pro vytvoření EvolutionItemu

Kód:

31

Tělo:

SELECT S2.STORECARD_ID,SC.ISPRODUCT,SC.NAME, SD.DOCDATE$DATE, SD.ID, DQ.CODE, SD.ORDNUMBER,PE.CODE, SD.DOCUMENTTYPE, S2.QUANTITY, SU.CODE FROM STOREDOCUMENTS2 S2
JOIN PLMMIPLMATERIALDISTRIB MD ON MD.STOREDOCUMENT2_ID = S2.ID
JOIN STOREDOCUMENTS SD ON SD.ID = S2.PARENT_ID
JOIN DOCQUEUES DQ ON DQ.ID = SD.DOCQUEUE_ID
JOIN PERIODS PE ON PE.ID = SD.PERIOD_ID
JOIN STORECARDS SC ON SC.ID = S2.STORECARD_ID
JOIN STOREUNITS SU ON SU.PARENT_ID = SC.ID
JOIN PLMJOINPUTITEMS JI ON JI.ID = MD.PARENT_ID
JOIN PLMJONODES JN ON JN.ID = JI.OWNER_ID
JOIN PLMJOBORDERS JO ON JO.ID = JN.PARENT_ID
WHERE (S2.PMSTATE_ID = '2000000001' OR S2.PMSTATE_ID = 'SDDEF00000') AND JO.ID = :JobOrderOID AND SU.UNITRATE = 1
  AND (
  	NOT EXISTS (SELECT 1 FROM CRPPlanSettingsStoreMenuItems)	  	  
  	OR EXISTS (
  		SELECT 1 FROM CRPPlanSettingsStoreMenuItems SMI 
  		JOIN STORECARDMENUITEMLINKS SCL ON SCL.STOREMENUITEM_ID = SMI.CRPSTOREMENU_ID
  		WHERE SCL.STORECARD_ID = S2.STORECARD_ID
  		)
  )   

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