DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on WF_ROUTING_RULES

Line 742: FROM wf_routing_rules wr,

738: wr.action_argument act_arg,
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)