DBA Data[Home] [Help] [Dependency Information]

TABLE: AMW.AMW_OPINION_COMPONTS_B

Object Details
Object Name: AMW_OPINION_COMPONTS_B
Object Type: TABLE
Owner: AMW
FND Design Data: TableAMW.AMW_OPINION_COMPONTS_B
Subobject Name:
Status: VALID


A component complexifies an opinion by capturing information about a different aspect of the object being evaluated, certified, etc.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_OPINION_COMPONTS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOPINION_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
OPINION_COMPONENT_ID NUMBER
Yes Entity Identifier
OPINION_COMPONENT_CODE VARCHAR2 (30) Yes The code associated with this opinion component
OBJECT_OPINION_TYPE_ID NUMBER
Yes Identifies a unique entry from the table AMW_OBJECT_OPINION_TYPES.
PAGE_ORDER NUMBER
Yes Identifies the vertical position of this opinion component in a webpage that interfaces the creation or modification of an 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_COMPONENT_ID
,      OPINION_COMPONENT_CODE
,      OBJECT_OPINION_TYPE_ID
,      PAGE_ORDER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
FROM AMW.AMW_OPINION_COMPONTS_B;

Dependencies

[top of page]

AMW.AMW_OPINION_COMPONTS_B does not reference any database object

AMW.AMW_OPINION_COMPONTS_B is referenced by following:

SchemaAPPS
SynonymAMW_OPINION_COMPONTS_B
Materialized ViewAMW_OPINION_LOG_MV
Materialized ViewAMW_OPINION_MV