Oded (Customer) asked a question.
I’m running a query on pv_change_request_work_item table and I’m getting the specific activity I was looking for. However, when I try to find details about the employee for whom the activity was opened, I can’t find any way to link this table to
consider joining with PV_CHANGE_REQUEST_ACTIVITY which has a column of AFFECTED_USER_ID
what is the best way to link between these 2 tables?
Thanks,
Our Joiners are still in a form of an activity until they're approved.
I executed the following query:
select
*
from
pv_change_request_work_item cri
where cri.NAME = 'Joiner Activity'
and cri.WORK_STATE <> 'Completed'
and cri.AVAILABLE_DATE <= sysdate
and cri.AVAILABLE_DATE > (sysdate - 3)
and the results are do no exsists in the PV_CHANGE_REQUEST_ACTIVITY table/