DBA Data[Home] [Help]

APPS.IEM_MIGRATION_PVT dependencies on IEM_MSG_PARTS

Line 112: from iem_rt_media_items a, iem_msg_parts part

108: from iem_post_mdts where email_account_id=l_email_account_id and agent_id=v3.resource_id ;
109: else
110: select count(a.rt_media_item_id)
111: into l_total_count
112: from iem_rt_media_items a, iem_msg_parts part
113: where a.rt_interaction_id in (select rtm.rt_interaction_id
114: from iem_rt_media_items rtm, iem_rt_interactions rti
115: where rtm.message_id in (select message_id from iem_post_mdts
116: where email_account_id = l_email_account_id and agent_id = v3.resource_id)