APPS.FUN_NET_EXTRACT_PKG dependencies on PO_VENDORS

Line 47: po_vendors pv,

43: ai.base_amount ledger_amount,
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

Line 103: l_supplier po_vendors.vendor_name%TYPE;

99: l_agreement_details c_get_agreement_details%ROWTYPE;
100: l_customer hz_parties.party_name%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;

Line 104: l_supplier_number po_vendors.segment1%TYPE;

100: l_customer hz_parties.party_name%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);