How to derive Inventory Organization on an Expense PO Line through REST API

Summary:

We have a client requirement for creating Expense Purchase Orders in Oracle via a REST API integration.

While creating the PO Line, the API Payload needs a value in the attribute "DestinationOrganizationCode" as it is a mandatory field. This is basically the inventory organization on the PO Line. Attached a screenshot from the UI for reference.

For this, we are aiming to create a BI Report which the middleware would call and fetch the value. We basically want to fetch the value set against "Default Deliver-to Organization" in the "Configure Requisitioning Business Function" task as we have the Requisition Business Unit details. We are using the below query (here, the Business Unit ID is the Requisition BU ID):