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.AP_AUTOSELECT_PKG dependencies on AP_USER_EXCHANGE_RATES

Line 3739: from ap_user_exchange_rates auer,

3735:
3736: update ap_selected_invoices_all asi
3737: set (payment_exchange_rate_type, payment_exchange_rate) =
3738: (select 'User', exchange_rate
3739: from ap_user_exchange_rates auer,
3740: ap_system_parameters_all asp
3741: where asp.org_id = asi.org_id
3742: and asi.payment_currency_code = auer.payment_currency_code
3743: and asp.base_currency_code = auer.ledger_currency_code

Line 3806: insert into ap_user_exchange_rates auer

3802: set status = 'MISSING RATES'
3803: where checkrun_id = l_checkrun_id;
3804:
3805: if l_batch_exchange_rate_type = 'User' then
3806: insert into ap_user_exchange_rates auer
3807: (checkrun_id,
3808: payment_currency_code,
3809: ledger_currency_code,
3810: creation_date,

Line 4301: from ap_user_exchange_rates auer,

4297:
4298: update ap_selected_invoices_all asi
4299: set (payment_exchange_rate_type, payment_exchange_rate) =
4300: (select 'User', exchange_rate
4301: from ap_user_exchange_rates auer,
4302: ap_system_parameters_all asp
4303: where asp.org_id = asi.org_id
4304: and asi.payment_currency_code = auer.payment_currency_code
4305: and asp.base_currency_code = auer.ledger_currency_code

Line 4367: insert into ap_user_exchange_rates auer

4363: set status = 'MISSING RATES'
4364: where checkrun_id = p_checkrun_id;
4365:
4366: if l_batch_exchange_rate_type = 'User' then
4367: insert into ap_user_exchange_rates auer
4368: (checkrun_id,
4369: payment_currency_code,
4370: ledger_currency_code,
4371: creation_date, --Bug 5123855

Line 4391: from ap_user_exchange_rates auer2

4387: and asp.org_id = asi.org_id
4388: and asp.base_currency_code <> asi.payment_currency_code
4389: and asi.checkrun_id = p_checkrun_id
4390: and not exists (select 'row already in auer'
4391: from ap_user_exchange_rates auer2
4392: where auer2.checkrun_id = asi.checkrun_id
4393: and auer2.payment_currency_code = asi.payment_currency_code
4394: and auer2.ledger_currency_code = asp.base_currency_code));
4395: