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]

TABLE: APPS.AMW_OPINION_LOG_MV

Object Details

Object Name:	AMW_OPINION_LOG_MV
Object Type:	TABLE
Owner:	APPS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_OPINION_LOG_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OBJECT_NAME
AMW_OPINION_LOG_MV_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPINION_TYPE_CODE
AMW_OPINION_LOG_MV_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PK1_VALUE
AMW_OPINION_LOG_MV_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PK2_VALUE
AMW_OPINION_LOG_MV_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PK3_VALUE
AMW_OPINION_LOG_MV_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PK4_VALUE
AMW_OPINION_LOG_MV_N7	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	AUTHORED_DATE
AMW_OPINION_LOG_MV_U1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPINION_LOG_ID

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 does not reference any database object

APPS.AMW_OPINION_LOG_MV is referenced by following:

APPS: AMW_FINSTMT_CERT_BES_PKG - show dependent code; AMW_OPINION_LOG_MV