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