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

TABLE: AMW.AMW_OBJECT_ASSESSMENTS

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


Sotres assessments details for a certification , mostly for process certification


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_OBJECT_ASSESSMENTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSESSMENT_ID
ColumnPK1
ColumnPK2
Columns
Name Datatype Length Mandatory Comments
OBJECT_ASSESSMENT_ID NUMBER

Stores the Object Assessment Id
OBJECT_TYPE VARCHAR2 (50)
Stores the Object type
ASSESSMENT_ID NUMBER

Stores the assessment id
PK1 NUMBER

Stores PK1
PK2 NUMBER

Stores PK2
PK3 NUMBER

Stores PK3
PK4 NUMBER

Not currently used
PK5 NUMBER

Not currently used
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
OBJECT_VERSION_NUMBER NUMBER

This column is used for optimistic locking.
Query Text

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


SELECT OBJECT_ASSESSMENT_ID
,      OBJECT_TYPE
,      ASSESSMENT_ID
,      PK1
,      PK2
,      PK3
,      PK4
,      PK5
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
FROM AMW.AMW_OBJECT_ASSESSMENTS;

Dependencies

[top of page]

AMW.AMW_OBJECT_ASSESSMENTS does not reference any database object

AMW.AMW_OBJECT_ASSESSMENTS is referenced by following:

SchemaAPPS
SynonymAMW_OBJECT_ASSESSMENTS