MTECH - Workflow Details

MTECH Workflow Details

SELECT DISTINCT WM.WORKFLOWMASKKEY, WM.WORKFLOWCODE, WM.WORKFLOWDESCRIPTION, WE.WORKFLOWEVENTKEY, WE.SEQUENCE, WE.EVENTKEY, E.EVENTDESCRIPTION, WE.DESCRIPTIONDISPLAY, -- WORKFLOW DETAIL
R.RULEKEY, -- RULE
TE.EVENTKEY, TE.EVENTDESCRIPTION, RT.NUMBEROFDAYS, -- TRIGGERING EVENT
CE.EVENTKEY, CE.EVENTDESCRIPTION,    -- CONDITIONEVENT
LE.EVENTKEY, LE.EVENTDESCRIPTION     -- LIMITEDEVENT
FROM WORKFLOWMASK WM
LEFT JOIN WORKFLOWEVENT WE ON WM.WORKFLOWMASKKEY = WE.WORKFLOWMASKKEY
LEFT JOIN TABLEEVENT E ON WE.EVENTKEY = E.EVENTKEY
LEFT JOIN TABLERULE R ON WE.EVENTKEY = R.EVENTKEY AND R.LAWKEY IS NULL
    LEFT JOIN TABLERULETRIGGER RT ON RT.RULEKEY = R.RULEKEY         -- TRIGGERING EVENT
    LEFT JOIN TABLEEVENT TE ON TE.EVENTKEY = RT.TRIGGEREVENTKEY
    LEFT JOIN TABLERULECONDITION RC ON RC.RULEKEY = R.RULEKEY       -- CONDITIONEVENT
    LEFT JOIN TABLEEVENT CE ON CE.EVENTKEY = RC.CONDITIONEVENTKEY
    LEFT JOIN TABLERULELIMIT RL ON RL.RULEKEY = R.RULEKEY           -- LIMITEDEVENT
    LEFT JOIN TABLEEVENT LE ON LE.EVENTKEY = RL.LIMITEVENTKEY
WHERE WM.WORKFLOWDESCRIPTION LIKE 'HK%'
ORDER BY WM.WORKFLOWCODE, WE.SEQUENCE