DBA Data[Home] [Help]

APPS.IEM_MIGRATION_PVT dependencies on IEM_MSG_PARTS

Line 125: from iem_rt_media_items a, iem_msg_parts part

121: else
122: -- this how you get the count for the draft folder of the agent
123: select count(a.rt_media_item_id)
124: into l_total_count
125: from iem_rt_media_items a, iem_msg_parts part
126: where a.rt_interaction_id in (select rtm.rt_interaction_id
127: from iem_rt_media_items rtm, iem_rt_interactions rti
128: where rtm.message_id in (select message_id from iem_post_mdts
129: where email_account_id = l_email_account_id and agent_id = v3.resource_id)