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.

DBA Data [Home] [Help] [Dependency Information]

MATERIALIZED VIEW: APPS.AMW_OPINION_LOG_MV

Object Details

Object Name:	AMW_OPINION_LOG_MV
Object Type:	MATERIALIZED VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

M-View Details

Container:	AMW_OPINION_LOG_MV
Updatable:	N
Rewrite Enabled:	Y
Rewrite Capability:	GENERAL
Refresh Mode:	DEMAND
Refresh Method:	FORCE
Build Mode:	DEFERRED
Fast Refreshable:	DIRLOAD_DML

MV Log Dependencies:


AMW_OBJECT_OPINION_TYPES
AMW_OPINIONS_LOG
AMW_OPINION_COMPONTS_B
AMW_OPINION_LOG_DETAILS
AMW_OPINION_TYPES_B
AMW_OPINION_VALUES_B
AMW_OPINION_VALUE_CODES
FND_OBJECTS

[View Source Query]

Columns

Name	Datatype	Length	Mandatory
opinion_rid	ROWID	(10)
obj_opin_types_rid	ROWID	(10)
opinion_types_rid	ROWID	(10)
opinion_detail_rid	ROWID	(10)
opinion_components	ROWID	(10)
opinion_value_rid	ROWID	(10)
fnd_object_rid	ROWID	(10)
OPINION_LOG_ID	NUMBER		Yes
OPINION_SET_ID	NUMBER		Yes
OPINION_ID	NUMBER		Yes
OBJECT_OPINION_TYPE_ID	NUMBER		Yes
OPINION_TYPE_CODE	VARCHAR2	(30)	Yes
PK1_VALUE	NUMBER
PK2_VALUE	NUMBER
PK3_VALUE	NUMBER
PK4_VALUE	NUMBER
PK5_VALUE	NUMBER
PK6_VALUE	NUMBER
PK7_VALUE	NUMBER
PK8_VALUE	NUMBER
PARTY_ID	NUMBER
OPINION_VALUE_ID	NUMBER		Yes
OPINION_VALUE_CODE	VARCHAR2	(30)	Yes
AUTHORED_BY	NUMBER
AUTHORED_DATE	DATE
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SECURITY_GROUP_ID	NUMBER
OBJECT_VERSION_NUMBER	NUMBER
OPINION_COMPONENT_CODE	VARCHAR2	(30)	Yes
CUST_ATTACHMENT_ID	NUMBER
ATTACHMENT_ID	NUMBER
CUST_IMAGE_FILE_NAME	VARCHAR2	(240)
IMAGE_FILE_NAME	VARCHAR2	(240)
OBJECT_NAME	VARCHAR2	(430)	Yes

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT opinion_rid
,      obj_opin_types_rid
,      opinion_types_rid
,      opinion_detail_rid
,      opinion_components
,      opinion_value_rid
,      fnd_object_rid
,      OPINION_LOG_ID
,      OPINION_SET_ID
,      OPINION_ID
,      OBJECT_OPINION_TYPE_ID
,      OPINION_TYPE_CODE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      PK6_VALUE
,      PK7_VALUE
,      PK8_VALUE
,      PARTY_ID
,      OPINION_VALUE_ID
,      OPINION_VALUE_CODE
,      AUTHORED_BY
,      AUTHORED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      OPINION_COMPONENT_CODE
,      CUST_ATTACHMENT_ID
,      ATTACHMENT_ID
,      CUST_IMAGE_FILE_NAME
,      IMAGE_FILE_NAME
,      OBJECT_NAME
FROM APPS.AMW_OPINION_LOG_MV;

Dependencies

[top of page]

APPS.AMW_OPINION_LOG_MV references the following:

AMW: AMW_OBJECT_OPINION_TYPES; AMW_OPINIONS_LOG; AMW_OPINION_COMPONTS_B; AMW_OPINION_LOG_DETAILS; AMW_OPINION_TYPES_B; AMW_OPINION_VALUES_B; AMW_OPINION_VALUE_CODES
APPLSYS: FND_OBJECTS
APPS: AMW_OPINION_LOG_MV

APPS.AMW_OPINION_LOG_MV is not referenced by any database object