APPS.FUN_NET_EXTRACT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 48: po_vendor_sites_all pvs,

44: nai.netted_amt netted_amount
45: FROM fun_net_ap_invs nai,
46: ap_invoices_all ai,
47: po_vendors pv,
48: po_vendor_sites_all pvs,
49: fun_net_suppliers_all ns
50: WHERE nai.batch_id = p_batch_id
51: AND nai.invoice_id = ai.invoice_id
52: AND ai.vendor_id = pv.vendor_id

Line 105: l_supplier_site po_vendor_sites_all.vendor_site_code%TYPE;

101: l_customer_number hz_cust_accounts_all.account_number%TYPE;
102: l_location hz_cust_site_uses_all.location%TYPE;
103: l_supplier po_vendors.vendor_name%TYPE;
104: l_supplier_number po_vendors.segment1%TYPE;
105: l_supplier_site po_vendor_sites_all.vendor_site_code%TYPE;
106: l_invoice_count NUMBER;
107: l_transaction_count NUMBER;
108: l_output_string VARCHAR2(2000);
109: l_func_currency gl_ledgers.currency_code%TYPE;