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_PP_QUEUE_PVT dependencies on IEM_RT_PP_QUEUE_DTLS

Line 132: INSERT INTO IEM_RT_PP_QUEUE_DTLS

128: if (p_attach_name_tbl.FIRST is not null) then
129:
130: FOR i in p_attach_name_tbl.FIRST..p_attach_name_tbl.LAST LOOP
131:
132: INSERT INTO IEM_RT_PP_QUEUE_DTLS
133: (
134: EMAIL_ID,
135: ATTACHMENT_NAME,
136: ATTACHMENT_SIZE,

Line 387: delete IEM_RT_PP_QUEUE_DTLS where email_id in

383:
384: -- Changed the Query to delete all records with 'Q' status as well( to clean up iem_rt_pp_queues table)
385: -- for the bug 7494127, since those messages with status 'Q' are not present in Inbox.
386: --Delete the records with 'X', which would allow the DP to enqueue the message again.
387: delete IEM_RT_PP_QUEUE_DTLS where email_id in
388: ( select email_id from iem_rt_pp_queues where flag in ('S','Q','X')
389: and email_account_id=p_acct_id );
390: delete IEM_RT_PP_QUEUES where flag in ('S','Q','X') and email_account_id=p_acct_id ;
391: