DBA Data[Home] [Help]

APPS.IEM_MGINBOX_PUB dependencies on IEM_MSG_PARTS

Line 196: from iem_rt_media_items rtm, iem_msg_parts part

192: begin
193: select rtm.rt_media_item_id, rtm.agent_account_id, rtm.folder_name,
194: rtm.folder_uid into l_outb_rt_media_item_id,
195: l_outb_agent_account_id, l_outb_folder_name, l_outb_msg_uid
196: from iem_rt_media_items rtm, iem_msg_parts part
197: where rtm.rt_interaction_id = l_rt_interaction_id
198: and rtm.email_type = 'O' and rtm.folder_uid > 0
199: and rtm.folder_name = 'Drafts'
200: and part.ref_key = rtm.rt_media_item_id

Line 325: from iem_rt_media_items rtm, iem_msg_parts part

321: l_err_msg := null;
322: select rtm.rt_media_item_id, rtm.agent_account_id, rtm.folder_name,
323: rtm.folder_uid into l_outb_rt_media_item_id,
324: l_outb_agent_account_id, l_outb_folder_name, l_outb_msg_uid
325: from iem_rt_media_items rtm, iem_msg_parts part
326: where rtm.rt_interaction_id = l_rt_interaction_id
327: and rtm.email_type = 'O' and rtm.folder_uid > 0
328: and rtm.folder_name = 'Drafts'
329: and part.ref_key = rtm.rt_media_item_id