DBA Data[Home] [Help]

APPS.IEM_MGINBOX_PUB dependencies on IEM_MSG_PARTS

Line 180: from iem_rt_media_items rtm, iem_msg_parts part

176: begin
177: select rtm.rt_media_item_id, rtm.agent_account_id, rtm.folder_name,
178: rtm.folder_uid into l_outb_rt_media_item_id,
179: l_outb_agent_account_id, l_outb_folder_name, l_outb_msg_uid
180: from iem_rt_media_items rtm, iem_msg_parts part
181: where rtm.rt_interaction_id = l_rt_interaction_id
182: and rtm.email_type = 'O' and rtm.folder_uid > 0
183: and rtm.folder_name = 'Drafts'
184: and part.ref_key = rtm.rt_media_item_id

Line 301: from iem_rt_media_items rtm, iem_msg_parts part

297: l_err_msg := null;
298: select rtm.rt_media_item_id, rtm.agent_account_id, rtm.folder_name,
299: rtm.folder_uid into l_outb_rt_media_item_id,
300: l_outb_agent_account_id, l_outb_folder_name, l_outb_msg_uid
301: from iem_rt_media_items rtm, iem_msg_parts part
302: where rtm.rt_interaction_id = l_rt_interaction_id
303: and rtm.email_type = 'O' and rtm.folder_uid > 0
304: and rtm.folder_name = 'Drafts'
305: and part.ref_key = rtm.rt_media_item_id