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

TABLE: AMW.AMW_SURVEY_ASSOCS

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


Stores details of association between survey and assessment


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SURVEY_ASSOC_ID NUMBER
Yes Survey Association Id
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
OBJECT_ID NUMBER
Yes Object Id
OBJECT_TYPE VARCHAR2 (30) Yes Object Type
IES_SURVEY_ID NUMBER

IES Survey Identifier
IES_CYCLE_ID NUMBER

IES Cycle Identifier
IES_DEPLOYMENT_ID NUMBER

IES Deployment Identifier
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 SURVEY_ASSOC_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_ID
,      OBJECT_TYPE
,      IES_SURVEY_ID
,      IES_CYCLE_ID
,      IES_DEPLOYMENT_ID
,      OBJECT_VERSION_NUMBER
FROM AMW.AMW_SURVEY_ASSOCS;

Dependencies

[top of page]

AMW.AMW_SURVEY_ASSOCS does not reference any database object

AMW.AMW_SURVEY_ASSOCS is referenced by following:

SchemaAPPS
SynonymAMW_SURVEY_ASSOCS