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: 196

        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: 220

        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: 590

            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: 617

            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: 650

   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: 668

        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: 687

        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: 955

            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: 1024

       select unit_of_measure
       into   x_unit_of_measure
       from   mtl_units_of_measure
       where  uom_code = p_uom_code;

Line: 1048

   the where and select clauses of rvtvq.lpc the lot specific UOM convertion for rti
   source_doc_quantity   for bug 14106596

========================================================================*/


  FUNCTION RTI_TRX_QTY_TO_SOC_QTY(P_INTERFACE_TRANSACTION_ID IN NUMBER,
                                  P_TO_ORG_ID                IN NUMBER,
                                  P_ITEM_ID                  IN NUMBER,
                                  P_FROM_QTY                 IN NUMBER,
                                  P_FROM_UOM                 IN VARCHAR2,
                                  P_TO_UOM                   IN VARCHAR2)
  /*this fuction is used to caculate the source_doc_quantity for rti*/
   RETURN NUMBER IS

    L_TOT_QTY     NUMBER := 0;

Line: 1089

      SELECT TRANSACTION_QUANTITY, LOT_NUMBER
        FROM MTL_TRANSACTION_LOTS_TEMP
       WHERE PRODUCT_TRANSACTION_ID = P_INTERFACE_TRANSACTION_ID;

Line: 1094

      SELECT TRANSACTION_QUANTITY, LOT_NUMBER
        FROM MTL_TRANSACTION_LOTS_INTERFACE
       WHERE PRODUCT_TRANSACTION_ID = P_INTERFACE_TRANSACTION_ID;

Line: 1104

    SELECT BASE_UOM_FLAG, uom_CLASS
   INTO l_base_fuom_flag, l_fuom_class
   FROM MTL_UNITS_OF_MEASURE
  WHERE UNIT_OF_MEASURE = P_FROM_UOM
   AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate) ;

Line: 1113

   SELECT BASE_UOM_FLAG, uom_CLASS
   INTO l_base_tuom_flag, l_tuom_class
   FROM MTL_UNITS_OF_MEASURE
  WHERE UNIT_OF_MEASURE = P_TO_UOM
   AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate) ;

Line: 1124

     SELECT DISTINCT UNIT_OF_MEASURE
     INTO l_base_fuom
     FROM MTL_UNITS_OF_MEASURE
     WHERE uom_CLASS=l_fuom_class
     AND BASE_UOM_FLAG='Y'
     AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);

Line: 1137

     SELECT DISTINCT UNIT_OF_MEASURE
     INTO l_base_tuom
     FROM MTL_UNITS_OF_MEASURE
     WHERE uom_CLASS=l_tuom_class
     AND BASE_UOM_FLAG='Y'
     AND nvl(disable_date, trunc(sysdate) + 1) > trunc(sysdate);

Line: 1153

      SELECT COUNT(1)
        INTO L_MTLT_COUNT
        FROM MTL_LOT_UOM_CLASS_CONVERSIONS MLUC,
             MTL_TRANSACTION_LOTS_TEMP     MTLT -- Used for form action
       WHERE MTLT.LOT_NUMBER = MLUC.LOT_NUMBER
         AND MLUC.ORGANIZATION_ID = P_TO_ORG_ID
         AND MLUC.INVENTORY_ITEM_ID = P_ITEM_ID
         AND MLUC.FROM_UNIT_OF_MEASURE = l_base_fuom
         AND MLUC.TO_UNIT_OF_MEASURE = l_base_tuom
         AND MTLT.PRODUCT_TRANSACTION_ID = P_INTERFACE_TRANSACTION_ID
 ;

Line: 1174

      SELECT COUNT(1)
        INTO L_MTLI_COUNT
        FROM MTL_LOT_UOM_CLASS_CONVERSIONS  MLUC,
             MTL_TRANSACTION_LOTS_INTERFACE MTLI -- Used for ROI&LOT action
       WHERE MTLI.LOT_NUMBER = MLUC.LOT_NUMBER
         AND MLUC.ORGANIZATION_ID = P_TO_ORG_ID
         AND MLUC.INVENTORY_ITEM_ID = P_ITEM_ID
         AND MLUC.FROM_UNIT_OF_MEASURE = l_base_fuom
         AND MLUC.TO_UNIT_OF_MEASURE = l_base_tuom
         AND MTLI.PRODUCT_TRANSACTION_ID = P_INTERFACE_TRANSACTION_ID;