select listenerId from tbl_SYS_EventListeners where ownerId = and ownerType = and eventName = 'confirmPurchasingProfile' and listenerPath = '/mstrcfmod/TPM/workflow/listeners/confirmPurchasingProfileListener.cfm' and eventSubjectType = 'OPR' insert into tbl_SYS_EventListeners ( ownerId, ownerType, eventName, eventSubjectType, listenerPath, useTransaction ) values( , , 'confirmPurchasingProfile', 'OPR', '/mstrcfmod/TPM/workflow/listeners/confirmPurchasingProfileListener.cfm', 'N') select distinct opr.operatorId, opr.companyName from tbl_TPM_Contracts c inner join tbl_TPM_Requests r on r.contractId = c.contractId and r.ownerId = c.ownerId and r.ownerType = c.ownertype and r.chainSequence = c.lastApprovedChainSequence inner join tbl_OPR_ClientOperators opr on opr.operatorId = c.partnerId and opr.ownerId = c.ownerId and opr.fsltablecode = c.ownerType where c.ownerId = and c.ownerType = and c.partnerType = 'OPR' order by companyName

#htmleditformat( companyName )# Queued