APPS.ARP_AUTOAPPLY_API dependencies on AR_CASH_AUTOMATCH_RULE_MAP

Line 975: AR_CASH_AUTOMATCH_RULE_MAP acm

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'
979: ORDER BY acm.priority;

Line 1231: ar_cash_automatch_rule_map amp,

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,
1235: ra_customer_trx trx,

Line 1478: ar_cash_automatch_rule_map amp,

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,
1482: ar_payment_schedules ps,

Line 1719: ar_cash_automatch_rule_map amp,

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,
1723: ar_payment_schedules ps,

Line 1963: ar_cash_automatch_rule_map amp,

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,
1967: ar_payment_schedules ps,

Line 2210: ar_cash_automatch_rule_map amp,

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,
2214: ar_payment_schedules ps,

Line 2471: ar_cash_automatch_rule_map amp,

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,
2475: ar_payment_schedules ps,

Line 2692: ar_cash_automatch_rule_map amp,

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,
2696: ar_payment_schedules ps,

Line 2938: ar_cash_automatch_rule_map amp,

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,
2942: ra_customer_trx trx,