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 1174: select 'Y' from ra_customer_merges m

1170: merge_fail_msg = null
1171: WHERE process_flag = l_new_process_flag
1172: --Start of SSUptake
1173: AND NOT EXISTS (
1174: select 'Y' from ra_customer_merges m
1175: where m.customer_merge_header_id = mh.customer_merge_header_id
1176: and mo_global.check_access(m.org_id) <> 'Y'
1177: and rownum =1
1178: )

Line 1182: FROM ra_customer_merges m, hz_cust_acct_sites site

1178: )
1179: --End of SSUptake
1180: AND ( EXISTS (
1181: SELECT 'Y'
1182: FROM ra_customer_merges m, hz_cust_acct_sites site
1183: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1184: AND m.duplicate_address_id = site.cust_acct_site_id
1185: AND ROWNUM = 1)
1186: OR EXISTS( --4693912

Line 1188: FROM ra_customer_merges m

1184: AND m.duplicate_address_id = site.cust_acct_site_id
1185: AND ROWNUM = 1)
1186: OR EXISTS( --4693912
1187: SELECT 'Y'
1188: FROM ra_customer_merges m
1189: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1190: AND m.duplicate_address_id = -1)
1191: )
1192: AND customer_merge_header_id in (SELECT customer_merge_header_id --3897822

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

1206: END IF;
1207:
1208: --N/A --Bug 1519688: Set request_id for merge headers.
1209:
1210: --Bug 1725662: Set request_id from ra_customer_merges. Rewrite sql to
1211: --use index.
1212:
1213: UPDATE ra_customer_merge_headers mh
1214: SET process_flag = 'Y'

Line 1220: FROM ra_customer_merges m

1216: AND process_flag = l_new_process_flag
1217: AND priority = p_priority --3897822
1218: AND EXISTS (
1219: SELECT 'Y'
1220: FROM ra_customer_merges m
1221: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1222: AND m.process_flag = 'Y'
1223: AND ROWNUM = 1 );
1224:

Line 1225: UPDATE ra_customer_merges m

1221: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1222: AND m.process_flag = 'Y'
1223: AND ROWNUM = 1 );
1224:
1225: UPDATE ra_customer_merges m
1226: SET (request_id,
1227: process_flag) = (
1228: SELECT mh.request_id, mh.process_flag
1229: FROM ra_customer_merge_headers mh

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

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

Line 1362: all sites specified in ra_customer_merges

1358:
1359: Select
1360: all sites that must be merged
1361: MINUS
1362: all sites specified in ra_customer_merges
1363: Migration to new customer model.
1364: -------------------------------
1365: With the new cust. model, cust acct and sites are already
1366: striped by ou. The cust accts are no longer global.

Line 1389: FROM ra_customer_merges m

1385: AND su.cust_acct_site_id = addr.cust_acct_site_id
1386: AND addr.cust_account_id = mh.duplicate_id
1387: AND NOT EXISTS (
1388: SELECT 'same site in merge detail'
1389: FROM ra_customer_merges m
1390: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1391: AND m.duplicate_site_id = su.site_use_id
1392: AND m.org_id = su.org_id
1393: );

Line 1396: --in ra_customer_merges table.

1392: AND m.org_id = su.org_id
1393: );
1394:
1395: --Bug 1391134: ignore those records with customer_createsame = 'Y'
1396: --in ra_customer_merges table.
1397:
1398: CURSOR check_invalid_merges IS
1399: /**
1400: Merge is INVALID if:

Line 1407: FROM ra_customer_merges m

1403: - duplicate_site_id = duplicate_site_id of another row
1404: */
1405:
1406: SELECT m.duplicate_id duplicate_id
1407: FROM ra_customer_merges m
1408: WHERE m.process_flag = p_process_flag
1409: AND m.request_id = req_id
1410: AND duplicate_address_id <> -1 --4693912
1411: -- AND (m.duplicate_site_id <> -99 AND m.customer_site_id <> -99)

