APPS.IEM_DP_MONITORING_PVT dependencies on FND_LOOKUPS

Line 827: from iem_mstemail_accounts a, iem_dp_acct_status b, fnd_lookups fl

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'
831: order by a.email_address desc;

Line 839: from iem_mstemail_accounts a, iem_dp_acct_status b,fnd_lookups fl

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'
843: order by a.email_address desc;