DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_RECEIPTS_ALL

Line 898: UPDATE ar_cash_receipts_all cr

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)