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_OPINION_COMPONTS_B

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

47: ,op.authored_date
48: /*,(select aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
49: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
50: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
51: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
52: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
53: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
54: ,(select aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
55: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID

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

53: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
54: ,(select aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
55: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
56: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
57: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
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,

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

131: ,op.authored_date /*last_evaluated_on*/
132: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
133: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
134: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
135: and aod.OPINION_COMPONENT_ID = (select OPINION_COMPONENT_ID from AMW_OPINION_COMPONTS_B
136: where OBJECT_OPINION_TYPE_ID = op.OBJECT_OPINION_TYPE_ID
137: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
138: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
139: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID

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

137: and OPINION_COMPONENT_CODE = 'OPERATING')) op_eff_id
138: ,(select /*aov.OPINION_VALUE_NAME*/ aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov
139: WHERE aov.language=userenv('LANG') and op.OPINION_LOG_ID = aod.OPINION_LOG_ID
140: and aod.OPINION_VALUE_ID = aov.OPINION_VALUE_ID
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,