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.GMS_AWARD_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 241: Hz_cust_acct_sites_all acct_site,

237: CURSOR C_verify_con_exists(p_customer_id number) IS
238: SELECT 'X'
239: FROM Hz_party_sites party_site,
240: Hz_locations loc,
241: Hz_cust_acct_sites_all acct_site,
242: hz_cust_site_uses su
243: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
244: AND acct_site.party_site_id = party_site.party_site_id
245: AND loc.location_id = party_site.location_id

Line 303: FROM hz_cust_acct_sites_all acct_site,

299: --TCA Enhancement : Replaced ra_address_all, ra_site_uses
300: CURSOR C_cust_info is
301: SELECT acct_site.cust_acct_site_id,
302: su.Contact_Id
303: FROM hz_cust_acct_sites_all acct_site,
304: hz_party_sites party_site,
305: hz_locations loc,
306: Hz_cust_site_uses su
307: Where acct_site.cust_acct_site_id = su.cust_acct_site_id