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_ISP_UTILITIES_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;

1332: l_invoice_amount ap_invoices_all.invoice_amount%type;
1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;

Line 1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;

1333: l_base_amount ap_invoices_all.base_amount%type;
1334: l_exchange_rate ap_invoices_all.exchange_rate%type;
1335: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1336: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1337: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1338: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1339: l_exchange_date ap_invoices_all.exchange_date%type;
1340: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1341: l_vendor_id ap_invoices_all.vendor_id%type;

Line 1345: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;

1341: l_vendor_id ap_invoices_all.vendor_id%type;
1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1345: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1346: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1347: l_error_code VARCHAR2(4000);
1348: l_curr_calling_sequence VARCHAR2(2000);
1349: l_debug_info VARCHAR2(500);

Line 1346: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;

1342: l_invoice_date ap_invoices_all.invoice_date%type;
1343: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1344: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1345: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1346: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1347: l_error_code VARCHAR2(4000);
1348: l_curr_calling_sequence VARCHAR2(2000);
1349: l_debug_info VARCHAR2(500);
1350: CURSOR approve_invoice_cur IS

Line 1371: ap_supplier_sites_all PVS

1367: pvs.tolerance_id,
1368: pvs.services_tolerance_id
1369: FROM ap_invoices_all AI,
1370: ap_suppliers PV,
1371: ap_supplier_sites_all PVS
1372: WHERE AI.invoice_id = p_invoice_id
1373: AND AI.vendor_id = PV.vendor_id
1374: AND AI.vendor_site_id = PVS.vendor_site_id;
1375: BEGIN

Line 1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;

1491: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1492: l_requester_id ap_invoices_all.requester_id%TYPE;
1493:
1494: l_wfitemkey VARCHAR2(50);
1495: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1496: -- Bug 6859035
1497: l_period_name ap_invoice_lines_all.period_name%TYPE;
1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1499: l_org_id ap_invoices_all.org_id%TYPE;

Line 1504: l_vendor_site_code ap_supplier_sites_all.vendor_site_code%TYPE;

1500:
1501: -- Bug 7706967 : Start
1502: l_vendor_name ap_suppliers.vendor_name%TYPE;
1503: l_vendor_id ap_suppliers.vendor_id%TYPE;
1504: l_vendor_site_code ap_supplier_sites_all.vendor_site_code%TYPE;
1505: l_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE;
1506: -- Bug 7706967 : End
1507:
1508: BEGIN

Line 1505: l_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE;

1501: -- Bug 7706967 : Start
1502: l_vendor_name ap_suppliers.vendor_name%TYPE;
1503: l_vendor_id ap_suppliers.vendor_id%TYPE;
1504: l_vendor_site_code ap_supplier_sites_all.vendor_site_code%TYPE;
1505: l_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE;
1506: -- Bug 7706967 : End
1507:
1508: BEGIN
1509: -- Update the calling sequence

Line 1567: FROM ap_supplier_sites_all apss, ap_invoices_all ai

1563: AND ROWNUM = 1;
1564:
1565: SELECT apss.vendor_site_code, ai.vendor_id, ai.vendor_site_id
1566: INTO l_vendor_site_code, l_vendor_id, l_vendor_site_id
1567: FROM ap_supplier_sites_all apss, ap_invoices_all ai
1568: WHERE ai.invoice_id = p_invoice_id
1569: AND apss.vendor_site_id = ai.vendor_site_id;
1570:
1571: UPDATE ap_invoices_all

Line 1652: FROM ap_supplier_sites_all asu,

1648:
1649: IF (AP_ISP_UTILITIES_PKG.get_po_number_switcher(p_invoice_id) = 'UNMATCHED') THEN
1650: SELECT asu.distribution_set_id
1651: INTO l_dist_set_id
1652: FROM ap_supplier_sites_all asu,
1653: ap_invoices_all ai
1654: WHERE ai.vendor_site_id = asu.vendor_site_id
1655: AND ai.invoice_id = p_invoice_id;
1656: --Create Distributions