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_PROCESS_ACTIVITIES

Line 168: FROM wf_process_activities wpa,

164: -- check whether parent information exists
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

Line 254: FROM wf_process_activities wpa,

250: wav.icon_name,
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

Line 350: FROM wf_process_activities wpa,

346: wav.icon_name,
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

Line 437: FROM wf_process_activities wpa,

433: label,
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

Line 441: wf_process_activities wpa2

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
444: AND wpa.process_version = x_base_version
445: AND wav.item_type = wpa.process_item_type

Line 632: FROM wf_process_activities wpa,

628: wf_core.activity_result(wav.result_type,wpa.default_result))
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

Line 738: FROM wf_process_activities wpa,

734: wf_core.activity_result(wav.result_type, wpa.default_result))
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 */

Line 839: FROM wf_process_activities wpa,

835: wpa2.icon_geometry to_icon,
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,

Line 843: wf_process_activities wpa2,

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
846: WHERE wpa.process_item_type = x_base_type /* check base activity */
847: AND wpa.process_name = x_base_name