Skip to Main Content

Developer Community

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to fetch list of approvers with approval date using SQL query

BhavinChoksiJan 4 2024

Hi,

Using SQL query, I want to fetch all the approvers of given requisition with their approval date in case the respective approver has approved it, else it will show pending approval against that approver name. Any idea how to achieve this, we are using BPM based approval system for requisition approval.

Regards,
Bhavin

Comments
Post Details
Added on Jan 4 2024
1 comment
5,392 views