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.AZW_FLOW dependencies on WF_ACTIVITY_ATTRIBUTES_VL

Line 60: wf_activity_attributes_vl waav,

56: waav2.text_default ctxt_type,
57: waav3.text_default parent_id,
58: waav4.text_default process_type
59: FROM wf_activities_vl wav,
60: wf_activity_attributes_vl waav,
61: wf_activity_attributes_vl waav1,
62: wf_activity_attributes_vl waav2,
63: wf_activity_attributes_vl waav3,
64: wf_activity_attributes_vl waav4

Line 61: wf_activity_attributes_vl waav1,

57: waav3.text_default parent_id,
58: waav4.text_default process_type
59: FROM wf_activities_vl wav,
60: wf_activity_attributes_vl waav,
61: wf_activity_attributes_vl waav1,
62: wf_activity_attributes_vl waav2,
63: wf_activity_attributes_vl waav3,
64: wf_activity_attributes_vl waav4
65: WHERE wav.item_type like 'AZW%'

Line 62: wf_activity_attributes_vl waav2,

58: waav4.text_default process_type
59: FROM wf_activities_vl wav,
60: wf_activity_attributes_vl waav,
61: wf_activity_attributes_vl waav1,
62: wf_activity_attributes_vl waav2,
63: wf_activity_attributes_vl waav3,
64: wf_activity_attributes_vl waav4
65: WHERE wav.item_type like 'AZW%'
66: AND wav.type = 'PROCESS'

Line 63: wf_activity_attributes_vl waav3,

59: FROM wf_activities_vl wav,
60: wf_activity_attributes_vl waav,
61: wf_activity_attributes_vl waav1,
62: wf_activity_attributes_vl waav2,
63: wf_activity_attributes_vl waav3,
64: wf_activity_attributes_vl waav4
65: WHERE wav.item_type like 'AZW%'
66: AND wav.type = 'PROCESS'
67: AND wav.runnable_flag = 'Y'

Line 64: wf_activity_attributes_vl waav4

60: wf_activity_attributes_vl waav,
61: wf_activity_attributes_vl waav1,
62: wf_activity_attributes_vl waav2,
63: wf_activity_attributes_vl waav3,
64: wf_activity_attributes_vl waav4
65: WHERE wav.item_type like 'AZW%'
66: AND wav.type = 'PROCESS'
67: AND wav.runnable_flag = 'Y'
68: AND wav.end_date is null

Line 74: FROM wf_activity_attributes_vl

70: AND waav.activity_name = wav.name
71: AND waav.name = 'AZW_IA_WFPROD'
72: AND waav.activity_version =
73: (SELECT MAX(activity_version)
74: FROM wf_activity_attributes_vl
75: WHERE activity_item_type = wav.item_type
76: AND activity_name = wav.name
77: AND name = 'AZW_IA_WFPROD')
78: AND waav1.activity_item_type = wav.item_type

Line 84: FROM wf_activity_attributes_vl

80: AND waav1.name = 'AZW_IA_VAWM'
81: AND waav1.text_default IS NOT NULL
82: AND waav1.activity_version =
83: (SELECT MAX(activity_version)
84: FROM wf_activity_attributes_vl
85: WHERE activity_item_type = wav.item_type
86: AND activity_name = wav.name
87: AND name = 'AZW_IA_VAWM')
88: AND waav2.activity_item_type = wav.item_type

Line 98: FROM wf_activity_attributes_vl

94: where lookup_code = waav2.text_default
95: AND lookup_type = 'AZ_CONTEXT_TYPE')
96: AND waav2.activity_version =
97: (SELECT MAX(activity_version)
98: FROM wf_activity_attributes_vl
99: WHERE activity_item_type = wav.item_type
100: AND activity_name = wav.name
101: AND name = 'AZW_IA_CTXTYP')
102: AND waav3.activity_item_type = wav.item_type

Line 112: FROM wf_activity_attributes_vl

108: WHERE ag.group_id = waav3.text_default
109: AND ag.process_type = fnd_profile.value('AZ_CURRENT_MODE'))
110: AND waav3.activity_version =
111: (SELECT MAX(activity_version)
112: FROM wf_activity_attributes_vl
113: WHERE activity_item_type = wav.item_type
114: AND activity_name = wav.name
115: AND name = 'AZW_IA_PARENTID')
116: -- Start : added by Swarup

Line 127: FROM wf_activity_attributes_vl

123: where lookup_code = waav4.text_default
124: AND lookup_type = 'AZ_PROCESS_TYPE')
125: AND waav4.activity_version =
126: (SELECT MAX(activity_version)
127: FROM wf_activity_attributes_vl
128: WHERE activity_item_type = wav.item_type
129: AND activity_name = wav.name
130: AND name = 'AZW_IA_FLOWTYPE')
131: -- End : added by Swarup

Line 141: v_application_ids wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;

137:
138: v_application_id NUMBER DEFAULT 0;
139: v_item_type wf_activities_vl.item_type%TYPE DEFAULT NULL;
140: v_process_name wf_activities_vl.name%TYPE DEFAULT NULL;
141: v_application_ids wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
142: v_display_order wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
143: v_ctxt_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
144: v_parent_id wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
145: v_process_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;

Line 142: v_display_order wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;

138: v_application_id NUMBER DEFAULT 0;
139: v_item_type wf_activities_vl.item_type%TYPE DEFAULT NULL;
140: v_process_name wf_activities_vl.name%TYPE DEFAULT NULL;
141: v_application_ids wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
142: v_display_order wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
143: v_ctxt_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
144: v_parent_id wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
145: v_process_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
146: v_installed_prod_id fnd_product_installations.application_id%TYPE DEFAULT NULL;

Line 143: v_ctxt_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;

139: v_item_type wf_activities_vl.item_type%TYPE DEFAULT NULL;
140: v_process_name wf_activities_vl.name%TYPE DEFAULT NULL;
141: v_application_ids wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
142: v_display_order wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
143: v_ctxt_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
144: v_parent_id wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
145: v_process_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
146: v_installed_prod_id fnd_product_installations.application_id%TYPE DEFAULT NULL;
147: id_count INTEGER DEFAULT 0;

Line 144: v_parent_id wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;

140: v_process_name wf_activities_vl.name%TYPE DEFAULT NULL;
141: v_application_ids wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
142: v_display_order wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
143: v_ctxt_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
144: v_parent_id wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
145: v_process_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
146: v_installed_prod_id fnd_product_installations.application_id%TYPE DEFAULT NULL;
147: id_count INTEGER DEFAULT 0;
148: v_display_number NUMBER(5) DEFAULT 0;

Line 145: v_process_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;

141: v_application_ids wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
142: v_display_order wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
143: v_ctxt_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
144: v_parent_id wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
145: v_process_type wf_activity_attributes_vl.text_default%TYPE DEFAULT NULL;
146: v_installed_prod_id fnd_product_installations.application_id%TYPE DEFAULT NULL;
147: id_count INTEGER DEFAULT 0;
148: v_display_number NUMBER(5) DEFAULT 0;
149: