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_CLIENT_PUB dependencies on IEM_MSG_DATAS

Line 3415: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.

3411:
3412: -- Delete each record from iem_rt_interactions where expire = 'Y'
3413: delete from iem_rt_interactions where expire = 'Y';
3414:
3415: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3416: delete from iem_msg_datas where msg_key in
3417: (select msg_key from iem_rt_media_items, iem_msg_datas
3418: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3419: and iem_rt_media_items.expire = 'Y');

Line 3416: delete from iem_msg_datas where msg_key in

3412: -- Delete each record from iem_rt_interactions where expire = 'Y'
3413: delete from iem_rt_interactions where expire = 'Y';
3414:
3415: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3416: delete from iem_msg_datas where msg_key in
3417: (select msg_key from iem_rt_media_items, iem_msg_datas
3418: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3419: and iem_rt_media_items.expire = 'Y');
3420:

Line 3417: (select msg_key from iem_rt_media_items, iem_msg_datas

3413: delete from iem_rt_interactions where expire = 'Y';
3414:
3415: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3416: delete from iem_msg_datas where msg_key in
3417: (select msg_key from iem_rt_media_items, iem_msg_datas
3418: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3419: and iem_rt_media_items.expire = 'Y');
3420:
3421: -- Delete each record from iem_rt_media_items where expire = 'Y'.

Line 3418: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key

3414:
3415: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3416: delete from iem_msg_datas where msg_key in
3417: (select msg_key from iem_rt_media_items, iem_msg_datas
3418: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3419: and iem_rt_media_items.expire = 'Y');
3420:
3421: -- Delete each record from iem_rt_media_items where expire = 'Y'.
3422: delete from iem_rt_media_items where expire = 'Y';