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.IEM_CLIENTLAUNCH_PUB dependencies on IEM_ROUTE_CLASSIFICATIONS

Line 179: l_classification_id iem_route_classifications.route_classification_id%type;

175: l_acct_id varchar2(30);
176: l_resource_id varchar2(30);
177: l_msg_id varchar2(30);
178:
179: l_classification_id iem_route_classifications.route_classification_id%type;
180: l_class_name iem_route_classifications.name%type;
181:
182: l_rt_media_item_id IEM_RT_MEDIA_ITEMS.rt_media_item_id%type;
183:

Line 180: l_class_name iem_route_classifications.name%type;

176: l_resource_id varchar2(30);
177: l_msg_id varchar2(30);
178:
179: l_classification_id iem_route_classifications.route_classification_id%type;
180: l_class_name iem_route_classifications.name%type;
181:
182: l_rt_media_item_id IEM_RT_MEDIA_ITEMS.rt_media_item_id%type;
183:
184: l_return_status VARCHAR2(200) := FND_API.G_RET_STS_SUCCESS;

Line 216: --from iem_route_classifications a, iem_post_mdts b

212: end if;
213:
214: select route_classification_id, name
215: into l_classification_id, l_class_name
216: --from iem_route_classifications a, iem_post_mdts b
217: from iem_route_classifications a, iem_rt_proc_emails b
218: where a.route_classification_id = b.rt_classification_id
219: and b.message_id = l_msg_id;
220:

Line 217: from iem_route_classifications a, iem_rt_proc_emails b

213:
214: select route_classification_id, name
215: into l_classification_id, l_class_name
216: --from iem_route_classifications a, iem_post_mdts b
217: from iem_route_classifications a, iem_rt_proc_emails b
218: where a.route_classification_id = b.rt_classification_id
219: and b.message_id = l_msg_id;
220:
221: select rt_media_item_id