DBA Data[Home] [Help]

APPS.PO_COO_S dependencies on PO_VENDOR_SITES_ALL

Line 37: from po_vendor_sites_all

33: if x_country_of_origin is null then
34: begin
35: select country_of_origin_code
36: into x_country_of_origin
37: from po_vendor_sites_all
38: where vendor_id = x_vendor_id
39: and vendor_site_id = x_vendor_site_id
40: and rownum = 1;
41:

Line 54: from po_vendor_sites_all

50: elsif x_item_id is null then
51: begin
52: select country_of_origin_code
53: into x_country_of_origin
54: from po_vendor_sites_all
55: where vendor_id = x_vendor_id
56: and vendor_site_id = x_vendor_site_id
57: and rownum = 1;
58: