View: PA_PERF_RULES_V

Product:	PA - Projects
Description:	This view stores the information regarding the available performance rules.
Implementation/DBA Data:	APPS.PA_PERF_RULES_V

View Text

SELECT PR.RULE_ID
, PR.RULE_NAME
, PR.RULE_DESCRIPTION
, PR.RULE_TYPE
, RT.MEANING
, PR.KPA_CODE
, KPA.MEANING
, PR.MEASURE_ID
, MS.MEASURE_NAME
, PR.MEASURE_FORMAT
, PR.CURRENCY_TYPE
, PR.PERIOD_TYPE
, PR.PRECISION
, PR.START_DATE_ACTIVE
, PR.END_DATE_ACTIVE
, PR.SCORE_METHOD
, PR.RECORD_VERSION_NUMBER
, PR.CREATION_DATE
, PR.CREATED_BY
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATED_BY
, PR.LAST_UPDATE_LOGIN
FROM PA_PERF_RULES PR
, PA_LOOKUPS RT
, PA_LOOKUPS KPA
, PJI_MT_MEASURES_V MS
WHERE RT.LOOKUP_TYPE = 'PA_PERF_RULE_TYPES'
AND RT.LOOKUP_CODE = PR.RULE_TYPE
AND KPA.LOOKUP_TYPE = 'PA_PERF_KEY_AREAS'
AND KPA.LOOKUP_CODE = PR.KPA_CODE
AND KPA.ENABLED_FLAG = 'Y'
AND PR.MEASURE_ID = MS.MEASURE_ID (+)

Columns