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