894:
895: /* * If a receipt has any unapplied remittance line, update the *
896: * receipt work_item_exception_reason with the exception reason *
897: * defined at the AutoMatchRule Setup * */
898: UPDATE ar_cash_receipts_all cr
899: SET WORK_ITEM_EXCEPTION_REASON =
900: (SELECT exception_reason
901: FROM ar_cash_auto_rule_sets
902: WHERE automatch_set_id = cr.automatch_set_id)