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_CMERGE_ARCUS dependencies on RA_CUSTOMER_MERGES

Line 285: FROM hz_cust_site_uses_all cust, ra_customer_merges merge --SSUptake

281: CURSOR c1 IS
282: SELECT merge.duplicate_site_id,merge.customer_site_id,
283: cust.bill_to_site_use_id,merge.duplicate_site_code,
284: merge.customer_createsame,cust.org_id --SSUptake
285: FROM hz_cust_site_uses_all cust, ra_customer_merges merge --SSUptake
286: WHERE merge.request_id = req_id
287: AND merge.set_number = set_num
288: AND merge.process_flag = 'N'
289: AND cust.site_use_id = merge.duplicate_site_id

Line 314: from ra_customer_merges

310: IF l_site_use_code = 'SHIP_TO' and l_create_same_site = 'Y' THEN
311: IF l_bill_to_site_use_id IS NOT NULL THEN
312: BEGIN
313: select customer_site_id into l_ra_bill_to_site_use_id
314: from ra_customer_merges
315: where duplicate_site_id = l_bill_to_site_use_id
316: and process_flag = 'N'
317: and request_id = req_id
318: and set_number = set_num;

Line 343: FROM ra_customer_merges merge

339: AND su.site_use_code='SHIP_TO'
340: AND su.bill_to_site_use_id = l_dup_site_id
341: AND site.cust_account_id in (
342: SELECT unique(customer_id)
343: FROM ra_customer_merges merge
344: WHERE merge.process_flag = 'N'
345: and merge.request_id = req_id
346: and merge.set_number = set_num
347: and merge.org_id = site.org_id --SSUptake

Line 354: from ra_customer_merges merge

350: FROM hz_cust_acct_relate_all rel --SSUptake
351: WHERE rel.org_id = l_org_id --SSUptake
352: AND rel.cust_account_id in (
353: select unique(customer_id)
354: from ra_customer_merges merge
355: where merge.process_flag = 'N'
356: and merge.request_id = req_id
357: and merge.set_number = set_num
358: and merge.org_id = rel.org_id ) --SSUptake

Line 426: FROM hz_cust_site_uses_all su, ra_customer_merges m --SSUptake

422: x_to_site_id NUMBER;
423:
424: CURSOR c1 IS
425: SELECT site_use_id
426: FROM hz_cust_site_uses_all su, ra_customer_merges m --SSUptake
427: WHERE m.request_id = req_id
428: AND m.process_flag = 'N'
429: AND m.set_number = set_num
430: AND m.org_id = su.org_id --SSUptake

Line 437: FROM ra_customer_merges m

433:
434:
435: CURSOR c2 is
436: SELECT distinct(m.customer_site_id), m.duplicate_site_id
437: FROM ra_customer_merges m
438: WHERE m.process_flag = 'N'
439: AND m.request_id = req_id
440: AND m.set_number = set_num
441: AND (m.delete_duplicate_flag = 'N' OR m.delete_duplicate_flag = 'Y');

Line 476: FROM ra_customer_merges m

472: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
473: program_update_date = sysdate
474: WHERE EXISTS (
475: SELECT 'Y'
476: FROM ra_customer_merges m
477: WHERE m.duplicate_site_id = yt.site_use_id
478: AND m.org_id = yt.org_id
479: AND m.process_flag = 'N'
480: AND m.request_id = req_id

Line 509: FROM ra_customer_merges m

505: program_id = arp_standard.profile.program_id,
506: program_update_date = sysdate
507: WHERE cust_acct_site_id IN (
508: SELECT m.duplicate_address_id
509: FROM ra_customer_merges m
510: WHERE m.process_flag = 'N'
511: AND m.request_id = req_id
512: AND m.set_number = set_num
513: AND m.delete_duplicate_flag = 'N' )

Line 542: FROM ra_customer_merges m

538: UPDATE HZ_CUST_SITE_USES_ALL yt
539: SET status = 'D'
540: WHERE EXISTS (
541: SELECT 'Y'
542: FROM ra_customer_merges m
543: WHERE m.duplicate_site_id = yt.site_use_id
544: AND m.org_id = yt.org_id
545: AND m.process_flag = 'N'
546: AND m.request_id = req_id

Line 568: FROM ra_customer_merges m

564: UPDATE HZ_CUST_SITE_USES su1
565: SET status = 'D'
566: WHERE cust_acct_site_id IN (
567: SELECT m.duplicate_address_id
568: FROM ra_customer_merges m
569: WHERE m.process_flag = 'N'
570: AND m.request_id = req_id
571: AND m.set_number = set_num
572: AND m.delete_duplicate_flag = 'Y' )

Line 692: FROM hz_cust_acct_sites_all yt, ra_customer_merges m --SSUptake

688:
689: --cursor c1 is used in 'inactivate' mode.
690: CURSOR c1 IS
691: SELECT yt.cust_acct_site_id
692: FROM hz_cust_acct_sites_all yt, ra_customer_merges m --SSUptake
693: WHERE yt.cust_acct_site_id = m.duplicate_address_id
694: AND m.org_id = yt.org_id --SSUptake
695: AND m.request_id = req_id
696: AND m.process_flag = 'N'

Line 710: FROM hz_cust_acct_sites_all yt, ra_customer_merges m --SSUptake

706:
707: --cursor c2 is used in 'delete' mode.
708: CURSOR c2 IS
709: SELECT yt.cust_acct_site_id
710: FROM hz_cust_acct_sites_all yt, ra_customer_merges m --SSUptake
711: WHERE m.request_id = req_id
712: AND m.process_flag = 'N'
713: AND m.set_number = set_num
714: AND m.delete_duplicate_flag = 'Y'

Line 727: FROM ra_customer_merges m

723: FOR UPDATE NOWAIT;
724:
725: cursor c3 is
726: SELECT distinct(m.customer_address_id), m.duplicate_address_id
727: FROM ra_customer_merges m
728: WHERE m.process_flag = 'N'
729: AND m.request_id = req_id
730: AND m.set_number = set_num
731: AND (m.delete_duplicate_flag = 'N' or m.delete_duplicate_flag = 'Y') --5571559

Line 776: FROM ra_customer_merges m

772: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
773: program_update_date = sysdate
774: WHERE EXISTS (
775: SELECT 'Y'
776: FROM ra_customer_merges m
777: WHERE m.process_flag = 'N'
778: AND m.request_id = req_id
779: AND m.set_number = set_num
780: AND m.delete_duplicate_flag = 'N'

Line 811: FROM ra_customer_merges m

807: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
808: program_update_date = sysdate
809: WHERE EXISTS (
810: SELECT 'Y'
811: FROM ra_customer_merges m
812: WHERE m.process_flag = 'N'
813: AND m.request_id = req_id
814: AND m.set_number = set_num
815: AND m.duplicate_address_id = yt.cust_acct_site_id

Line 848: FROM ra_customer_merges m

844: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
845: program_update_date = sysdate
846: WHERE EXISTS (
847: SELECT 'Y'
848: FROM ra_customer_merges m
849: WHERE m.process_flag = 'N'
850: AND m.request_id = req_id
851: AND m.set_number = set_num
852: AND m.delete_duplicate_flag = 'N'

Line 885: FROM ra_customer_merges m

881: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
882: program_update_date = sysdate
883: WHERE EXISTS (
884: SELECT 'Y'
885: FROM ra_customer_merges m
886: WHERE m.process_flag = 'N'
887: AND m.request_id = req_id
888: AND m.set_number = set_num
889: AND m.delete_duplicate_flag = 'N'

Line 920: FROM ra_customer_merges m

916: UPDATE HZ_CUST_ACCT_SITES_ALL yt --SSUptake
917: SET status = 'D'
918: WHERE EXISTS (
919: SELECT 'Y'
920: FROM ra_customer_merges m
921: WHERE m.process_flag = 'N'
922: AND m.request_id = req_id
923: AND m.set_number = set_num
924: AND m.delete_duplicate_flag = 'Y'

Line 1047: FROM hz_cust_accounts yt, ra_customer_merges m

1043:
1044: --cursor c1 is used in 'inactivate' mode.
1045: CURSOR c1 IS
1046: SELECT yt.cust_account_id
1047: FROM hz_cust_accounts yt, ra_customer_merges m
1048: WHERE cust_account_id = m.duplicate_id
1049: AND m.process_flag = 'N'
1050: AND m.request_id = req_id
1051: AND m.set_number = set_num

Line 1064: FROM hz_cust_accounts yt, ra_customer_merges m

1060:
1061: --cursor c2 is used in 'delete' mode.
1062: CURSOR c2 IS
1063: SELECT cust_account_id
1064: FROM hz_cust_accounts yt, ra_customer_merges m
1065: WHERE cust_account_id = m.duplicate_id
1066: AND m.process_flag = 'N'
1067: AND m.request_id = req_id
1068: AND m.set_number = set_num

Line 1080: FROM ra_customer_merges m

1076: FOR UPDATE NOWAIT;
1077:
1078: cursor c3 is
1079: SELECT distinct(m.customer_id), m.duplicate_id
1080: FROM ra_customer_merges m
1081: WHERE m.process_flag = 'N'
1082: AND m.request_id =req_id
1083: AND m.set_number = set_num
1084: AND (m.delete_duplicate_flag = 'N' OR m.delete_duplicate_flag = 'Y')

Line 1128: FROM ra_customer_merges m

1124: program_id = hz_utility_v2pub.program_id,--arp_standard.profile.program_id,
1125: program_update_date = sysdate
1126: WHERE cust_account_id IN (
1127: SELECT m.duplicate_id
1128: FROM ra_customer_merges m
1129: WHERE m.process_flag = 'N'
1130: AND m.request_id = req_id
1131: AND m.set_number = set_num
1132: AND m.delete_duplicate_flag = 'N' )

Line 1159: FROM ra_customer_merges m

1155: UPDATE HZ_CUST_ACCOUNTS yt
1156: SET status = 'D'
1157: WHERE cust_account_id IN (
1158: SELECT m.duplicate_id
1159: FROM ra_customer_merges m
1160: WHERE m.process_flag = 'N'
1161: AND m.request_id = req_id
1162: AND m.set_number = set_num
1163: AND m.delete_duplicate_flag = 'Y' )

Line 1281: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake

1277:
1278: --cursor c1 is for from cust account
1279: CURSOR c1 IS
1280: SELECT yt.cust_account_id
1281: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake
1282: WHERE
1283: --NOT EXISTS (
1284: -- SELECT 'active accounts exist'
1285: -- FROM hz_cust_accounts acct

Line 1298: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake

1294:
1295: --cursor c2 is for to cust account
1296: CURSOR c2 IS
1297: SELECT yt.related_cust_account_id
1298: FROM hz_cust_acct_relate_all yt, ra_customer_merges m --SSUptake
1299: WHERE
1300: --NOT EXISTS (
1301: -- SELECT 'active accounts exist'
1302: -- FROM hz_cust_accounts acct

Line 1318: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm

1314: CURSOR c_from_rel_cust_id IS
1315: SELECT unique yt.cust_acct_relate_id,cm.customer_id,yt.cust_account_id,yt.related_cust_account_id,
1316: yt.customer_reciprocal_flag,nvl(yt.bill_to_flag,'N') bill_to_flag,
1317: nvl(yt.ship_to_flag,'N') ship_to_flag,yt.rowid,yt.org_id
1318: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm
1319: WHERE cm.request_id = req_id
1320: AND cm.process_flag = 'N'
1321: AND cm.set_number = set_num
1322: AND cm.duplicate_id <> cm.customer_id --merging sites for same customer

Line 1331: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm

1327: CURSOR c_from_cust_rel_id IS
1328: SELECT unique yt.cust_acct_relate_id,cm.customer_id,yt.cust_account_id,yt.related_cust_account_id,
1329: yt.customer_reciprocal_flag,nvl(yt.bill_to_flag,'N') bill_to_flag,
1330: nvl(yt.ship_to_flag,'N') ship_to_flag,yt.rowid,yt.org_id
1331: FROM hz_cust_acct_relate_all yt, ra_customer_merges cm
1332: WHERE cm.request_id = req_id
1333: AND cm.process_flag = 'N'
1334: AND cm.set_number = set_num
1335: AND cm.duplicate_id <> cm.customer_id --merging sites for same customer

Line 1529: FROM ra_customer_merges m

1525: program_id = arp_standard.profile.program_id,
1526: program_update_date = sysdate
1527: WHERE EXISTS (
1528: SELECT 'relationship to self not allowed'
1529: FROM ra_customer_merges m
1530: WHERE m.customer_id = yt.related_cust_account_id
1531: AND m.duplicate_id = yt.cust_account_id
1532: AND m.process_flag = 'N'
1533: AND m.request_id = req_id

Line 1539: FROM ra_customer_merges m

1535: AND m.org_id = yt.org_id
1536: AND m.delete_duplicate_flag = 'N' )
1537: OR EXISTS (
1538: SELECT 'relationship to self not allowed'
1539: FROM ra_customer_merges m
1540: WHERE m.customer_id = yt.cust_account_id
1541: AND m.duplicate_id = yt.related_cust_account_id
1542: AND m.process_flag = 'N'
1543: AND m.request_id = req_id

Line 1561: FROM RA_CUSTOMER_MERGES M

1557: WHERE (RELATED_CUST_ACCOUNT_ID,CUST_ACCOUNT_ID,ORG_ID ) IN
1558: (SELECT CUSTOMER_ID,
1559: DUPLICATE_ID,
1560: ORG_ID
1561: FROM RA_CUSTOMER_MERGES M
1562: WHERE M.PROCESS_FLAG = 'N'
1563: AND M.REQUEST_ID = req_id
1564: AND M.SET_NUMBER = set_num
1565: AND M.DELETE_DUPLICATE_FLAG = 'N' );

Line 1582: FROM RA_CUSTOMER_MERGES M

1578: WHERE (CUST_ACCOUNT_ID,RELATED_CUST_ACCOUNT_ID,ORG_ID ) IN
1579: (SELECT CUSTOMER_ID,
1580: DUPLICATE_ID,
1581: ORG_ID
1582: FROM RA_CUSTOMER_MERGES M
1583: WHERE M.PROCESS_FLAG = 'N'
1584: AND M.REQUEST_ID = req_id
1585: AND M.SET_NUMBER = set_num
1586: AND M.DELETE_DUPLICATE_FLAG = 'N' );

Line 1618: FROM ra_customer_merges m

1614: -- WHERE acct.cust_account_id = yt.cust_account_id
1615: -- AND acct.status <> 'D' )
1616: EXISTS ( --SSUptake
1617: SELECT 'Y'
1618: FROM ra_customer_merges m
1619: WHERE m.duplicate_id = yt.cust_account_id
1620: AND m.process_flag = 'N'
1621: AND m.request_id = req_id
1622: AND m.set_number = set_num

Line 1628: ra_customer_merges m

1624: AND m.org_id = yt.org_id ) --SSUptake
1625: AND ( EXISTS (
1626: SELECT 'relationship already exists, cannot update'
1627: FROM HZ_CUST_ACCT_RELATE_ALL r, --SSUptake
1628: ra_customer_merges m
1629: WHERE m.customer_id = r.cust_account_id
1630: AND m.duplicate_id = yt.cust_account_id
1631: AND r.related_cust_account_id = yt.related_cust_account_id
1632: AND r.org_id = yt.org_id --SSUptake

Line 1640: FROM ra_customer_merges m

1636: AND m.delete_duplicate_flag = 'Y'
1637: AND m.org_id = r.org_id ) --SSUptake
1638: OR EXISTS (
1639: SELECT 'relationship to self not allowed'
1640: FROM ra_customer_merges m
1641: WHERE m.customer_id = yt.related_cust_account_id
1642: AND m.duplicate_id = yt.cust_account_id
1643: AND m.process_flag = 'N'
1644: AND m.request_id = req_id

Line 1651: from ra_customer_merges m

1647: AND m.org_id = yt.org_id ) ) --SSUptake
1648: --Bug fix 2909303
1649: AND NOT EXISTS(
1650: select 'merging sites for same customer, cannot update'
1651: from ra_customer_merges m
1652: where m.duplicate_id = m.customer_id
1653: and m.duplicate_id = yt.cust_account_id
1654: AND m.process_flag = 'N'
1655: AND m.request_id = req_id

Line 1679: FROM ra_customer_merges m

1675: -- WHERE acct.cust_account_id = yt.related_cust_account_id
1676: -- AND acct.status <> 'D' )
1677: EXISTS (
1678: SELECT 'Y'
1679: FROM ra_customer_merges m
1680: WHERE yt.related_cust_account_id = m.duplicate_id
1681: AND m.org_id = yt.org_id --SSUptake
1682: AND m.process_flag = 'N'
1683: AND m.request_id = req_id

Line 1689: ra_customer_merges m

1685: AND m.delete_duplicate_flag = 'Y')
1686: AND ( EXISTS (
1687: SELECT 'relationship already exists, cannot update'
1688: FROM HZ_CUST_ACCT_RELATE_ALL r,
1689: ra_customer_merges m
1690: WHERE m.customer_id = r.related_cust_account_id
1691: AND m.duplicate_id = yt.related_cust_account_id
1692: AND r.cust_account_id = yt.cust_account_id
1693: AND r.org_id = yt.org_id --SSUptake

Line 1701: FROM ra_customer_merges m

1697: AND m.set_number = set_num
1698: AND m.delete_duplicate_flag = 'Y')--SSUptake
1699: OR EXISTS (
1700: SELECT 'relationship to self not allowed'
1701: FROM ra_customer_merges m
1702: WHERE m.customer_id = yt.cust_account_id
1703: AND m.duplicate_id = yt.related_cust_account_id
1704: AND m.org_id = yt.org_id --SSUptake
1705: AND m.process_flag = 'N'

Line 1712: from ra_customer_merges m

1708: AND m.delete_duplicate_flag = 'Y' ) )
1709: --Bug fix 2909303
1710: AND NOT EXISTS(
1711: select 'merging sites for same customer, cannot update'
1712: from ra_customer_merges m
1713: where m.duplicate_id = m.customer_id
1714: and m.duplicate_id = yt.related_cust_account_id
1715: AND m.org_id = yt.org_id --SSUptake
1716: AND m.process_flag = 'N'

Line 1796: FROM RA_CUST_RECEIPT_METHODS ra, ra_customer_merges m

1792:
1793: --cursor c1 and c2 are used in 'inactivate' mode
1794: CURSOR c1 IS
1795: SELECT CUST_RECEIPT_METHOD_ID
1796: FROM RA_CUST_RECEIPT_METHODS ra, ra_customer_merges m
1797: WHERE ra.customer_id = m.duplicate_id
1798: AND site_use_id = m.duplicate_site_id
1799: AND m.process_flag = 'N'
1800: AND m.request_id = req_id

Line 1807: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1803: FOR UPDATE NOWAIT;
1804:
1805: CURSOR c2 IS
1806: SELECT CUST_RECEIPT_METHOD_ID
1807: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1808: WHERE yt.customer_id = m.duplicate_id
1809: AND m.process_flag = 'N'
1810: AND m.request_id = req_id
1811: AND m.set_number = set_num

Line 1821: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;

1817: WHERE acct.cust_account_id = yt.customer_id
1818: AND acct.status = 'A' )
1819: FOR UPDATE NOWAIT;
1820:
1821: TYPE customer_merge_header_id_tab IS TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1822: TYPE cust_receipt_method_id_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.CUST_RECEIPT_METHOD_ID%TYPE INDEX BY BINARY_INTEGER;
1823: TYPE end_date_tab IS TABLE OF RA_CUST_RECEIPT_METHODS.END_DATE%TYPE INDEX BY BINARY_INTEGER;
1824:
1825: header_id customer_merge_header_id_tab;

Line 1858: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1854: SELECT distinct CUSTOMER_MERGE_HEADER_ID,
1855: CUST_RECEIPT_METHOD_ID,
1856: END_DATE
1857: BULK COLLECT INTO header_id,receipt_id,end_date
1858: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1859: WHERE (yt.CUSTOMER_ID = m.DUPLICATE_ID
1860: AND ( ( yt.SITE_USE_ID IS NULL
1861: AND NOT EXISTS (
1862: SELECT 'active accounts exist'

Line 1956: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

1952: FROM (
1953: SELECT distinct CUSTOMER_MERGE_HEADER_ID,
1954: CUST_RECEIPT_METHOD_ID,
1955: END_DATE
1956: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
1957: WHERE (yt.CUSTOMER_ID = m.DUPLICATE_ID
1958: AND ( ( yt.SITE_USE_ID IS NULL
1959: AND NOT EXISTS (
1960: SELECT 'active accounts exist'

Line 1986: | FROM ra_customer_merges m

Line 2011: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h

2007: , PROGRAM_ID=arp_standard.profile.program_id
2008: , PROGRAM_UPDATE_DATE=SYSDATE
2009: WHERE (CUST_RECEIPT_METHOD_ID) in (
2010: SELECT PRIMARY_KEY_ID
2011: FROM HZ_CUSTOMER_MERGE_LOG l1, RA_CUSTOMER_MERGES h
2012: WHERE h.CUSTOMER_MERGE_HEADER_ID = l1.MERGE_HEADER_ID
2013: AND l1.TABLE_NAME = 'RA_CUST_RECEIPT_METHODS'
2014: AND l1.REQUEST_ID = req_id
2015: AND h.set_number = set_num);

Line 2056: | FROM ra_customer_merges m

Line 2135: FROM ra_customer_merges

2131: to_account_id NUMBER;
2132:
2133: CURSOR accounts IS
2134: SELECT DISTINCT duplicate_id, customer_id
2135: FROM ra_customer_merges
2136: WHERE process_flag = 'N'
2137: AND request_id = req_id
2138: AND set_number = set_num
2139: AND duplicate_id <> customer_id;

Line 2271: FROM ra_customer_merges

2267:
2268: CURSOR sites IS
2269: SELECT DISTINCT duplicate_id, customer_id,
2270: duplicate_address_id, customer_address_id
2271: FROM ra_customer_merges
2272: WHERE process_flag = 'N'
2273: AND request_id = req_id
2274: AND set_number = set_num
2275: AND duplicate_address_id <> -1; --4693912

Line 2386: FROM hz_cust_account_roles yt, ra_customer_merges m

2382: l_party_id HZ_CUST_ACCOUNT_ROLES.PARTY_ID%TYPE;
2383:
2384: CURSOR c1 IS
2385: SELECT cust_account_role_id
2386: FROM hz_cust_account_roles yt, ra_customer_merges m
2387: WHERE cust_acct_site_id = m.duplicate_address_id
2388: AND m.process_flag = 'N'
2389: AND m.request_id = req_id
2390: AND m.set_number = set_num

Line 2396: FROM hz_cust_account_roles yt, ra_customer_merges m

2392: FOR UPDATE NOWAIT;
2393:
2394: CURSOR c2 IS
2395: SELECT cust_account_role_id
2396: FROM hz_cust_account_roles yt, ra_customer_merges m
2397: WHERE cust_account_id = m.duplicate_id
2398: AND m.process_flag = 'N'
2399: AND m.request_id = req_id
2400: AND m.set_number = set_num

Line 2407: FROM HZ_CUST_ACCOUNT_ROLES yt,ra_customer_merges m,HZ_CUST_ACCOUNTS ca,hz_relationships rel

2403: FOR UPDATE NOWAIT;
2404: ----Bug No: 5067291
2405: CURSOR c3 is
2406: SELECT yt.party_id
2407: FROM HZ_CUST_ACCOUNT_ROLES yt,ra_customer_merges m,HZ_CUST_ACCOUNTS ca,hz_relationships rel
2408: WHERE m.customer_id=ca.cust_account_id
2409: AND m.duplicate_id = yt.cust_account_id
2410: AND rel.party_id = yt.party_id
2411: AND rel.subject_type = 'PERSON'

Line 2475: FROM ra_customer_merges m

2471:
2472: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2473: SET (cust_account_id, cust_acct_site_id) = (
2474: SELECT MIN(m.customer_id), MIN(m.customer_address_id)
2475: FROM ra_customer_merges m
2476: WHERE yt.cust_account_id = m.duplicate_id
2477: AND yt.cust_acct_site_id = m.duplicate_address_id
2478: AND m.request_id = req_id
2479: AND m.set_number = set_num

Line 2490: FROM ra_customer_merges m

2486: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2487: program_update_date = sysdate
2488: WHERE cust_acct_site_id IN (
2489: SELECT m.duplicate_address_id
2490: FROM ra_customer_merges m
2491: WHERE m.process_flag = 'N'
2492: AND m.request_id = req_id
2493: AND m.set_number = set_num )
2494: AND role_type = 'CONTACT'

Line 2510: FROM ra_customer_merges m

2506:
2507: UPDATE HZ_CUST_ACCOUNT_ROLES yt
2508: SET cust_account_id = (
2509: SELECT m.customer_id
2510: FROM ra_customer_merges m
2511: WHERE yt.cust_account_id = m.duplicate_id
2512: AND m.request_id = req_id
2513: AND m.process_flag = 'N'
2514: AND m.set_number = set_num

Line 2525: FROM ra_customer_merges m

2521: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2522: program_update_date = sysdate
2523: WHERE cust_account_id IN (
2524: SELECT m.duplicate_id
2525: FROM ra_customer_merges m
2526: WHERE m.process_flag = 'N'
2527: AND m.request_id = req_id
2528: AND m.set_number = set_num)
2529: AND cust_acct_site_id IS NULL

Line 2538: FROM hz_cust_account_roles r, ra_customer_merges m

2534: -- Start Bug 4712462
2535: FOR rec IN (
2536: SELECT min(cust_account_role_id) cust_account_role_id, cust_account_id,
2537: nvl(cust_acct_site_id,-1) cust_acct_site_id,party_id
2538: FROM hz_cust_account_roles r, ra_customer_merges m
2539: where m.request_id = req_id AND m.set_number = set_num
2540: AND r.cust_account_id = m.customer_id AND m.process_flag = 'N'
2541: GROUP BY cust_account_id,cust_acct_site_id,status,party_id
2542: HAVING NVL(STATUS,'A') ='A' AND count(1) > 1) LOOP

Line 2619: FROM hz_cust_contact_points yt, ra_customer_merges m

2615:
2616: --cursor c1 and c2 are used in 'inactivate' mode
2617: CURSOR c1 IS
2618: SELECT cust_contact_point_id
2619: FROM hz_cust_contact_points yt, ra_customer_merges m
2620: WHERE cust_account_site_id = m.duplicate_address_id
2621: AND m.process_flag = 'N'
2622: AND m.request_id = req_id
2623: AND m.set_number = set_num

Line 2628: FROM hz_cust_contact_points yt, ra_customer_merges m

2624: FOR UPDATE NOWAIT;
2625:
2626: CURSOR c2 is
2627: SELECT cust_contact_point_id
2628: FROM hz_cust_contact_points yt, ra_customer_merges m
2629: WHERE cust_account_id = m.duplicate_id
2630: AND m.process_flag = 'N'
2631: AND m.request_id = req_id
2632: AND m.set_number = set_num

Line 2662: FROM ra_customer_merges m

2658:
2659: UPDATE HZ_CUST_CONTACT_POINTS yt
2660: SET (cust_account_id, cust_account_site_id) = (
2661: SELECT min(m.customer_id), min(m.customer_address_id)
2662: FROM ra_customer_merges m
2663: WHERE yt.cust_account_id = m.duplicate_id
2664: AND yt.cust_account_site_id = m.duplicate_address_id
2665: AND m.request_id = req_id
2666: AND m.set_number = set_num

Line 2677: FROM ra_customer_merges m

2673: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2674: program_update_date = sysdate
2675: WHERE cust_account_site_id IN (
2676: SELECT m.duplicate_address_id
2677: FROM ra_customer_merges m
2678: WHERE m.process_flag = 'N'
2679: AND m.request_id = req_id
2680: AND m.set_number = set_num );
2681:

Line 2695: FROM ra_customer_merges m

2691:
2692: UPDATE HZ_CUST_CONTACT_POINTS yt
2693: SET cust_account_id = (
2694: SELECT DISTINCT m.customer_id
2695: FROM ra_customer_merges m
2696: WHERE yt.cust_account_id = m.duplicate_id
2697: AND m.request_id = req_id
2698: AND m.process_flag = 'N'
2699: AND m.set_number = set_num),

Line 2709: FROM ra_customer_merges m

2705: program_id =hz_utility_v2pub.program_id,-- arp_standard.profile.program_id,
2706: program_update_date = sysdate
2707: WHERE cust_account_id IN (
2708: SELECT m.duplicate_id
2709: FROM ra_customer_merges m
2710: WHERE m.process_flag = 'N'
2711: AND m.request_id = req_id
2712: AND m.set_number = set_num)
2713: AND cust_account_site_id IS NULL;

Line 2784: FROM ra_customer_merges m, hz_cust_accounts c1

2780: SELECT party_usg_assignment_id
2781: FROM hz_party_usg_assignments pu
2782: WHERE party_usage_code = 'CUSTOMER'
2783: AND EXISTS (SELECT 'Y'
2784: FROM ra_customer_merges m, hz_cust_accounts c1
2785: WHERE m.duplicate_id = c1.cust_account_id
2786: AND c1.party_id = pu.party_id
2787: AND m.process_flag = 'N'
2788: AND m.request_id = req_id

Line 2834: FROM ra_customer_merges m, hz_cust_accounts c1

2830: WHERE c.party_id = pu.party_id
2831: AND c.status ='A'
2832: )
2833: AND EXISTS (SELECT 'Y'
2834: FROM ra_customer_merges m, hz_cust_accounts c1
2835: WHERE m.request_id = req_id
2836: AND m.process_flag = 'N'
2837: AND m.set_number = set_num
2838: AND m.delete_duplicate_flag = 'N'

Line 2893: FROM ra_customer_merges m, hz_cust_accounts c1

2889: and rownum=1)
2890:
2891:
2892: AND EXISTS (SELECT 'Y'
2893: FROM ra_customer_merges m, hz_cust_accounts c1
2894: WHERE m.request_id = req_id
2895: AND m.process_flag = 'N'
2896: AND m.set_number = set_num
2897: AND m.delete_duplicate_flag = 'Y'--Bug No. 4558392

Line 2949: FROM ra_customer_merges m, hz_cust_accounts c1

2945: AND c.status = 'A')
2946: )*/
2947: ----Bug No.4558392
2948: AND EXISTS (SELECT 'Y'
2949: FROM ra_customer_merges m, hz_cust_accounts c1
2950: WHERE m.request_id = req_id
2951: AND m.process_flag = 'N'
2952: AND m.set_number = set_num
2953: AND m.delete_duplicate_flag = 'Y'

Line 3240: FROM ra_customer_merges

3236: --merge context.
3237:
3238: CURSOR d IS
3239: SELECT DISTINCT duplicate_address_id --, customer_address_id
3240: FROM ra_customer_merges
3241: WHERE duplicate_id = p_from_account_id
3242: AND customer_id = p_to_account_id
3243: AND process_flag = 'N'
3244: AND request_id = p_req_id

Line 4325: FROM HZ_CUST_SITE_USES_ALL su, ra_customer_merges m --SSUptake

4321: ) IS
4322:
4323: CURSOR cust_site_uses IS
4324: SELECT site_use_id
4325: FROM HZ_CUST_SITE_USES_ALL su, ra_customer_merges m --SSUptake
4326: WHERE cust_acct_site_id = m.duplicate_address_id
4327: AND m.org_id = su.org_id --SSUptake
4328: AND m.process_flag = 'N'
4329: AND m.request_id = req_id

Line 4337: FROM HZ_CUST_ACCT_SITES_ALL addr, ra_customer_merges m --SSUptake

4333: FOR UPDATE NOWAIT;
4334:
4335: CURSOR cust_sites IS
4336: SELECT cust_acct_site_id
4337: FROM HZ_CUST_ACCT_SITES_ALL addr, ra_customer_merges m --SSUptake
4338: WHERE cust_acct_site_id = m.duplicate_address_id
4339: AND m.org_id = addr.org_id --SSUptake
4340: AND m.process_flag = 'N'
4341: AND m.request_id = req_id

Line 4349: FROM HZ_CUST_ACCOUNTS acct, ra_customer_merges m

4345: FOR UPDATE NOWAIT;
4346:
4347: CURSOR cust_accounts IS
4348: SELECT cust_account_id
4349: FROM HZ_CUST_ACCOUNTS acct, ra_customer_merges m
4350: WHERE cust_account_id = m.duplicate_id
4351: AND m.process_flag = 'N'
4352: AND m.request_id = req_id
4353: AND m.set_number = set_num

Line 4360: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake

4356: FOR UPDATE NOWAIT;
4357:
4358: CURSOR cust_rel1 IS
4359: SELECT rel.cust_account_id
4360: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake
4361: WHERE cust_account_id = m.duplicate_id
4362: AND m.org_id = rel.org_id --SSUptake
4363: AND m.process_flag = 'N'
4364: AND m.request_id = req_id

Line 4372: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake

4368: FOR UPDATE NOWAIT;
4369:
4370: CURSOR cust_rel2 IS
4371: SELECT rel.related_cust_account_id
4372: FROM HZ_CUST_ACCT_RELATE_ALL rel, ra_customer_merges m --SSUptake
4373: WHERE related_cust_account_id = m.duplicate_id
4374: AND m.org_id = rel.org_id --SSUptake
4375: AND m.process_flag = 'N'
4376: AND m.request_id = req_id

Line 4384: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

4380: FOR UPDATE NOWAIT;
4381:
4382: CURSOR cust_receipt_methods_site IS
4383: SELECT CUST_RECEIPT_METHOD_ID
4384: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
4385: WHERE yt.customer_id = m.duplicate_id
4386: AND yt.site_use_id = m.duplicate_site_id
4387: AND m.process_flag = 'N'
4388: AND m.request_id = req_id

Line 4395: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m

4391: FOR UPDATE NOWAIT;
4392:
4393: CURSOR cust_receipt_methods_acct IS
4394: SELECT CUST_RECEIPT_METHOD_ID
4395: FROM RA_CUST_RECEIPT_METHODS yt, ra_customer_merges m
4396: WHERE yt.customer_id = m.duplicate_id
4397: AND m.process_flag = 'N'
4398: AND m.request_id = req_id
4399: AND m.set_number = set_num

Line 4415: AND party_id in (SELECT DISTINCT c.party_id from hz_cust_accounts c, ra_customer_merges m

4411: SELECT party_usg_assignment_id
4412: FROM hz_party_usg_assignments u
4413: WHERE party_usage_code = 'CUSTOMER'
4414: AND status_flag = 'D'
4415: AND party_id in (SELECT DISTINCT c.party_id from hz_cust_accounts c, ra_customer_merges m
4416: WHERE c.cust_account_id = m.duplicate_id
4417: AND m.process_flag = 'N'
4418: AND m.request_id = req_id
4419: AND m.set_number = set_num

Line 4439: AND party_id in (SELECT DISTINCT c.party_id from hz_cust_accounts c, ra_customer_merges m

4435:
4436: DELETE FROM hz_party_usg_assignments u
4437: WHERE party_usage_code = 'CUSTOMER'
4438: AND status_flag = 'D'
4439: AND party_id in (SELECT DISTINCT c.party_id from hz_cust_accounts c, ra_customer_merges m
4440: WHERE c.cust_account_id = m.duplicate_id
4441: AND m.process_flag = 'N'
4442: AND m.request_id = req_id
4443: AND m.set_number = set_num

Line 4466: FROM ra_customer_merges m

4462: owner_table_id in (
4463: select site_use_id from hz_cust_site_uses_all su
4464: where status = 'D'
4465: and exists ( SELECT 'Y'
4466: FROM ra_customer_merges m
4467: WHERE su.cust_acct_site_id = m.duplicate_address_id
4468: AND su.org_id = m.org_id
4469: AND m.process_flag = 'N'
4470: AND m.request_id = req_id

Line 4479: FROM ra_customer_merges m

4475:
4476: DELETE FROM HZ_CUST_SITE_USES_ALL su
4477: WHERE EXISTS (
4478: SELECT 'Y'
4479: FROM ra_customer_merges m
4480: WHERE m.duplicate_address_id = su.cust_acct_site_id
4481: AND m.org_id = su.org_id
4482: AND m.process_flag = 'N'
4483: AND m.request_id = req_id

Line 4510: FROM ra_customer_merges m

4506: select cust_acct_site_id from hz_cust_acct_sites_all sites --SSuptake
4507: where status = 'D'
4508: and EXISTS
4509: ( SELECT 'Y'
4510: FROM ra_customer_merges m
4511: WHERE m.duplicate_address_id = sites.cust_acct_site_id
4512: AND m.org_id = sites.org_id
4513: AND m.process_flag = 'N'
4514: AND m.request_id = req_id

Line 4521: FROM ra_customer_merges m

4517:
4518: DELETE FROM HZ_CUST_ACCT_SITES_ALL yt --SSUptake
4519: WHERE EXISTS (
4520: SELECT 'Y'
4521: FROM ra_customer_merges m
4522: WHERE m.duplicate_address_id = yt.cust_acct_site_id
4523: AND m.org_id = yt.org_id
4524: AND m.process_flag = 'N'
4525: AND m.request_id = req_id

Line 4548: FROM ra_customer_merges m

4544: owner_table_id in (
4545: select cust_account_id from hz_cust_accounts where
4546: status = 'D' and cust_account_id in
4547: ( SELECT m.duplicate_id
4548: FROM ra_customer_merges m
4549: WHERE m.process_flag = 'N'
4550: AND m.request_id = req_id
4551: AND m.set_number = set_num
4552: AND m.delete_duplicate_flag = 'Y' ));

Line 4557: FROM ra_customer_merges m

4553:
4554: DELETE FROM HZ_CUST_ACCOUNTS
4555: WHERE cust_account_id IN (
4556: SELECT m.duplicate_id
4557: FROM ra_customer_merges m
4558: WHERE m.process_flag = 'N'
4559: AND m.request_id = req_id
4560: AND m.set_number = set_num
4561: AND m.delete_duplicate_flag = 'Y' )

Line 4581: FROM ra_customer_merges m

4577:
4578: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake
4579: WHERE EXISTS (
4580: SELECT 'Y'
4581: FROM ra_customer_merges m
4582: WHERE m.duplicate_id = rel.cust_account_id
4583: AND m.org_id = rel.org_id
4584: AND m.process_flag = 'N'
4585: AND m.request_id = req_id

Line 4606: FROM ra_customer_merges m

4602:
4603: DELETE FROM HZ_CUST_ACCT_RELATE_ALL rel --SSUptake
4604: WHERE EXISTS (
4605: SELECT 'Y'
4606: FROM ra_customer_merges m
4607: WHERE m.duplicate_id = rel.related_cust_account_id
4608: AND m.org_id = rel.org_id
4609: AND m.process_flag = 'N'
4610: AND m.request_id = req_id

Line 4633: FROM ra_customer_merges m

4629:
4630: DELETE FROM RA_CUST_RECEIPT_METHODS yt
4631: WHERE (customer_id, site_use_id) in (
4632: SELECT m.duplicate_id, m.duplicate_site_id
4633: FROM ra_customer_merges m
4634: WHERE m.process_flag = 'N'
4635: AND m.request_id = req_id
4636: AND m.set_number = set_num
4637: AND m.delete_duplicate_flag = 'Y');

Line 4655: FROM ra_customer_merges m

4651:
4652: DELETE FROM RA_CUST_RECEIPT_METHODS yt
4653: WHERE customer_id in (
4654: SELECT m.duplicate_id
4655: FROM ra_customer_merges m
4656: WHERE m.process_flag = 'N'
4657: AND m.request_id = req_id
4658: AND m.set_number = set_num )
4659: AND site_use_id IS NULL

Line 4757: | we need to fill out the columns of ra_customer_merges for later query.

4753: | So we should not update, for example, merge-to's party site with merge-from's
4754: | party site if there exists a party site on the location for merge-to's party.
4755: |
4756: | After create account site for merge-to customer,
4757: | we need to fill out the columns of ra_customer_merges for later query.
4758: | -- customer_address_id <-- cust_acct_site_id
4759: | -- customer_site_id <-- site_use_id
4760: | -- customer_ref <-- orig_system_reference
4761: | -- customer_primary_flag <-- primary_flag

Line 4831: | in ra_customer_merges.

4827: | flag is checked. Added a call to
4828: | hz_cust_account_merge_v2pvt.create_party_site_use
4829: | in procedure create_same_sites.
4830: | S.V.Sowjanya 02-DEC-04 Bug No: 3959776. Updated column customer_site_number
4831: | in ra_customer_merges.
4832: | S.V.Sowjanya 04-JAN-05 Bug No: 4018346. Assigned null values to l_customer_location,
4833: | l_customer_site_id in the beginning of the loop for
4834: | cursor sites_need_to_create and removed nvl condition
4835: | for l_customer_location in the update statement of ra_customer_merges

Line 4835: | for l_customer_location in the update statement of ra_customer_merges

4831: | in ra_customer_merges.
4832: | S.V.Sowjanya 04-JAN-05 Bug No: 4018346. Assigned null values to l_customer_location,
4833: | l_customer_site_id in the beginning of the loop for
4834: | cursor sites_need_to_create and removed nvl condition
4835: | for l_customer_location in the update statement of ra_customer_merges
4836: | at the end of the loop for cursor sites_need_to_create.
4837: | S V Sowjanya 10-AUG-05 Bug No:4492628. Moved code that copies party_site_uses
4838: | to copy party_site_use after the creation of account_site
4839: | Kalyana 12-Oct-07 Bug No: 6469732 Modified the procedure create_same_site so that if already an Active Customer

Line 4855: FROM ra_customer_merges

4851: --new sites.
4852: CURSOR sites_need_to_create IS
4853: SELECT duplicate_id, duplicate_address_id, duplicate_site_id,
4854: duplicate_site_code, customer_id,org_id --SSUptake
4855: FROM ra_customer_merges
4856: WHERE duplicate_id <> customer_id
4857: AND process_flag = 'N'
4858: AND request_id = req_id
4859: AND set_number = set_num

Line 6183: FROM ra_customer_merges

6179: --since location is madatory. We have to enforce system generate.
6180: --Only if the customer_location value is NULL.
6181:
6182: SELECT customer_location into l_customer_location
6183: FROM ra_customer_merges
6184: WHERE customer_id = l_customer_id
6185: AND duplicate_site_id = l_duplicate_site_id
6186: --Bug Fix 2929527
6187: AND ROWNUM=1;

Line 6509: --Update ra_customer_merges table with the new info. we created.

6505: END; --end of creating
6506:
6507: --Will migrate the contacts (phones and emails) during merge process
6508:
6509: --Update ra_customer_merges table with the new info. we created.
6510: --Select customer orig system reference.
6511: SELECT orig_system_reference
6512: INTO l_customer_ref
6513: FROM hz_cust_acct_sites

Line 6533: UPDATE ra_customer_merges

6529: FROM hz_party_sites
6530: WHERE party_site_id = ( SELECT party_site_id
6531: FROM hz_cust_acct_sites
6532: WHERE cust_acct_site_id = l_customer_address_id);
6533: UPDATE ra_customer_merges
6534: SET customer_address_id = l_customer_address_id,
6535: customer_ref = l_customer_ref,
6536: customer_primary_flag = nvl(l_customer_primary_flag,'N'),
6537: customer_site_id = nvl(l_customer_site_id,-99),

Line 6599: l_customer_merge_header_id RA_CUSTOMER_MERGES.customer_merge_header_id%TYPE;

6595: PROCEDURE merge_history(req_id NUMBER,
6596: set_num NUMBER,
6597: status OUT NOCOPY NUMBER) IS
6598:
6599: l_customer_merge_header_id RA_CUSTOMER_MERGES.customer_merge_header_id%TYPE;
6600:
6601:
6602: BEGIN
6603:

Line 6841: from ra_customer_merges cm

6837: c.application_id ,
6838: c.selling_party_id ,
6839: req_id
6840: FROM (select distinct duplicate_id , customer_merge_header_id , customer_id
6841: from ra_customer_merges cm
6842: where cm.process_flag = 'N'
6843: and cm.request_id = req_id
6844: and cm.set_number = set_num) , HZ_CUST_ACCOUNTS c
6845: WHERE c.cust_account_id = duplicate_id

Line 7001: from ra_customer_merges cm

6997: ar.created_by_module ,
6998: ar.application_id ,
6999: req_id
7000: FROM(select distinct duplicate_id,duplicate_address_id,customer_merge_header_id
7001: from ra_customer_merges cm
7002: where cm.process_flag = 'N'
7003: and cm.request_id = req_id
7004: and cm.set_number = set_num
7005: and cm.duplicate_id <> cm.customer_id), hz_cust_account_roles ar

Line 7237: from ra_customer_merges cm

7233: cp.party_id ,
7234: cp.last_credit_review_date ,
7235: req_id
7236: FROM(select distinct duplicate_id,duplicate_site_id,customer_merge_header_id
7237: from ra_customer_merges cm
7238: where cm.process_flag = 'N'
7239: and cm.request_id = req_id
7240: and cm.set_number = set_num
7241: and cm.duplicate_id <> cm.customer_id ), hz_customer_profiles cp

Line 7424: from ra_customer_merges cm

7420: pa.created_by_module ,
7421: pa.application_id ,
7422: req_id
7423: FROM (select distinct duplicate_id,duplicate_site_id,customer_merge_header_id
7424: from ra_customer_merges cm
7425: where cm.process_flag = 'N'
7426: and cm.request_id = req_id
7427: and cm.set_number = set_num ),hz_cust_profile_amts pa
7428: WHERE (pa.cust_account_id = duplicate_id and pa.site_use_id is NULL)

Line 7594: from ra_customer_merges cm

7590: acs.created_by_module ,
7591: acs.application_id ,
7592: req_id
7593: FROM (select distinct duplicate_id,duplicate_address_id,customer_merge_header_id,org_id
7594: from ra_customer_merges cm
7595: where cm.process_flag = 'N'
7596: and cm.request_id = req_id
7597: and cm.set_number = set_num ) m,hz_cust_acct_sites_all acs
7598: WHERE acs.cust_acct_site_id = duplicate_address_id

Line 7846: from ra_customer_merges cm

7842: su.created_by_module ,
7843: su.application_id ,
7844: req_id
7845: FROM (select distinct duplicate_site_id,customer_merge_header_id,org_id
7846: from ra_customer_merges cm
7847: where cm.process_flag = 'N'
7848: and cm.request_id = req_id
7849: and cm.set_number = set_num ) m,hz_cust_site_uses_all su --SSUptake
7850: WHERE su.site_use_id = duplicate_site_id

Line 7938: from ra_customer_merges cm

7934: yt.created_by_module ,
7935: yt.application_id ,
7936: req_id
7937: FROM (select distinct duplicate_id, customer_merge_header_id,org_id
7938: from ra_customer_merges cm
7939: where cm.process_flag = 'N'
7940: and cm.request_id = req_id
7941: and cm.set_number = set_num
7942: and cm.duplicate_id <> cm.customer_id) m,hz_cust_acct_relate_all yt --SSUptake