VIEW: APPS.EDR_WFEVENT_XMLMAP_V

Source

View Text - Preformatted

SELECT a.owner_tag, a.display_name, a.name, EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE',b.GUID) from wf_events_vl a,wf_event_subscriptions b WHERE b.EVENT_FILTER_GUID=a.guid and b.RULE_FUNCTION = 'EDR_PSIG_RULE.PSIG_RULE' and b.source_type ='LOCAL' and b.system_guid = hextoraw(wf_core.translate('WF_SYSTEM_GUID'))

View Text - HTML Formatted

SELECT A.OWNER_TAG
, A.DISPLAY_NAME
, A.NAME
, EDR_INDEXED_XML_UTIL.GET_WF_PARAMS('EDR_XML_MAP_CODE'
, B.GUID)
FROM WF_EVENTS_VL A
, WF_EVENT_SUBSCRIPTIONS B
WHERE B.EVENT_FILTER_GUID=A.GUID
AND B.RULE_FUNCTION = 'EDR_PSIG_RULE.PSIG_RULE'
AND B.SOURCE_TYPE ='LOCAL'
AND B.SYSTEM_GUID = HEXTORAW(WF_CORE.TRANSLATE('WF_SYSTEM_GUID'))