VIEW: APPS.PA_PERF_RULES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)