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 41: where owner_table_name='HZ_PARTIES'

37: BEGIN
38: x_return_status := 'S';
39: select owner_table_id into p_party_id
40: from hz_contact_points
41: where owner_table_name='HZ_PARTIES'
42: and contact_point_type='EMAIL'
43: and status='A'
44: and upper(email_address)=upper(p_email)
45: and contact_point_id not in (select contact_level_table_id from HZ_CONTACT_PREFERENCES

Line 85: from hz_contact_points a,hz_parties b

81: l_counter1 number:=1;
82: l_counter2 number:=1;
83: cursor c1 is
84: select a.owner_table_id,b.party_type,a.email_address
85: from hz_contact_points a,hz_parties b
86: where a.owner_table_name='HZ_PARTIES'
87: and upper(a.email_address)=upper(p_email)
88: and a.contact_point_type='EMAIL'
89: and a.status='A'

Line 86: where a.owner_table_name='HZ_PARTIES'

82: l_counter2 number:=1;
83: cursor c1 is
84: select a.owner_table_id,b.party_type,a.email_address
85: from hz_contact_points a,hz_parties b
86: where a.owner_table_name='HZ_PARTIES'
87: and upper(a.email_address)=upper(p_email)
88: and a.contact_point_type='EMAIL'
89: and a.status='A'
90: and b.party_id=a.owner_table_id

Line 127: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr

123: ELSIF l_rec_tbl2.count>0 THEN
124: FOR j in l_rec_tbl2.FIRST..l_rec_tbl2.LAST LOOP
125:
126: select count(hzr.party_id) into l_v1count
127: from HZ_PARTIES hzp, HZ_RELATIONSHIPS hzr
128: where hzp.party_type='PARTY_RELATIONSHIP'
129: and hzr.party_id=hzp.party_id
130: and hzr.party_id=l_rec_tbl2(j).owner_table_id
131: and hzr.status in('A','I')