DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on WF_ACTIVITIES

Line 370: wf_activities wa,

366: wias_to.item_type,
367: wias_to.item_key
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

Line 482: wf_activities wa,

478: wias_to.item_type
479: INTO l_activity, l_item_type
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

Line 622: wf_activities wa,

618: wias_to.item_type
619: INTO l_activity, l_item_type
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