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.AMW_LOAD_KEY_ACC_DATA dependencies on AMW_FIN_KEY_ACCOUNTS_VL

Line 210: from amw_fin_key_accounts_vl

206: if(kacc_rec.natural_account_acc_id is null) then
207: l_prb_counts := 0;
208: select count(distinct natural_account_value)
209: into l_prb_counts
210: from amw_fin_key_accounts_vl
211: where end_date is null
212: and account_name in (select distinct afkav.account_name
213: from amw_fin_key_accounts_vl afkav
214: where afkav.natural_account_id=kacc_rec.natural_account_id

Line 213: from amw_fin_key_accounts_vl afkav

209: into l_prb_counts
210: from amw_fin_key_accounts_vl
211: where end_date is null
212: and account_name in (select distinct afkav.account_name
213: from amw_fin_key_accounts_vl afkav
214: where afkav.natural_account_id=kacc_rec.natural_account_id
215: and afkav.end_date is null);
216: if(l_prb_counts > 1) then
217: fnd_message.set_name('AMW', 'AMW_WEBADI_VALID_ERROR');

Line 245: where exists (select * from amw_fin_key_accounts_vl

241: /*computed NaturalAccountId*/
242:
243: begin
244: select 1 into l_valid_acc from dual
245: where exists (select * from amw_fin_key_accounts_vl
246: where natural_account_id=l_natural_account_id
247: and natural_account_value=l_natural_account_value
248: and end_date is null);
249: exception