APPS.PO_UNIT_OF_MEASURES_SV1 SQL Statements

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

Line: 28

   SELECT count(*)
     INTO x_temp
     FROM po_units_of_measure_val_v
    WHERE (uom_code = x_uom_code
		OR
	   X_uom_code IS NULL)
       AND (unit_of_measure = X_unit_of_measure
		OR
	   X_unit_of_measure IS NULL);

Line: 68

   SELECT count(*)
     INTO x_temp
     FROM mtl_item_uoms_view
    WHERE unit_of_measure = x_item_unit_of_measure
      AND inventory_item_id = x_item_id
      AND organization_id = x_organization_id;

Line: 105

 SELECT unit_of_measure
   INTO X_unit_of_measure_v
   FROM po_units_of_measure_val_v
  WHERE uom_code = X_uom_code;