DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_ROUTING_RULE_ATTRIBUTES

Line 743: wf_routing_rule_attributes wra,

739: wra.name,
740: wra.type,
741: nvl(nvl(wra.text_value, to_char(wra.number_value)), to_char(wra.date_value)) value
742: FROM wf_routing_rules wr,
743: wf_routing_rule_attributes wra,
744: wf_notifications wn
745: WHERE wr.rule_id = wra.rule_id (+)
746: AND (wr.role = wn.recipient_role or wr.action_argument = wn.recipient_role)
747: AND wn.notification_id = p_nid;