[Home] [Help] [Dependency Information]
Object Name: | WF_WORKLIST_DEFINITIONS# |
---|---|
Object Type: | VIEW |
Owner: | APPLSYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLUG_ID | NUMBER | |||
USERNAME | VARCHAR2 | (320) | ||
DEFINITION_NAME | VARCHAR2 | (30) | ||
WHERE_STATUS | VARCHAR2 | (30) | ||
WHERE_FROM | VARCHAR2 | (30) | ||
WHERE_ITEM_TYPE | VARCHAR2 | (8) | ||
WHERE_NOTIF_TYPE | VARCHAR2 | (30) | ||
WHERE_SUBJECT | VARCHAR2 | (240) | ||
WHERE_SENT_START | DATE | |||
WHERE_SENT_END | DATE | |||
WHERE_DUE_START | DATE | |||
WHERE_DUE_END | DATE | |||
WHERE_PRIORITY | VARCHAR2 | (10) | ||
WHERE_NOTIF_DEL_BY_ME | VARCHAR2 | (1) | ||
ORDER_PRIMARY | VARCHAR2 | (30) | ||
ORDER_ASC_DESC | VARCHAR2 | (4) | ||
SECURITY_GROUP_ID | VARCHAR2 | (32) |
Cut, paste (and edit) the following text to query this object:
SELECT PLUG_ID
, USERNAME
, DEFINITION_NAME
, WHERE_STATUS
, WHERE_FROM
, WHERE_ITEM_TYPE
, WHERE_NOTIF_TYPE
, WHERE_SUBJECT
, WHERE_SENT_START
, WHERE_SENT_END
, WHERE_DUE_START
, WHERE_DUE_END
, WHERE_PRIORITY
, WHERE_NOTIF_DEL_BY_ME
, ORDER_PRIMARY
, ORDER_ASC_DESC
, SECURITY_GROUP_ID
FROM APPLSYS.WF_WORKLIST_DEFINITIONS#;
|
|
|