Can we call SQL in order to determine a workflow approver?
Summary
We have a Descriptive Flexfield which holds name of Employee Mentor, we want to send a workflow approval to this MentorContent
We have a Descriptive Flexfield which holds name of Employee Mentor, we want to send a workflow approval to this Mentor
The flexfield as a valueset with Table Validation as defined below
MENTOR_PERSON_DETAILS
Module: Core Setup
Value Data Type: Character
From Clause
per_employees_x pex, PER_ASSIGNMENT_SECURED_LIST_V ASG, PER_ALL_PEOPLE_F PER
Value Column Name
pex.LAST_NAME || ' ' || pex.FIRST_NAME || ' ' || asg.assignment_name
Value Column Type: VARCHAR2
Tagged:
0