APPS.AP_ISP_UTILITIES_PKG dependencies on AP_SUPPLIERS

Line 1370: ap_suppliers PV,

1366: nvl(AI.exclude_freight_from_discount,'N'),
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;

Line 1502: l_vendor_name ap_suppliers.vendor_name%TYPE;

1498: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
1499: l_org_id ap_invoices_all.org_id%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

Line 1503: l_vendor_id ap_suppliers.vendor_id%TYPE;

1499: l_org_id ap_invoices_all.org_id%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:

Line 1559: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai

1555:
1556: -- Bug 7706967 - Start
1557: SELECT nvl(aps.vendor_name, hzp.party_name)
1558: INTO l_vendor_name
1559: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai
1560: WHERE ai.invoice_id = p_invoice_id
1561: AND aps.vendor_id = ai.vendor_id
1562: AND hzp.party_id = aps.party_id
1563: AND ROWNUM = 1;

Line 1884: FROM ap_suppliers

1880:
1881: --5077334, added party_id
1882: SELECT vendor_name, party_id
1883: INTO p_attr_value1, p_party_id
1884: FROM ap_suppliers
1885: WHERE vendor_id = p_attr_value;
1886: END IF;
1887: END IF;
1888: l_debug_info := 'securing attribute value1 = '|| p_attr_value1;