With the below SQL query we can get list of users by responsibility name:
SELECT U.LOGIN
FROM SIEBEL.S_USER U, SIEBEL.S_PER_RESP PER, SIEBEL.S_RESP R
WHERE U.ROW_ID = PER.PER_ID
AND R.ROW_ID = PER.RESP_ID
AND R.NAME LIKE 'Responsibility Name';
A place to learn and share about Oracle Siebel CRM.
Subscribe to:
Post Comments (Atom)
Updating parent BC depending on the status of child BC using configuration
Parent BC: Service Request Child BC: Action Requirement: When all the Actions corresponding to an SR are closed the SR status should be “Clo...
No comments:
Post a Comment