[Home] [Help]
211: op.last_updated_by, /*last_evaluator_id*/
212: op.authored_date, /*last_evaluated_on*/
213: all_risks.risk_rev_id,
214: op.audit_result_code
215: FROM AMW_RISK_ASSOCIATIONS risks,
216: AMW_RISKS_ALL_VL all_risks,
217: AMW_PROCESS_ORGANIZATION_VL proc,
218: HR_ALL_ORGANIZATION_UNITS o,
219: HR_ALL_ORGANIZATION_UNITS_TL otl,
247: opinionstable.audit_result as eval,
248: procorg.display_name as process_name,
249: assoctable.risk_rev_id as risk_rev_id,
250: opinionstable.audit_result_code as audit_result_code
251: FROM amw_risk_associations assoctable,
252: amw_risks_all_vl risktable,
253: amw_audit_units_v orgtable,
254: amw_opinions_log_v opinionstable,
255: amw_execution_scope execs,