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

Object Details

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

An opinion can have multiple components, the details for each component being stored in table AMW_OPINION_DETAILS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMW_OPINIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OPINION_ID
AMW_OPINIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_OPINION_TYPE_ID PK1_VALUE PK2_VALUE PK3_VALUE PK4_VALUE PK5_VALUE
AMW_OPINIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_OPINION_TYPE_ID PK1_VALUE PK3_VALUE PK4_VALUE PK5_VALUE
AMW_OPINIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_OPINION_TYPE_ID PK2_VALUE PK3_VALUE PK4_VALUE PK5_VALUE
AMW_OPINIONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATED_BY

Columns

Name	Datatype	Length	Mandatory	Comments
OPINION_SET_ID	NUMBER		Yes	Opinion Set Identifier: Opinions can be grouped into sets.
OPINION_ID	NUMBER		Yes	Entity Identifier
OBJECT_OPINION_TYPE_ID	NUMBER		Yes	Identifies a unique entry from the table AMW_OBJECT_OPINION_TYPES.
PK1_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK2_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK3_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK4_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK5_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK6_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK7_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PK8_VALUE	NUMBER			Used in identifying the context hierarchy of the entity to which this opinion correponds.
PARTY_ID	NUMBER			Identifies the party that has last modified this opinion.
AUTHORED_BY	NUMBER			Identifies the employee who has last modified this opinion.
AUTHORED_DATE	DATE			Dates the creation or the last modification of this opinion.
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			Standard Column
OBJECT_VERSION_NUMBER	NUMBER			Standard Column

Query Text

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


SELECT 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;

Dependencies

[top of page]

AMW.AMW_OPINIONS does not reference any database object

AMW.AMW_OPINIONS is referenced by following:

APPS: AMW_OPINIONS; AMW_OPINION_MV