How can I join the hz_parties table to a project number or contract number table using sql.
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:
0