VIEW: PA.PA_PERF_TRANSACTIONS#

Source

View Text - Preformatted

select PERF_TXN_ID PERF_TXN_ID, PERF_TXN_OBJ_TYPE PERF_TXN_OBJ_TYPE, PERF_TXN_OBJ_ID PERF_TXN_OBJ_ID, OBJECT_RULE_ID OBJECT_RULE_ID, RELATED_OBJ_TYPE RELATED_OBJ_TYPE, RELATED_OBJ_ID RELATED_OBJ_ID, RULE_ID RULE_ID, PROJECT_ID PROJECT_ID, KPA_CODE KPA_CODE, MEASURE_ID MEASURE_ID, MEASURE_VALUE MEASURE_VALUE, PERIOD_NAME PERIOD_NAME, INDICATOR_CODE INDICATOR_CODE, THRESHOLD_FROM THRESHOLD_FROM, THRESHOLD_TO THRESHOLD_TO, WEIGHTING WEIGHTING, PRECISION PRECISION, PERIOD_TYPE PERIOD_TYPE, CURRENCY_TYPE CURRENCY_TYPE, MEASURE_FORMAT MEASURE_FORMAT, PROGRAM_ID PROGRAM_ID, DATE_CHECKED DATE_CHECKED, EXCEPTION_FLAG EXCEPTION_FLAG, CURRENT_FLAG CURRENT_FLAG, INCLUDED_IN_SCORING INCLUDED_IN_SCORING, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, 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_TRANSACTIONS"

View Text - HTML Formatted

SELECT PERF_TXN_ID PERF_TXN_ID
, PERF_TXN_OBJ_TYPE PERF_TXN_OBJ_TYPE
, PERF_TXN_OBJ_ID PERF_TXN_OBJ_ID
, OBJECT_RULE_ID OBJECT_RULE_ID
, RELATED_OBJ_TYPE RELATED_OBJ_TYPE
, RELATED_OBJ_ID RELATED_OBJ_ID
, RULE_ID RULE_ID
, PROJECT_ID PROJECT_ID
, KPA_CODE KPA_CODE
, MEASURE_ID MEASURE_ID
, MEASURE_VALUE MEASURE_VALUE
, PERIOD_NAME PERIOD_NAME
, INDICATOR_CODE INDICATOR_CODE
, THRESHOLD_FROM THRESHOLD_FROM
, THRESHOLD_TO THRESHOLD_TO
, WEIGHTING WEIGHTING
, PRECISION PRECISION
, PERIOD_TYPE PERIOD_TYPE
, CURRENCY_TYPE CURRENCY_TYPE
, MEASURE_FORMAT MEASURE_FORMAT
, PROGRAM_ID PROGRAM_ID
, DATE_CHECKED DATE_CHECKED
, EXCEPTION_FLAG EXCEPTION_FLAG
, CURRENT_FLAG CURRENT_FLAG
, INCLUDED_IN_SCORING INCLUDED_IN_SCORING
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, 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_TRANSACTIONS"