SELECT A.ID FROM PMStatesTransitions A JOIN PMStates ToState ON ToState.ID = A.ToState_ID LEFT JOIN PMStatesTransitionsDocQueues Q ON Q.StatesTransition_ID = A.ID WHERE (A.CLSID = :CLSID) AND (A.FromState_ID IS NULL) AND (A.Hidden = 'N') AND (Q.DocQueue_ID IS NULL OR (Q.DocQueue_ID = :DocQueue_ID)) ORDER BY COALESCE(Q.DocQueue_ID, '0000000000') DESC, ToState.SequenceNumber, ToState.SystemState
Generated by ABRA Software a.s. 27.10.2021 16:34:10