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_COMPONTS_B

Line 252: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B

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

Line 258: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B

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
260: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
261: ,agpv.period_year
262: ,agpv.period_num

Line 441: amw_opinion_componts_b compb

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
444: AND compb.object_opinion_type_id = opinionstable.object_opinion_type_id
445: AND compb.opinion_component_code = 'OPERATING'

Line 451: amw_opinion_componts_b compb

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
454: AND compb.object_opinion_type_id = opinionstable.object_opinion_type_id
455: AND compb.opinion_component_code = 'DESIGN'

Line 661: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B

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

Line 667: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B

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
669: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
670: ,agpv.period_year
671: ,agpv.period_num

Line 834: amw_opinion_componts_b compb

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
837: AND compb.object_opinion_type_id = opinionstable.object_opinion_type_id
838: AND compb.opinion_component_code = 'OPERATING'

Line 844: amw_opinion_componts_b compb

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
847: AND compb.object_opinion_type_id = opinionstable.object_opinion_type_id
848: AND compb.opinion_component_code = 'DESIGN'