Procedura-PLMGetChildJobOrdersSN

Popis:

Vrací všechny podřízené JOBORDERSSN_ID po linii komponent

Parametry:

Název	Popis	Datový typ
A_JOBORDERSSN_ID		ID

Návratové hodnoty:

Název	Popis	Datový typ
ID		ID
TreeLevel		Integer

Tělo:

BEGIN
  FOR
   WITH RECURSIVE T(JOBORDERSSN_ID, TreeLevel) AS 
   (
      SELECT SN.ID, 0 AS TreeLevel FROM  PLMJOBORDERSSN SN WHERE SN.ID = :A_JOBORDERSSN_ID 
      UNION ALL
      SELECT SN2.ID, T.TreeLevel + 1 AS TreeLevel 
      FROM PLMJOBORDERSCOMPONENTS JOC2 
      JOIN PLMJOBORDERSSN SN2 ON SN2.STOREBATCH_ID = JOC2.COMPONENT_ID
      JOIN T ON T.JOBORDERSSN_ID = JOC2.PARENT_ID 
   )
    SELECT DISTINCT JOBORDERSSN_ID, TreeLevel FROM T
    INTO :ID, :TreeLevel
  DO BEGIN
    SUSPEND;
  END
END

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