DBA Data[Home] [Help]

APPS.WF_MONITOR dependencies on WF_ACTIVITY_TRANSITIONS

Line 1019: wf_activity_transitions t,

1015: p2.instance_id to_instance_id
1016: from wf_activities pd,
1017: wf_process_activities p1,
1018: wf_activities a,
1019: wf_activity_transitions t,
1020: wf_item_activity_statuses s,
1021: wf_lookups l,
1022: wf_process_activities p2
1023: where pd.item_type = x_proc_type

Line 1045: (select null from wf_activity_transitions tr

1041: and ((s.activity_status = 'COMPLETE' and
1042: (t.result_code in (nvl(s.activity_result_code, '#NULL'),
1043: wf_engine.eng_trans_any) or
1044: t.result_code = wf_engine.eng_trans_default and not exists
1045: (select null from wf_activity_transitions tr
1046: where tr.from_process_activity = p1.instance_id
1047: and tr.result_code = nvl(s.activity_result_code, '#NULL'))) and
1048: l.lookup_code = 'T') or
1049: (not (s.activity_status = 'COMPLETE' and

Line 1053: (select null from wf_activity_transitions tr

1049: (not (s.activity_status = 'COMPLETE' and
1050: (t.result_code in (nvl(s.activity_result_code, '#NULL'),
1051: wf_engine.eng_trans_any) or
1052: t.result_code = wf_engine.eng_trans_default and not exists
1053: (select null from wf_activity_transitions tr
1054: where tr.from_process_activity = p1.instance_id
1055: and tr.result_code = nvl(s.activity_result_code, '#NULL')))) or
1056: s.activity_status is null) and
1057: l.lookup_code = 'F')