Line 1415: FROM ra_customer_merges m2

1411: -- AND (m.duplicate_site_id <> -99 AND m.customer_site_id <> -99)
1412: AND ((m.customer_createsame <> 'Y'
1413: AND (m.customer_site_id IN (
1414: SELECT m2.duplicate_site_id
1415: FROM ra_customer_merges m2
1416: WHERE m2.rowid <> m.rowid
1417: AND m2.process_flag = p_process_flag
1418: AND m2.duplicate_address_id = m.customer_address_id )
1419: OR m.duplicate_site_id IN (

Line 1421: FROM ra_customer_merges m2

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

Line 1427: FROM ra_customer_merges m2

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

Line 1443: UPDATE ra_customer_merges

1439:
1440: FOR missing_sites IN val_all_sites_merged LOOP
1441:
1442: --Mark Invalid Merges
1443: UPDATE ra_customer_merges
1444: SET process_flag = 'ERROR 1'
1445: WHERE duplicate_id = missing_sites.duplicate_id
1446: AND request_id = req_id
1447: AND process_flag = p_process_flag;

Line 1468: UPDATE ra_customer_merges

1464:
1465: FOR invalid_merges IN check_invalid_merges LOOP
1466:
1467: --Mark Invalid Merges
1468: UPDATE ra_customer_merges
1469: SET process_flag = 'ERROR 2'
1470: WHERE duplicate_id = invalid_merges.duplicate_id
1471: AND request_id = req_id
1472: AND process_flag = p_process_flag;

Line 1535: FROM ra_customer_merges

1531: ) IS
1532:
1533: CURSOR partition is
1534: SELECT rowid, duplicate_id
1535: FROM ra_customer_merges
1536: WHERE request_id = req_id
1537: AND process_flag = p_process_flag
1538: ORDER BY duplicate_id;
1539:

Line 1578: UPDATE ra_customer_merges

1574: END IF;
1575:
1576: v_count := v_count + 1;
1577:
1578: UPDATE ra_customer_merges
1579: SET set_number = v_last_set
1580: WHERE rowid = v_rowid;
1581:
1582: END loop;

Line 1637: FROM ra_customer_merges

1633: ) IS
1634:
1635: CURSOR partition is
1636: SELECT rowid, duplicate_id
1637: FROM ra_customer_merges
1638: WHERE request_id = req_id
1639: AND set_number = set_num
1640: ORDER BY duplicate_id;
1641:

Line 1681: UPDATE ra_customer_merges

1677: END IF;
1678:
1679: v_count := v_count + 1;
1680:
1681: UPDATE ra_customer_merges
1682: SET set_number = v_last_set
1683: WHERE request_id = req_id
1684: AND rowid = v_rowid;
1685:

Line 1688: from ra_customer_merges

1684: AND rowid = v_rowid;
1685:
1686: begin
1687: select set_number into l_count
1688: from ra_customer_merges
1689: where request_id = req_id
1690: AND set_number = v_last_set
1691: AND rowid = v_rowid;
1692: exception

Line 1757: UPDATE ra_customer_merges

1753:
1754: --delete customer alternative names
1755: arp_cmerge_master.delete_customer_alt_names ( req_id , set_num ) ;
1756:
1757: UPDATE ra_customer_merges
1758: SET process_flag = 'Y',
1759: last_update_date = sysdate,
1760: last_updated_by = hz_utility_v2pub.user_id,
1761: last_update_login = hz_utility_v2pub.last_update_login,

Line 1790: FROM ra_customer_merges m

1786: m.last_update_login,
1787: m.program_application_id,
1788: m.program_id,
1789: sysdate
1790: FROM ra_customer_merges m
1791: WHERE m.request_id = req_id
1792: AND m.set_number = set_num
1793: AND m.process_flag = 'Y'
1794: AND mh.customer_merge_header_id =

Line 1799: FROM ra_customer_merges m

1795: m.customer_merge_header_id
1796: AND ROWNUM = 1)
1797: WHERE mh.customer_merge_header_id IN (
1798: SELECT m.customer_merge_header_id
1799: FROM ra_customer_merges m
1800: WHERE m.request_id = req_id
1801: AND m.process_flag = 'Y'
1802: AND m.set_number = set_num );
1803:

Line 1846: | update ra_customer_merges. Commented the statement

1842: | Jianying Huang 07-DEC-00 Reset merge header table.
1843: | Jianying Huang 07-APR-01 Bug 1725662: Rewrite some queries based on
1844: | the new added indexes for performance improvements.
1845: | Jianying Huang 07-JUN-01 Should not update set_number to NULL when
1846: | update ra_customer_merges. Commented the statement
1847: | out.
1848: |
1849: +===========================================================================*/
1850:

Line 1866: UPDATE ra_customer_merges

1862: --Bug fix 2669389
1863: if (p_process_flag = 'SAVED') then
1864:
1865: arp_message.set_line('in resetmerge flag is saved');
1866: UPDATE ra_customer_merges
1867: SET
1868: -- set_number = null,
1869: -- request_id = null,
1870: process_flag = 'SAVED',

Line 1898: FROM ra_customer_merges m

1894: m.last_update_login,
1895: m.program_application_id,
1896: m.program_id,
1897: sysdate
1898: FROM ra_customer_merges m
1899: WHERE m.request_id = req_id
1900: AND m.set_number = set_num
1901: AND m.process_flag = 'SAVED'
1902: AND mh.customer_merge_header_id =

Line 1907: FROM ra_customer_merges m

1903: m.customer_merge_header_id
1904: AND ROWNUM = 1)
1905: WHERE mh.customer_merge_header_id IN (
1906: SELECT m.customer_merge_header_id
1907: FROM ra_customer_merges m
1908: WHERE m.request_id = req_id
1909: AND m.process_flag = 'SAVED'
1910: AND m.set_number = set_num );
1911: --Bug Fix 2669389

