APPS.JL_CMERGE dependencies on RA_CUSTOMER_MERGES

Line 54: FROM JL_BR_AR_BANK_RETURNS yt, ra_customer_merges m

50: CURSOR merged_records IS
51: SELECT distinct CUSTOMER_MERGE_HEADER_ID
52: ,RETURN_ID
53: ,yt.CUSTOMER_ID
54: FROM JL_BR_AR_BANK_RETURNS yt, ra_customer_merges m
55: WHERE (
56: yt.CUSTOMER_ID = m.DUPLICATE_ID
57: ) AND m.process_flag = 'N'
58: AND m.request_id = req_id

Line 196: FROM JL_BR_AR_OCCURRENCE_DOCS yt, ra_customer_merges m

192: SELECT distinct CUSTOMER_MERGE_HEADER_ID
193: ,OCCURRENCE_ID
194: ,yt.CUSTOMER_ID
195: ,yt.SITE_USE_ID
196: FROM JL_BR_AR_OCCURRENCE_DOCS yt, ra_customer_merges m
197: WHERE (
198: yt.CUSTOMER_ID = m.DUPLICATE_ID
199: OR yt.SITE_USE_ID = m.DUPLICATE_SITE_ID
200: ) AND m.process_flag = 'N'

Line 339: FROM JL_BR_AR_PAY_SCHED_AUX yt, ra_customer_merges m

335: CURSOR merged_records IS
336: SELECT distinct CUSTOMER_MERGE_HEADER_ID
337: ,PAYMENT_SCHEDULE_ID
338: ,yt.CUSTOMER_SITE_USE_ID
339: FROM JL_BR_AR_PAY_SCHED_AUX yt, ra_customer_merges m
340: WHERE (
341: yt.CUSTOMER_SITE_USE_ID = m.DUPLICATE_SITE_ID
342: ) AND m.process_flag = 'N'
343: AND m.request_id = req_id

Line 618: FROM JL_BR_JOURNALS_ALL yt, ra_customer_merges m

614: ,period_set_name
615: ,period_name
616: ,personnel_id
617: ,journal_balance_flag
618: FROM JL_BR_JOURNALS_ALL yt, ra_customer_merges m
619: WHERE yt.PERSONNEL_ID = m.duplicate_id
620: AND m.process_flag = 'N'
621: AND m.request_id = req_id
622: AND m.set_number = set_num

Line 630: -- FROM ra_customer_merges m

626: -- CURSOR c1 IS
627: -- SELECT SET_OF_BOOKS_ID
628: -- FROM jl_br_journals_all
629: -- WHERE (personnel_id) IN (SELECT unique m.duplicate_id
630: -- FROM ra_customer_merges m
631: -- WHERE m.process_flag = 'N'
632: -- AND m.request_id = req_id
633: -- AND m.set_number = set_num)
634: -- AND application_id=222

Line 662: FROM ra_customer_merges m

658: --customer level update--
659: /*
660: UPDATE jl_br_journals_all j
661: SET personnel_id = (SELECT distinct m.customer_id
662: FROM ra_customer_merges m
663: WHERE j.personnel_id = m.duplicate_id
664: AND m.process_flag = 'N'
665: AND m.request_id = req_id
666: AND m.set_number = set_num),

Line 672: FROM ra_customer_merges m

668: last_updated_by = arp_standard.profile.user_id,
669: last_update_login = arp_standard.profile.last_update_login,
670: JOURNAL_BALANCE_FLAG = 'N'
671: WHERE (personnel_id) IN (SELECT unique m.duplicate_id
672: FROM ra_customer_merges m
673: WHERE m.process_flag = 'N'
674: AND m.request_id = req_id
675: AND m.set_number = set_num)
676: AND application_id=222;

Line 839: FROM ra_customer_merges m

835: CURSOR c1 IS
836: SELECT SET_OF_BOOKS_ID
837: FROM jl_br_balances_all
838: WHERE (personnel_id) IN (SELECT unique m.duplicate_id
839: FROM ra_customer_merges m
840: WHERE m.process_flag = 'N'
841: AND m.request_id = req_id
842: AND m.set_number = set_num)
843: AND application_id=222

Line 933: ra_customer_merges m

929: ,yt.ending_balance_sign
930: ,yt.period_year
931: ,yt.period_num
932: FROM JL_BR_BALANCES_ALL yt,
933: ra_customer_merges m
934: WHERE (yt.personnel_id = m.duplicate_id)
935: AND m.process_flag = 'N'
936: AND m.request_id = req_id
937: AND m.set_number = set_num

Line 1029: FROM ra_customer_merges m

1025:
1026:
1027: CURSOR c_customer IS
1028: SELECT unique m.customer_id
1029: FROM ra_customer_merges m
1030: WHERE m.process_flag = 'N'
1031: AND m.request_id = req_id
1032: AND m.set_number = set_num;
1033:

Line 1543: FROM ra_customer_merges m

1539:
1540: /*
1541: delete jl_br_balances_all
1542: where (personnel_id) IN (SELECT unique m.duplicate_id
1543: FROM ra_customer_merges m
1544: WHERE m.process_flag = 'N'
1545: AND m.request_id = req_id
1546: AND m.set_number = set_num)
1547: AND application_id=222;