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 300: from ap_supplier_sites_all assi,

296: BEGIN
297: -- bug8711412
298: select nvl(assi.terms_date_basis, aps.terms_date_basis)
299: into l_terms_date_basis
300: from ap_supplier_sites_all assi,
301: ap_product_setup aps
302: where assi.vendor_site_id = l_vendor_site_id;
303: EXCEPTION
304: WHEN NO_DATA_FOUND THEN

Line 1241: ap_supplier_sites_all assa

1237: BEGIN
1238: SELECT decode(assa.exclude_freight_from_discount,NULL,nvl(aps.exclude_freight_from_discount,'N'),assa.exclude_freight_from_discount)
1239: INTO l_exclude_freight_from_disc
1240: FROM ap_suppliers aps,
1241: ap_supplier_sites_all assa
1242: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)
1243: AND assa.vendor_id = aps.vendor_id
1244: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1245:

Line 1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;

1420: l_invoice_amount ap_invoices_all.invoice_amount%type;
1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;

Line 1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;

1421: l_base_amount ap_invoices_all.base_amount%type;
1422: l_exchange_rate ap_invoices_all.exchange_rate%type;
1423: l_invoice_currency_code ap_invoices_all.invoice_currency_code%type;
1424: l_invoice_amount_limit ap_supplier_sites_all.invoice_amount_limit%type;
1425: l_hold_future_payments_flag ap_supplier_sites_all.hold_future_payments_flag%type;
1426: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%type;
1427: l_exchange_date ap_invoices_all.exchange_date%type;
1428: l_exchange_rate_type ap_invoices_all.exchange_rate_type%type;
1429: l_vendor_id ap_invoices_all.vendor_id%type;

Line 1433: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;

1429: l_vendor_id ap_invoices_all.vendor_id%type;
1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1433: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1434: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1435: l_error_code VARCHAR2(4000);
1436: l_curr_calling_sequence VARCHAR2(2000);
1437: l_debug_info VARCHAR2(500);

Line 1434: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;

1430: l_invoice_date ap_invoices_all.invoice_date%type;
1431: l_disc_is_inv_less_tax_flag ap_invoices_all.disc_is_inv_less_tax_flag%type;
1432: l_exclude_freight_from_disc ap_invoices_all.exclude_freight_from_discount%type;
1433: l_tolerance_id ap_supplier_sites_all.tolerance_id%type;
1434: l_services_tolerance_id ap_supplier_sites_all.services_tolerance_id%type;
1435: l_error_code VARCHAR2(4000);
1436: l_curr_calling_sequence VARCHAR2(2000);
1437: l_debug_info VARCHAR2(500);
1438: CURSOR approve_invoice_cur IS

Line 1459: ap_supplier_sites_all PVS

1455: pvs.tolerance_id,
1456: pvs.services_tolerance_id
1457: FROM ap_invoices_all AI,
1458: ap_suppliers PV,
1459: ap_supplier_sites_all PVS
1460: WHERE AI.invoice_id = p_invoice_id
1461: AND AI.vendor_id = PV.vendor_id
1462: AND AI.vendor_site_id = PVS.vendor_site_id;
1463: BEGIN

Line 1586: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;

1582: l_exchange_date ap_invoices_all.exchange_date%TYPE;
1583: l_requester_id ap_invoices_all.requester_id%TYPE;
1584:
1585: l_wfitemkey VARCHAR2(50);
1586: l_dist_set_id ap_supplier_sites_all.distribution_set_id%TYPE;
1587: -- Bug 6859035
1588: l_period_name ap_invoice_lines_all.period_name%TYPE;
1589: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1590: l_org_id ap_invoices_all.org_id%TYPE;

Line 1595: l_vendor_site_code ap_supplier_sites_all.vendor_site_code%TYPE;

1591:
1592: -- Bug 7706967 : Start
1593: l_vendor_name ap_suppliers.vendor_name%TYPE;
1594: l_vendor_id ap_suppliers.vendor_id%TYPE;
1595: l_vendor_site_code ap_supplier_sites_all.vendor_site_code%TYPE;
1596: l_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE;
1597: -- Bug 7706967 : End
1598:
1599: l_payment_priority ap_supplier_sites_all.payment_priority%TYPE ; -- B# 8649741

Line 1596: l_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE;

1592: -- Bug 7706967 : Start
1593: l_vendor_name ap_suppliers.vendor_name%TYPE;
1594: l_vendor_id ap_suppliers.vendor_id%TYPE;
1595: l_vendor_site_code ap_supplier_sites_all.vendor_site_code%TYPE;
1596: l_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE;
1597: -- Bug 7706967 : End
1598:
1599: l_payment_priority ap_supplier_sites_all.payment_priority%TYPE ; -- B# 8649741
1600:

Line 1599: l_payment_priority ap_supplier_sites_all.payment_priority%TYPE ; -- B# 8649741

1595: l_vendor_site_code ap_supplier_sites_all.vendor_site_code%TYPE;
1596: l_vendor_site_id ap_supplier_sites_all.vendor_site_id%TYPE;
1597: -- Bug 7706967 : End
1598:
1599: l_payment_priority ap_supplier_sites_all.payment_priority%TYPE ; -- B# 8649741
1600:
1601: --CARS Project. Bug 8865603.
1602: l_iter number := 0;
1603:

Line 1680: FROM ap_supplier_sites_all apss, ap_invoices_all ai

1676: AND ROWNUM = 1;
1677:
1678: SELECT apss.vendor_site_code, ai.vendor_id, ai.vendor_site_id
1679: INTO l_vendor_site_code, l_vendor_id, l_vendor_site_id
1680: FROM ap_supplier_sites_all apss, ap_invoices_all ai
1681: WHERE ai.invoice_id = p_invoice_id
1682: AND apss.vendor_site_id = ai.vendor_site_id;
1683:
1684: UPDATE ap_invoices_all

Line 1770: ap_supplier_sites_all assa

1766: BEGIN
1767: SELECT decode(assa.exclude_freight_from_discount,NULL,nvl(aps.exclude_freight_from_discount,'N'),assa.exclude_freight_from_discount)
1768: INTO l_exclude_freight_from_disc
1769: FROM ap_suppliers aps,
1770: ap_supplier_sites_all assa
1771: WHERE aps.vendor_id = (select vendor_id from ap_invoices_all where invoice_id = p_invoice_id)
1772: AND assa.vendor_id = aps.vendor_id
1773: AND assa.vendor_site_id = (select vendor_site_id from ap_invoices_all where invoice_id = p_invoice_id);
1774:

Line 1896: FROM ap_supplier_sites_all s,

1892: BEGIN
1893:
1894: SELECT nvl(payment_priority,99)
1895: INTO l_payment_priority
1896: FROM ap_supplier_sites_all s,
1897: ap_invoices_all i
1898: WHERE s.vendor_id = i.vendor_id
1899: AND s.vendor_site_id = i.vendor_site_id
1900: AND i.invoice_id = p_invoice_id ;

Line 1931: FROM ap_supplier_sites_all asu,

1927:
1928: IF (AP_ISP_UTILITIES_PKG.get_po_number_switcher(p_invoice_id) = 'UNMATCHED') THEN
1929: SELECT asu.distribution_set_id
1930: INTO l_dist_set_id
1931: FROM ap_supplier_sites_all asu,
1932: ap_invoices_all ai
1933: WHERE ai.vendor_site_id = asu.vendor_site_id
1934: AND ai.invoice_id = p_invoice_id;
1935: --Create Distributions