DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on PO_VENDOR_SITES_ALL

Line 307: l_address_line1 po_vendor_sites_all.address_line1%TYPE;

303: AND AI.invoice_id = ASI.invoice_id
304: AND AI.invoice_type_lookup_code <> 'PAYMENT REQUEST';
305:
306:
307: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
308: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
309: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
310: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
311: l_amount_remaining NUMBER;

Line 308: l_address_line2 po_vendor_sites_all.address_line2%TYPE;

304: AND AI.invoice_type_lookup_code <> 'PAYMENT REQUEST';
305:
306:
307: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
308: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
309: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
310: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
311: l_amount_remaining NUMBER;
312: l_attention_ar_flag VARCHAR2(1);

Line 309: l_address_line3 po_vendor_sites_all.address_line3%TYPE;

305:
306:
307: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
308: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
309: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
310: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
311: l_amount_remaining NUMBER;
312: l_attention_ar_flag VARCHAR2(1);
313: l_awt_status_lookup_code VARCHAR2(25);

Line 310: l_address_line4 po_vendor_sites_all.address_line4%TYPE;

306:
307: l_address_line1 po_vendor_sites_all.address_line1%TYPE;
308: l_address_line2 po_vendor_sites_all.address_line2%TYPE;
309: l_address_line3 po_vendor_sites_all.address_line3%TYPE;
310: l_address_line4 po_vendor_sites_all.address_line4%TYPE;
311: l_amount_remaining NUMBER;
312: l_attention_ar_flag VARCHAR2(1);
313: l_awt_status_lookup_code VARCHAR2(25);
314: l_city ap_selected_invoices_all.city%type; --6708281

Line 353: l_site_code po_vendor_sites_all.vendor_site_code%TYPE;

349: l_payment_priority NUMBER(2);
350: l_proposed_interest_count NUMBER;
351: l_province VARCHAR2(150);
352: l_set_of_books_id number;
353: l_site_code po_vendor_sites_all.vendor_site_code%TYPE;
354: l_site_id NUMBER(15);
355: l_state VARCHAR2(150);
356: l_vendor_id number;
357: l_voucher_num VARCHAR2(50);