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_SITE_USES

Line 242: hz_cust_site_uses su

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
246: AND acct_site.cust_account_id = p_customer_id

Line 306: Hz_cust_site_uses su

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
308: And acct_site.cust_account_id = l_Customer_Id
309: And acct_site.party_site_id = party_site.party_site_id
310: And loc.location_id = party_site.location_id

Line 4345: FROM hz_cust_site_uses a,

4341:
4342:
4343: CURSOR l_valid_usage_csr IS
4344: SELECT 'X'
4345: FROM hz_cust_site_uses a,
4346: Hz_cust_acct_sites b,
4347: ar_lookups c,
4348: gms_awards_all ga
4349: WHERE a.cust_acct_site_id = b.cust_acct_site_id

Line 4625: FROM hz_cust_site_uses a,

4621: AND lookup_code = G_report_rec.frequency;
4622:
4623: CURSOR l_valid_site_code_csr IS
4624: SELECT 'X'
4625: FROM hz_cust_site_uses a,
4626: Hz_cust_acct_sites b,
4627: ar_lookups c,
4628: gms_awards_all d
4629: WHERE a.cust_acct_site_id = b. cust_acct_site_id