[Home] [Help] [Dependency Information]
Object Name: | WF_EVENT_SUBSCRIPTIONS |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.WF_EVENT_SUBSCRIPTIONS |
Subobject Name: | |
Status: | VALID |
Subscription for Business Event System
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WF_EVENT_SUBSCRIPTIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
GUID
ZD_EDITION_NAME |
WF_EVENT_SUBSCRIPTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
SYSTEM_GUID
SOURCE_TYPE EVENT_FILTER_GUID |
WF_EVENT_SUBSCRIPTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | EVENT_FILTER_GUID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
GUID | RAW | (16) | Yes | Event subscription global unique id |
SYSTEM_GUID | RAW | (16) | Yes | System that this subscription should take action |
SOURCE_TYPE | VARCHAR2 | (8) | Yes | Where the event comes from like ERROR, EXTERNAL or LOCAL |
SOURCE_AGENT_GUID | RAW | (16) | From which agent the event comes from | |
EVENT_FILTER_GUID | RAW | (16) | Yes | What event this subscription is interested in |
PHASE | NUMBER | Order of subscriptions to take place when there are multiple subscriptions on an event. when phase is 100 or above, the subscription is considered deferred. | ||
STATUS | VARCHAR2 | (8) | Yes | Subscription status which could be ENALBLED or DISABLED. |
RULE_DATA | VARCHAR2 | (8) | Yes | Data that the rule function is interested in which could be KEY or MESSAGE |
OUT_AGENT_GUID | RAW | (16) | Send the event to this agent | |
TO_AGENT_GUID | RAW | (16) | Retrive event from this agent | |
PRIORITY | NUMBER | Subscription priority | ||
RULE_FUNCTION | VARCHAR2 | (240) | Function to be run for this subscription | |
WF_PROCESS_TYPE | VARCHAR2 | (30) | Item type of a workflow to be invoked | |
WF_PROCESS_NAME | VARCHAR2 | (30) | Process in above item type to be invoked | |
PARAMETERS | VARCHAR2 | (4000) | Parameters to be passed in | |
OWNER_NAME | VARCHAR2 | (30) | Subscription owner name which usually is the product name | |
OWNER_TAG | VARCHAR2 | (30) | Subscription owner tag wich usually is the product short code | |
DESCRIPTION | VARCHAR2 | (240) | Description of the subscription | |
EXPRESSION | VARCHAR2 | (4000) | something that will be evaluated at runtime to further restrict if an event subscription rule applied | |
SECURITY_GROUP_ID | VARCHAR2 | (32) | identifier reserved for hosting environment | |
CUSTOMIZATION_LEVEL | VARCHAR2 | (1) | Yes | CUSTOMIZATION_LEVEL |
LICENSED_FLAG | VARCHAR2 | (1) | Yes | LICENSED_FLAG |
INVOCATION_ID | NUMBER | INVOCATION_ID | ||
MAP_CODE | VARCHAR2 | (30) | MAP_CODE | |
STANDARD_TYPE | VARCHAR2 | (30) | STANDARD_TYPE | |
STANDARD_CODE | VARCHAR2 | (30) | STANDARD_CODE | |
JAVA_RULE_FUNC | VARCHAR2 | (240) | JAVA_RULE_FUNC | |
ON_ERROR_CODE | VARCHAR2 | (30) | ON_ERROR_CODE | |
ACTION_CODE | VARCHAR2 | (30) | ACTION_CODE | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT GUID
, SYSTEM_GUID
, SOURCE_TYPE
, SOURCE_AGENT_GUID
, EVENT_FILTER_GUID
, PHASE
, STATUS
, RULE_DATA
, OUT_AGENT_GUID
, TO_AGENT_GUID
, PRIORITY
, RULE_FUNCTION
, WF_PROCESS_TYPE
, WF_PROCESS_NAME
, PARAMETERS
, OWNER_NAME
, OWNER_TAG
, DESCRIPTION
, EXPRESSION
, SECURITY_GROUP_ID
, CUSTOMIZATION_LEVEL
, LICENSED_FLAG
, INVOCATION_ID
, MAP_CODE
, STANDARD_TYPE
, STANDARD_CODE
, JAVA_RULE_FUNC
, ON_ERROR_CODE
, ACTION_CODE
, ZD_EDITION_NAME
FROM APPLSYS.WF_EVENT_SUBSCRIPTIONS;
APPLSYS.WF_EVENT_SUBSCRIPTIONS does not reference any database object
APPLSYS.WF_EVENT_SUBSCRIPTIONS is referenced by following:
|
|
|