Hi everyone,
I need your valuable input on a complex query example used in EBS D2K Forms to create a custom solution for AR billing for customers. Below, I have attached a sample query that retrieves the data for customers' contract details. We need to implement similar logic in Visual Builder as a list of values. However, I'm unsure how we can achieve this since all this data comes from separate REST APIs in Oracle Fusion SaaS. How can we create a select list based on a complex query in Oracle Visual Builder?

Thanks a lot.