MATERIALIZED VIEW: APPS.AMW_OPINION_MV

Source

SELECT /* bug#4526784 bug5696107 */ ao.rowid "opinion_rid", aoot.rowid "obj_opin_types_rid",
aot.rowid "opinion_types_rid", det.rowid "opinion_detail_rid", aocb.rowid "opinion_components",
aovb.rowid "opinion_value_rid", fo.rowid "fnd_object_rid",
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.AMW_OPINIONS ao, 
     AMW.AMW_OBJECT_OPINION_TYPES aoot, 
     AMW.AMW_OPINION_TYPES_B aot,
     APPLSYS.FND_OBJECTS fo,
     AMW.AMW_OPINION_DETAILS det,
     AMW.AMW_OPINION_COMPONTS_B aocb,
     AMW.AMW_OPINION_VALUE_CODES acode,
     AMW.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