Please enable JavaScript.
Coggle requires JavaScript to display documents.
DMS_JOB, Async store from Portal in signComment to Active - Coggle Diagram
DMS_JOB
-
RejectPartitioningStep
SELECT distinct e.TRADE_FINANCE_ID, e.id
FROM TF_TFEVENT e
INNER JOIN TF_DOC d ON e.id=d.RELATED_EVENT_ID
INNER JOIN WDP_EVENT we ON e.id=we.id
WHERE we.STATE <> 'CREATED'
AND we.EVENT_STATE IN ('canceled', 'rejected')
AND (d.DMS_ID is null OR (d.DMS_ID is not null AND d.DMS_DOCUMENT_STATE <> 'rejected'))
-