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_PARTIES

Line 39: --Join with hz_parties and do not include inactivated relationships/parties

35: l_api_name VARCHAR2(255):='GetCustomerId';
36: l_ptype VARCHAR2(30);
37: BEGIN
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'

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 43: where a.owner_table_name='HZ_PARTIES'

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'
47: and b.party_id=a.owner_table_id

Line 53: where owner_table_name='HZ_PARTIES'

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)
57: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

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 98: where a.owner_table_name='HZ_PARTIES'

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'
102: AND b.status = 'A'--Fix for bug 14337195 - 7/30/2012 - Sharanya R

Line 140: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr

136: ELSIF l_rec_tbl2.count>0 THEN
137: FOR j in l_rec_tbl2.FIRST..l_rec_tbl2.LAST LOOP
138:
139: select count(hzr.party_id) into l_v1count
140: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr
141: where hzp.party_type='PARTY_RELATIONSHIP'
142: and hzr.party_id=hzp.party_id
143: and hzr.party_id=l_rec_tbl2(j).owner_table_id
144: and hzr.status in('A','I')