eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_AUTOMATCHES

Line 13: TYPE l_processed_rules_tab IS TABLE OF AR_CASH_AUTOMATCHES.AUTOMATCH_ID%TYPE

9: g_next_reco_id NUMBER;
10: g_prev_reco_num NUMBER;
11: G_MAX_ARRAY_SIZE NUMBER := 1000;
12:
13: TYPE l_processed_rules_tab IS TABLE OF AR_CASH_AUTOMATCHES.AUTOMATCH_ID%TYPE
14: INDEX BY BINARY_INTEGER;
15: l_processed_rules l_processed_rules_tab;
16: g_reco_index NUMBER := 0;
17: reco_id_arr reco_id_tab;

Line 974: FROM AR_CASH_AUTOMATCHES aca,

970: CURSOR auto_rule_cursor(p_automatch_set_id IN NUMBER) IS
971: SELECT aca.automatch_id automatch_id,
972: aca.matching_option matching_option,
973: NVL(aca.use_matching_date, 'N') use_matching_date
974: FROM AR_CASH_AUTOMATCHES aca,
975: AR_CASH_AUTOMATCH_RULE_MAP acm
976: WHERE acm.automatch_set_id = p_automatch_set_id
977: AND aca.automatch_id = acm.automatch_id
978: AND NVL(aca.active_flag, 'N') = 'Y'

Line 1230: FROM ar_cash_automatches am,

1226: tr.partial_discount_flag partial_discount_flag,
1227: RANK() OVER (PARTITION BY ps.trx_number, ps.customer_site_use_id,
1228: ref.remit_reference_id, ps.customer_trx_id
1229: ORDER BY ps.payment_schedule_id) AS reco_num
1230: FROM ar_cash_automatches am,
1231: ar_cash_automatch_rule_map amp,
1232: ar_cash_remit_refs_interim ref,
1233: ar_cash_receipts cr,
1234: ar_payment_schedules ps,

Line 1477: FROM ar_cash_automatches am,

1473: tr.partial_discount_flag partial_discount_flag,
1474: RANK() OVER (PARTITION BY trx.purchase_order, ps.customer_site_use_id,
1475: ref.remit_reference_id, ps.customer_trx_id
1476: ORDER BY ps.payment_schedule_id) AS reco_num
1477: FROM ar_cash_automatches am,
1478: ar_cash_automatch_rule_map amp,
1479: ar_cash_remit_refs_interim ref,
1480: ar_cash_receipts cr,
1481: ra_customer_trx trx,

Line 1718: FROM ar_cash_automatches am,

1714: tr.partial_discount_flag partial_discount_flag,
1715: RANK() OVER (PARTITION BY lin.sales_order, ps.customer_site_use_id,
1716: ref.remit_reference_id, ps.customer_trx_id
1717: ORDER BY ps.payment_schedule_id) AS reco_num
1718: FROM ar_cash_automatches am,
1719: ar_cash_automatch_rule_map amp,
1720: ar_cash_remit_refs_interim ref,
1721: ar_cash_receipts cr,
1722: ra_customer_trx_lines lin,

Line 1962: FROM ar_cash_automatches am,

1958: tr.partial_discount_flag partial_discount_flag,
1959: RANK() OVER (PARTITION BY lin.sales_order, ps.customer_site_use_id,
1960: ref.remit_reference_id, ps.customer_trx_id
1961: ORDER BY ps.payment_schedule_id) AS reco_num
1962: FROM ar_cash_automatches am,
1963: ar_cash_automatch_rule_map amp,
1964: ar_cash_remit_refs_interim ref,
1965: ar_cash_receipts cr,
1966: ra_customer_trx_lines lin,

Line 2209: FROM ar_cash_automatches am,

2205: tr.partial_discount_flag partial_discount_flag,
2206: RANK() OVER (PARTITION BY trx.interface_header_attribute' || p_attribute_number ||', ps.customer_site_use_id,
2207: ref.remit_reference_id, ps.customer_trx_id
2208: ORDER BY ps.payment_schedule_id) AS reco_num
2209: FROM ar_cash_automatches am,
2210: ar_cash_automatch_rule_map amp,
2211: ar_cash_remit_refs_interim ref,
2212: ar_cash_receipts cr,
2213: ra_customer_trx trx,

Line 2470: FROM ar_cash_automatches am,

2466: tr.partial_discount_flag partial_discount_flag,
2467: RANK() OVER (PARTITION BY trx.waybill_number, ps.customer_site_use_id,
2468: ref.remit_reference_id, ps.customer_trx_id
2469: ORDER BY ps.payment_schedule_id) AS reco_num
2470: FROM ar_cash_automatches am,
2471: ar_cash_automatch_rule_map amp,
2472: ar_cash_remit_refs_interim ref,
2473: ar_cash_receipts cr,
2474: ra_customer_trx trx,

Line 2691: FROM ar_cash_automatches am,

