[Home] [Help]
348: SELECT
349: SHIPMENT_NUM
350: INTO L_SHIPMENT_NUMBER
351: FROM
352: PO_LINE_LOCATIONS_ALL
353: WHERE LINE_LOCATION_ID = C_PO_LINE_LOCATION_ID
354: AND ROWNUM < 2;
355: EXCEPTION
356: WHEN NO_DATA_FOUND THEN