Bonjour,

Pour avoir l'information de la tâche, j'utilise plutôt la table MSP_ASSIGNMENTS car avec MSP_TASK retourne parfois NULL.

Donc, avec la modification, la partie du FROM doit être comme:

FROM MSP_ASSIGNMENT_TRANSACTIONS MAT INNER JOIN

MSP_RESOURCES MR ON

MAT.ASSN_TRANS_SUBMITTER_RES_UID = MR.RES_UID INNER JOIN

MSP_RESOURCES MA ON

MAT.ASSN_TRANS_APPROVER_RES_UID = MA.RES_UID INNER JOIN

MSP_PROJECTS MP ON

MAT.PROJ_UID=MP.PROJ_UID INNER JOIN

MSP_ASSIGNMENTS MS ON

MAT.ASSN_UID=MS.ASSN_UID

Et le SELECT:

MAT.ASSN_TRANS_UID, MAT.ASSN_TRANS_SUBMIT_DATE, MAT.ASSN_TRANS_UPDATE_DATE, MR.RES_NAME AS 'SUBMITTER', MA.RES_NAME AS 'APPROVER', MP.PROJ_NAME AS 'PROJECT', MS.TASK_NAME AS 'TASK NAME'