APPS.RCI_ORG_DFCY_ETL_PKG dependencies on AMW_OPINION_VALUES_TL

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

290: ,all_ctrls.control_id
291: ,op.audit_result_code
292: ,op.authored_by /*last_evaluated_by_id*/
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

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

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

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

905: ,all_ctrls.control_id
906: ,op.audit_result_code
907: ,op.authored_by /*last_evaluated_by_id*/
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

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

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