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

Line 487: UPDATE ra_customer_merges set process_flag = 'FAILED'

483: p_error_text IN VARCHAR2
484: ) IS
485:
486: BEGIN
487: UPDATE ra_customer_merges set process_flag = 'FAILED'
488: WHERE request_id = p_request_id
489: AND customer_merge_header_id = p_customer_merge_header_id
490: ;
491:

Line 652: from ra_customer_merges

648: BEGIN
649: --Get the bad merge records and update them as failed.
650:
651: select customer_merge_header_id into l_customer_merge_header_id
652: from ra_customer_merges
653: where request_id = req_id
654: AND set_number = v_current_set
655: AND process_flag = 'N'
656: AND ROWNUM = 1

Line 674: update ra_customer_merges

670: END ;
671:
672: --reset back the original set number
673:
674: update ra_customer_merges
675: set set_number = set_num
676: WHERE request_id = req_id
677: AND (process_flag = 'N' or process_flag = 'FAILED')
678: AND set_number = v_current_set;

Line 685: FROM ra_customer_merges

681:
682: --Finished processing the set in set_size of 1
683: BEGIN
684: SELECT count(*) INTO l_count
685: FROM ra_customer_merges
686: WHERE request_id = req_id
687: AND set_number = set_num
688: AND process_flag = 'FAILED'
689: ;

Line 1185: SELECT 'Y' FROM ra_customer_merges m

1181: FROM ra_customer_merge_headers mh1
1182: WHERE mh1.priority = p_priority
1183: AND mh1.process_flag = l_new_process_flag
1184: AND NOT EXISTS (
1185: SELECT 'Y' FROM ra_customer_merges m
1186: WHERE m.customer_merge_header_id = mh1.customer_merge_header_id
1187: AND mo_global.check_access(m.org_id) <> 'Y'
1188: AND ROWNUM =1
1189: )

Line 1193: FROM ra_customer_merges m, hz_cust_acct_sites site

1189: )
1190:
1191: AND ( EXISTS (
1192: SELECT 'Y'
1193: FROM ra_customer_merges m, hz_cust_acct_sites site
1194: WHERE m.customer_merge_header_id = mh1.customer_merge_header_id
1195: AND m.duplicate_address_id = site.cust_acct_site_id
1196: AND ROWNUM = 1)
1197: OR EXISTS(

Line 1199: FROM ra_customer_merges m

1195: AND m.duplicate_address_id = site.cust_acct_site_id
1196: AND ROWNUM = 1)
1197: OR EXISTS(
1198: SELECT 'Y'
1199: FROM ra_customer_merges m
1200: WHERE m.customer_merge_header_id = mh1.customer_merge_header_id
1201: AND m.duplicate_address_id = -1)
1202: )
1203:

Line 1217: --Bug 1725662: Set request_id from ra_customer_merges. Rewrite sql to

1213: END IF;
1214:
1215: --N/A --Bug 1519688: Set request_id for merge headers.
1216:
1217: --Bug 1725662: Set request_id from ra_customer_merges. Rewrite sql to
1218: --use index.
1219:
1220: UPDATE ra_customer_merge_headers mh
1221: SET process_flag = 'Y'

Line 1227: FROM ra_customer_merges m

1223: AND process_flag = l_new_process_flag
1224: AND priority = p_priority --3897822
1225: AND EXISTS (
1226: SELECT 'Y'
1227: FROM ra_customer_merges m
1228: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1229: AND m.process_flag = 'Y'
1230: AND ROWNUM = 1 );
1231:

Line 1232: UPDATE ra_customer_merges m

