Need Project Contract Details in BI Report

Hi Team,
We have a requirement of BI report where we want to include associated project and task details from project contract lines page.
But we are not able to identify the table or join details. We tried below query but it did not worked for us,

SELECT CH.CONTRACT_NUMBER
,CL.LINE_NUMBER
,CH.STS_CODE CONTRACT_STATUS
,CL.STS_CODE CONTRACT_LINE_STATUS
,CL.CURRENCY_CODE CONTRACT_LINE_CURRENCY_CODE
,CL.ATTRIBUTE3
,CL.LINE_AMOUNT
,CL.ATTRIBUTE2
,(SELECT PPA.NAME
FROM PJF_PROJECTS_ALL_VL PPA
WHERE PPA.SEGMENT1 = CL.ATTRIBUTE3) PROJECT_NAME
FROM OKC_K_HEADERS_ALL_B CH