票据已汇款 风险解除无法变更状态为“结清”

/*以下两个票据已汇款  风险解除无法变更状态为“结清”，我查了一下，不是上次汇款日期的原因，请帮忙看一下是原因，谢谢！
25199928        30533658*/
/* BEGIN 
  mo_global.init('M');
END;*/
 SELECT selected_remittance_batch_id, 
        RECEIPT_METHOD_NAME, 
        RECEIPT_NUMBER, 
        OVERRIDE_FLAG, 
        REMIT_BANK_ACCOUNT_NUMBER, 
        CUSTOMER_BANK_ACCOUNT_NUMBER, 
        RECEIPT_DATE, 
        MATURITY_DATE, 
        REMIT_BANK_NAME, 
        REMIT_BANK_BRANCH_NAME, 
        BANK_CHARGES, 
        CUSTOMER_BANK_NAME, 
        CUSTOMER_BANK_BRANCH_NAME, 
        CUSTOMER_NAME, 
        CUSTOMER_NUMBER, 
        ROW_ID, 
        REMITTANCE_BANK_BRANCH_ID, 
        REMITTANCE_BANK_ACCOUNT_ID, 
        CUSTOMER_BANK_ACCOUNT_ID, 
        CUSTOMER_BANK_BRANCH_ID, 
        BATCH_BANK_ACCOUNT_ID, 
        RECEIPT_METHOD_ID, 
        AMOUNT, 
        BATCH_ID, 
        REMIT_METHOD_CODE, 
        SELECTION_TYPE, 
        CURRENCY_CODE, 
        SELECTED_REMITTANCE_BATCH_ID, 
        PAY_FROM_CUSTOMER, 
        CUSTOMER_SITE_USE_ID, 
        CASH_RECEIPT_ID, 
        CASH_RECEIPT_HISTORY_ID, 
        PAYMENT_SCHEDULE_ID, 
        PAYMENT_TRXN_EXTENSION_ID, 
        PAYMENT_CHANNEL_CODE, 
        ATTRIBUTE_CATEGORY, 
        ATTRIBUTE1, 
        ATTRIBUTE2, 
        ATTRIBUTE3, 
        ATTRIBUTE4, 
        ATTRIBUTE5, 
        ATTRIBUTE6, 
        ATTRIBUTE7, 
        ATTRIBUTE8, 
        ATTRIBUTE9, 
        ATTRIBUTE10, 
        ATTRIBUTE11, 
        ATTRIBUTE12, 
        ATTRIBUTE13, 
        ATTRIBUTE14, 
        ATTRIBUTE15 
   FROM AR_BOE_REMIT_RECEIPTS_NONCBR_V 
  where 
        /* WHERE (((selection_type in ('POTENTIAL_RECEIPTS_FOR_REMIT')) AND 
        (remittance_bank_account_id<> 10017 AND 
        batch_bank_account_id <> 10017) OR 
        (batch_bank_account_id <> 10017 AND override_flag = 'Y')) OR 
        (selection_type IN ('CURRENT_BATCH_UNREMITTED') --AND 
        \* selected_remittance_batch_id = 6046*\)) 
        AND REVERSAL_DATE IS NULL 
        and (REMIT_METHOD_CODE IN ('STANDARD_AND_FACTORING', 'STANDARD')) 
        and (CURRENCY_CODE = 'CNY')*/ 
        RECEIPT_NUMBER IN ( '20391021-1','25199928', '30533658')

 

 SELECT REVERSAL_DATE, 
        RECEIPT_METHOD_NAME, 
        RECEIPT_NUMBER, 
        OVERRIDE_FLAG, 
        REMIT_BANK_ACCOUNT_NUMBER, 
        CUSTOMER_BANK_ACCOUNT_NUMBER, 
        RECEIPT_DATE, 
        MATURITY_DATE, 
        REMIT_BANK_NAME, 
        REMIT_BANK_BRANCH_NAME, 
        BANK_CHARGES, 
        CUSTOMER_BANK_NAME, 
        CUSTOMER_BANK_BRANCH_NAME, 
        CUSTOMER_NAME, 
        CUSTOMER_NUMBER, 
        ROW_ID, 
        REMITTANCE_BANK_BRANCH_ID, 
        REMITTANCE_BANK_ACCOUNT_ID, 
        CUSTOMER_BANK_ACCOUNT_ID, 
        CUSTOMER_BANK_BRANCH_ID, 
        BATCH_BANK_ACCOUNT_ID, 
        RECEIPT_METHOD_ID, 
        AMOUNT, 
        BATCH_ID, 
        REMIT_METHOD_CODE, 
        SELECTION_TYPE, 
        CURRENCY_CODE, 
        SELECTED_REMITTANCE_BATCH_ID, 
        PAY_FROM_CUSTOMER, 
        CUSTOMER_SITE_USE_ID, 
        CASH_RECEIPT_ID, 
        CASH_RECEIPT_HISTORY_ID, 
        PAYMENT_SCHEDULE_ID, 
        PAYMENT_TRXN_EXTENSION_ID, 
        PAYMENT_CHANNEL_CODE, 
        ATTRIBUTE_CATEGORY, 
        ATTRIBUTE1, 
        ATTRIBUTE2, 
        ATTRIBUTE3, 
        ATTRIBUTE4, 
        ATTRIBUTE5, 
        ATTRIBUTE6, 
        ATTRIBUTE7, 
        ATTRIBUTE8, 
        ATTRIBUTE9, 
        ATTRIBUTE10, 
        ATTRIBUTE11, 
        ATTRIBUTE12, 
        ATTRIBUTE13, 
        ATTRIBUTE14, 
        ATTRIBUTE15 
   FROM AR_BOE_REMIT_RECEIPTS_CBR_V 
  WHERE (BATCH_ID in( 8011,28066,12038,12037) )
    and (SELECTION_TYPE LIKE 'CURRENT_BATCH_REMITTED')