1228: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1229: AND m.process_flag = 'Y'
1230: AND ROWNUM = 1 );
1231:
1232: UPDATE ra_customer_merges m
1233: SET (request_id,
1234: process_flag) = (
1235: SELECT mh.request_id, mh.process_flag
1236: FROM ra_customer_merge_headers mh

Line 1333: | ra_customer_merges to -1, so merge form can submit

1329: | Jianying Huang 07-DEC-00 Bug 1391134: We modified createSites as
1330: | set-based procedure and call if before merge products
1331: | for each set. We also set not-null columns
1332: | customer_address_id and customer_site_id in table
1333: | ra_customer_merges to -1, so merge form can submit
1334: | the merges. To accommodate that changes, we donot
1335: | validate those records with customer_createsame = 'Y'
1336: | Jianying Huang 08-MAR-01 Bug 1610924: Modified the procedure to allow
1337: | merging all of the site uses.

Line 1369: all sites specified in ra_customer_merges

1365:
1366: Select
1367: all sites that must be merged
1368: MINUS
1369: all sites specified in ra_customer_merges
1370: Migration to new customer model.
1371: -------------------------------
1372: With the new cust. model, cust acct and sites are already
1373: striped by ou. The cust accts are no longer global.

Line 1396: FROM ra_customer_merges m

1392: AND su.cust_acct_site_id = addr.cust_acct_site_id
1393: AND addr.cust_account_id = mh.duplicate_id
1394: AND NOT EXISTS (
1395: SELECT 'same site in merge detail'
1396: FROM ra_customer_merges m
1397: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1398: AND m.duplicate_site_id = su.site_use_id
1399: AND m.org_id = su.org_id
1400: );

Line 1403: --in ra_customer_merges table.

1399: AND m.org_id = su.org_id
1400: );
1401:
1402: --Bug 1391134: ignore those records with customer_createsame = 'Y'
1403: --in ra_customer_merges table.
1404:
1405: CURSOR check_invalid_merges IS
1406: /**
1407: Merge is INVALID if:

Line 1414: FROM ra_customer_merges m

1410: - duplicate_site_id = duplicate_site_id of another row
1411: */
1412:
1413: SELECT m.duplicate_id duplicate_id
1414: FROM ra_customer_merges m
1415: WHERE m.process_flag = p_process_flag
1416: AND m.request_id = req_id
1417: AND duplicate_address_id <> -1 --4693912
1418: -- AND (m.duplicate_site_id <> -99 AND m.customer_site_id <> -99)

Line 1422: FROM ra_customer_merges m2

1418: -- AND (m.duplicate_site_id <> -99 AND m.customer_site_id <> -99)
1419: AND ((m.customer_createsame <> 'Y'
1420: AND (m.customer_site_id IN (
1421: SELECT m2.duplicate_site_id
1422: FROM ra_customer_merges m2
1423: WHERE m2.rowid <> m.rowid
1424: AND m2.process_flag = p_process_flag
1425: AND m2.duplicate_address_id = m.customer_address_id )
1426: OR m.duplicate_site_id IN (

Line 1428: FROM ra_customer_merges m2

1424: AND m2.process_flag = p_process_flag
1425: AND m2.duplicate_address_id = m.customer_address_id )
1426: OR m.duplicate_site_id IN (
1427: SELECT m2.customer_site_id
1428: FROM ra_customer_merges m2
1429: WHERE m2.rowid <> m.rowid
1430: AND m2.process_flag = p_process_flag
1431: AND m2.customer_address_id = m.duplicate_address_id )))
1432: OR m.duplicate_site_id IN (

Line 1434: FROM ra_customer_merges m2

1430: AND m2.process_flag = p_process_flag
1431: AND m2.customer_address_id = m.duplicate_address_id )))
1432: OR m.duplicate_site_id IN (
1433: SELECT m2.duplicate_site_id
1434: FROM ra_customer_merges m2
1435: WHERE m2.rowid <> m.rowid
1436: AND m2.process_flag = p_process_flag
1437: --AND m2.duplicate_site_id <> -99
1438: AND m2.duplicate_address_id = m.duplicate_address_id));

Line 1450: UPDATE ra_customer_merges

1446:
1447: FOR missing_sites IN val_all_sites_merged LOOP
1448:
1449: --Mark Invalid Merges
1450: UPDATE ra_customer_merges
1451: SET process_flag = 'ERROR 1'
1452: WHERE duplicate_id = missing_sites.duplicate_id
1453: AND request_id = req_id
1454: AND process_flag = p_process_flag;

Line 1475: UPDATE ra_customer_merges

1471:
1472: FOR invalid_merges IN check_invalid_merges LOOP
1473:
1474: --Mark Invalid Merges
1475: UPDATE ra_customer_merges
1476: SET process_flag = 'ERROR 2'
1477: WHERE duplicate_id = invalid_merges.duplicate_id
1478: AND request_id = req_id
1479: AND process_flag = p_process_flag;

Line 1542: FROM ra_customer_merges

1538: ) IS
1539:
1540: CURSOR partition is
1541: SELECT rowid, duplicate_id
1542: FROM ra_customer_merges
1543: WHERE request_id = req_id
1544: AND process_flag = p_process_flag
1545: ORDER BY duplicate_id;
1546:

Line 1585: UPDATE ra_customer_merges

1581: END IF;
1582:
1583: v_count := v_count + 1;
1584:
1585: UPDATE ra_customer_merges
1586: SET set_number = v_last_set
1587: WHERE rowid = v_rowid;
1588:
1589: END loop;

Line 1644: FROM ra_customer_merges

1640: ) IS
1641:
1642: CURSOR partition is
1643: SELECT rowid, duplicate_id
1644: FROM ra_customer_merges
1645: WHERE request_id = req_id
1646: AND set_number = set_num
1647: ORDER BY duplicate_id;
1648:

Line 1688: UPDATE ra_customer_merges

