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 AR_LOOKUPS

Line 4349: ar_lookups c,

4345: CURSOR l_valid_usage_csr IS
4346: SELECT 'X'
4347: FROM hz_cust_site_uses a,
4348: Hz_cust_acct_sites b,
4349: ar_lookups c,
4350: gms_awards_all ga
4351: WHERE a.cust_acct_site_id = b.cust_acct_site_id
4352: AND b.cust_account_id = decode(ga.billing_format,'LOC',ga.bill_to_customer_id,ga.funding_source_id)
4353: AND c.lookup_type = 'SITE_USE_CODE'

Line 4629: ar_lookups c,

4625: CURSOR l_valid_site_code_csr IS
4626: SELECT 'X'
4627: FROM hz_cust_site_uses a,
4628: Hz_cust_acct_sites b,
4629: ar_lookups c,
4630: gms_awards_all d
4631: WHERE a.cust_acct_site_id = b. cust_acct_site_id
4632: AND b. cust_account_id = d.funding_source_id
4633: AND d.award_id = G_report_rec.award_id