Approval Name query
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;
Unnikrishnan Balan replied
Please try below query and give your feedback
SELECT T5.U_NAME "RequestedBy"
, 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
Order By T0."DocDate", T0."DocNum"