Dear Experts , Can you suggest right way to find list of violation users who not only created Purchase order but also approved purchase orders. ?
Page 1 / 1
Assuming that User information is availble in activity tabel:
COUNT(CASE WHEN PU_FIRST (EKPO, ACTIVITY.USER_NAME, ACTIVITY.ACTIVITYNAME = 'Created Purchase Order') =
PU_FIRST (EKPO, ACTIVITY.USER_NAME, ACTIVITY.ACTIVITYNAME = 'Approved Purchase Order') THEN EKPO.CASE_KEY END )
It will return #number of PO items Created and Approved by same user.
That makes sense , Thank you Mukesh , much appreciated.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.