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_SYSTEM_PARAMETERS_ALL

Line 283: ap_system_parameters_all asp

279: FROM /* ap_interest_periods, Bug#12835170 */
280: ap_invoices AI, --Bug6040657. Changed from ap_invoices_all to ap_invoices
281: ap_selected_invoices_all ASI,
282: po_vendors pov,
283: ap_system_parameters_all asp
284: WHERE ASI.checkrun_id = P_checkrun_id
285: AND ASP.auto_calculate_interest_flag = 'Y'
286: AND ASP.org_id = asi.org_id
287: AND TRUNC(P_check_date) > TRUNC(due_date)

Line 2967: ' ap_system_parameters_all asp, '||

2963: ' FROM ap_supplier_sites_all sites, '||
2964: ' ap_suppliers suppliers, '||
2965: ' ap_invoices ai, '|| /* inv, '||Commented for bug#9182499 --Bug6040657. Changed from ap_invoices_all to ap_invoices */
2966: ' ap_payment_schedules_all ps, '||
2967: ' ap_system_parameters_all asp, '||
2968: ' hz_parties hzp, '||
2969: ' hz_party_sites hzps, '||-- Bug 5620285
2970: ' hz_locations hzl '||-- Bug 5620285
2971: ' WHERE ps.checkrun_id is null '||-- Bug 5705276. Regression

Line 3790: ' ap_system_parameters_all asp, '||

3786: ' FROM ap_supplier_sites_all sites, '||
3787: ' ap_suppliers suppliers, '||
3788: ' ap_invoices ai, '|| /* inv, '|| Commented for bug#9182499 GSCC Error File.Sql.6 --Bug6040657. Changed from ap_invoices_all to ap_invoices */
3789: ' ap_payment_schedules_all ps, '||
3790: ' ap_system_parameters_all asp, '||
3791: ' hz_parties hzp, '||
3792: ' hz_party_sites hzps, '|| -- Bug 5620285
3793: ' hz_locations hzl '|| -- Bug 5620285
3794: ' WHERE ps.checkrun_id is null '|| -- Bug 5705276. Regression

Line 4500: Ap_System_Parameters_All ASP

4496: dont_pay_reason_code = 'PRE DATE NOT ALLOWED'
4497: WHERE checkrun_id = l_checkrun_id
4498: AND Exists (SELECT /*+NO_UNNEST INDEX(ASI2 AP_SELECTED_INVOICES_N1)*/ NULL
4499: FROM Ap_Selected_Invoices_All ASI2,
4500: Ap_System_Parameters_All ASP
4501: WHERE ASI.invoice_id = ASI2.invoice_id
4502: AND ASI.payment_num = ASI2.payment_num
4503: AND ASI2.checkrun_id = l_checkrun_id
4504: AND ASI2.org_id = ASP.org_id

Line 4798: ap_system_parameters_all asp

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
4802: and asp.base_currency_code <> asi.payment_currency_code

Line 4808: ap_system_parameters_all asp2

4804: where checkrun_id = l_checkrun_id
4805: and (invoice_id, payment_num) in
4806: (select invoice_id, payment_num
4807: from ap_selected_invoices_all asi2,
4808: ap_system_parameters_all asp2
4809: where asp2.org_id = asi2.org_id
4810: and asp2.base_currency_code <> asi2.payment_currency_code
4811: and asi2.checkrun_id = l_checkrun_id);
4812:

Line 4825: from ap_system_parameters_all asp

4821: asp.base_currency_code,
4822: l_batch_exchange_rate_type,
4823: l_check_date,
4824: 'AUTOSELECT')
4825: from ap_system_parameters_all asp
4826: where asp.org_id = asi.org_id
4827: and asp.base_currency_code <> asi.payment_currency_code)
4828: where checkrun_id = l_checkrun_id
4829: and (invoice_id, payment_num) in

Line 4832: ap_system_parameters_all asp2

4828: where checkrun_id = l_checkrun_id
4829: and (invoice_id, payment_num) in
4830: (select invoice_id, payment_num
4831: from ap_selected_invoices_all asi2,
4832: ap_system_parameters_all asp2
4833: where asp2.org_id = asi2.org_id
4834: and asp2.base_currency_code <> asi2.payment_currency_code
4835: and asi2.checkrun_id = l_checkrun_id); --Bug 5123855
4836:

Line 4844: ap_system_parameters_all asp

4840:
4841: select count(*)
4842: into l_missing_rates_count
4843: from ap_selected_invoices_all asi,
4844: ap_system_parameters_all asp
4845: where asi.org_id = asp.org_id
4846: and asi.checkrun_id = l_checkrun_id
4847: and asi.payment_currency_code <> asp.base_currency_code
4848: and asi.payment_exchange_rate is null

Line 4882: ap_system_parameters_all asp

4878: SYSDATE,
4879: FND_GLOBAL.user_id,
4880: FND_GLOBAL.login_id
4881: from ap_selected_invoices_all asi,
4882: ap_system_parameters_all asp
4883: where asi.payment_exchange_rate is null
4884: and asp.org_id = asi.org_id
4885: and asp.base_currency_code <> asi.payment_currency_code
4886: and asi.checkrun_id = l_checkrun_id

