APPS.PO_INTERFACE_S dependencies on PO_VENDOR_SITES

Line 62: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL --

58: * Used to default invoice match flag from financial system parameter,
59: * vendor and vendor site
60: */
61: invoice_match_option po_vendors.match_option%type := null,
62: shipping_control PO_VENDOR_SITES.shipping_control%TYPE := NULL --
63: );
64:
65: /* Type declaration for Item defaults structure */
66: /*Bug 1391523 . Added market price to the record

Line 1440: po_vendor_sites_sv.get_vendor_site_info

1436: vendor.vat_registration_num,
1437: vendor.inspection_required_flag);
1438:
1439: IF(interface.vendor_site_id is not null) THEN
1440: po_vendor_sites_sv.get_vendor_site_info
1441: (interface.vendor_site_id,
1442: vendor.ship_to_location_id,
1443: vendor.bill_to_location_id,
1444: l_vs_ship_via_lookup_code,

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

2816: l_interface_line_id_tbl interface_line_id_tbl;
2817: --
2818:
2819: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type; --
2820: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type; --bug#5255878
2821: BEGIN
2822: l_outsourced_assembly :=2; --
2823: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
2824: PO_DEBUG.debug_begin(p_log_head => g_log_head||l_api_name);

Line 3952: FROM po_vendor_sites_all

3948: -- vendor_site_id is not null.
3949: IF(interface.vendor_site_id is not null)THEN
3950: SELECT retainage_rate
3951: into l_retainage_rate
3952: FROM po_vendor_sites_all
3953: WHERE vendor_site_id = interface.vendor_site_id;
3954: END IF;
3955: -- bug 4887900 END
3956:

Line 7790: FROM po_vendor_sites_all --

7786: l_progress := '010';
7787: /* Retrieve Invoice Match Option from Vendor site*/
7788: SELECT match_option
7789: INTO x_invoice_match_option
7790: FROM po_vendor_sites_all --
7791: WHERE vendor_site_id = X_vendor_site_id;
7792: end if;
7793:
7794: if(x_invoice_match_option is NULL) then