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_EMAIL_PROC_PVT dependencies on HZ_CONTACT_PREFERENCES

Line 1762: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

1758: where owner_table_name='HZ_PARTIES'
1759: and owner_table_id=l_customer_id
1760: and contact_point_type='EMAIL'
1761: and upper(email_address)=upper(l_sender)
1762: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
1763: where contact_level_table='HZ_CONTACT_POINTS' and status='A');
1764:
1765:
1766: if g_statement_log then

Line 7372: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

7368: from hz_contact_points a, hz_parties b
7369: where a.owner_table_name='HZ_PARTIES'
7370: and a.contact_point_type='PHONE'
7371: and a.status='A'
7372: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
7373: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
7374: and a.owner_table_id = b.party_id
7375: and b.party_type in ('PERSON', 'ORGANIZATION')
7376: and reverse(a.transposed_phone_number)=REGEXP_REPLACE(p_customer_phone,'([[:punct:]|[:space:]]*)');

Line 7411: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

7407: from hz_contact_points a, hz_parties b
7408: where a.owner_table_name='HZ_PARTIES'
7409: and a.contact_point_type = 'EMAIL'
7410: and a.status='A'
7411: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
7412: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
7413: and a.owner_table_id = b.party_id
7414: and b.party_type in ('PERSON', 'ORGANIZATION')
7415: and upper(a.email_address) =upper(p_customer_email);

Line 7525: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

7521: and a.status='A'
7522: and a.primary_flag = 'Y'
7523: and a.owner_table_id = b.party_id
7524: and directional_flag = 'B'
7525: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
7526: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
7527: and b.object_id = c.party_id
7528: and c.party_number = p_contact_number;
7529: */

Line 7634: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

7630: and a.status='A'
7631: and a.primary_flag = 'Y'
7632: and a.owner_table_id = b.party_id
7633: and directional_flag = 'B'
7634: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
7635: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
7636: and b.object_id = c.party_id
7637: and reverse(a.transposed_phone_number)=REGEXP_REPLACE(p_contact_phone,'([[:punct:]|[:space:]]*)');
7638: EXCEPTION

Line 7675: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

7671: and a.status='A'
7672: and a.primary_flag = 'Y'
7673: and a.owner_table_id = b.party_id
7674: and directional_flag = 'B'
7675: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
7676: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
7677: and b.object_id = c.party_id
7678: and upper(a.email_address) =upper(p_contact_email);
7679:

Line 8361: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8357: where a.owner_table_name='HZ_PARTIES'
8358: and a.contact_point_type='PHONE'
8359: and a.status='A'
8360: and a.owner_table_id = b.party_id
8361: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8362: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8363: and b.party_id = c.party_id
8364: and b.object_id in (select party_id from hz_parties where party_number = p_contact_number)
8365: --and c.party_number =p_contact_number

Line 8380: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8376: where a.owner_table_name='HZ_PARTIES'
8377: and a.contact_point_type='PHONE'
8378: and a.status='A'
8379: and a.owner_table_id = b.party_id
8380: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8381: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8382: and b.party_id = c.party_id
8383: --and b.object_id in (select party_id from hz_parties where party_number = p_contact_number)
8384: and c.party_number =p_contact_number

Line 8423: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8419: where a.owner_table_name='HZ_PARTIES'
8420: and a.contact_point_type = 'EMAIL'
8421: and a.status='A'
8422: and a.owner_table_id = b.party_id
8423: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8424: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8425: and b.party_id = c.party_id
8426: and b.object_id in (select party_id from hz_parties where party_number = p_contact_number)
8427: --and c.party_number =p_contact_number

Line 8442: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8438: where a.owner_table_name='HZ_PARTIES'
8439: and a.contact_point_type = 'EMAIL'
8440: and a.status='A'
8441: and a.owner_table_id = b.party_id
8442: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8443: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8444: and b.party_id = c.party_id
8445: --and b.object_id in (select party_id from hz_parties where party_number = p_contact_number)
8446: and c.party_number =p_contact_number

Line 8495: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8491: where a.owner_table_name='HZ_PARTIES'
8492: and a.status='A'
8493: and a.primary_flag = 'Y'
8494: and a.owner_table_id = b.party_id
8495: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8496: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8497: and b.party_id = c.party_id
8498: and b.object_id in (select party_id from hz_parties where party_number = p_contact_number)
8499: -- and c.party_number =p_contact_number

Line 8513: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8509: where a.owner_table_name='HZ_PARTIES'
8510: and a.status='A'
8511: and a.primary_flag = 'Y'
8512: and a.owner_table_id = b.party_id
8513: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8514: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8515: and b.party_id = c.party_id
8516: --and b.object_id in (select party_id from hz_parties where party_number = p_contact_number)
8517: and c.party_number =p_contact_number

Line 8582: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8578: where a.owner_table_name='HZ_PARTIES'
8579: and a.contact_point_type='PHONE'
8580: and a.status='A'
8581: and a.owner_table_id = b.party_id
8582: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8583: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8584: and b.party_id = c.party_id
8585: and b.object_id in (select party_id from hz_parties where upper(party_name) =upper(p_contact_name))
8586: --and upper(c.party_name) =upper(p_contact_name)

Line 8621: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8617: where a.owner_table_name='HZ_PARTIES'
8618: and a.contact_point_type = 'EMAIL'
8619: and a.status='A'
8620: and a.owner_table_id = b.party_id
8621: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8622: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8623: and b.party_id = c.party_id
8624: -- and upper(c.party_name) =upper(p_contact_name)
8625: and b.object_id in (select party_id from hz_parties where upper(party_name) =upper(p_contact_name))

Line 8666: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8662: where a.owner_table_name='HZ_PARTIES'
8663: and a.status='A'
8664: and a.primary_flag = 'Y'
8665: and a.owner_table_id = b.party_id
8666: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8667: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8668: and b.party_id = c.party_id
8669: and b.object_id in (select party_id from hz_parties where upper(party_name) =upper(p_contact_name))
8670: --and upper(c.party_name) =upper(p_contact_name)

Line 8725: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8721: where a.owner_table_name='HZ_PARTIES'
8722: and a.contact_point_type='PHONE'
8723: and a.status='A'
8724: and a.owner_table_id = b.party_id
8725: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8726: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8727: and b.party_id = c.party_id
8728: and reverse(a.transposed_phone_number)=REGEXP_REPLACE(p_contact_phone,'([[:punct:]|[:space:]]*)')
8729: and b.subject_id = g_customer_id;

Line 8771: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

8767: where a.owner_table_name='HZ_PARTIES'
8768: and a.contact_point_type='EMAIL'
8769: and a.status='A'
8770: and a.owner_table_id = b.party_id
8771: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
8772: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
8773: and b.party_id = c.party_id
8774: and upper(a.email_address)=upper(p_contact_email)
8775: and b.subject_id = g_customer_id;