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: AMW.AMW_OPINIONS_LOG

Object Details

Object Name:	AMW_OPINIONS_LOG
Object Type:	TABLE
Owner:	AMW
FND Design Data:	AMW.AMW_OPINIONS_LOG
Subobject Name:
Status:	VALID

the opinion history information. the latest opinion is stored in AMW_OPINIONS

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_OPINIONS_LOG_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OPINION_LOG_ID
AMW_OPINIONS_LOG_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OPINION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OPINION_LOG_ID	NUMBER		Yes	opinion log id
OPINION_SET_ID	NUMBER		Yes	opinion set id
OPINION_ID	NUMBER		Yes	opinion id
OBJECT_OPINION_TYPE_ID	NUMBER		Yes	object opinion type id
PK1_VALUE	NUMBER			primary key 1 value
PK2_VALUE	NUMBER			primary key 2 value
PK3_VALUE	NUMBER			primary key 3 value
PK4_VALUE	NUMBER			primary key 4 value
PK5_VALUE	NUMBER			primary key 5 value
PK6_VALUE	NUMBER			primary key 6 value
PK7_VALUE	NUMBER			primary key 7 value
PK8_VALUE	NUMBER			primary key 8 value
PARTY_ID	NUMBER			party id
AUTHORED_BY	NUMBER			authored by
AUTHORED_DATE	DATE			authored date
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used for hosting environments
OBJECT_VERSION_NUMBER	NUMBER			Object version number for locking

Query Text

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


SELECT OPINION_LOG_ID
,      OPINION_SET_ID
,      OPINION_ID
,      OBJECT_OPINION_TYPE_ID
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      PK6_VALUE
,      PK7_VALUE
,      PK8_VALUE
,      PARTY_ID
,      AUTHORED_BY
,      AUTHORED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM AMW.AMW_OPINIONS_LOG;

Dependencies

[top of page]

AMW.AMW_OPINIONS_LOG does not reference any database object

AMW.AMW_OPINIONS_LOG is referenced by following:

APPS: AMW_OPINIONS_LOG; AMW_OPINION_LOG_MV