VIEW: APPS.WF_ACTIVE_SUBSCRIPTIONS_V

Source

View Text - Preformatted

SELECT evt.name EVENT_NAME, DECODE(evt.generate_function, NULL, DECODE(evt.JAVA_GENERATE_FUNC, NULL, NULL, 'java://' || evt.JAVA_GENERATE_FUNC), evt.generate_function) GENERATE_FUNCTION, sub.system_guid SYSTEM_GUID, sub.guid SUBSCRIPTION_GUID, sub.source_type SUBSCRIPTION_SOURCE_TYPE, sub.source_agent_guid SUBSCRIPTION_SOURCE_AGENT_GUID, NVL(sub.phase, 0) SUBSCRIPTION_PHASE, sub.rule_data SUBSCRIPTION_RULE_DATA, sub.out_agent_guid SUBSCRIPTION_OUT_AGENT_GUID, sub.to_agent_guid SUBSCRIPTION_TO_AGENT_GUID, sub.priority SUBSCRIPTION_PRIORITY, DECODE(sub.rule_function, NULL, DECODE(sub.JAVA_RULE_FUNC, NULL, NULL, 'java://' || sub.JAVA_RULE_FUNC), sub.rule_function) SUBSCRIPTION_RULE_FUNCTION, sub.wf_process_type WF_PROCESS_TYPE, sub.wf_process_name WF_PROCESS_NAME, sub.parameters SUBSCRIPTION_PARAMETERS, sub.ON_ERROR_CODE SUBSCRIPTION_ON_ERROR_TYPE, sub.EXPRESSION SUBSCRIPTION_EXPRESSION FROM wf_event_subscriptions sub, wf_events evt WHERE sub.status = 'ENABLED' AND sub.licensed_flag = 'Y' AND sub.event_filter_guid = evt.guid AND evt.type = 'EVENT' AND evt.status = 'ENABLED' AND evt.licensed_flag = 'Y' UNION ALL (SELECT evt.name EVENT_NAME, DECODE(evt.generate_function, NULL, DECODE(evt.JAVA_GENERATE_FUNC, NULL, NULL, 'java://' || evt.JAVA_GENERATE_FUNC), evt.generate_function) GENERATE_FUNCTION, sub.system_guid SYSTEM_GUID, sub.guid SUBSCRIPTION_GUID, sub.source_type SUBSCRIPTION_SOURCE_TYPE, sub.source_agent_guid SUBSCRIPTION_SOURCE_AGENT_GUID, NVL(sub.phase, 0) SUBSCRIPTION_PHASE, sub.rule_data SUBSCRIPTION_RULE_DATA, sub.out_agent_guid SUBSCRIPTION_OUT_AGENT_GUID, sub.to_agent_guid SUBSCRIPTION_TO_AGENT_GUID, sub.priority SUBSCRIPTION_PRIORITY, DECODE(sub.rule_function, NULL, DECODE(sub.JAVA_RULE_FUNC, NULL, NULL, 'java://' || sub.JAVA_RULE_FUNC), sub.rule_function) SUBSCRIPTION_RULE_FUNCTION, sub.wf_process_type WF_PROCESS_TYPE, sub.wf_process_name WF_PROCESS_NAME, sub.parameters SUBSCRIPTION_PARAMETERS, sub.ON_ERROR_CODE SUBSCRIPTION_ON_ERROR_TYPE, sub.EXPRESSION SUBSCRIPTION_EXPRESSION FROM wf_event_subscriptions sub, wf_event_groups egrp, wf_events grp, wf_events evt WHERE sub.status = 'ENABLED' AND sub.licensed_flag = 'Y' AND grp.guid = sub.event_filter_guid AND grp.type = 'GROUP' AND grp.status = 'ENABLED' AND egrp.group_guid = grp.guid AND egrp.member_guid = evt.guid AND evt.type = 'EVENT' AND evt.status = 'ENABLED' AND evt.licensed_flag = 'Y') ORDER BY 7

View Text - HTML Formatted

