Třídová akce

Popis:

Porovná skladové karty použité v technologickém postupu s kusovníkem

Kód:

16

Tělo:

SELECT
  StoreCard_ID,
  Quantity AS Quantity,
  QUnit,
  UnitRate,
  Phase_ID,
  P.Code
FROM
  (
   SELECT
     StoreCard_ID,
     SUM(Quantity) AS Quantity,
     QUnit,
     MAX(UnitRate) AS UnitRate,
     MIN(AllQuantity) AS AllQuantity,
     Phase_ID
   FROM
     (SELECT
        PL.StoreCard_ID,
        PL.Quantity,
        PL.QUnit,
        PL.UnitRate,
        'N' as AllQuantity,
        PL.Phase_ID
      FROM
        PLMPieceLists2 PL
      WHERE
        PL.Parent_ID = :APLMPieceList_ID

      UNION ALL

      SELECT
        RM.StoreCard_ID,
        -RM.Quantity as Quantity,
        RM.QUnit,
        RM.UnitRate,
        RM.AllQuantity,
        R2.Phase_ID
      FROM
        PLMRoutinesMaterials RM
        JOIN PLMRoutines2 R2 ON R2.ID = RM.Parent_ID
      WHERE
        R2.Parent_ID = :APLMRoutines_ID       
     ) SelA
   GROUP BY
     SelA.StoreCard_ID, SelA.QUnit, SelA.Phase_ID
  ) SelB
  LEFT JOIN PLMPHASES P ON P.ID = SelB.Phase_ID 
WHERE
   (SelB.Quantity*:AKind > 0 AND SelB.AllQuantity = 'N')
   OR     
   (SelB.Quantity = 0 AND :AKind = -1 AND SelB.AllQuantity = 'A')

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