Dynamic Approval Rules based on PO Total Amount
With reference to post : https://cloudcustomerconnect.oracle.com/posts/00d17df2cc,
I was able to achieve dynamic approvals for PO based on project number. However, I want to add more condition like if total PO amount > input_value_constant2 and total PO amount < input_value_constant3 so as to achieve dynamic approvers based on PO amount and project combination. I came to know that total PO amount is not stored directly in the PO_HEADERS_ALL table and we can find total amount using Doc ID 433220.1, but when I try to merge the 2 queries, approval rules fail, however the same query fetches data while running normal SQL. Not sure what is going wrong.