APPS.RCV_RMA_RCPT_PURGE SQL Statements

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

Line: 16

  select count(*) into x_interface_ct
  from rcv_transactions_interface
  where oe_order_line_id = x_order_line_id
  and processing_status_code in ('PENDING','ERROR');

Line: 52

select shipment_line_id,shipment_header_id
from rcv_shipment_lines
where oe_order_line_id = x_order_line_id;

Line: 71

  /* delete from rcv_lots_supply */
 delete from rcv_lots_supply
 where shipment_line_id = x_ship_line_id;

Line: 76

 /* delete from rcv_serials_supply */
 delete from rcv_serials_supply
 where shipment_line_id = x_ship_line_id;

Line: 81

 /* delete from rcv_lot_transactions */
 delete from rcv_lot_transactions
 where shipment_line_id = x_ship_line_id;

Line: 86

 /* delete from rcv_lots_supply */
 delete from rcv_serial_transactions
 where shipment_line_id = x_ship_line_id;

Line: 91

 /* delete from rcv_shipment_lines */
 delete from rcv_shipment_lines
 where shipment_line_id = x_ship_line_id;

Line: 96

   * then delete the header .
   */
  select count(*) into x_line_count
  from rcv_shipment_lines
  where shipment_header_id = x_ship_header_id;

Line: 103

    delete from rcv_shipment_headers
    where shipment_header_id = x_ship_header_id;

Line: 109

 /* delete from rcv_transactions */
 delete from rcv_transactions
 where shipment_line_id = x_ship_line_id;