APPS.PO_COO_S SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12

   SELECT   paa.country_of_origin_code
    	  FROM     po_approved_supplier_lis_val_v pasl,
		   po_asl_attributes paa
    	  WHERE    pasl.item_id = x_item_id
    	  AND	   pasl.vendor_id = x_vendor_id
    	  AND	   nvl(pasl.vendor_site_id, -1) = nvl(x_vendor_site_id, -1)
    	  AND	   pasl.using_organization_id IN (-1, x_ship_to_org_id)
	  AND	   paa.asl_id = pasl.asl_id
	  ORDER BY paa.using_organization_id DESC;

Line: 35

  	   select country_of_origin_code
	   into x_country_of_origin
	   from po_vendor_sites_all
	   where vendor_id = x_vendor_id
	   and   vendor_site_id = x_vendor_site_id
	   and   rownum = 1;

Line: 52

  	   select country_of_origin_code
	   into x_country_of_origin
	   from po_vendor_sites_all
	   where vendor_id = x_vendor_id
	   and   vendor_site_id = x_vendor_site_id
	   and   rownum = 1;