Objektová akce

Kód:

9

Tělo:

SELECT /*+ DYNAMIC_SAMPLING(N 5) */ {FIELDS}, I.ID AS InputItem_ID, O.ID AS OutputItem_ID, N.TreePath AS TreePath, N.TreeLevel AS TreeLevel
FROM 
#IB
  GetPLMReqCostingNodes(:OBJID) N
#MS
  GetPLMReqCostingNodes(:OBJID) N
#ORA
  Table(GetPLMReqCostingNodes(:OBJID)) N
#ALL
JOIN PLMReqCostingNodes A ON A.ID = N.ID
LEFT JOIN PLMReqCostingOutputItems O ON O.Owner_ID = A.ID
LEFT JOIN PLMReqCostingInputItems I ON I.Owner_ID = A.ID

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