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_LEAD_ENGINE_PVT dependencies on HZ_PARTY_SITES

Line 669: AND phon.owner_table_name = 'HZ_PARTY_SITES'

665: /*
666: SELECT phon.phone_area_code
667: FROM hz_contact_points phon
668: WHERE phon.owner_table_id = c_address_id
669: AND phon.owner_table_name = 'HZ_PARTY_SITES'
670: AND phon.contact_point_type = 'PHONE'
671: AND phon.status in ('A','I')
672: UNION ALL
673: SELECT phon.phone_area_code

Line 684: FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC

680:
681: CURSOR C_Get_Location(C_Address_Id NUMBER) IS
682: SELECT LOC.COUNTRY, LOC.STATE, LOC.PROVINCE, LOC.COUNTY,
683: LOC.CITY, LOC.POSTAL_CODE
684: FROM HZ_PARTY_SITES SITE, HZ_LOCATIONS LOC
685: WHERE SITE.PARTY_SITE_ID = c_address_id
686: AND SITE.LOCATION_ID = LOC.LOCATION_ID;
687:
688: