View: WF_ACTIVE_SUBSCRIPTIONS_V

Product:	FND - Application Object Library
Description:	WF_ACTIVE_SUBSCRIPTIONS_V
Implementation/DBA Data:	APPS.WF_ACTIVE_SUBSCRIPTIONS_V

View Text

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

Columns