[Home] [Help]
374: WHERE RT.transaction_id = RLT.transaction_id));
375:
376: l_progress := '090';
377:
378: --SQL What: Delete rcv_serial_transactions data
379: DELETE
380: FROM rcv_serial_transactions RST
381: WHERE (RST.shipment_line_id > 0
382: AND
376: l_progress := '090';
377:
378: --SQL What: Delete rcv_serial_transactions data
379: DELETE
380: FROM rcv_serial_transactions RST
381: WHERE (RST.shipment_line_id > 0
382: AND
383: NOT EXISTS (
384: SELECT NULL