Identifying Underlying Queries for SmartLOV/ VOs In BI Publisher

Summary:

Content (please ensure you mask any confidential information):

Hi experts,

Would any of you know how to identify the underlying query for a view object in BI Publisher? For instance, we'd like the query behind - Person|CaROEInterfacePersonPVO

We are on Oracle Fusion Cloud and do not have access to BICC etc.

I did try to follow the guides here, but no luck -

https://www.vaamg.com/post/oracle-fusion-pvos

https://community.oracle.com/products/oracleanalytics/discussion/20157/how-to-query-pvo-in-oracle-bi-publisher-data-model

Version (include the version you are using, if applicable):

23D

Code Snippet (add any code snippets that support your topic, if applicable):