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_GETCUST_PVT dependencies on HZ_CONTACT_POINTS

Line 42: from hz_contact_points a,hz_parties b

38: x_return_status := 'S';
39: --Join with hz_parties and do not include inactivated relationships/parties
40: --Fix for bug 14337195 - 7/30/2012 - Sharanya R
41: select a.owner_table_id into p_party_id
42: from hz_contact_points a,hz_parties b
43: where a.owner_table_name='HZ_PARTIES'
44: and a.contact_point_type='EMAIL'
45: and a.status='A'
46: and b.status = 'A'

Line 50: where contact_level_table='HZ_CONTACT_POINTS' and status='A');

46: and b.status = 'A'
47: and b.party_id=a.owner_table_id
48: and upper(a.email_address)=upper(p_email)
49: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
50: where contact_level_table='HZ_CONTACT_POINTS' and status='A');
51: /*select owner_table_id into p_party_id
52: from hz_contact_points
53: where owner_table_name='HZ_PARTIES'
54: and contact_point_type='EMAIL'

Line 52: from hz_contact_points

48: and upper(a.email_address)=upper(p_email)
49: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
50: where contact_level_table='HZ_CONTACT_POINTS' and status='A');
51: /*select owner_table_id into p_party_id
52: from hz_contact_points
53: where owner_table_name='HZ_PARTIES'
54: and contact_point_type='EMAIL'
55: and status='A'
56: and upper(email_address)=upper(p_email)

Line 58: where contact_level_table='HZ_CONTACT_POINTS' and status='A');*/

54: and contact_point_type='EMAIL'
55: and status='A'
56: and upper(email_address)=upper(p_email)
57: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
58: where contact_level_table='HZ_CONTACT_POINTS' and status='A');*/
59: EXCEPTION
60: WHEN NO_DATA_FOUND THEN
61: p_party_id:=-1;
62: when too_many_rows then

Line 97: from hz_contact_points a,hz_parties b

93: l_counter1 number:=1;
94: l_counter2 number:=1;
95: cursor c1 is
96: select a.owner_table_id,b.party_type,a.email_address
97: from hz_contact_points a,hz_parties b
98: where a.owner_table_name='HZ_PARTIES'
99: and upper(a.email_address)=upper(p_email)
100: and a.contact_point_type='EMAIL'
101: and a.status='A'

Line 105: where contact_level_table='HZ_CONTACT_POINTS' and status='A')

101: and a.status='A'
102: AND b.status = 'A'--Fix for bug 14337195 - 7/30/2012 - Sharanya R
103: and b.party_id=a.owner_table_id
104: and a.contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES
105: where contact_level_table='HZ_CONTACT_POINTS' and status='A')
106: order by 2,1 DESC;
107: BEGIN
108: -- Standard call to check for call compatibility.
109: IF NOT FND_API.Compatible_API_Call (l_api_version_number,