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_TERR_PUB dependencies on HZ_CUSTOMER_PROFILES

Line 426: UPDATE HZ_CUSTOMER_PROFILES ACC

422: logmessage('Start updating the Customer Profiles Table' );
423:
424: FOR i IN x_winners_rec.terr_id.FIRST .. x_winners_rec.terr_id.LAST LOOP
425: BEGIN
426: UPDATE HZ_CUSTOMER_PROFILES ACC
427: SET object_version_number = nvl(object_version_number,0) + 1,
428: ACC.LAST_UPDATE_DATE = SYSDATE,
429: ACC.LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
430: ACC.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id ,

Line 536: from hz_customer_profiles where CUST_ACCOUNT_PROFILE_id = l_profile_id;

532: IF NOT isRefreshProgramsRunning THEN
533:
534: SELECT cust_account_id, site_use_id, party_id,collector_id
535: into l_custaccount_id, l_siteuse_id, l_party_id ,l_collector_id
536: from hz_customer_profiles where CUST_ACCOUNT_PROFILE_id = l_profile_id;
537:
538:
539: x_return_status := SYNC_TCA_SUMMARY
540: ( p_party_id => l_party_id,