[Home] [Help]
View: PA_PERF_OBJECT_RULES_V
View Text
SELECT PO.OBJECT_RULE_ID
, PO.OBJECT_TYPE
, PO.OBJECT_ID
, PR.RULE_ID
, PR.RULE_NAME
, PR.RULE_DESCRIPTION
, PR.RULE_TYPE
, PR.RULE_TYPE_NAME
, PR.KPA_CODE
, PR.KPA_NAME
, PR.MEASURE_ID
, PR.MEASURE_NAME
, PR.MEASURE_FORMAT
, PR.CURRENCY_TYPE
, PR.PERIOD_TYPE
, PR.PRECISION
, PR.START_DATE_ACTIVE
, PR.END_DATE_ACTIVE
, PR.SCORE_METHOD
, PO.RECORD_VERSION_NUMBER
, PR.CREATION_DATE
, PR.CREATED_BY
, PR.LAST_UPDATE_LOGIN
, PR.LAST_UPDATED_BY
FROM PA_PERF_RULES_V PR
, PA_PERF_OBJECT_RULES PO
WHERE PO.RULE_ID=PR.RULE_ID
Columns
OBJECT_RULE_ID |
OBJECT_TYPE |
OBJECT_ID |
RULE_ID |
RULE_NAME |
RULE_DESCRIPTION |
RULE_TYPE |
RULE_TYPE_NAME |
KPA_CODE |
KPA_NAME |
MEASURE_ID |
MEASURE_NAME |
MEASURE_FORMAT |
CURRENCY_TYPE |
PERIOD_TYPE |
PRECISION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
SCORE_METHOD |
RECORD_VERSION_NUMBER |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LAST_UPDATED_BY |
Name |