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_INVOICE_LINES_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 239: ap_system_parameters SP

235: INTO l_prepay_dist_code_ccid,
236: l_invoice_type_lookup_code
237: FROM ap_invoices AI,
238: po_vendor_sites PVS,
239: ap_system_parameters SP
240: WHERE AI.invoice_id = X_invoice_lines_rec.invoice_id
241: AND PVS.vendor_site_id = AI.vendor_site_id;
242:
243: i := 0;

Line 1220: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

1216: WHERE invoice_id = x_invoice_id;
1217:
1218: l_chart_of_accounts_id GL_SETS_OF_BOOKS.CHART_OF_ACCOUNTS_ID%TYPE;
1219: l_set_of_books_id GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID%TYPE;
1220: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
1221:
1222: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
1223:
1224: l_dist_set_percent_number NUMBER := 0;

Line 1460: -- get chart_of_accounts_id from ap_system_parameters

1456: --------------------------------------------------------------
1457: debug_info := 'Get system information';
1458:
1459: BEGIN
1460: -- get chart_of_accounts_id from ap_system_parameters
1461: SELECT gsob.chart_of_accounts_id,
1462: ap.base_currency_code
1463: INTO l_chart_of_accounts_id,
1464: l_base_currency_code

Line 1465: FROM ap_system_parameters ap, gl_sets_of_books gsob

1461: SELECT gsob.chart_of_accounts_id,
1462: ap.base_currency_code
1463: INTO l_chart_of_accounts_id,
1464: l_base_currency_code
1465: FROM ap_system_parameters ap, gl_sets_of_books gsob
1466: WHERE ap.set_of_books_id = gsob.set_of_books_id
1467: AND ap.set_of_books_id = l_set_of_books_id
1468: AND ap.org_id = l_invoice_line_rec.org_id;
1469:

Line 1662: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;

1658:
1659: RETURN BOOLEAN IS
1660: l_rounded_amt NUMBER := 0;
1661: l_round_dist_id_list distribution_id_tab_type;
1662: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
1663: l_line_base_amount ap_invoice_lines.base_amount%TYPE;
1664: l_line_amount ap_invoice_lines.amount%TYPE;
1665: l_invoice_currency_code ap_invoices.invoice_currency_code%TYPE;
1666: l_reporting_currency_code ap_invoices.invoice_currency_code%TYPE;

Line 1679: FROM ap_invoices AI, ap_system_parameters ASP, ap_invoice_lines AIL

1675: SELECT decode(x_reporting_ledger_id, null, AIL.base_amount, null),
1676: AIL.amount, -- line_amount
1677: AI.invoice_currency_code, -- invoice_currency_code
1678: ASP.base_currency_code -- base_currency_code
1679: FROM ap_invoices AI, ap_system_parameters ASP, ap_invoice_lines AIL
1680: WHERE AI.invoice_id = X_invoice_id
1681: AND AIL.invoice_id = AI.invoice_id
1682: AND AIL.line_number = X_line_number
1683: AND ASP.org_id = AI.org_id;

Line 2039: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;

2035:
2036: --bug 8361741
2037: l_itm_dist_count NUMBER;
2038: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
2039: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
2040:
2041: -- Bug 8623061 - Start
2042: l_award_id ap_invoice_distributions_all.award_id%TYPE;
2043:

Line 2555: ap_system_parameters_all asp

2551: l_invoice_rec.invoice_date,
2552: l_invoice_rec.disc_is_inv_less_tax_flag,
2553: l_invoice_rec.exclude_freight_from_discount
2554: FROM ap_invoices ai,
2555: ap_system_parameters_all asp
2556: WHERE invoice_id = p_line_rec.invoice_id
2557: AND ai.org_id = asp.org_id;
2558:
2559: /*-----------------------------------------------------------------+