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

TABLE: AMW.AMW_ROLE_CONSTRAINT_DENORM

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


Stores the 'Menu/Function Structure within Responsibility' for Potential Responsibility Violation of constraints


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMW_ROLE_CONSTRAINT_DENORM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONSTRAINT_REV_ID
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
FUNCTION_ID NUMBER
Yes Stores the function Id
MENU_ID NUMBER

Stores the menu id
CONSTRAINT_REV_ID NUMBER
Yes Stores the constraint rev id
OBJECT_TYPE VARCHAR2 (30)
Stores the object type. FUNC - Function,CP - Concurrent Program
GROUP_CODE VARCHAR2 (30)
Stores the Incompatible Set code
ROLE_NAME VARCHAR2 (320)
Stores the role name
RESPONSIBILITY_ID NUMBER

Stores the responsibility id
Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      FUNCTION_ID
,      MENU_ID
,      CONSTRAINT_REV_ID
,      OBJECT_TYPE
,      GROUP_CODE
,      ROLE_NAME
,      RESPONSIBILITY_ID
FROM AMW.AMW_ROLE_CONSTRAINT_DENORM;

Dependencies

[top of page]

AMW.AMW_ROLE_CONSTRAINT_DENORM does not reference any database object

AMW.AMW_ROLE_CONSTRAINT_DENORM is referenced by following:

SchemaAPPS
SynonymAMW_ROLE_CONSTRAINT_DENORM