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_AUDIT_UNITS_V

Line 175: amw_audit_units_v orgtable,

171: ctrlassoc.control_rev_id as ctrl_rev_id,
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

Line 253: amw_audit_units_v orgtable,

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,
256: AMW_PROCESS_ORGANIZATION_VL procorg
257: WHERE execs.entity_id = assoctable.pk1

Line 302: amw_audit_units_v aauv,

298: where change_order_type_id in (select change_order_type_id
299: from eng_change_order_types
300: where type_classification='HEADER'
301: and change_mgmt_type_code='AMW_PROC_CERT_ISSUES')) open_issues,
302: amw_audit_units_v aauv,
303: amw_certification_vl acv
304: ---amw_latest_revisions_v alrv
305: where aauv.organization_id=open_issues.organization_id
306: and open_issues.certification_id = acv.certification_id