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.CSD_RETURNS_UTIL dependencies on HZ_CONTACT_POINTS

Line 1443: FROM hz_contact_points contacts,hz_parties parties

1439: IF l_party_type = 'PERSON'
1440: THEN
1441: SELECT contacts.contact_point_id,contacts.owner_table_id
1442: INTO l_contact_point_id,l_contact_party_id
1443: FROM hz_contact_points contacts,hz_parties parties
1444: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1445: AND contacts.email_address = p_email
1446: AND parties.party_id = p_party_id
1447: AND contacts.owner_table_id = parties.party_id

Line 1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr

1449: AND ROWNUM < 2;
1450: ELSE
1451: SELECT contacts.contact_point_id,contacts.owner_table_id
1452: INTO l_contact_point_id,l_contact_party_id
1453: FROM hz_contact_points contacts,hz_parties parties,fnd_user usr
1454: WHERE contacts.owner_table_name = 'HZ_PARTIES'
1455: AND contacts.email_address = p_email
1456: AND usr.user_id = fnd_global.user_id
1457: AND parties.party_id = usr.customer_id