How to get the list of Hyperion Financial Reporting books and corresponding Reports

Hi,

We are on EPM 11.1.2.4(Pure essbase and HFR). There is a need for us to identify the reporting books and corresponding reports in the HFR. I did some research and found the following query from web which will provide me the path of the reporting books & reports but what i am missing is the reporting books which are made up of the reports. 

Ideally i would need the link between the Reporting book and the corresponding report.

Below query provides me the path of the reporting book/ report in the system.

SELECT B.FR_PATH

      ,DECODE(A.META_TYPE_UUID,'ID202','Reporting Book','ID200','Report','ID03','Folder') "Report/Book"