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_DFCY_ETL_PKG dependencies on AMW_OPINION_COMPONTS_B

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

293: ,op.authored_date /*last_evaluated_on*/
294: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
295: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
296: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
297: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
298: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
299: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
300: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
301: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID

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

299: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
300: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
301: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
302: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
303: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
304: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
305: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
306: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
307: AMW_CONTROLS_ALL_VL all_ctrls,

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

908: ,op.authored_date /*last_evaluated_on*/
909: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
910: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
911: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
912: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
913: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
914: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
915: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
916: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID

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

914: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
915: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
916: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
917: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
918: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
919: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
920: and OPINION_COMPONENT_CODE = 'DESIGN')) des_eff_id
921: FROM AMW_CONTROL_ASSOCIATIONS ctrls,
922: AMW_CONTROLS_ALL_VL all_ctrls,