APPS.ARP_CMERGE_ARTRX dependencies on RA_CUSTOMER_MERGES

Line 43: FROM AR_CASH_RECEIPTS yt, ra_customer_merges m

39: SELECT distinct CUSTOMER_MERGE_HEADER_ID
40: ,cash_receipt_id
41: ,pay_from_customer
42: ,customer_site_use_id
43: FROM AR_CASH_RECEIPTS yt, ra_customer_merges m
44: WHERE ( (yt.pay_from_customer = m.DUPLICATE_ID AND
45: nvl(yt.customer_site_use_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID))
46: AND m.process_flag = 'N'
47: AND m.request_id = req_id

Line 174: FROM AR_PAYMENT_SCHEDULES yt, ra_customer_merges m

170: SELECT distinct CUSTOMER_MERGE_HEADER_ID
171: ,payment_schedule_id
172: ,yt.customer_id
173: ,customer_site_use_id
174: FROM AR_PAYMENT_SCHEDULES yt, ra_customer_merges m
175: WHERE ( yt.customer_id = m.DUPLICATE_ID AND
176: nvl(yt.customer_site_use_id, m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID)
177: AND m.process_flag = 'N'
178: AND m.request_id = req_id

Line 347: FROM RA_CUSTOMER_TRX yt, ra_customer_merges m

343: ,ship_to_customer_id
344: ,ship_to_site_use_id
345: ,sold_to_customer_id
346: ,sold_to_site_use_id
347: FROM RA_CUSTOMER_TRX yt, ra_customer_merges m
348: WHERE ( (yt.bill_to_customer_id = m.DUPLICATE_ID AND
349: yt.bill_to_site_use_id = m.DUPLICATE_SITE_ID)
350: OR (yt.paying_customer_id = m.DUPLICATE_ID AND
351: yt.paying_site_use_id = m.DUPLICATE_SITE_ID)

Line 570: RA_CUSTOMER_MERGES.CUSTOMER_REF%TYPE

566:
567: /* Bug3500125 : Added following table type and added CUSTOMER_REF to CURSOR merged_records*/
568:
569: TYPE CUSTOMER_REF_LIST_TYPE IS TABLE OF
570: RA_CUSTOMER_MERGES.CUSTOMER_REF%TYPE
571: INDEX BY BINARY_INTEGER;
572: VCHAR_COL6_ORIG_LIST CUSTOMER_REF_LIST_TYPE;
573: VCHAR_COL6_NEW_LIST CUSTOMER_REF_LIST_TYPE;
574:

Line 577: FTS on table ra_customer_merges */

573: VCHAR_COL6_NEW_LIST CUSTOMER_REF_LIST_TYPE;
574:
575: /*Additional change for ra_interface_lines under bug2447449*/
576: /* bug3667197: Modified the where clause of cursor merged_records to avoid
577: FTS on table ra_customer_merges */
578: /* bug4075234: Replaced 'exists' clause in CURSOR merged_records with 'IN' for performance
579: improvement */
580: l_profile_val VARCHAR2(30);
581:

Line 597: ra_customer_merges m

593: ,ORIG_SYSTEM_BILL_ADDRESS_REF
594: ,ORIG_SYSTEM_SHIP_ADDRESS_REF
595: ,m.CUSTOMER_REF
596: from ra_interface_lines rai,
597: ra_customer_merges m
598: where nvl(rai.interface_status,'N') <> 'P' /* bug 1611619 : check interface_status */
599: and (
600: m.duplicate_id = rai.orig_system_bill_customer_id
601: or (m.duplicate_ref = rai.orig_system_bill_customer_ref)

Line 834: FROM AR_DISTRIBUTIONS yt, ra_customer_merges m

830: SELECT distinct CUSTOMER_MERGE_HEADER_ID
831: ,line_id
832: ,third_party_id
833: ,third_party_sub_id
834: FROM AR_DISTRIBUTIONS yt, ra_customer_merges m
835: WHERE ( (yt.third_party_id = m.DUPLICATE_ID AND
836: nvl(yt.third_party_sub_id,m.DUPLICATE_SITE_ID) = m.DUPLICATE_SITE_ID))
837: AND m.process_flag = 'N'
838: AND m.request_id = req_id