Approval Name query

[millicentdark]

Hi Experts,

i have created an approval stage and approval template for A/P Downpayment request.

I will like to have a query that will be used for A/P down payment request that will show the names of the authorizers for the document. The number of approval required is two and i want to see both names of the users approving the document.

Just as shown below;

[former_member212181 · Accepted solution]

Hi Justice,
Please try below query and give your feedback

SELECT T5.U_NAME "RequestedBy"

,T6."U_NAME" "Originator"

, T0."DocNum", T0."DocStatus", T0."DocDate"

,T13.U_Name [Authorized By]

FROM ODPO T0 

Left Outer Join ODRF T4 ON T0.[draftKey] = T4.[DocEntry] and T4.ObjType = 204

Left Outer Join OUSR T5 on T4.UserSign = T5.USERID

LEFT oUTER jOIN OUSR T6 on T0.UserSign = T6.USERID

Left Outer Join OWDD T11 on T11.ObjType = 204and T11.DocEntry = T0.DocEntry

Left Outer join  WDD1 T12 on T12.WddCode= T11.WddCode and T12.Status='Y'

LEFT oUTER jOIN OUSR T13 on T12.UserID = T13.USERID

WHERE T0."CANCELED"='N'

Order By T0."DocDate", T0."DocNum"

Thanks

Unnikrishnan