begin 
mo_global.init(p_appl_short_name => 'AR'); 
end;

 

select ba.bank_acct_use_id bank_account_id,
       bb.bank_name bank_name,
       bb.branch_number bank_number,
       cba.bank_account_num bank_account_number,
       cba.bank_account_name bank_account_name,
       cba.currency_code bank_account_currency,
       l1.meaning ||
       decode(crh.status,
              'CLEARED',
              decode(crh.factor_flag, 'Y', ' ' || l2.meaning, ''),
              '') status,
       cr.receipt_number receipt_number,
       to_char(ps.due_date, 'dd-mm-yyyy') maturity_date,
       rm.name payment_method,
       cr.currency_code currency_code,
       crh.amount amount,
       crh.acctd_amount func_amount
  from ar_lookups              l1,
       ar_lookups              l2,
       ar_payment_schedules    ps,
       ar_cash_receipts        cr,
       ar_cash_receipt_history crh,
       ar_receipt_methods      rm,
       ce_bank_accounts        cba,
       ce_bank_acct_uses       ba,
       ce_bank_branches_v      bb
 where crh.cash_receipt_id = cr.cash_receipt_id
   and cr.cash_receipt_id = ps.cash_receipt_id(+)
   and cr.receipt_method_id = rm.receipt_method_id
   and cr.remit_bank_acct_use_id = ba.bank_acct_use_id(+)
   and ba.bank_account_id = cba.bank_account_id(+)
   and bb.branch_party_id = cba.bank_branch_id -- Bug 6925308 
   --and bb.bank_party_id = cba.bank_branch_id 
   and crh.status = l1.lookup_code
   and l1.lookup_type = 'RECEIPT_CREATION_STATUS'
   and l2.lookup_type = 'REMITTANCE_METHOD'
   and l2.lookup_code = 'FACTORING'
   and RECEIPT_NUMBER IN ('20391021-1')
   --and crh.cash_receipt_history_id > :MAX_CRH_ID 
 order by bb.bank_name,
          cba.bank_account_num,
          crh.status,
          decode(crh.factor_flag, 'Y', 1, 'N', 2),
          cr.currency_code,
          cr.receipt_number