what is these fields in POR_REQUISITION_LINES_ALL ?
When we create a requisition and submit for approval, we are observing that the fields in the table POR_REQUISITION_LINES_ALL
gets populated with the full job hierarchy from the requestor level to the top level. REQUESTER_SUPERVISOR_LEVEL10, REQUESTER_SUPERVISOR_LEVEL9, REQUESTER_SUPERVISOR_LEVEL8... REQUESTER_SUPERVISOR_LEVEL2, REQUESTER_SUPERVISOR_LEVEL1
This is true even if the Requisition amount is 1 USD or a large number
Question- What is the purpose of these fields ?
We see from the UI that the Requisition Approval rule stops at a level, depending upon the Header Amount.
Requirement- We are trying to develop a report which can identify the approvers for a Requisition with status 'Pending Approval'.