APPS.GMD_LABUOM_CALCULATE_PKG SQL Statements

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

Line: 91

      SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
      FROM   mtl_uom_conversions uomc, mtl_units_of_measure uom
      WHERE  uom.uom_code             = Vum_code
      AND    uomc.uom_code          = uom.uom_code
      AND    uomc.inventory_item_id = Vinventory_item_id
      UNION
      SELECT 2, b.uom_class, a.conversion_rate
      FROM   mtl_uom_conversions a, mtl_units_of_measure b
      WHERE  a.uom_code = b.uom_code
      AND    b.uom_code = Vum_code
      ORDER by 1;

Line: 104

      SELECT primary_uom_code
      FROM   mtl_system_items
      WHERE  inventory_item_id = v_item_id;

Line: 113

      SELECT num_data
      FROM   gmd_technical_data_vl
      WHERE  organization_id = v_lab_type
      AND    inventory_item_id  = v_item_id
      AND    lot_number  = v_lot_number
      AND    formula_id = v_formula_id
      AND    tech_parm_name = v_parm_name;

Line: 122

       SELECT concatenated_segments
       FROM   mtl_system_items_kfv
       WHERE  inventory_item_id = Vitem_id;

Line: 126

      SELECT uom_class
      FROM   mtl_units_of_measure
      WHERE  uom_code = V_uom_code;