APPS.POR_RCV_VALIDATION_PKG SQL Statements

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

Line: 19

    select nvl(pll.quantity, 0),
           nvl(pll.quantity_received, 0),
       	   nvl(pll.quantity_cancelled, 0),
           1 + (nvl(pll.qty_rcv_tolerance, 0)/100),
           pll.qty_rcv_exception_code,
           pl.unit_meas_lookup_code
    into   xQuantityOrdered, xQuantityReceived,
	   xQuantityCancelled, xRcvTolerance,
	   pExceptionCode, xPoUOMCode
    from   po_line_locations pll,
           po_lines pl
    where  pll.line_location_id = pLineLocationId
    and    pll.po_line_id = pl.po_line_id;