APPS.IEM_DP_MONITORING_PVT dependencies on IEM_DP_LOGS

Line 569: FROM IEM_DP_LOGS;

565: DELETE
566: FROM IEM_DP_PROCESS_STATUS;
567:
568: DELETE
569: FROM IEM_DP_LOGS;
570:
571:
572: IEM_PP_QUEUE_PVT.reset_data (
573: p_api_version_number =>P_Api_Version_Number,

Line 826: (select count(*) from iem_dp_logs where email_account_id = a.email_account_id) as log

822:
823: select a.email_account_id, a.email_address, a.active_flag, fl.meaning as account_status,
824: b.last_update_date as processor_status, b.last_update_date as last_run_time,
825: b.inbox_msg_count, b.processed_msg_count, b.retry_msg_count,
826: (select count(*) from iem_dp_logs where email_account_id = a.email_account_id) as log
827: from iem_mstemail_accounts a, iem_dp_acct_status b, fnd_lookups fl
828: where a.email_account_id = b.email_account_id
829: and a.active_flag=fl.lookup_code and fl.lookup_type='IEM_ACCOUNT_STATUS'
830: and a.active_flag='Y' and a.deleted_flag='N'

Line 838: (select count(*) from iem_dp_logs where email_account_id = a.email_account_id) as log

834:
835: select a.email_account_id, a.email_address, a.active_flag, fl.meaning as account_status,
836: b.last_update_date as processor_status, b.last_update_date as last_run_time,
837: b.inbox_msg_count, b.processed_msg_count, b.retry_msg_count,
838: (select count(*) from iem_dp_logs where email_account_id = a.email_account_id) as log
839: from iem_mstemail_accounts a, iem_dp_acct_status b,fnd_lookups fl
840: where a.email_account_id = b.email_account_id(+) and a.deleted_flag='N'
841: and a.active_flag<>'M'
842: and a.active_flag=fl.lookup_code and fl.lookup_type='IEM_ACCOUNT_STATUS'

Line 935: select count(*) into l_count_error from IEM_DP_LOGS where email_account_id=v_res.email_account_id;

931: l_inbox_msg_count(i) := v_res.inbox_msg_count;
932: l_process_msg_count(i) := v_res.processed_msg_count;
933: l_retry_msg_count(i) := v_res.retry_msg_count;
934:
935: select count(*) into l_count_error from IEM_DP_LOGS where email_account_id=v_res.email_account_id;
936:
937: if l_count_error > 0 then
938: l_log(i) := 'logDetailEnabled'; --'viewwebsites_enabled.gif';
939: else

Line 998: select count(*) into l_count_error from IEM_DP_LOGS where email_account_id=v_res.email_account_id;

994: l_inbox_msg_count(i) := v_res.inbox_msg_count;
995: l_process_msg_count(i) := v_res.processed_msg_count;
996: l_retry_msg_count(i) := v_res.retry_msg_count;
997:
998: select count(*) into l_count_error from IEM_DP_LOGS where email_account_id=v_res.email_account_id;
999:
1000: if l_count_error > 0 then
1001: l_log(i) := 'logDetailEnabled'; --'viewwebsites_enabled.gif';
1002: else