DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on WF_ACTIVITY_TRANSITIONS

Line 372: wf_activity_transitions wat,

368: FROM wf_item_activity_statuses wias_to,
369: wf_process_activities wpa_to,
370: wf_activities wa,
371: wf_item_activity_statuses wias_from,
372: wf_activity_transitions wat,
373: wf_items wi
374: WHERE wpa_to.instance_id= wias_to.process_activity
375: AND wat.to_process_activity = wpa_to.instance_id
376: AND wat.result_code = 'ON_HOLD'

Line 484: wf_activity_transitions wat

480: FROM wf_item_activity_statuses wias_to,
481: wf_process_activities wpa_to,
482: wf_activities wa,
483: wf_item_activity_statuses wias_from,
484: wf_activity_transitions wat
485: WHERE wpa_to.instance_id= wias_to.process_activity
486: AND wat.to_process_activity = wpa_to.instance_id
487: AND wat.result_code = 'ON_HOLD'
488: AND wias_from.process_activity = wat.from_process_activity

Line 624: wf_activity_transitions wat

620: FROM wf_item_activity_statuses wias_to,
621: wf_process_activities wpa_to,
622: wf_activities wa,
623: wf_item_activity_statuses wias_from,
624: wf_activity_transitions wat
625: WHERE wpa_to.instance_id= wias_to.process_activity
626: AND wat.to_process_activity = wpa_to.instance_id
627: AND wat.result_code = 'ON_HOLD'
628: AND wias_from.process_activity = wat.from_process_activity