2687: ctt.allow_overapplication_flag allow_overapplication_flag,
2688: tr.partial_discount_flag partial_discount_flag,
2689: RANK() OVER (PARTITION BY ci.cons_billing_number, ci.site_use_id, ref.remit_reference_id
2690: ORDER BY ps.due_date, ps.payment_schedule_id) AS reco_num
2691: FROM ar_cash_automatches am,
2692: ar_cash_automatch_rule_map amp,
2693: ar_cash_remit_refs_interim ref,
2694: ar_cash_receipts cr,
2695: ar_cons_inv ci,

Line 2937: FROM ar_cash_automatches am,

2933: tr.partial_discount_flag partial_discount_flag,
2934: RANK() OVER (PARTITION BY trx.ct_reference, ps.customer_site_use_id,
2935: ref.remit_reference_id, ps.customer_trx_id
2936: ORDER BY ps.payment_schedule_id) AS reco_num
2937: FROM ar_cash_automatches am,
2938: ar_cash_automatch_rule_map amp,
2939: ar_cash_remit_refs_interim ref,
2940: ar_cash_receipts cr,
2941: ar_payment_schedules ps,

Line 3132: FROM ar_cash_automatches am,

3128: SET rec.match_reason_code = 'AR_AA_DATE_MISMATCH'
3129: WHERE rec.request_id = p_req_id
3130: AND match_reason_code = 'AR_AM_INV_THRESHOLD'
3131: AND EXISTS ( SELECT 'Date Not Matching'
3132: FROM ar_cash_automatches am,
3133: ar_cash_remit_refs_interim ref
3134: WHERE am.automatch_id = rec.automatch_id
3135: AND ref.remit_reference_id = rec.remit_reference_id
3136: AND am.use_matching_date = 'ALWAYS'

Line 3163: ar_cash_automatches am,

3159: WHERE rec.request_id = p_req_id
3160: AND match_reason_code = 'AR_AM_INV_THRESHOLD'
3161: AND EXISTS ( SELECT ref.remit_reference_id
3162: FROM ar_cash_reco_lines lin,
3163: ar_cash_automatches am,
3164: ar_cash_remit_refs_interim ref
3165: WHERE lin.request_id = p_req_id
3166: AND am.automatch_id = rec.automatch_id
3167: AND am.use_matching_amount = 'ALWAYS'

Line 3348: ar_cash_automatches am

3344: AND trunc(rec1.resolved_matching_date) = (SELECT decode(am.use_matching_date,
3345: 'DUPLICATE', nvl(ref.matching_reference_date, rec1.resolved_matching_date),
3346: rec1.resolved_matching_date)
3347: FROM ar_cash_remit_refs_interim ref,
3348: ar_cash_automatches am
3349: WHERE ref.worker_number = p_worker_number
3350: AND ref.remit_reference_id = rec1.remit_reference_id
3351: AND am.automatch_id = rec1.automatch_id)
3352: AND EXISTS ( SELECT ref.remit_reference_id

Line 3354: ar_cash_automatches am,

3350: AND ref.remit_reference_id = rec1.remit_reference_id
3351: AND am.automatch_id = rec1.automatch_id)
3352: AND EXISTS ( SELECT ref.remit_reference_id
3353: FROM ar_cash_reco_lines lin,
3354: ar_cash_automatches am,
3355: ar_cash_remit_refs_interim ref
3356: WHERE lin.request_id = p_req_id
3357: AND am.automatch_id = rec.automatch_id
3358: AND am.use_matching_amount = 'DUPLICATE'

Line 3411: ar_cash_automatches am,

3407: am.use_matching_amount
3408: FROM ar_cash_recos rec,
3409: ar_cash_reco_lines lin,
3410: ar_cash_remit_refs_interim ref,
3411: ar_cash_automatches am,
3412: ar_payment_schedules ps
3413: WHERE rec.request_id = p_req_id
3414: AND rec.match_reason_code = 'AR_AA_DUPLICATE_RECOS'
3415: AND ref.remit_reference_id = rec.remit_reference_id

Line 4108: l_use_matching_date AR_CASH_AUTOMATCHES.use_matching_date%TYPE;

4104: , p_match_resolved_using IN VARCHAR2) IS
4105: l_block_index NUMBER;
4106: l_recommendation_id NUMBER;
4107: l_recommendation_reason VARCHAR2(30);
4108: l_use_matching_date AR_CASH_AUTOMATCHES.use_matching_date%TYPE;
4109: l_use_matching_amount AR_CASH_AUTOMATCHES.use_matching_amount%TYPE;
4110: l_ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE;
4111: l_ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE;
4112: l_ref_orig_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;

Line 4109: l_use_matching_amount AR_CASH_AUTOMATCHES.use_matching_amount%TYPE;

4105: l_block_index NUMBER;
4106: l_recommendation_id NUMBER;
4107: l_recommendation_reason VARCHAR2(30);
4108: l_use_matching_date AR_CASH_AUTOMATCHES.use_matching_date%TYPE;
4109: l_use_matching_amount AR_CASH_AUTOMATCHES.use_matching_amount%TYPE;
4110: l_ref_amount_applied AR_CASH_REMIT_REFS.amount_applied%TYPE;
4111: l_ref_amount_applied_from AR_CASH_REMIT_REFS.amount_applied_from%TYPE;
4112: l_ref_orig_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;
4113: l_ref_rem_amount AR_CASH_REMIT_REFS.amount_applied%TYPE;