APPS.PO_INTERFACE_S dependencies on PO_VENDOR_SITES_ALL

Line 1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;

1479:
1480:
1481: --
1482: l_default_method VARCHAR2(30);
1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
1484: l_fax_number VARCHAR2(100);
1485: l_document_num PO_HEADERS_ALL.segment1%TYPE;
1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;

Line 1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;

1482: l_default_method VARCHAR2(30);
1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
1484: l_fax_number VARCHAR2(100);
1485: l_document_num PO_HEADERS_ALL.segment1%TYPE;
1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
1488: --
1489:
1490:

Line 1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;

1483: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
1484: l_fax_number VARCHAR2(100);
1485: l_document_num PO_HEADERS_ALL.segment1%TYPE;
1486: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
1487: l_vendor_site_id PO_VENDOR_SITES_ALL.vendor_site_id%TYPE;
1488: --
1489:
1490:
1491: BEGIN

Line 3157: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878

3153: l_interface_line_id_tbl interface_line_id_tbl;
3154: --
3155:
3156: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
3157: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878
3158:
3159: --
3160: l_enhanced_pricing_flag po_doc_style_headers.enhanced_pricing_flag%type;
3161: l_pricing_call_src VARCHAR2(5);

Line 4363: FROM po_vendor_sites_all

4359: -- Bug 13556601 Included complex work flag to avoid copying retainage rate for other document types.
4360: IF(interface.vendor_site_id is not null AND p_is_complex_work_po)THEN
4361: SELECT retainage_rate
4362: into l_retainage_rate
4363: FROM po_vendor_sites_all
4364: WHERE vendor_site_id = interface.vendor_site_id;
4365: END IF;
4366: -- bug 4887900 END
4367:

Line 8397: FROM po_vendor_sites_all --

8393: l_progress := '010';
8394: /* Retrieve Invoice Match Option from Vendor site*/
8395: SELECT match_option
8396: INTO x_invoice_match_option
8397: FROM po_vendor_sites_all --
8398: WHERE vendor_site_id = X_vendor_site_id;
8399: end if;
8400:
8401: if(x_invoice_match_option is NULL) then