SELECT EVT.NAME EVENT_NAME
, DECODE(EVT.GENERATE_FUNCTION
, NULL
, DECODE(EVT.JAVA_GENERATE_FUNC
, NULL
, NULL
, 'JAVA://' || EVT.JAVA_GENERATE_FUNC)
, EVT.GENERATE_FUNCTION) GENERATE_FUNCTION
, SUB.SYSTEM_GUID SYSTEM_GUID
, SUB.GUID SUBSCRIPTION_GUID
, SUB.SOURCE_TYPE SUBSCRIPTION_SOURCE_TYPE
, SUB.SOURCE_AGENT_GUID SUBSCRIPTION_SOURCE_AGENT_GUID
, NVL(SUB.PHASE
, 0) SUBSCRIPTION_PHASE
, SUB.RULE_DATA SUBSCRIPTION_RULE_DATA
, SUB.OUT_AGENT_GUID SUBSCRIPTION_OUT_AGENT_GUID
, SUB.TO_AGENT_GUID SUBSCRIPTION_TO_AGENT_GUID
, SUB.PRIORITY SUBSCRIPTION_PRIORITY
, DECODE(SUB.RULE_FUNCTION
, NULL
, DECODE(SUB.JAVA_RULE_FUNC
, NULL
, NULL
, 'JAVA://' || SUB.JAVA_RULE_FUNC)
, SUB.RULE_FUNCTION) SUBSCRIPTION_RULE_FUNCTION
, SUB.WF_PROCESS_TYPE WF_PROCESS_TYPE
, SUB.WF_PROCESS_NAME WF_PROCESS_NAME
, SUB.PARAMETERS SUBSCRIPTION_PARAMETERS
, SUB.ON_ERROR_CODE SUBSCRIPTION_ON_ERROR_TYPE
, SUB.EXPRESSION SUBSCRIPTION_EXPRESSION
FROM WF_EVENT_SUBSCRIPTIONS SUB
, WF_EVENTS EVT
WHERE SUB.STATUS = 'ENABLED'
AND SUB.LICENSED_FLAG = 'Y'
AND SUB.EVENT_FILTER_GUID = EVT.GUID
AND EVT.TYPE = 'EVENT'
AND EVT.STATUS = 'ENABLED'
AND EVT.LICENSED_FLAG = 'Y' UNION ALL (SELECT EVT.NAME EVENT_NAME
, DECODE(EVT.GENERATE_FUNCTION
, NULL
, DECODE(EVT.JAVA_GENERATE_FUNC
, NULL
, NULL
, 'JAVA://' || EVT.JAVA_GENERATE_FUNC)
, EVT.GENERATE_FUNCTION) GENERATE_FUNCTION
, SUB.SYSTEM_GUID SYSTEM_GUID
, SUB.GUID SUBSCRIPTION_GUID
, SUB.SOURCE_TYPE SUBSCRIPTION_SOURCE_TYPE
, SUB.SOURCE_AGENT_GUID SUBSCRIPTION_SOURCE_AGENT_GUID
, NVL(SUB.PHASE
, 0) SUBSCRIPTION_PHASE
, SUB.RULE_DATA SUBSCRIPTION_RULE_DATA
, SUB.OUT_AGENT_GUID SUBSCRIPTION_OUT_AGENT_GUID
, SUB.TO_AGENT_GUID SUBSCRIPTION_TO_AGENT_GUID
, SUB.PRIORITY SUBSCRIPTION_PRIORITY
, DECODE(SUB.RULE_FUNCTION
, NULL
, DECODE(SUB.JAVA_RULE_FUNC
, NULL
, NULL
, 'JAVA://' || SUB.JAVA_RULE_FUNC)
, SUB.RULE_FUNCTION) SUBSCRIPTION_RULE_FUNCTION
, SUB.WF_PROCESS_TYPE WF_PROCESS_TYPE
, SUB.WF_PROCESS_NAME WF_PROCESS_NAME
, SUB.PARAMETERS SUBSCRIPTION_PARAMETERS
, SUB.ON_ERROR_CODE SUBSCRIPTION_ON_ERROR_TYPE
, SUB.EXPRESSION SUBSCRIPTION_EXPRESSION
FROM WF_EVENT_SUBSCRIPTIONS SUB
, WF_EVENT_GROUPS EGRP
, WF_EVENTS GRP
, WF_EVENTS EVT
WHERE SUB.STATUS = 'ENABLED'
AND SUB.LICENSED_FLAG = 'Y'
AND GRP.GUID = SUB.EVENT_FILTER_GUID
AND GRP.TYPE = 'GROUP'
AND GRP.STATUS = 'ENABLED'
AND EGRP.GROUP_GUID = GRP.GUID
AND EGRP.MEMBER_GUID = EVT.GUID
AND EVT.TYPE = 'EVENT'
AND EVT.STATUS = 'ENABLED'
AND EVT.LICENSED_FLAG = 'Y') ORDER BY 7