DBA Data[Home] [Help]

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_AUTO_RULE_SETS

Line 779: ar_cash_auto_rule_sets aca,

775: SET cri.receipt_reference_status = 'AR_AA_RULE_SET_INACTIVE'
776: WHERE cri.cash_receipt_id IN (
777: SELECT distinct cr.cash_receipt_id
778: FROM ar_cash_remit_refs_interim cri1,
779: ar_cash_auto_rule_sets aca,
780: ar_cash_receipts cr
781: WHERE cr.cash_receipt_id = cri1.cash_receipt_id
782: AND cr.automatch_set_id = aca.automatch_set_id
783: AND (cr.receipt_date < NVL(aca.start_date, cr.receipt_date)

Line 901: FROM ar_cash_auto_rule_sets

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)
903: WHERE cash_receipt_id IN
904: (SELECT distinct cash_receipt_id
905: FROM ar_cash_remit_refs_interim cri