APPS.POS_QUANTITIES_S SQL Statements

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

Line: 97

   SELECT uom_code
   INTO   x_asn_uom_code
   FROM   mtl_units_of_measure
   WHERE  unit_of_measure = x_asn_unit_of_measure;

Line: 102

   SELECT uom_code
   INTO   x_po_uom_code
   FROM   mtl_units_of_measure
   WHERE  unit_of_measure = (select nvl(poll.UNIT_MEAS_LOOKUP_CODE, pol.UNIT_MEAS_LOOKUP_CODE)
                             from po_line_locations_all poll,
                                  po_lines_all pol
                             where poll.line_location_id = x_line_location_id and
                                   poll.po_line_id = pol.po_line_id );