Need to add more rows to multi-row Autoquery block using Forms Personalization
In OM there's the Enter Order form, where in the the Additional Line Information option there's a form with several tabs. One of them is the "Invoices / Credit Memos", which does an autoquery on a view. This view, though, limits the results to only shows AR invoices created by OM. However, we have a 3rd party tool, certified by Oracle, which also creates AR invoices related to the OM orders and I would like to "add" these invoices to the result set.
How can I do it?
I was thinking about, if I could, changing the base view of the block(oe_ra_customer_trx_perf_v) and add a "custom" view with all the invoices. This is a query-only form and the additional information is FYI only, no processing will be done on them.