1684: END IF;
1685:
1686: v_count := v_count + 1;
1687:
1688: UPDATE ra_customer_merges
1689: SET set_number = v_last_set
1690: WHERE request_id = req_id
1691: AND rowid = v_rowid;
1692:

Line 1695: from ra_customer_merges

1691: AND rowid = v_rowid;
1692:
1693: begin
1694: select set_number into l_count
1695: from ra_customer_merges
1696: where request_id = req_id
1697: AND set_number = v_last_set
1698: AND rowid = v_rowid;
1699: exception

Line 1764: UPDATE ra_customer_merges

1760:
1761: --delete customer alternative names
1762: arp_cmerge_master.delete_customer_alt_names ( req_id , set_num ) ;
1763:
1764: UPDATE ra_customer_merges
1765: SET process_flag = 'Y',
1766: last_update_date = sysdate,
1767: last_updated_by = hz_utility_v2pub.user_id,
1768: last_update_login = hz_utility_v2pub.last_update_login,

Line 1797: FROM ra_customer_merges m

1793: m.last_update_login,
1794: m.program_application_id,
1795: m.program_id,
1796: sysdate
1797: FROM ra_customer_merges m
1798: WHERE m.request_id = req_id
1799: AND m.set_number = set_num
1800: AND m.process_flag = 'Y'
1801: AND mh.customer_merge_header_id =

Line 1806: FROM ra_customer_merges m

1802: m.customer_merge_header_id
1803: AND ROWNUM = 1)
1804: WHERE mh.customer_merge_header_id IN (
1805: SELECT m.customer_merge_header_id
1806: FROM ra_customer_merges m
1807: WHERE m.request_id = req_id
1808: AND m.process_flag = 'Y'
1809: AND m.set_number = set_num );
1810:

Line 1853: | update ra_customer_merges. Commented the statement

1849: | Jianying Huang 07-DEC-00 Reset merge header table.
1850: | Jianying Huang 07-APR-01 Bug 1725662: Rewrite some queries based on
1851: | the new added indexes for performance improvements.
1852: | Jianying Huang 07-JUN-01 Should not update set_number to NULL when
1853: | update ra_customer_merges. Commented the statement
1854: | out.
1855: |
1856: +===========================================================================*/
1857:

Line 1873: UPDATE ra_customer_merges

1869: --Bug fix 2669389
1870: if (p_process_flag = 'SAVED') then
1871:
1872: arp_message.set_line('in resetmerge flag is saved');
1873: UPDATE ra_customer_merges
1874: SET
1875: -- set_number = null,
1876: -- request_id = null,
1877: process_flag = 'SAVED',

Line 1905: FROM ra_customer_merges m

1901: m.last_update_login,
1902: m.program_application_id,
1903: m.program_id,
1904: sysdate
1905: FROM ra_customer_merges m
1906: WHERE m.request_id = req_id
1907: AND m.set_number = set_num
1908: AND m.process_flag = 'SAVED'
1909: AND mh.customer_merge_header_id =

Line 1914: FROM ra_customer_merges m

1910: m.customer_merge_header_id
1911: AND ROWNUM = 1)
1912: WHERE mh.customer_merge_header_id IN (
1913: SELECT m.customer_merge_header_id
1914: FROM ra_customer_merges m
1915: WHERE m.request_id = req_id
1916: AND m.process_flag = 'SAVED'
1917: AND m.set_number = set_num );
1918: --Bug Fix 2669389

Line 1926: UPDATE ra_customer_merges

1922: --Bug 1519688: should not reset request_id to NULL.
1923: --Set process_flag = 'FAILED' indicate this is a failed merge, we need
1924: --to pick it up next time.
1925:
1926: UPDATE ra_customer_merges
1927: SET
1928: -- set_number = null,
1929: -- request_id = null,
1930: process_flag = 'FAILED',

Line 1961: FROM ra_customer_merges m

1957: m.last_update_login,
1958: m.program_application_id,
1959: m.program_id,
1960: sysdate
1961: FROM ra_customer_merges m
1962: WHERE m.request_id = req_id
1963: AND m.set_number = set_num
1964: AND m.process_flag = 'FAILED'
1965: AND mh.customer_merge_header_id =

Line 1970: FROM ra_customer_merges m

1966: m.customer_merge_header_id
1967: AND ROWNUM = 1)
1968: WHERE mh.customer_merge_header_id IN (
1969: SELECT m.customer_merge_header_id
1970: FROM ra_customer_merges m
1971: WHERE m.request_id = req_id
1972: AND m.process_flag = 'FAILED'
1973: AND m.set_number = set_num );
1974:

Line 2046: UPDATE ra_customer_merges m

