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 3477: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.

3473:
3474: -- Delete each record from iem_rt_interactions where expire = 'Y'
3475: delete from iem_rt_interactions where expire = 'Y';
3476:
3477: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3478: delete from iem_msg_datas where msg_key in
3479: (select msg_key from iem_rt_media_items, iem_msg_datas
3480: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3481: and iem_rt_media_items.expire = 'Y');

Line 3478: delete from iem_msg_datas where msg_key in

3474: -- Delete each record from iem_rt_interactions where expire = 'Y'
3475: delete from iem_rt_interactions where expire = 'Y';
3476:
3477: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3478: delete from iem_msg_datas where msg_key in
3479: (select msg_key from iem_rt_media_items, iem_msg_datas
3480: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3481: and iem_rt_media_items.expire = 'Y');
3482:

Line 3479: (select msg_key from iem_rt_media_items, iem_msg_datas

3475: delete from iem_rt_interactions where expire = 'Y';
3476:
3477: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3478: delete from iem_msg_datas where msg_key in
3479: (select msg_key from iem_rt_media_items, iem_msg_datas
3480: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3481: and iem_rt_media_items.expire = 'Y');
3482:
3483: -- Delete each record from iem_rt_media_items where expire = 'Y'.

Line 3480: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key

3476:
3477: -- Delete each record from iem_msg_datas where its reference at iem_rt_media_items has expire ='Y'.
3478: delete from iem_msg_datas where msg_key in
3479: (select msg_key from iem_rt_media_items, iem_msg_datas
3480: where iem_rt_media_items.rt_media_item_id = iem_msg_datas.msg_key
3481: and iem_rt_media_items.expire = 'Y');
3482:
3483: -- Delete each record from iem_rt_media_items where expire = 'Y'.
3484: delete from iem_rt_media_items where expire = 'Y';