To find all reports, their paths, and their types, you can use the following SQL:
Demystifying GL_FRC_REPORTS_B: Technical Blueprint of Oracle ERP Cloud Metadata Tracking glfrcreportsb