1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
SELECT
[FML_ID],
[MAT_ID],
[DOM_ID],
(
SELECT TOP 1
[D].[WFI_NAME]
FROM
[dbo].[T_INSTANCE_WORKFLOW] [B]
INNER JOIN
[dbo].[T_INSTANCE_WORKFLOW_ITEM] [C] ON [C].[IWF_ID] = [B].[IWF_ID]
INNER JOIN
[dbo].[T_WORKFLOW_ITEM] [D] ON [D].[WFI_ID] = [C].[WFI_ID]
WHERE
[A].[IWF_ID] = [B].[IWF_ID]
ORDER BY
[IWI_DATE]
DESC
) AS [FML_STATUS],
[IWF_ID],
[TYP_ID],
[FML_NAME],
[FML_LABEL],
[FML_VERSION],
[FML_ORIGINE_TYPE],
[FML_ORIGINE_FORMULA_ID],
[FML_EXPIRATION_DURATION],
[FML_EXPIRATION_UNIT],
[FML_QUANTITY],
[FML_LAST_EDIT_BY],
[FML_LAST_EDIT_AT],
[FML_MINIMUM_QUANTITY],
[FML_MAXIMUM_QUANTITY],
[FML_EXPIRE]
FROM
[T_FORMULA] [A]
GO |
Partager