采购退货接口更改状态后重新运行SQL

Update RCV_TRANSACTIONS_INTERFACE

          set Last_Update_Date       = SYSDATE,

           --   Transaction_Date       = SYSDATE,

              Processing_Status_Code = 'PENDING',

              Processing_Request_Id  = null,

              request_id             = null,

              Primary_Quantity          = null,

              Primary_Unit_Of_Measure   = null,

              Validation_Flag           = 'Y',

              Interface_Available_Qty   = null,

              Interface_Transaction_Qty = null,

              Order_Transaction_Id      = null

        where group_id = V1.GROUP_ID;

       Update rcv_headers_interface

          set Processing_Status_Code = 'PENDING'

        where group_id = V1.GROUP_ID;