DBA Data[Home] [Help]

APPS.WF_TASKFLOW dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 635: wf_item_activity_statuses wias

631: activity_status
632: FROM wf_process_activities wpa,
633: wf_activities_vl wav,
634: wf_activities_vl wav2,
635: wf_item_activity_statuses wias
636: WHERE wpa.process_item_type = x_item_type -- check parent activity
637: AND wpa.process_name = x_parent_name
638: AND wav2.item_type = wpa.process_item_type
639: AND wav2.name = wpa.process_name

Line 741: wf_item_activity_statuses wias

737: activity_status
738: FROM wf_process_activities wpa,
739: wf_activities_vl wav,
740: wf_activities_vl wav2,
741: wf_item_activity_statuses wias
742: WHERE wpa.process_item_type = x_base_type /* check base activity */
743: AND wpa.process_name = x_base_name
744: AND wav2.item_type = wpa.process_item_type
745: AND wav2.name = wpa.process_name

Line 844: wf_item_activity_statuses wias,

840: wf_activities_vl wav,
841: wf_activities_vl wav2,
842: wf_activity_transitions wat,
843: wf_process_activities wpa2,
844: wf_item_activity_statuses wias,
845: wf_lookups wl
846: WHERE wpa.process_item_type = x_base_type /* check base activity */
847: AND wpa.process_name = x_base_name
848: AND wav.item_type = wpa.process_item_type