Select
  PPOM_USER.PUSER_ID         As TcUserID,
  PIMANVOLUME.PVOLUME_NAME   As UserDefVol,
  PIMANVOLUME.PWNT_PATH_NAME As VolRoot_DP,
  PIMANFILE.PSD_PATH_NAME    As UsersVolCurSubDir,
  count(*)                   As NFiles 
From
  PUSER
Left Join PIMANVOLUME
On
  PUSER.RVOLUMEU = PIMANVOLUME.PUID
Inner Join PUSER_PATHS
On
  PIMANVOLUME.PUID = PUSER_PATHS.PUID
Inner Join PUSERS
On
  PUSER_PATHS.PUID = PUSERS.PUID
And PUSERS.PSEQ    = PUSER_PATHS.PSEQ
And PUSER.PUID     = PUSERS.PVALU_0
Inner Join PIMANFILE
On
  PUSER_PATHS.PVAL_0 = PIMANFILE.PSD_PATH_NAME
Inner Join PPOM_USER
On
  PUSER.PUID = PPOM_USER.PUID
Where
  upper(PPOM_USER.PUSER_ID) Like upper(:para_like_PUSER_ID)
Group By
  PIMANVOLUME.PVOLUME_NAME,
  PIMANVOLUME.PWNT_PATH_NAME,
  PIMANFILE.PSD_PATH_NAME,
  PPOM_USER.PUSER_ID
Order By
  PPOM_USER.PUSER_ID