Line 1919: UPDATE ra_customer_merges

1915: --Bug 1519688: should not reset request_id to NULL.
1916: --Set process_flag = 'FAILED' indicate this is a failed merge, we need
1917: --to pick it up next time.
1918:
1919: UPDATE ra_customer_merges
1920: SET
1921: -- set_number = null,
1922: -- request_id = null,
1923: process_flag = 'FAILED',

Line 1954: FROM ra_customer_merges m

1950: m.last_update_login,
1951: m.program_application_id,
1952: m.program_id,
1953: sysdate
1954: FROM ra_customer_merges m
1955: WHERE m.request_id = req_id
1956: AND m.set_number = set_num
1957: AND m.process_flag = 'FAILED'
1958: AND mh.customer_merge_header_id =

Line 1963: FROM ra_customer_merges m

1959: m.customer_merge_header_id
1960: AND ROWNUM = 1)
1961: WHERE mh.customer_merge_header_id IN (
1962: SELECT m.customer_merge_header_id
1963: FROM ra_customer_merges m
1964: WHERE m.request_id = req_id
1965: AND m.process_flag = 'FAILED'
1966: AND m.set_number = set_num );
1967:

Line 2039: UPDATE ra_customer_merges m

2035: program_update_date = sysdate
2036: WHERE process_flag in ('ERROR 1', 'ERROR 2')
2037: AND request_id = req_id;
2038:
2039: UPDATE ra_customer_merges m
2040: SET (process_flag,
2041: last_update_date,
2042: last_updated_by,
2043: last_update_login,

Line 2161: FROM ra_customer_merges

2157: v_lock_status NUMBER;
2158:
2159: CURSOR alt_names_deletion IS
2160: SELECT duplicate_id , customer_id , duplicate_site_id
2161: FROM ra_customer_merges
2162: WHERE request_id = req_id
2163: AND set_number = set_num
2164: AND process_flag = 'N'
2165: ORDER BY duplicate_id ;

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

2308: BEGIN
2309:
2310: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()+' );
2311:
2312: /*--Unset the delete_duplicate_flag in ra_customer_merges --*/
2313: UPDATE ra_customer_merges m
2314: SET delete_duplicate_flag = 'N'
2315: WHERE m.duplicate_id = from_customer_id
2316: AND m.process_flag = 'N'

Line 2313: UPDATE ra_customer_merges m

2309:
2310: arp_message.set_line( 'ARP_CMERGE_MASTER.Veto_Delete()+' );
2311:
2312: /*--Unset the delete_duplicate_flag in ra_customer_merges --*/
2313: UPDATE ra_customer_merges m
2314: SET delete_duplicate_flag = 'N'
2315: WHERE m.duplicate_id = from_customer_id
2316: AND m.process_flag = 'N'
2317: AND m.request_id = req_id

Line 2326: from ra_customer_merges m

2322: UPDATE ra_customer_merge_headers
2323: SET delete_duplicate_flag = 'N'
2324: WHERE customer_merge_header_id in
2325: (select customer_merge_header_id
2326: from ra_customer_merges m
2327: where m.duplicate_id = from_customer_id
2328: AND m.process_flag = 'N'
2329: AND m.request_id = req_id
2330: AND m.set_number = set_num)

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

2342: program_id = hz_utility_v2pub.program_id,
2343: program_update_date = sysdate
2344: WHERE EXISTS
2345: ( select 'Y'
2346: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake
2347: where site.cust_account_id = from_customer_id
2348: and m.duplicate_address_id = site.cust_acct_site_id
2349: and su.cust_acct_site_id = site.cust_acct_site_id
2350: and m.request_id = req_id

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

2370: program_application_id = hz_utility_v2pub.program_application_id,
2371: program_id = hz_utility_v2pub.program_id,
2372: program_update_date = sysdate
2373: where addr.cust_account_id = from_customer_id
2374: AND EXISTS (select 'Y' from ra_customer_merges m
2375: where m.request_id = req_id
2376: and m.process_flag = 'N'
2377: and m.set_number = set_num
2378: and m.duplicate_id = from_customer_id

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

2409: program_application_id =hz_utility_v2pub.program_application_id,
2410: program_id = hz_utility_v2pub.program_id,
2411: program_update_date = sysdate
2412: WHERE rel.cust_account_id = from_customer_id
2413: AND EXISTS (select 'Y' from ra_customer_merges m
2414: where m.request_id = req_id
2415: and m.process_flag = 'N'
2416: and m.set_number = set_num
2417: and m.duplicate_id = rel.cust_account_id

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

2433: program_application_id =hz_utility_v2pub.program_application_id,
2434: program_id = hz_utility_v2pub.program_id,
2435: program_update_date = sysdate
2436: WHERE related_cust_account_id = from_customer_id
2437: AND EXISTS (select 'Y' from ra_customer_merges m
2438: where m.request_id = req_id
2439: and m.process_flag = 'N'
2440: and m.set_number = set_num
2441: and m.duplicate_id = rel2.related_cust_account_id

Line 2465: FROM ra_customer_merges m

2461: program_update_date = sysdate
2462: WHERE customer_id = from_customer_id
2463: AND customer_id IN (
2464: SELECT m.duplicate_id
2465: FROM ra_customer_merges m
2466: WHERE m.process_flag = 'N'
2467: AND m.request_id = req_id
2468: AND m.set_number = set_num
2469: AND m.delete_duplicate_flag = 'N' )

Line 2520: from ra_customer_merges m

2516: UPDATE RA_CUSTOMER_MERGE_HEADERS
2517: SET MERGE_FAIL_MSG= veto_reason
2518: WHERE customer_merge_header_id in
2519: (select customer_merge_header_id
2520: from ra_customer_merges m
2521: where m.duplicate_id = from_customer_id
2522: AND m.process_flag = 'N'
2523: AND m.request_id = req_id
2524: AND m.set_number = set_num);