eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_TASKFLOW dependencies on WF_ACTIVITIES

Line 169: wf_activities wav

165: BEGIN
166: SELECT DISTINCT wav.item_type, wav.name, wav.version
167: INTO parent_type, parent_name, parent_version
168: FROM wf_process_activities wpa,
169: wf_activities wav
170: WHERE wpa.activity_item_type = x_base_type
171: AND wpa.activity_name = x_base_name
172: AND wav.item_type = wpa.process_item_type
173: AND wav.name = wpa.process_name

Line 189: FROM wf_activities

185: END;
186:
187: SELECT version
188: INTO base_version
189: FROM wf_activities
190: WHERE item_type = x_base_type
191: AND name = x_base_name
192: AND begin_date <= start_date
193: AND (end_date IS NULL

Line 255: wf_activities_vl wav,

251: wpa.instance_id,
252: NVL(wpa.start_end,' ') start_end,
253: DECODE(wpa.icon_geometry, '', '0,0', wpa.icon_geometry) geometry
254: FROM wf_process_activities wpa,
255: wf_activities_vl wav,
256: wf_activities wav2
257: WHERE wpa.process_item_type = x_parent_type /* check parent activity */
258: AND wpa.process_name = x_parent_name
259: AND wav2.item_type = wpa.process_item_type

Line 256: wf_activities wav2

252: NVL(wpa.start_end,' ') start_end,
253: DECODE(wpa.icon_geometry, '', '0,0', wpa.icon_geometry) geometry
254: FROM wf_process_activities wpa,
255: wf_activities_vl wav,
256: wf_activities wav2
257: WHERE wpa.process_item_type = x_parent_type /* check parent activity */
258: AND wpa.process_name = x_parent_name
259: AND wav2.item_type = wpa.process_item_type
260: AND wav2.name = wpa.process_name

Line 351: wf_activities_vl wav,

347: wpa.instance_id,
348: NVL(wpa.start_end,' ') start_end,
349: wpa.icon_geometry
350: FROM wf_process_activities wpa,
351: wf_activities_vl wav,
352: wf_activities wav2
353: WHERE wpa.process_item_type = x_base_type /* check base activity */
354: AND wpa.process_name = x_base_name
355: AND wpa.process_version = x_base_version /* must have version */

Line 352: wf_activities wav2

348: NVL(wpa.start_end,' ') start_end,
349: wpa.icon_geometry
350: FROM wf_process_activities wpa,
351: wf_activities_vl wav,
352: wf_activities wav2
353: WHERE wpa.process_item_type = x_base_type /* check base activity */
354: AND wpa.process_name = x_base_name
355: AND wpa.process_version = x_base_version /* must have version */
356: AND wav2.item_type = wpa.process_item_type

Line 438: wf_activities_vl wav,

434: wpa2.icon_geometry to_icon,
435: wpa2.instance_id to_instance,
436: wat.arrow_geometry
437: FROM wf_process_activities wpa,
438: wf_activities_vl wav,
439: wf_activities_vl wav2,
440: wf_activity_transitions wat,
441: wf_process_activities wpa2
442: WHERE wpa.process_item_type = x_base_type /* check base activity */

Line 439: wf_activities_vl wav2,

435: wpa2.instance_id to_instance,
436: wat.arrow_geometry
437: FROM wf_process_activities wpa,
438: wf_activities_vl wav,
439: wf_activities_vl wav2,
440: wf_activity_transitions wat,
441: wf_process_activities wpa2
442: WHERE wpa.process_item_type = x_base_type /* check base activity */
443: AND wpa.process_name = x_base_name

Line 633: wf_activities_vl wav,

629: usage_result,
630: DECODE(wias.activity_status, '', ' ', wias.activity_status)
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

Line 634: wf_activities_vl wav2,

630: DECODE(wias.activity_status, '', ' ', wias.activity_status)
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

Line 739: wf_activities_vl wav,

735: usage_result,
736: DECODE(wias.activity_status, '', ' ', wias.activity_status)
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

Line 740: wf_activities_vl wav2,

736: DECODE(wias.activity_status, '', ' ', wias.activity_status)
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

Line 840: wf_activities_vl wav,

836: wpa2.instance_id to_instance,
837: wat.arrow_geometry,
838: wl.lookup_code visited /* transition status */
839: FROM wf_process_activities wpa,
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,

Line 841: wf_activities_vl wav2,

837: wat.arrow_geometry,
838: wl.lookup_code visited /* transition status */
839: FROM wf_process_activities wpa,
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