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.JTF_BRM_UTILITY_PVT dependencies on WF_LOOKUPS

Line 21: FROM wf_lookups

17: CURSOR c_lookup
18: (b_lookup_type IN VARCHAR2
19: ,b_lookup_code IN VARCHAR2
20: )IS SELECT meaning
21: FROM wf_lookups
22: WHERE lookup_type = b_lookup_type
23: AND lookup_code = b_lookup_code;
24:
25: l_meaning VARCHAR2(80);

Line 200: , wf_lookups wlu

196: , val.text_value attribute_value
197: , wlu.meaning attribute_meaning
198: FROM jtf_brm_wf_attr_values_v val
199: , jtf_brm_processes pro
200: , wf_lookups wlu
201: WHERE pro.rule_id = b_rule_id
202: AND pro.workflow_item_type = b_wf_item_type
203: AND pro.process_id = val.wf_process_id
204: AND pro.workflow_item_type = val.wf_item_type

Line 219: , wf_lookups wlu

215: , b_wf_attribute_name IN VARCHAR2
216: )IS SELECT wf1.text_default attribute_value
217: , wlu.meaning attribute_meaning
218: FROM wf_activity_attributes_vl wf1
219: , wf_lookups wlu
220: WHERE wf1.activity_version = (SELECT max(wf2.activity_version)
221: FROM wf_activity_attributes_vl wf2
222: WHERE wf2.activity_item_type = wf1.activity_item_type
223: AND wf2.activity_name = wf1.activity_name