APPS.POA_DBI_UOM_PKG SQL Statements

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

Line: 52

     select conversion_rate
       from mtl_uom_conversions
      where uom_class = l_uom_class
        and unit_of_measure = l_unit_of_measure
        and INVENTORY_ITEM_ID in (l_item_id,0)
     --  to take care of item specific vs standard conversion
     order by INVENTORY_ITEM_ID desc;

Line: 67

     SELECT conversion_rate
       FROM mtl_uom_conversions
      WHERE uom_class = l_uom_class
        AND uom_code  = l_uom_code
        AND INVENTORY_ITEM_ID in (l_item_id,0)
     --  to take care of item specific vs standard conversion
     ORDER BY INVENTORY_ITEM_ID desc ;

Line: 80

     select conversion_rate,from_uom_class
            -- to take care of two way conversions
       from MTL_UOM_CLASS_CONVERSIONS
      where inventory_item_id = l_item_id
        and FROM_UOM_CLASS in (l_from_uom_class,l_to_uom_class)
	and TO_UOM_CLASS in (l_from_uom_class,l_to_uom_class)
     order by decode(FROM_UOM_CLASS,l_from_uom_class,1,2);

Line: 103

      select uom.UOM_CLASS,uom.BASE_UOM_FLAG
        into l_line_uom_class,l_line_base_uom
        from mtl_units_of_measure uom
       where uom.UNIT_OF_MEASURE = p_from_unit_of_measure;

Line: 109

        SELECT  uom.uom_class
              , uom.base_uom_flag
        INTO l_line_uom_class
           , l_line_base_uom
        FROM mtl_units_of_measure uom
        WHERE uom.uom_code = p_from_uom_code ;

Line: 126

        select uom.UOM_CLASS, uom.base_uom_flag, item.primary_uom_code
          into l_item_uom_class, l_item_base_uom, l_item_primary_uom_code
          from mtl_units_of_measure uom
              ,mtl_system_items item
         where uom.UOM_CODE = item.PRIMARY_UOM_CODE
           and item.inventory_item_id = p_item_id
           and item.organization_id = p_org_id;

Line: 134

        select uom_class, base_uom_flag
          into l_item_uom_class, l_item_base_uom
          from mtl_units_of_measure
         where uom_code = p_item_primary_uom_code;

Line: 250

SELECT (from_uom.conversion_rate * (1/to_uom.conversion_rate)) rate into l_conversion_rate
FROM
   (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_from_unit_of_measure AND inventory_item_id=0) from_uom,
   (SELECT conversion_rate, uom_class FROM mtl_uom_conversions WHERE unit_of_measure=p_to_unit_of_measure AND inventory_item_id=0) to_uom
WHERE
     from_uom.uom_class=to_uom.uom_class;

Line: 272

    select primary_unit_of_measure
    into l_base_uom
    from mtl_system_items
    where inventory_item_id = p_item_id
    and organization_id = p_org_id;