PJS_PERF_RULES_VL

Details

• Schema: FUSION

• Object owner: PJS

• Object type: VIEW

Columns

Name

RULE_ID THRESHOLD_LEVEL RULE_NAME RULE_DESCRIPTION RULE_TYPE KPA_CODE MEASURE_ID MEASURE_FORMAT CURRENCY_TYPE PERIOD_TYPE START_DATE_ACTIVE END_DATE_ACTIVE SCORE_METHOD PROJECT_UNIT_ID TREND_INDICATOR_TYPE TOLERANCE_PERCENT TRACK_TASK_INDICATOR TRACK_RESOURCE_INDICATOR TASK_INDICATOR_1 TASK_INDICATOR_2 TASK_INDICATOR_3 TASK_INDICATOR_4 TASK_INDICATOR_5 RESOURCE_INDICATOR_1 RESOURCE_INDICATOR_2 RESOURCE_INDICATOR_3 RESOURCE_INDICATOR_4 RESOURCE_INDICATOR_5 OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT PJS_PERF_RULES_B.RULE_ID, PJS_PERF_RULES_B.THRESHOLD_LEVEL, PJS_PERF_RULES_TL.RULE_NAME, PJS_PERF_RULES_TL.RULE_DESCRIPTION, PJS_PERF_RULES_B.RULE_TYPE, PJS_PERF_RULES_B.KPA_CODE, PJS_PERF_RULES_B.MEASURE_ID, PJS_PERF_RULES_B.MEASURE_FORMAT, PJS_PERF_RULES_B.CURRENCY_TYPE, PJS_PERF_RULES_B.PERIOD_TYPE, PJS_PERF_RULES_B.START_DATE_ACTIVE, PJS_PERF_RULES_B.END_DATE_ACTIVE, PJS_PERF_RULES_B.SCORE_METHOD, PJS_PERF_RULES_B.PROJECT_UNIT_ID, PJS_PERF_RULES_B.TREND_INDICATOR_TYPE, PJS_PERF_RULES_B.TOLERANCE_PERCENT, PJS_PERF_RULES_B.TRACK_TASK_INDICATOR, PJS_PERF_RULES_B.TRACK_RESOURCE_INDICATOR, PJS_PERF_RULES_B.TASK_INDICATOR_1, PJS_PERF_RULES_B.TASK_INDICATOR_2, PJS_PERF_RULES_B.TASK_INDICATOR_3, PJS_PERF_RULES_B.TASK_INDICATOR_4, PJS_PERF_RULES_B.TASK_INDICATOR_5, PJS_PERF_RULES_B.RESOURCE_INDICATOR_1, PJS_PERF_RULES_B.RESOURCE_INDICATOR_2, PJS_PERF_RULES_B.RESOURCE_INDICATOR_3, PJS_PERF_RULES_B.RESOURCE_INDICATOR_4, PJS_PERF_RULES_B.RESOURCE_INDICATOR_5, PJS_PERF_RULES_B.OBJECT_VERSION_NUMBER, PJS_PERF_RULES_B.CREATION_DATE, PJS_PERF_RULES_B.CREATED_BY, PJS_PERF_RULES_B.LAST_UPDATE_DATE, PJS_PERF_RULES_B.LAST_UPDATED_BY, PJS_PERF_RULES_B.LAST_UPDATE_LOGIN FROM PJS_PERF_RULES_B, PJS_PERF_RULES_TL WHERE PJS_PERF_RULES_B.RULE_ID = PJS_PERF_RULES_TL.RULE_ID AND PJS_PERF_RULES_TL.LANGUAGE = USERENV('LANG')