VIEW: APPS.PA_PERF_OBJECT_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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