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.

[Home] [Help]

VIEW: APPS.AMW_OPINION_M_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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