APPS.RCV_LCM_WEB_SERVICE SQL Statements

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

Line: 49

         UPDATE rcv_transactions_interface
         SET    processing_status_code  = 'ERROR'
         WHERE  processing_status_code  = 'RUNNING'
         AND    transaction_status_code = 'PENDING'
         AND    mo_global.check_access(org_id) = 'Y'
         AND    processing_mode_code = p_processing_mode
         AND    group_id = nvl(p_group_id, group_id)
         AND    source_document_code = 'PO'
         AND    transaction_type NOT IN ('SHIP', 'RECEIVE', 'ACCEPT', 'REJECT','TRANSFER','UNORDERED')
         AND    lcm_shipment_line_id IS NOT NULL;

Line: 60

         asn_debug.put_line(sql%rowcount || ' RTIs updated to Error' );