You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!