This may not be the best place to post this so please advise where I should put it if I need to move it
Having an issue with Projects in Fusion. To cut a long story short - when you go into the Fusion application and look at the resources associated to a project, the screen shows 7 people.
However when we run any reports at all off the data, there is an 8th person coming out who we don't think should be associated to it but is showing up when joining on project party id.
So for example, the screen in Fusion would show 7 resources allocated to this project but the query below will show 8:
FROM PJF_PROJECTS_ALL_B PJAB,
WHERE PJAB.PROJECT_ID = PJP.PROJECT_ID
AND PJP.RESOURCE_SOURCE_ID = HP.PARTY_ID
AND PPRTT.PROJECT_ROLE_ID = PJP.PROJECT_ROLE_ID
AND PPRTT.LANGUAGE = 'US'
AND TRUNC(SYSDATE) BETWEEN NVL(PJP.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(PJP.END_DATE_ACTIVE, TRUNC(SYSDATE))
AND PPRTT.PROJECT_ROLE_NAME <> 'Customer Organization'
AND pjab.project_id = '300000003431942'
AND pjab.segment1 = '10303'
ORDER BY PROJECT_ID