View: AMW_OPINION_M_V

Product:	AMW - Internal Controls Manager
Description:	the modified amw_opinion_v. only used for the upgrade script.
Implementation/DBA Data:	APPS.AMW_OPINION_M_V

View Text

SELECT AO.OPINION_SET_ID
, AO.OPINION_ID
, AO.OBJECT_OPINION_TYPE_ID
, AOT.OPINION_TYPE_CODE
, AO.PK1_VALUE
, AO.PK2_VALUE
, AO.PK3_VALUE
, AO.PK4_VALUE
, AO.PK5_VALUE
, AO.PK6_VALUE
, AO.PK7_VALUE
, AO.PK8_VALUE
, AO.PARTY_ID
, AOVB.OPINION_VALUE_ID
, AOVB.OPINION_VALUE_CODE
, AO.AUTHORED_BY
, AO.AUTHORED_DATE
, AO.CREATED_BY
, AO.CREATION_DATE
, AO.LAST_UPDATED_BY
, AO.LAST_UPDATE_DATE
, AO.LAST_UPDATE_LOGIN
, AO.SECURITY_GROUP_ID
, AO.OBJECT_VERSION_NUMBER
, AOCB.OPINION_COMPONENT_CODE
, AOVB.ATTACHMENT_ID CUST_ATTACHMENT_ID
, ACODE.ATTACHMENT_ID
, AOVB.IMAGE_FILE_NAME CUST_IMAGE_FILE_NAME
, ACODE.IMAGE_FILE_NAME
, FO.OBJ_NAME OBJECT_NAME
FROM AMW_OPINIONS AO
, AMW_OBJECT_OPINION_TYPES AOOT
, AMW_OPINION_TYPES_B AOT
, FND_OBJECTS FO
, AMW_OPINION_DETAILS DET
, AMW_OPINION_COMPONTS_B AOCB
, AMW_OPINION_VALUE_CODES ACODE
, AMW_OPINION_VALUES_B AOVB
WHERE AO.OBJECT_OPINION_TYPE_ID = AOOT.OBJECT_OPINION_TYPE_ID
AND AOOT.OPINION_TYPE_ID = AOT.OPINION_TYPE_ID
AND AOOT.OBJECT_ID = FO.OBJECT_ID
AND AO.OPINION_ID = DET.OPINION_ID
AND AOCB.OBJECT_OPINION_TYPE_ID= AOOT.OBJECT_OPINION_TYPE_ID
AND AOCB.OPINION_COMPONENT_ID = DET.OPINION_COMPONENT_ID
AND DET.OPINION_VALUE_ID = AOVB.OPINION_VALUE_ID
AND ACODE.OPINION_VALUE_CODE_NAME = AOVB.OPINION_VALUE_CODE

Columns