Question

Identify User where the person who created order is same as one who approved .

Dear Experts , Can you suggest right way to find list of violation users who not only created Purchase order but also approved purchase orders. ?

+15

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.

Sign up