table for Rate Matrix resource data filter

Products

• Clarity PPM On Premise

Issue/Introduction

I want to understand the logic that pulls data in the lookup for resource in rate matrix.

Environment

Release : 15.8.1

Component : CA PPM APPLICATION

Cause

I want to understand the query used to show resources who can be added to the Resource column in the matrix

Resolution

This is found in

PAC_MNT_MATRIX_LOKUP_VALUES_SP

And the query it uses is

  SELECT RTRIM(P.RESOURCE_CODE) "RESOURCE_CODE", R.FULL_NAME
      FROM SRM_RESOURCES R,
           PAC_MNT_RESOURCES P,
     PRJ_RESOURCES PRJ 
     WHERE R.ID = P.ID
    AND R.ID = PRJ.PRID
--       AND P.resource_class = NVL(RTRIM(PAC_MNT_MATRIX_LOKUP_VALUES_SP.cResource_Class), P.resource_class)
  --     AND UPPER(P.RESOURCE_CODE) LIKE PAC_MNT_MATRIX_LOKUP_VALUES_SP.qbeValue
 --      AND UPPER(R.FULL_NAME) LIKE PAC_MNT_MATRIX_LOKUP_VALUES_SP.qbeDescription
  --     AND (-999 = NVL(v_roleResource, -999) OR R.RESOURCE_TYPE IN ( v_roleResource ) ) --AND R.PERSON_TYPE <> 0
       AND R.is_active <> 0
    AND PRJ.PRISROLE = 0