select ownerId, ownerType, requestId, config, 'N' cancel, 0 opportunityId, requestTime, fromUserId, disposition from tbl_WRK_UserRequests where config like '%OPPORTUNITYID=%' and disposition = '?' select opportunityId from tbl_SPL_Opportunities where ownerId = and ownerType = and opportunityId = select * from qmd_userRequest where cancel = 'Y'

Preview Only

Requests Cancelled