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_CTRL_DETAIL_ETL_PKG dependencies on AMW_OPINION_LOG_DETAILS

Line 249: ,(select /aov.OPINION_VALUE_NAME/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov

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
250: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
251: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
252: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
253: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID

Line 255: ,(select /aov.OPINION_VALUE_NAME/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov

251: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
252: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
253: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
254: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
255: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
256: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
257: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
258: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
259: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID

Line 439: FROM amw_opinion_log_details details,

435: opinionstable.audit_result_code,
436: opinionstable.last_updated_by,
437: opinionstable.authored_date,
438: (SELECT valuestable.opinion_value_id
439: FROM amw_opinion_log_details details,
440: amw_opinion_values_tl valuestable,
441: amw_opinion_componts_b compb
442: WHERE opinionstable.opinion_log_id = details.opinion_log_id
443: AND details.opinion_component_id = compb.opinion_component_id

Line 449: FROM amw_opinion_log_details details,

445: AND compb.opinion_component_code = 'OPERATING'
446: AND valuestable.language = userenv('LANG')
447: AND details.opinion_value_id = valuestable.opinion_value_id ),
448: (SELECT valuestable.opinion_value_id
449: FROM amw_opinion_log_details details,
450: amw_opinion_values_tl valuestable,
451: amw_opinion_componts_b compb
452: WHERE opinionstable.opinion_log_id = details.opinion_log_id
453: AND details.opinion_component_id = compb.opinion_component_id

Line 658: ,(select /aov.OPINION_VALUE_NAME/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov

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
659: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
660: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
661: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
662: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID

Line 664: ,(select /aov.OPINION_VALUE_NAME/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov

660: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
661: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
662: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
663: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
664: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
665: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
666: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
667: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
668: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID

Line 832: FROM amw_opinion_log_details details,

828: opinionstable.audit_result_code,
829: opinionstable.last_updated_by,
830: opinionstable.authored_date,
831: (SELECT valuestable.opinion_value_id
832: FROM amw_opinion_log_details details,
833: amw_opinion_values_tl valuestable,
834: amw_opinion_componts_b compb
835: WHERE opinionstable.opinion_log_id = details.opinion_log_id
836: AND details.opinion_component_id = compb.opinion_component_id

Line 842: FROM amw_opinion_log_details details,

838: AND compb.opinion_component_code = 'OPERATING'
839: AND valuestable.language = userenv('LANG')
840: AND details.opinion_value_id = valuestable.opinion_value_id ),
841: (SELECT valuestable.opinion_value_id
842: FROM amw_opinion_log_details details,
843: amw_opinion_values_tl valuestable,
844: amw_opinion_componts_b compb
845: WHERE opinionstable.opinion_log_id = details.opinion_log_id
846: AND details.opinion_component_id = compb.opinion_component_id

APPS.RCI_CTRL_DETAIL_ETL_PKG dependencies on AMW_OPINION_LOG_DETAILS

Line 249: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov

Line 255: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov