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.IEX_CUST_OVERVIEW_PVT dependencies on HZ_PARTY_SITES

Line 2789: FROM HZ_PARTY_SITES

2785: l_call_api BOOLEAN;
2786:
2787: CURSOR c_CheckPartySite(p_partyid number,p_location_id Number) IS
2788: SELECT party_site_id,party_site_number
2789: FROM HZ_PARTY_SITES
2790: where party_id = p_partyid
2791: AND location_id = p_location_id;
2792:
2793: BEGIN

Line 3124: select location_id,party_site_id into l_location_id,l_party_site_id from hz_party_sites

3120: -- begin ER 13329879
3121:
3122: /*
3123: begin
3124: select location_id,party_site_id into l_location_id,l_party_site_id from hz_party_sites
3125: where identifying_address_flag = 'Y'
3126: and party_id = p_org_party_id;
3127: exception
3128: when others then

Line 3207: SELECT hz_party_sites_s.nextval

3203:
3204: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':HZ_GENERATE_PARTY_SITE_NUMBER=' || fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'));
3205:
3206: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER'), 'Y') = 'N' THEN
3207: SELECT hz_party_sites_s.nextval
3208: INTO l_Party_Site_Create_rec.Party_Site_Number
3209: FROM dual;
3210: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || ':l_party_site_number=' || l_party_site_create_rec.party_site_number);
3211: ELSE