Objektová akce

Popis:

Vrátí záznam, pokud je aspoň u jednoho VP v parametrech AllowUseMDAfterPR = 'N'

Kód:

14

Tělo:

select DISTINCT SPQ.modeusemdafterpr
  FROM STOREDOCUMENTS2 SD2
  INNER JOIN PLMMIPLMATERIALDISTRIB MIPLMD ON (MIPLMD.STOREDOCUMENT2_ID = SD2.ID)
  INNER JOIN PLMJOInputItems MIPL   ON (MIPL.ID = MIPLMD.PARENT_ID)
  INNER JOIN PLMJONodes             N      ON (N.ID = MIPL.Owner_ID) 
  INNER JOIN PLMJOBORDERS           JO     ON (JO.ID = N.PARENT_ID)
  INNER JOIN DOCQUEUES              DQ     ON (JO.DOCQUEUE_ID = DQ.ID)
  INNER JOIN PLMJOSETPARSQUEUES     SPQ    ON (SPQ.DOCQUEUE_ID = DQ.ID)
WHERE SD2.parent_id = :OBJID
      AND SPQ.modeusemdafterpr = 0

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