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 4797: from ap_user_exchange_rates auer,

4793: 'N',exchange_rate,
4794: 'Y', 1/exchange_rate
4795: )
4796: /* Added for bug#12660492 End */
4797: from ap_user_exchange_rates auer,
4798: ap_system_parameters_all asp
4799: where asp.org_id = asi.org_id
4800: and asi.payment_currency_code = auer.payment_currency_code
4801: and asp.base_currency_code = auer.ledger_currency_code

Line 4864: insert into ap_user_exchange_rates auer

4860: set status = 'MISSING RATES'
4861: where checkrun_id = l_checkrun_id;
4862:
4863: if l_batch_exchange_rate_type = 'User' then
4864: insert into ap_user_exchange_rates auer
4865: (checkrun_id,
4866: payment_currency_code,
4867: ledger_currency_code,
4868: creation_date,

Line 5590: from ap_user_exchange_rates auer,

5586: 'N',exchange_rate,
5587: 'Y', 1/exchange_rate
5588: )
5589: /* Added for bug#12660492 End */
5590: from ap_user_exchange_rates auer,
5591: ap_system_parameters_all asp
5592: where asp.org_id = asi.org_id
5593: and asi.payment_currency_code = auer.payment_currency_code
5594: and asp.base_currency_code = auer.ledger_currency_code

Line 5653: insert into ap_user_exchange_rates auer

5649: set status = 'MISSING RATES'
5650: where checkrun_id = p_checkrun_id;
5651:
5652: if l_batch_exchange_rate_type = 'User' then
5653: insert into ap_user_exchange_rates auer
5654: (checkrun_id,
5655: payment_currency_code,
5656: ledger_currency_code,
5657: creation_date, --Bug 5123855

Line 5677: from ap_user_exchange_rates auer2

5673: and asp.org_id = asi.org_id
5674: and asp.base_currency_code <> asi.payment_currency_code
5675: and asi.checkrun_id = p_checkrun_id
5676: and not exists (select 'row already in auer'
5677: from ap_user_exchange_rates auer2
5678: where auer2.checkrun_id = asi.checkrun_id
5679: and auer2.payment_currency_code = asi.payment_currency_code
5680: and auer2.ledger_currency_code = asp.base_currency_code));
5681:

Line 5857: from ap_user_exchange_rates auer,

5853:
5854: update ap_selected_invoices_all asi
5855: set (payment_exchange_rate_type, payment_exchange_rate) =
5856: (select 'User', exchange_rate
5857: from ap_user_exchange_rates auer,
5858: ap_system_parameters_all asp
5859: where asp.org_id = asi.org_id
5860: and asi.payment_currency_code = auer.payment_currency_code
5861: and asp.base_currency_code = auer.ledger_currency_code

Line 5923: insert into ap_user_exchange_rates auer

5919: set status = 'MISSING RATES'
5920: where checkrun_id = p_checkrun_id;
5921:
5922: if l_batch_exchange_rate_type = 'User' then
5923: insert into ap_user_exchange_rates auer
5924: (checkrun_id,
5925: payment_currency_code,
5926: ledger_currency_code,
5927: creation_date, --Bug 5123855

Line 5947: from ap_user_exchange_rates auer2

5943: and asp.org_id = asi.org_id
5944: and asp.base_currency_code <> asi.payment_currency_code
5945: and asi.checkrun_id = p_checkrun_id
5946: and not exists (select 'row already in auer'
5947: from ap_user_exchange_rates auer2
5948: where auer2.checkrun_id = asi.checkrun_id
5949: and auer2.payment_currency_code = asi.payment_currency_code
5950: and auer2.ledger_currency_code = asp.base_currency_code));
5951: