how to join xcc_budget_accounts to projects,tasks and expenditure types

3:33PM

Summary:

i want to know the joins between xcc_budget_accounts and project tables.

i have tried to join segment_value1 with project number from pjf_projects_all_b which is the same

for segment_value2 and segment_value4 the value is getting concatenated and segment_value4 only stores half value of expenditure_type.

Could you please help me to join this tables.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):