Objektová akce

Popis:

Vrátí, jestli jsou vyrovnány pracovní lístky

Kód:

43

Tělo:

SELECT JO.ID
   FROM PLMJobOrdersRoutines JOR
     JOIN PLMJOOUTPUTITEMS JOOI ON (JOR.parent_id = JOOI.id)
     JOIN PLMJONODES JON ON (JOOI.owner_id = JON.id)
     JOIN PLMJOBORDERS JO ON (JON.parent_id = JO.id)
   WHERE JO.ID = :OBJID
   GROUP BY JO.ID, JOR.ID
   HAVING
   ((
    ((SELECT COALESCE(SUM(SalaryCosts+GeneralExpense+OverheadCosts), 0) FROM PLMJOBORDERSROUTINEAD AD WHERE AD.parent_id = JOR.ID)
      <
     (SELECT COALESCE(SUM(SalaryCosts+GeneralExpense+OverheadCosts), 0) FROM PLMOPERATIONS OP WHERE OP.JOBORDERSROUTINES_ID =JOR.ID))
    )
  )

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