APPS.PO_UOM_S SQL Statements

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

Line: 33

  SELECT  unit_of_measure
  INTO    X_unit_of_measure_v
  FROM    mtl_units_of_measure
  WHERE   sysdate < nvl(disable_date, sysdate + 1)
  AND     unit_of_measure = X_unit_of_measure;

Line: 133

        select  t.conversion_rate      std_to_rate,
                t.uom_class            std_to_class,
                f.conversion_rate      std_from_rate,
                f.uom_class            std_from_class
        from  mtl_uom_conversions t,
              mtl_uom_conversions f
        where t.inventory_item_id in (item_id, 0)
        and   t.unit_of_measure = to_unit
        and   nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
        and   f.inventory_item_id in (item_id, 0)
        and   f.unit_of_measure = from_unit
        and   nvl(f.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
        order by t.inventory_item_id desc,
                 f.inventory_item_id desc;

Line: 157

        select decode(to_uom_class, to_class, 1, 2) to_flag,
               decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
               conversion_rate rate
        from   mtl_uom_class_conversions
        where  ((inv_item_flag = 'Y' and inventory_item_id = item_id)
		  or
	     	(inv_item_flag = 'N' and inventory_item_id = 0))
        and    to_uom_class in (from_class, to_class)
        and    nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);

Line: 512

            select buom.unit_of_measure
            into primary_unit
            from mtl_units_of_measure cuom,
                 mtl_units_of_measure buom
            where cuom.unit_of_measure = current_unit_of_measure
            and   cuom.uom_class = buom.uom_class
            and   buom.base_uom_flag = 'Y';

Line: 539

            select msi.primary_unit_of_measure
            into primary_unit
            from mtl_system_items msi
            where msi.inventory_item_id = item_id
            and   msi.organization_id = org_id;

Line: 572

   the where and select clauses of a SQL stmt.bug 1365577
   ******************************************************
   So, any change in the po_uom_convertion proc in rvpo02
   should be implemented in this new function.
   ******************************************************
========================================================================*/
function po_uom_convert_p ( from_unit  varchar2, to_unit
 	varchar2, item_id number ) return number as

	/*
	** declare variables that are referenced in the cursor definitions
	*/

    from_class              varchar2(10);

Line: 590

        select  t.conversion_rate      std_to_rate,
                t.uom_class            std_to_class,
                f.conversion_rate      std_from_rate,
                f.uom_class            std_from_class
        from  mtl_uom_conversions t,
              mtl_uom_conversions f
        where t.inventory_item_id in (item_id, 0)
        and   t.unit_of_measure = to_unit
        and   nvl(t.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
        and   f.inventory_item_id in (item_id, 0)
        and   f.unit_of_measure = from_unit
        and   nvl(f.disable_date, trunc(sysdate) + 1) > trunc(sysdate)
        order by t.inventory_item_id desc,
                 f.inventory_item_id desc;

Line: 609

        select decode(to_uom_class, to_class, 1, 2) to_flag,
               decode(from_uom_class, from_class, 1, to_class, 2, 0) from_flag,
               conversion_rate rate
        from   mtl_uom_class_conversions
        where  inventory_item_id = item_id
        and    to_uom_class in (from_class, to_class)
        and    nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);

Line: 877

            select msi.tracking_quantity_ind,msi.secondary_uom_code, muom.unit_of_measure
            into   l_tracking_quantity_ind, x_secondary_uom_code,x_secondary_unit_of_measure
            from mtl_system_items msi, mtl_units_of_measure muom
            where msi.inventory_item_id = p_item_id
            and   msi.organization_id = p_org_id
            and   msi.secondary_uom_code = muom.uom_code(+);

Line: 946

       select unit_of_measure
       into   x_unit_of_measure
       from   mtl_units_of_measure
       where  uom_code = p_uom_code;