[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
AMW.AMW_OPINIONS does not reference any database object
AMW.AMW_OPINIONS is referenced by following:
|
|
|