APPS.AP_ISP_UTILITIES_PKG dependencies on AP_SUPPLIERS

Line 1240: FROM ap_suppliers aps,

1236: --Bug 9239655
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);

Line 1458: ap_suppliers PV,

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

Line 1593: l_vendor_name ap_suppliers.vendor_name%TYPE;

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

Line 1594: l_vendor_id ap_suppliers.vendor_id%TYPE;

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

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

1668:
1669: -- Bug 7706967 - Start
1670: /*SELECT nvl(aps.vendor_name, hzp.party_name)
1671: INTO l_vendor_name
1672: FROM ap_suppliers aps, hz_parties hzp, ap_invoices_all ai
1673: WHERE ai.invoice_id = p_invoice_id
1674: AND aps.vendor_id = ai.vendor_id
1675: AND hzp.party_id = aps.party_id
1676: AND ROWNUM = 1;

Line 1696: FROM ap_suppliers po,

1692:
1693: -- Bug 9531531 Begin
1694: SELECT po.type_1099
1695: INTO l_type_1099
1696: FROM ap_suppliers po,
1697: ap_invoices_all ai
1698: WHERE po.vendor_id = ai.vendor_id
1699: AND ai.invoice_id = p_invoice_id;
1700:

Line 1769: FROM ap_suppliers aps,

1765: --Bug 9239655
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);

Line 2176: FROM ap_suppliers

2172:
2173: --5077334, added party_id
2174: SELECT vendor_name, party_id
2175: INTO p_attr_value1, p_party_id
2176: FROM ap_suppliers
2177: WHERE vendor_id = p_attr_value;
2178: END IF;
2179: END IF;
2180: l_debug_info := 'securing attribute value1 = '|| p_attr_value1;

Line 3327: FROM ap_suppliers

3323: BEGIN
3324:
3325: SELECT 'Y'
3326: INTO l_active_sup
3327: FROM ap_suppliers
3328: WHERE vendor_id = p_vendor_id
3329: AND sysdate <= nvl(end_date_active, sysdate + 1);
3330:
3331: RETURN 'Y';