[Home] [Help]
241: ,all_ctrls.automation_type
242: ,all_ctrls.control_frequency
243: ,upper(nvl(all_ctrls.key_mitigating,'N'))
244: ,upper(nvl(all_ctrls.disclosure_control,'N'))
245: ,(select max(rev_num) from amw_controls_b where control_id=all_ctrls.control_id) /*latest_rev_num*/
246: ,op.audit_result_code
247: ,op.authored_by /*last_evaluated_by_id*/
248: ,op.authored_date /*last_evaluated_on*/
249: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
430: controltable.automation_type,
431: controltable.control_frequency,
432: nvl(controltable.key_mitigating,'N'),
433: nvl(controltable.disclosure_control,'N'),
434: (select max(rev_num) from amw_controls_b where control_id=controltable.control_id),
435: opinionstable.audit_result_code,
436: opinionstable.last_updated_by,
437: opinionstable.authored_date,
438: (SELECT valuestable.opinion_value_id
650: ,all_ctrls.automation_type
651: ,all_ctrls.control_frequency
652: ,upper(nvl(all_ctrls.key_mitigating,'N'))
653: ,upper(nvl(all_ctrls.disclosure_control,'N'))
654: ,(select max(rev_num) from amw_controls_b where control_id=all_ctrls.control_id) /*latest_rev_num*/
655: ,op.audit_result_code
656: ,op.authored_by /*last_evaluated_by_id*/
657: ,op.authored_date /*last_evaluated_on*/
658: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
823: controltable.automation_type,
824: controltable.control_frequency,
825: nvl(controltable.key_mitigating,'N'),
826: nvl(controltable.disclosure_control,'N'),
827: (select max(rev_num) from amw_controls_b where control_id=controltable.control_id),
828: opinionstable.audit_result_code,
829: opinionstable.last_updated_by,
830: opinionstable.authored_date,
831: (SELECT valuestable.opinion_value_id