Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How can I join the hz_parties table to a project number or contract number table using sql.

in Reporting and Analytics for ERP 2 comments

Hi everyone,

I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with:

  • PJF_PROJECTS_ALL_B (PPAB): Holds project details.
  • PJF_TASKS_V (PTV): Contains task information.
  • PJC_EXP_ITEMS_ALL (PEIA): Stores expense item details.
  • PJB_BILL_PLANS_B (PBPB): Manages billing plans.
  • OKC_K_HEADERS_ALL_B (OKHAB): Contains contract Number.

I want to add customer name from table (HZ_PARTIES) and i am having a problem that i cant find a join with other tables.

Can you advise on the most efficient way to join these tables using the correct columns and relationships? Any guidance or code examples demonstrating the joins would be a lifesaver!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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