2042: program_update_date = sysdate
2043: WHERE process_flag in ('ERROR 1', 'ERROR 2')
2044: AND request_id = req_id;
2045:
2046: UPDATE ra_customer_merges m
2047: SET (process_flag,
2048: last_update_date,
2049: last_updated_by,
2050: last_update_login,

Line 2168: FROM ra_customer_merges

2164: v_lock_status NUMBER;
2165:
2166: CURSOR alt_names_deletion IS
2167: SELECT duplicate_id , customer_id , duplicate_site_id
2168: FROM ra_customer_merges
2169: WHERE request_id = req_id
2170: AND set_number = set_num
2171: AND process_flag = 'N'
2172: ORDER BY duplicate_id ;

Line 2319: /--Unset the delete_duplicate_flag in ra_customer_merges --/

2315: BEGIN
2316:
2317: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()+' );
2318:
2319: /*--Unset the delete_duplicate_flag in ra_customer_merges --*/
2320: UPDATE ra_customer_merges m
2321: SET delete_duplicate_flag = 'N'
2322: WHERE m.duplicate_id = from_customer_id
2323: AND m.process_flag = 'N'

Line 2320: UPDATE ra_customer_merges m

2316:
2317: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()+' );
2318:
2319: /*--Unset the delete_duplicate_flag in ra_customer_merges --*/
2320: UPDATE ra_customer_merges m
2321: SET delete_duplicate_flag = 'N'
2322: WHERE m.duplicate_id = from_customer_id
2323: AND m.process_flag = 'N'
2324: AND m.request_id = req_id

Line 2333: from ra_customer_merges m

2329: UPDATE ra_customer_merge_headers
2330: SET delete_duplicate_flag = 'N'
2331: WHERE customer_merge_header_id in
2332: (select customer_merge_header_id
2333: from ra_customer_merges m
2334: where m.duplicate_id = from_customer_id
2335: AND m.process_flag = 'N'
2336: AND m.request_id = req_id
2337: AND m.set_number = set_num)

Line 2353: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake

2349: program_id = hz_utility_v2pub.program_id,
2350: program_update_date = sysdate
2351: WHERE EXISTS
2352: ( select 'Y'
2353: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake
2354: where site.cust_account_id = from_customer_id
2355: and m.duplicate_address_id = site.cust_acct_site_id
2356: and su.cust_acct_site_id = site.cust_acct_site_id
2357: and m.request_id = req_id

Line 2381: AND EXISTS (select 'Y' from ra_customer_merges m

2377: program_application_id = hz_utility_v2pub.program_application_id,
2378: program_id = hz_utility_v2pub.program_id,
2379: program_update_date = sysdate
2380: where addr.cust_account_id = from_customer_id
2381: AND EXISTS (select 'Y' from ra_customer_merges m
2382: where m.request_id = req_id
2383: and m.process_flag = 'N'
2384: and m.set_number = set_num
2385: and m.duplicate_id = from_customer_id

Line 2420: AND EXISTS (select 'Y' from ra_customer_merges m

2416: program_application_id =hz_utility_v2pub.program_application_id,
2417: program_id = hz_utility_v2pub.program_id,
2418: program_update_date = sysdate
2419: WHERE rel.cust_account_id = from_customer_id
2420: AND EXISTS (select 'Y' from ra_customer_merges m
2421: where m.request_id = req_id
2422: and m.process_flag = 'N'
2423: and m.set_number = set_num
2424: and m.duplicate_id = rel.cust_account_id

Line 2444: AND EXISTS (select 'Y' from ra_customer_merges m

2440: program_application_id =hz_utility_v2pub.program_application_id,
2441: program_id = hz_utility_v2pub.program_id,
2442: program_update_date = sysdate
2443: WHERE related_cust_account_id = from_customer_id
2444: AND EXISTS (select 'Y' from ra_customer_merges m
2445: where m.request_id = req_id
2446: and m.process_flag = 'N'
2447: and m.set_number = set_num
2448: and m.duplicate_id = rel2.related_cust_account_id

Line 2472: FROM ra_customer_merges m

2468: program_update_date = sysdate
2469: WHERE customer_id = from_customer_id
2470: AND customer_id IN (
2471: SELECT m.duplicate_id
2472: FROM ra_customer_merges m
2473: WHERE m.process_flag = 'N'
2474: AND m.request_id = req_id
2475: AND m.set_number = set_num
2476: AND m.delete_duplicate_flag = 'N' )

Line 2527: from ra_customer_merges m

2523: UPDATE RA_CUSTOMER_MERGE_HEADERS
2524: SET MERGE_FAIL_MSG= veto_reason
2525: WHERE customer_merge_header_id in
2526: (select customer_merge_header_id
2527: from ra_customer_merges m
2528: where m.duplicate_id = from_customer_id
2529: AND m.process_flag = 'N'
2530: AND m.request_id = req_id
2531: AND m.set_number = set_num);