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.AS_SALES_LEADS_PVT dependencies on HZ_LOCATIONS

Line 3285: FROM HZ_PARTY_SITES SITE,HZ_LOCATIONS LOC

3281:
3282: -- Bug 3385646 - MKTU3R10:COUNTRY IS NOT POPULATED WHEN THE LEAD IS CREATED THROUGH HTML
3283: CURSOR c_get_country_code (X_CUSTOMER_ID NUMBER, X_ADDRESS_ID NUMBER) IS
3284: select LOC.COUNTRY
3285: FROM HZ_PARTY_SITES SITE,HZ_LOCATIONS LOC
3286: WHERE SITE.PARTY_ID = X_CUSTOMER_ID
3287: AND SITE.PARTY_SITE_ID = X_ADDRESS_ID
3288: AND SITE.STATUS IN ('A','I')
3289: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 4442: FROM HZ_PARTY_SITES SITE,HZ_LOCATIONS LOC

4438:
4439: -- Bug 3385646 - MKTU3R10:COUNTRY IS NOT POPULATED WHEN THE LEAD IS CREATED THROUGH HTML
4440: CURSOR c_get_country_code (X_CUSTOMER_ID NUMBER, X_ADDRESS_ID NUMBER) IS
4441: select LOC.COUNTRY
4442: FROM HZ_PARTY_SITES SITE,HZ_LOCATIONS LOC
4443: WHERE SITE.PARTY_ID = X_CUSTOMER_ID
4444: AND SITE.PARTY_SITE_ID = X_ADDRESS_ID
4445: AND SITE.STATUS IN ('A','I')
4446: AND SITE.LOCATION_ID = LOC.LOCATION_ID;