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_APPROVAL_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 787: ap_system_parameters_all ASP --added table for bug 8425996

783: nvl(pvs.services_tolerance_id,ASP.services_tolerance_id) --added nvl for bug 8425996
784: FROM ap_invoices_all AI,
785: ap_suppliers PV,
786: ap_supplier_sites_all PVS,
787: ap_system_parameters_all ASP --added table for bug 8425996
788: WHERE AI.invoice_id = p_invoice_id
789: AND AI.vendor_id = PV.vendor_id
790: AND AI.vendor_site_id = PVS.vendor_site_id
791: AND ASP.org_id = AI.org_id;

Line 2750: FROM ap_system_parameters_all sp,

2746: p_inv_enc_type_id,
2747: p_purch_enc_type_id,
2748: p_receipt_acc_days,
2749: p_gl_date_from_receipt_flag
2750: FROM ap_system_parameters_all sp,
2751: financials_system_params_all fp,
2752: gl_sets_of_books gls
2753: WHERE sp.org_id = p_org_id
2754: AND fp.org_id = sp.org_id

Line 6045: FROM ap_system_parameters_all asp,

6041: /* 5886500 */
6042: --bug 9293773
6043: SELECT nvl(asp.withholding_date_basis,'INVOICEDATE')
6044: INTO l_withhold_date_basis
6045: FROM ap_system_parameters_all asp,
6046: ap_invoices_all ai
6047: WHERE ai.invoice_id = p_invoice_id
6048: AND ai.org_id = asp.org_id;
6049:

Line 8027: from ap_system_parameters_all asp, ap_invoices_all ai

8023: /* bug 13035539 starts */
8024:
8025: select BASE_CURRENCY_CODE
8026: into l_tmp_base_curr_code
8027: from ap_system_parameters_all asp, ap_invoices_all ai
8028: where asp.org_id = ai.org_id
8029: and ai.invoice_id = p_invoice_id;
8030:
8031: /* bug 13035539 ends */

Line 9278: ap_system_parameters_all ASP --Bug8524767

9274: nvl(S.tolerance_id,ASP.tolerance_id), --Bug8524767
9275: nvl(S.services_tolerance_id,ASP.services_tolerance_id) --Bug8524767
9276: FROM ap_invoices_all I,
9277: ap_supplier_sites_all S,
9278: ap_system_parameters_all ASP --Bug8524767
9279: WHERE I.vendor_site_id = S.vendor_site_id (+)
9280: AND I.validation_request_id = AP_APPROVAL_PKG.G_VALIDATION_REQUEST_ID
9281: AND ASP.org_id = I.org_id
9282: ORDER BY I.org_id;

Line 9508: --Added ap_system_parameters_all table and nvl condition for

9504: COMMIT;
9505:
9506: BEGIN
9507: --Modified SELECT statement for bug #8420964/8556734
9508: --Added ap_system_parameters_all table and nvl condition for
9509: --tolerance columns
9510:
9511: SELECT
9512: ai.invoice_num, ai.org_id, ai.invoice_type_lookup_code, ai.validation_request_id,

Line 9523: ap_system_parameters_all asp

9519: l_exchange_rate_type, l_exchange_date, l_vendor_id, l_org_id, l_tolerance_id,
9520: l_services_tolerance_id
9521: FROM ap_invoices_all ai,
9522: ap_supplier_sites_all s,
9523: ap_system_parameters_all asp
9524: WHERE ai.invoice_id = l_invoice_id
9525: AND ai.vendor_site_id = s.vendor_site_id(+)
9526: AND ai.org_id = asp.org_id;
9527: EXCEPTION

Line 11244: FROM ap_system_parameters_all sp,

11240: nvl(disc_is_inv_less_tax_flag,'N') disc_is_inv_less_tax_flag,
11241: fp.org_id org_id,
11242: 5 System_User,
11243: fnd_global.user_id User_Id
11244: FROM ap_system_parameters_all sp,
11245: financials_system_params_all fp,
11246: gl_sets_of_books gls,
11247: Mo_Glob_Org_Access_Tmp mo
11248: WHERE sp.set_of_books_id = gls.set_of_books_id