SELECT v.Competence_ID,
v.MobileCompetence_ID,
v.CompetenceName,
v.CategoryName,
v.Category_ID,
v.InputValue,
v.CompetenceValue,
v.CompetenceType,
v.Duration,
v.Validity,
v.CalculateTBC,
v.Overlap,
v.MasterItemID,
v.MirrorMachine_ID
FROM CRPPlanVariants3 v
WHERE (v.Parent_ID = :Parent_ID and v.Machine_ID = :Machine_ID and v.Variant_ID = :Variant_ID)
ORDER BY v.ItemID Generated by ABRA Software a.s. 27.10.2021 16:35:42