eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_PROCESS_ORGANIZATION_VL

Line 178: AMW_PROCESS_ORGANIZATION_VL procorg

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
181: AND execs.organization_id = orgtable.organization_id
182: AND procorg.process_org_rev_id(+) = execs.process_org_rev_id

Line 217: AMW_PROCESS_ORGANIZATION_VL proc,

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,
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

Line 256: AMW_PROCESS_ORGANIZATION_VL procorg

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
259: AND execs.organization_id = orgtable.organization_id
260: AND assoctable.object_type = 'BUSIPROC_CERTIFICATION'

Line 339: AMW_PROCESS_ORGANIZATION_VL proc,

335: AMW_FIN_PROC_CERT_RELAN REL,
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

Line 378: AMW_PROCESS_ORGANIZATION_VL proc,

374: AMW_FIN_PROC_CERT_RELAN REL,
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

Line 417: AMW_PROCESS_ORGANIZATION_VL proc,

413: AMW_FIN_PROC_CERT_RELAN REL,
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