DBA Data[Home] [Help]

APPS.WF_STANDARD dependencies on WF_ACTIVITY_TRANSITIONS

Line 160: FROM WF_ACTIVITY_TRANSITIONS WAT

156: -- The And fails if there is at least one in-transition which is either
157: -- incomplete or complete with the wrong result.
158: SELECT count(1)
159: into cnt
160: FROM WF_ACTIVITY_TRANSITIONS WAT
161: WHERE WAT.TO_PROCESS_ACTIVITY = actid
162: AND NOT EXISTS
163: (SELECT NULL
164: FROM WF_ITEM_ACTIVITY_STATUSES WIAS

Line 174: FROM WF_ACTIVITY_TRANSITIONS WAT2

170: wf_engine.eng_trans_any)
171: OR (WAT.RESULT_CODE = wf_engine.eng_trans_default
172: AND NOT EXISTS
173: (SELECT NULL
174: FROM WF_ACTIVITY_TRANSITIONS WAT2
175: WHERE WAT2.FROM_PROCESS_ACTIVITY =
176: WAT.FROM_PROCESS_ACTIVITY
177: AND WAT2.RESULT_CODE = WIAS.ACTIVITY_RESULT_CODE)
178: )

Line 1644: FROM wf_activity_transitions wat,

1640: SELECT wat.to_process_activity,
1641: wpa.activity_name,
1642: wpa.perform_role,
1643: wpa.perform_role_type
1644: FROM wf_activity_transitions wat,
1645: wf_process_activities wpa
1646: WHERE wat.from_process_activity = actid
1647: AND wat.result_code = wf_engine.eng_trans_default
1648: AND wat.to_process_activity = wpa.instance_id;