[Home] [Help]
61: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
62: AMW_CONTROLS_ALL_VL all_ctrls,
63: HR_ALL_ORGANIZATION_UNITS o,
64: HR_ALL_ORGANIZATION_UNITS_TL otl,
65: AMW_OPINIONS_LOG_V op
66: WHERE ctrls.object_type = 'RISK_FINCERT'
67: and ctrls.control_rev_id = all_ctrls.control_rev_id
68: and all_ctrls.APPROVAL_STATUS = 'A'
69: and o.organization_id = ctrls.pk2
85: ,aov2.audit_result_code -----evaluation_result_code
86: ,aov2.authored_by -----last_evaluated_by_id
87: ,aov2.authored_date -----last_evaluated_on
88: from amw_control_associations aca
89: ,amw_opinions_log_v aolv
90: ,amw_latest_revisions_v alrv
91: ,HR_ALL_ORGANIZATION_UNITS haou
92: ,HR_ALL_ORGANIZATION_UNITS_TL haout
93: ,amw_opinions_v aov1
144: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
145: AMW_CONTROLS_ALL_VL all_ctrls,
146: HR_ALL_ORGANIZATION_UNITS o,
147: HR_ALL_ORGANIZATION_UNITS_TL otl,
148: AMW_OPINIONS_LOG_V op
149: WHERE ctrls.object_type = 'RISK_FINCERT'
150: and ctrls.control_rev_id = all_ctrls.control_rev_id
151: and all_ctrls.APPROVAL_STATUS = 'A'
152: and o.organization_id = ctrls.pk2
172: opinionstable.audit_result_code as audit_result_code
173: FROM amw_control_associations ctrlassoc,
174: amw_controls_all_vl controltable,
175: amw_audit_units_v orgtable,
176: amw_opinions_log_v opinionstable,
177: amw_execution_scope execs,
178: AMW_PROCESS_ORGANIZATION_VL procorg
179: WHERE execs.entity_id = ctrlassoc.pk1
180: AND execs.entity_type = ctrlassoc.object_type
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,
220: AMW_OPINIONS_LOG_V op,
221: (select pk1,pk2,NATURAL_ACCOUNT_ID from AMW_ACCT_ASSOCIATIONS where object_type='PROCESS_ORG' and approval_date is not null and deletion_approval_date is null) aaa
222: WHERE risks.object_type = 'PROCESS_FINCERT'
223: and all_risks.risk_rev_id = risks.risk_rev_id
224: and o.organization_id = risks.pk2
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,
256: AMW_PROCESS_ORGANIZATION_VL procorg
257: WHERE execs.entity_id = assoctable.pk1
258: AND execs.entity_type = assoctable.object_type
336: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
337: HR_ALL_ORGANIZATION_UNITS o,
338: HR_ALL_ORGANIZATION_UNITS_TL otl,
339: AMW_PROCESS_ORGANIZATION_VL proc,
340: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
341: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
342: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
343: and rel.end_date is null
344: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
337: HR_ALL_ORGANIZATION_UNITS o,
338: HR_ALL_ORGANIZATION_UNITS_TL otl,
339: AMW_PROCESS_ORGANIZATION_VL proc,
340: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
341: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
342: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
343: and rel.end_date is null
344: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
345: and finprocsum.ORGANIZATION_ID = finscope.ORGANIZATION_ID
375: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
376: HR_ALL_ORGANIZATION_UNITS o,
377: HR_ALL_ORGANIZATION_UNITS_TL otl,
378: AMW_PROCESS_ORGANIZATION_VL proc,
379: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
380: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
381: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
382: and rel.end_date is null
383: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
376: HR_ALL_ORGANIZATION_UNITS o,
377: HR_ALL_ORGANIZATION_UNITS_TL otl,
378: AMW_PROCESS_ORGANIZATION_VL proc,
379: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
380: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
381: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
382: and rel.end_date is null
383: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
384: and finprocsum.ORGANIZATION_ID = finscope.ORGANIZATION_ID
414: AMW_FIN_PROCESS_EVAL_SUM finprocsum,
415: HR_ALL_ORGANIZATION_UNITS o,
416: HR_ALL_ORGANIZATION_UNITS_TL otl,
417: AMW_PROCESS_ORGANIZATION_VL proc,
418: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
419: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
420: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
421: and rel.end_date is null
422: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
415: HR_ALL_ORGANIZATION_UNITS o,
416: HR_ALL_ORGANIZATION_UNITS_TL otl,
417: AMW_PROCESS_ORGANIZATION_VL proc,
418: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V certopn,
419: /*AMW_OPINIONS_V*/ AMW_OPINIONS_LOG_V evalopn
420: where rel.FIN_STMT_CERT_ID = finprocsum.FIN_CERTIFICATION_ID
421: and rel.end_date is null
422: and finprocsum.FIN_CERTIFICATION_ID = finscope.fin_certification_id
423: and finprocsum.ORGANIZATION_ID = finscope.ORGANIZATION_ID