Line 5370: ap_system_parameters_all asp

5366: , payment_num
5367: , checkrun_id --bug 8888311
5368: , withholding_amount --bug 8888311
5369: FROM ap_SELECTed_invoices_all ASI,
5370: ap_system_parameters_all asp
5371: WHERE checkrun_name = l_checkrun_name
5372: AND original_invoice_id IS NULL
5373: AND asp.org_id = asi.org_id
5374: and checkrun_id = p_checkrun_id

Line 5591: ap_system_parameters_all asp

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
5595: and asp.base_currency_code <> asi.payment_currency_code

Line 5601: ap_system_parameters_all asp2

5597: where checkrun_id = p_checkrun_id
5598: and (invoice_id, payment_num) in
5599: (select invoice_id, payment_num
5600: from ap_selected_invoices_all asi2,
5601: ap_system_parameters_all asp2
5602: where asp2.org_id = asi2.org_id
5603: and asp2.base_currency_code <> asi2.payment_currency_code
5604: and asi2.checkrun_id = p_checkrun_id);
5605:

Line 5618: from ap_system_parameters_all asp

5614: asp.base_currency_code,
5615: l_batch_exchange_rate_type,
5616: l_check_date,
5617: 'AUTOSELECT')
5618: from ap_system_parameters_all asp
5619: where asp.org_id = asi.org_id
5620: and asp.base_currency_code <> asi.payment_currency_code)
5621: where checkrun_id = p_checkrun_id
5622: and (invoice_id, payment_num) in

Line 5625: ap_system_parameters_all asp2

5621: where checkrun_id = p_checkrun_id
5622: and (invoice_id, payment_num) in
5623: (select invoice_id, payment_num
5624: from ap_selected_invoices_all asi2,
5625: ap_system_parameters_all asp2
5626: where asp2.org_id = asi2.org_id
5627: and asp2.base_currency_code <> asi2.payment_currency_code
5628: and asi2.checkrun_id = p_checkrun_id);
5629:

Line 5635: ap_system_parameters_all asp

5631:
5632: select count(*)
5633: into l_missing_rates_count
5634: from ap_selected_invoices_all asi,
5635: ap_system_parameters_all asp
5636: where asi.org_id = asp.org_id
5637: and asi.checkrun_id = p_checkrun_id
5638: and asi.payment_currency_code <> asp.base_currency_code
5639: and asi.payment_exchange_rate is null

Line 5671: ap_system_parameters_all asp

5667: SYSDATE,
5668: FND_GLOBAL.user_id,
5669: FND_GLOBAL.login_id
5670: from ap_selected_invoices_all asi,
5671: ap_system_parameters_all asp
5672: where asi.payment_exchange_rate is null
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

Line 5858: ap_system_parameters_all asp

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
5862: and asp.base_currency_code <> asi.payment_currency_code

Line 5868: ap_system_parameters_all asp2

5864: where checkrun_id = p_checkrun_id
5865: and (invoice_id, payment_num) in
5866: (select invoice_id, payment_num
5867: from ap_selected_invoices_all asi2,
5868: ap_system_parameters_all asp2
5869: where asp2.org_id = asi2.org_id
5870: and asp2.base_currency_code <> asi2.payment_currency_code
5871: and asi2.checkrun_id = p_checkrun_id);
5872:

Line 5885: from ap_system_parameters_all asp

5881: asp.base_currency_code,
5882: l_batch_exchange_rate_type,
5883: l_check_date,
5884: 'AUTOSELECT')
5885: from ap_system_parameters_all asp
5886: where asp.org_id = asi.org_id
5887: and asp.base_currency_code <> asi.payment_currency_code)
5888: where checkrun_id = p_checkrun_id
5889: and (invoice_id, payment_num) in

Line 5892: ap_system_parameters_all asp2

5888: where checkrun_id = p_checkrun_id
5889: and (invoice_id, payment_num) in
5890: (select invoice_id, payment_num
5891: from ap_selected_invoices_all asi2,
5892: ap_system_parameters_all asp2
5893: where asp2.org_id = asi2.org_id
5894: and asp2.base_currency_code <> asi2.payment_currency_code
5895: and asi2.checkrun_id = p_checkrun_id);
5896:

Line 5904: ap_system_parameters_all asp

5900:
5901: select count(*)
5902: into l_missing_rates_count
5903: from ap_selected_invoices_all asi,
5904: ap_system_parameters_all asp
5905: where asi.org_id = asp.org_id
5906: and asi.checkrun_id = p_checkrun_id
5907: and asi.payment_currency_code <> asp.base_currency_code
5908: and asi.payment_exchange_rate is null

Line 5941: ap_system_parameters_all asp

5937: SYSDATE,
5938: FND_GLOBAL.user_id,
5939: FND_GLOBAL.login_id
5940: from ap_selected_invoices_all asi,
5941: ap_system_parameters_all asp
5942: where asi.payment_exchange_rate is null
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