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_PARTY_SITES

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 3333: from hz_party_sites

3329: ---- bug 2533638 - TST1158.7:MSTR:ORG. ADDRESS IS NOT PICKED WHEN CREATING LEAD FROM PARTNER DETAIL
3330:
3331: CURSOR primary_address ( p_customer_id NUMBER) IS
3332: select party_site_id
3333: from hz_party_sites
3334: where party_id = p_customer_id
3335: and IDENTIFYING_ADDRESS_FLAG = 'Y';
3336: ----
3337:

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;