[Home] [Help] [Dependency Information]
Object Name: | EGO_OBJ_ROLE_MAPPINGS |
---|---|
Object Type: | TABLE |
Owner: | EGO |
FND Design Data: | EGO.EGO_OBJ_ROLE_MAPPINGS |
Subobject Name: | |
Status: | VALID |
Table contains Mapping between different object roles
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EGO_OBJ_ROLE_MAPPINGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PARENT_OBJECT_ID
CHILD_OBJECT_ID PARENT_ROLE_ID CHILD_OBJECT_TYPE CHILD_ROLE_ID ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARENT_OBJECT_ID | NUMBER | Yes | Parent Object Id | |
PARENT_ROLE_ID | NUMBER | Yes | Parent Role Id | |
CHILD_OBJECT_ID | NUMBER | Yes | Child Object Id | |
CHILD_OBJECT_TYPE | VARCHAR2 | (60) | Type of Child Object | |
CHILD_ROLE_ID | NUMBER | Yes | Child Role 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 | ||
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PARENT_OBJECT_ID
, PARENT_ROLE_ID
, CHILD_OBJECT_ID
, CHILD_OBJECT_TYPE
, CHILD_ROLE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM EGO.EGO_OBJ_ROLE_MAPPINGS;
EGO.EGO_OBJ_ROLE_MAPPINGS does not reference any database object
EGO.EGO_OBJ_ROLE_MAPPINGS is referenced by following:
|
|
|