[Home] [Help] [Dependency Information]
Object Name: | WF_ROLE_HIERARCHIES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.WF_ROLE_HIERARCHIES |
Subobject Name: | |
Status: | VALID |
WF_ROLE_HIERARCHIES
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WF_ROLE_HIERARCHIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RELATIONSHIP_ID |
WF_ROLE_HIERARCHIES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SUPER_NAME
SUB_NAME |
WF_ROLE_HIERARCHIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SUB_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RELATIONSHIP_ID | NUMBER | Yes | RELATIONSHIP_ID | |
SUB_NAME | VARCHAR2 | (320) | Yes | SUB_NAME |
SUPER_NAME | VARCHAR2 | (320) | Yes | SUPER_NAME |
CREATED_BY | NUMBER | (15) | CREATED_BY | |
CREATION_DATE | DATE | CREATION_DATE | ||
LAST_UPDATED_BY | NUMBER | (15) | LAST_UPDATED_BY | |
LAST_UPDATE_DATE | DATE | LAST_UPDATE_DATE | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | LAST_UPDATE_LOGIN | |
ENABLED_FLAG | VARCHAR2 | (1) | Yes | ENABLED_FLAG |
SECURITY_GROUP_ID | VARCHAR2 | (32) | SECURITY_GROUP_ID | |
PROPAGATE_DATE | DATE | |||
PARTITION_ID | NUMBER | Yes | ||
SUPERIOR_PARTITION_ID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RELATIONSHIP_ID
, SUB_NAME
, SUPER_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ENABLED_FLAG
, SECURITY_GROUP_ID
, PROPAGATE_DATE
, PARTITION_ID
, SUPERIOR_PARTITION_ID
FROM APPLSYS.WF_ROLE_HIERARCHIES;
APPLSYS.WF_ROLE_HIERARCHIES does not reference any database object
APPLSYS.WF_ROLE_HIERARCHIES is referenced by following:
|
|
|