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_CONTROLS_ALL_VL

Line 62: AMW_CONTROLS_ALL_VL all_ctrls,

58: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
59: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
60: ***/
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'

Line 145: AMW_CONTROLS_ALL_VL all_ctrls,

141: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
142: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
143: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
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'

Line 174: amw_controls_all_vl controltable,

170: opinionstable.audit_result as eval,
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