eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PA.PA_PERF_KPA_SUMMARY_DET#

Source

View Text - Preformatted


select KPA_SUMMARY_DET_ID KPA_SUMMARY_DET_ID, KPA_SUMMARY_ID KPA_SUMMARY_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, KPA_CODE KPA_CODE, INDICATOR_CODE INDICATOR_CODE, COUNT COUNT, SCORE SCORE, RULE_ID RULE_ID, IND1_COUNT IND1_COUNT, IND1_SCORE IND1_SCORE, IND2_COUNT IND2_COUNT, IND2_SCORE IND2_SCORE, IND3_COUNT IND3_COUNT, IND3_SCORE IND3_SCORE, IND4_COUNT IND4_COUNT, IND4_SCORE IND4_SCORE, IND5_COUNT IND5_COUNT, IND5_SCORE IND5_SCORE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_PERF_KPA_SUMMARY_DET"

View Text - HTML Formatted

SELECT KPA_SUMMARY_DET_ID KPA_SUMMARY_DET_ID
, KPA_SUMMARY_ID KPA_SUMMARY_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, KPA_CODE KPA_CODE
, INDICATOR_CODE INDICATOR_CODE
, COUNT COUNT
, SCORE SCORE
, RULE_ID RULE_ID
, IND1_COUNT IND1_COUNT
, IND1_SCORE IND1_SCORE
, IND2_COUNT IND2_COUNT
, IND2_SCORE IND2_SCORE
, IND3_COUNT IND3_COUNT
, IND3_SCORE IND3_SCORE
, IND4_COUNT IND4_COUNT
, IND4_SCORE IND4_SCORE
, IND5_COUNT IND5_COUNT
, IND5_SCORE IND5_SCORE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_PERF_KPA_SUMMARY_DET"