APPS.RCI_ORG_CERT_ETL_PKG dependencies on AMW_OPINION_VALUES_TL

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

44: ---,all_ctrls.control_id
45: ,op.audit_result_code
46: ,op.authored_by
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

Line 54: ,(select aov.opinion_value_id from AMW_OPINION_LOG_DETAILS aod, AMW_OPINION_VALUES_TL aov

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

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

128: ,all_ctrls.control_id
129: ,op.audit_result_code
130: ,op.authored_by /*last_evaluated_by_id*/
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

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

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