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 89: ap_system_parameters_all asp

85: FROM ap_interest_periods,
86: ap_invoices AI, --Bug6040657. Changed from ap_invoices_all to ap_invoices
87: ap_selected_invoices_all ASI,
88: po_vendors pov,
89: ap_system_parameters_all asp
90: WHERE ASI.checkrun_id = P_checkrun_id
91: AND ASP.auto_calculate_interest_flag = 'Y'
92: AND ASP.org_id = asi.org_id
93: AND TRUNC(P_check_date) > TRUNC(due_date)

Line 2045: ap_system_parameters_all asp,

2041: FROM ap_supplier_sites_all sites,
2042: ap_suppliers suppliers,
2043: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2044: ap_payment_schedules_all ps,
2045: ap_system_parameters_all asp,
2046: hz_parties hzp,
2047: hz_party_sites hzps, -- Bug 5620285
2048: hz_locations hzl -- Bug 5620285
2049: WHERE ps.checkrun_id is null -- Bug 5705276. Regression

Line 2339: ap_system_parameters_all asp,

2335: FROM ap_supplier_sites_all sites,
2336: ap_suppliers suppliers,
2337: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2338: ap_payment_schedules_all ps,
2339: ap_system_parameters_all asp,
2340: hz_parties hzp,
2341: hz_party_sites hzps, -- Bug 5620285
2342: hz_locations hzl -- Bug 5620285
2343: WHERE ps.checkrun_id is null -- Bug 5705276. Regression

Line 3451: Ap_System_Parameters_All ASP

3447: dont_pay_reason_code = 'PRE DATE NOT ALLOWED'
3448: WHERE checkrun_id = l_checkrun_id
3449: AND Exists (SELECT /*+NO_UNNEST */ NULL
3450: FROM Ap_Selected_Invoices_All ASI2,
3451: Ap_System_Parameters_All ASP
3452: WHERE ASI.invoice_id = ASI2.invoice_id
3453: AND ASI.payment_num = ASI2.payment_num
3454: AND ASI2.checkrun_id = l_checkrun_id
3455: AND ASI2.org_id = ASP.org_id

Line 3740: ap_system_parameters_all asp

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

Line 3750: ap_system_parameters_all asp2

3746: where checkrun_id = l_checkrun_id
3747: and (invoice_id, payment_num) in
3748: (select invoice_id, payment_num
3749: from ap_selected_invoices_all asi2,
3750: ap_system_parameters_all asp2
3751: where asp2.org_id = asi2.org_id
3752: and asp2.base_currency_code <> asi2.payment_currency_code
3753: and asi2.checkrun_id = l_checkrun_id);
3754:

Line 3767: from ap_system_parameters_all asp

3763: asp.base_currency_code,
3764: l_batch_exchange_rate_type,
3765: l_check_date,
3766: 'AUTOSELECT')
3767: from ap_system_parameters_all asp
3768: where asp.org_id = asi.org_id
3769: and asp.base_currency_code <> asi.payment_currency_code)
3770: where checkrun_id = l_checkrun_id
3771: and (invoice_id, payment_num) in

Line 3774: ap_system_parameters_all asp2

3770: where checkrun_id = l_checkrun_id
3771: and (invoice_id, payment_num) in
3772: (select invoice_id, payment_num
3773: from ap_selected_invoices_all asi2,
3774: ap_system_parameters_all asp2
3775: where asp2.org_id = asi2.org_id
3776: and asp2.base_currency_code <> asi2.payment_currency_code
3777: and asi2.checkrun_id = l_checkrun_id); --Bug 5123855
3778:

Line 3786: ap_system_parameters_all asp

3782:
3783: select count(*)
3784: into l_missing_rates_count
3785: from ap_selected_invoices_all asi,
3786: ap_system_parameters_all asp
3787: where asi.org_id = asp.org_id
3788: and asi.checkrun_id = l_checkrun_id
3789: and asi.payment_currency_code <> asp.base_currency_code
3790: and asi.payment_exchange_rate is null

Line 3824: ap_system_parameters_all asp

3820: SYSDATE,
3821: FND_GLOBAL.user_id,
3822: FND_GLOBAL.login_id
3823: from ap_selected_invoices_all asi,
3824: ap_system_parameters_all asp
3825: where asi.payment_exchange_rate is null
3826: and asp.org_id = asi.org_id
3827: and asp.base_currency_code <> asi.payment_currency_code
3828: and asi.checkrun_id = l_checkrun_id

Line 4101: ap_system_parameters_all asp

4097: SELECT invoice_id
4098: , vendor_id
4099: , payment_num
4100: FROM ap_SELECTed_invoices_all ASI,
4101: ap_system_parameters_all asp
4102: WHERE checkrun_name = l_checkrun_name
4103: AND original_invoice_id IS NULL
4104: AND asp.org_id = asi.org_id
4105: and checkrun_id = p_checkrun_id

Line 4302: ap_system_parameters_all asp

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

Line 4312: ap_system_parameters_all asp2

4308: where checkrun_id = p_checkrun_id
4309: and (invoice_id, payment_num) in
4310: (select invoice_id, payment_num
4311: from ap_selected_invoices_all asi2,
4312: ap_system_parameters_all asp2
4313: where asp2.org_id = asi2.org_id
4314: and asp2.base_currency_code <> asi2.payment_currency_code
4315: and asi2.checkrun_id = p_checkrun_id);
4316:

Line 4329: from ap_system_parameters_all asp

4325: asp.base_currency_code,
4326: l_batch_exchange_rate_type,
4327: l_check_date,
4328: 'AUTOSELECT')
4329: from ap_system_parameters_all asp
4330: where asp.org_id = asi.org_id
4331: and asp.base_currency_code <> asi.payment_currency_code)
4332: where checkrun_id = p_checkrun_id
4333: and (invoice_id, payment_num) in

Line 4336: ap_system_parameters_all asp2

4332: where checkrun_id = p_checkrun_id
4333: and (invoice_id, payment_num) in
4334: (select invoice_id, payment_num
4335: from ap_selected_invoices_all asi2,
4336: ap_system_parameters_all asp2
4337: where asp2.org_id = asi2.org_id
4338: and asp2.base_currency_code <> asi2.payment_currency_code
4339: and asi2.checkrun_id = p_checkrun_id);
4340:

Line 4348: ap_system_parameters_all asp

4344:
4345: select count(*)
4346: into l_missing_rates_count
4347: from ap_selected_invoices_all asi,
4348: ap_system_parameters_all asp
4349: where asi.org_id = asp.org_id
4350: and asi.checkrun_id = p_checkrun_id
4351: and asi.payment_currency_code <> asp.base_currency_code
4352: and asi.payment_exchange_rate is null

Line 4385: ap_system_parameters_all asp

4381: SYSDATE,
4382: FND_GLOBAL.user_id,
4383: FND_GLOBAL.login_id
4384: from ap_selected_invoices_all asi,
4385: ap_system_parameters_all asp
4386: where asi.payment_exchange_rate is null
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