APPS.WIP_OPERATIONS_GRP SQL Statements

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

Line: 26

SELECT operation_seq_num,sum(inv_convert.inv_um_convert(0,
                                        NULL,
                                wor.scheduled_units * assigned_units,
                                        wor.UOM_CODE,
					l_hrUom,
                                        NULL,
                                        NULL ))
FROM    wip_operation_resources_v wor
WHERE   wor.wip_entity_id = p_wip_entity_id
AND     wor.UOM_CODE  in (SELECT UOM_CODE
                            FROM mtl_units_of_measure
                            WHERE UOM_CLASS = l_uomclass)
GROUP BY wor.operation_seq_num ;

Line: 42

SELECT progress_percentage
FROM   wip_operations
WHERE  operation_seq_num = l_op_seq_num
AND    wip_entity_id = p_wip_entity_id ;

Line: 50

    SELECT conversion_rate, uom_class
      INTO l_hrVal, l_uomClass
      FROM mtl_uom_conversions
     WHERE uom_code = l_hrUOM
       AND nvl(disable_date, sysdate + 1) > sysdate
       AND inventory_item_id = 0;

Line: 70

  SELECT
     sum(inv_convert.inv_um_convert( 0 ,
                                      NULL ,
                                      wor.scheduled_units * assigned_units,
                                      wor.UOM_CODE,
                            	      l_hrUOM,
                           	      NULL,
                               	      NULL  ))
  INTO    l_scheduled_hours
  FROM    wip_operation_resources_v wor
  WHERE   wor.wip_entity_id = p_wip_entity_id
  AND  	wor.UOM_CODE  in (SELECT UOM_CODE
                          FROM mtl_units_of_measure
                          WHERE UOM_CLASS  = l_uomclass);