DBA Data[Home] [Help]

APPS.OE_HOLDS_PVT dependencies on WF_ACTIVITY_TRANSITIONS

Line 470: wf_activity_transitions wat,

466: wf_process_activities wpa_to,
467: wf_activities wa,
468: wf_item_activity_statuses wias_from,
469: wf_process_activities wpa_from,
470: wf_activity_transitions wat,
471: wf_items wi
472: WHERE wpa_to.instance_id= wias_to.process_activity
473: AND wat.to_process_activity = wpa_to.instance_id
474: AND wat.result_code = 'ON_HOLD'

Line 608: wf_activity_transitions wat

604: wf_process_activities wpa_to,
605: wf_activities wa,
606: wf_item_activity_statuses wias_from,
607: wf_process_activities wpa_from,
608: wf_activity_transitions wat
609: WHERE wpa_to.instance_id= wias_to.process_activity
610: AND wat.to_process_activity = wpa_to.instance_id
611: AND wat.result_code = 'ON_HOLD'
612: AND wias_from.process_activity = wat.from_process_activity

Line 637: wf_activity_transitions wat

633: wf_process_activities wpa_to,
634: wf_activities wa,
635: wf_item_activity_statuses wias_from,
636: wf_process_activities wpa_from,
637: wf_activity_transitions wat
638: WHERE wpa_to.instance_id= wias_to.process_activity
639: AND wat.to_process_activity = wpa_to.instance_id
640: AND wat.result_code = 'ON_HOLD'
641: AND wias_from.process_activity = wat.from_process_activity

Line 691: wf_activity_transitions wat

687: wf_process_activities wpa_to,
688: wf_activities wa,
689: wf_item_activity_statuses_h wias_from,
690: wf_process_activities wpa_from,
691: wf_activity_transitions wat
692: WHERE wpa_to.instance_id= wias_to.process_activity
693: AND wat.to_process_activity = wpa_to.instance_id
694: AND wat.result_code = 'ON_HOLD'
695: AND wias_from.process_activity = wat.from_process_activity

Line 850: wf_activity_transitions wat

846: wf_process_activities wpa_to,
847: wf_activities wa,
848: wf_item_activity_statuses wias_from,
849: wf_process_activities wpa_from,
850: wf_activity_transitions wat
851: WHERE wpa_to.instance_id= wias_to.process_activity
852: AND wat.to_process_activity = wpa_to.instance_id
853: AND wat.result_code = 'ON_HOLD'
854: AND wias_from.process_activity = wat.from_process_activity

Line 901: wf_activity_transitions wat

897: wf_process_activities wpa_to,
898: wf_activities wa,
899: wf_item_activity_statuses_h wias_from,
900: wf_process_activities wpa_from,
901: wf_activity_transitions wat
902: WHERE wpa_to.instance_id= wias_to.process_activity
903: AND wat.to_process_activity = wpa_to.instance_id
904: AND wat.result_code = 'ON_HOLD'
905: AND wias_from.process_activity = wat.from_process_activity