APPS.RCV_CORRECTION_SV SQL Statements

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

Line: 47

       select displayed_field
       from   po_lookup_codes
       where  lookup_type = p_lookup_type
       and    lookup_code = p_lookup_code
       AND    ROWNUM<=1;

Line: 54

       select uom_class
       from   mtl_units_of_measure
       where  unit_of_measure = p_uom
       AND    ROWNUM<=1;

Line: 60

       select unit_of_measure
       from   mtl_units_of_measure
       where  uom_code = p_uom_code
       AND    ROWNUM<=1;

Line: 66

       select LICENSE_PLATE_NUMBER
       from   WMS_LICENSE_PLATE_NUMBERS
       where  LPN_ID = p_license_plate_id
       AND    ROWNUM<=1;

Line: 239

	SELECT 	hazard_class
    	INTO   	x_hazard_class
    	FROM   	po_hazard_classes
    	WHERE  	hazard_class_id = x_hazard_class_id;

Line: 254

	SELECT 	un_number
    	INTO   	x_un_number
    	FROM   	po_un_numbers
    	WHERE  	un_number_id = x_un_number_id;

Line: 263

         * We select the packing_slip for the block rcv_transaction
         * in the Enter Corrections form from the rcv_shipment_lines.
        */
        SELECT nvl(packing_slip,' ')
        INTO x_packing_slip
        FROM rcv_shipment_lines
        WHERE shipment_line_id = x_shipment_line_id;