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.HZ_ACCOUNT_MERGE_PUB dependencies on RA_CUSTOMER_MERGES

Line 935: from ra_customer_merges cm, ra_customer_merge_headers cmh , hz_cust_acct_sites_all cas

931: l_exist := 'N';
932:
933: select 'Y' , cmh.duplicate_number, cmh.customer_number
934: into l_exist, tmp_duplicate_number, tmp_customer_number
935: from ra_customer_merges cm, ra_customer_merge_headers cmh , hz_cust_acct_sites_all cas
936: where cas.cust_account_id = cm.duplicate_id
937: and (cmh.process_flag NOT IN ('FAILED' ,'Y','DISCARD') )
938: and cmh.customer_merge_header_id = cm.customer_merge_header_id
939: and cas.cust_account_id = l_account_merge_request_obj.merge_from_account.account_id

Line 1367: --Populate ra_customer_merges with sites to be merged

1363: , NVL(l_account_merge_request_obj.merge_reason_code, 'DEDUP')
1364: , NVL(l_account_merge_request_obj.priority, 'P3')
1365: , l_account_merge_request_obj.org_id);
1366:
1367: --Populate ra_customer_merges with sites to be merged
1368:
1369: IF (l_account_merge_request_obj.site_merge_details IS NOT NULL AND
1370: l_account_merge_request_obj.site_merge_details.count > 0) THEN
1371:

Line 1429: INSERT INTO RA_CUSTOMER_MERGES(

1425: l_to_site_use_location := g_site_use_location(l_account_merge_request_obj.site_merge_details(i).site_use_merge_details(j).merge_to_site_use_obj.acct_site_use_id);
1426:
1427: --populate sites with site usage
1428:
1429: INSERT INTO RA_CUSTOMER_MERGES(
1430: CUSTOMER_MERGE_ID
1431: , CREATION_DATE
1432: , CREATED_BY
1433: , LAST_UPDATE_DATE

Line 1470: VALUES( ra_customer_merges_s.nextval /CUSTOMER_MERGE_ID/

1466: , CUSTOMER_CREATESAME
1467: , DUPLICATE_SITE_NUMBER
1468: , CUSTOMER_SITE_NUMBER
1469: , ORG_ID)
1470: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1471: , sysdate /*CREATION_DATE*/
1472: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1473: , sysdate /*LAST_UPDATE_DATE*/
1474: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

Line 1521: INSERT INTO RA_CUSTOMER_MERGES(

1517: ELSE
1518:
1519: --populate sites with out site usage
1520:
1521: INSERT INTO RA_CUSTOMER_MERGES(
1522: CUSTOMER_MERGE_ID
1523: , CREATION_DATE
1524: , CREATED_BY
1525: , LAST_UPDATE_DATE

Line 1562: VALUES( ra_customer_merges_s.nextval /CUSTOMER_MERGE_ID/

1558: , CUSTOMER_CREATESAME
1559: , DUPLICATE_SITE_NUMBER
1560: , CUSTOMER_SITE_NUMBER
1561: , ORG_ID)
1562: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1563: , sysdate /*CREATION_DATE*/
1564: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1565: , sysdate /*LAST_UPDATE_DATE*/
1566: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

Line 1613: --Populate ra_customer_merges with sites to be transferred

1609:
1610: END IF; -- Insert site_merge_details
1611:
1612:
1613: --Populate ra_customer_merges with sites to be transferred
1614:
1615: IF (l_account_merge_request_obj.merge_to_account.account_id <> l_account_merge_request_obj.merge_from_account.account_id) THEN
1616: l_site_cnt := 0;
1617:

Line 1630: INSERT INTO RA_CUSTOMER_MERGES(

1626: END;
1627:
1628: IF l_site_cnt = 0 THEN
1629:
1630: INSERT INTO RA_CUSTOMER_MERGES(
1631: CUSTOMER_MERGE_ID
1632: , CREATION_DATE
1633: , CREATED_BY
1634: , LAST_UPDATE_DATE

Line 1659: VALUES( ra_customer_merges_s.nextval /CUSTOMER_MERGE_ID/

1655: , DUPLICATE_LAST_NAME
1656: , DUPLICATE_TYPE
1657: , CUSTOMER_CREATESAME
1658: , ORG_ID)
1659: VALUES( ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1660: , sysdate /*CREATION_DATE*/
1661: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1662: , sysdate /*LAST_UPDATE_DATE*/
1663: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

Line 1690: INSERT INTO RA_CUSTOMER_MERGES(

1686: , l_account_merge_request_obj.org_id);
1687:
1688: ELSE
1689:
1690: INSERT INTO RA_CUSTOMER_MERGES(
1691: CUSTOMER_MERGE_ID
1692: , CREATION_DATE
1693: , CREATED_BY
1694: , LAST_UPDATE_DATE

Line 1731: select ra_customer_merges_s.nextval /CUSTOMER_MERGE_ID/

1727: , CUSTOMER_CREATESAME
1728: , DUPLICATE_SITE_NUMBER
1729: , CUSTOMER_SITE_NUMBER
1730: , ORG_ID)
1731: select ra_customer_merges_s.nextval /*CUSTOMER_MERGE_ID*/
1732: , sysdate /*CREATION_DATE*/
1733: , HZ_UTILITY_V2PUB.CREATED_BY /*CREATED_BY*/
1734: , sysdate /*LAST_UPDATE_DATE*/
1735: , HZ_UTILITY_V2PUB.LAST_UPDATED_BY /*LAST_UPDATED_BY*/

Line 1775: from ra_customer_merges m

1771: from hz_merge_addresses_v a
1772: where customer_id = l_account_merge_request_obj.merge_from_account.account_id
1773: and a.org_id = decode(l_account_merge_request_obj.org_id,-1,a.org_id,l_account_merge_request_obj.org_id)
1774: and ((a.site_use_id <> -99 AND a.site_use_id not in (select duplicate_site_id
1775: from ra_customer_merges m
1776: where m.customer_merge_header_id = l_header_id))
1777:
1778: OR
1779:

Line 1781: from ra_customer_merges m

1777:
1778: OR
1779:
1780: (a.site_use_id = -99 AND a.address_id not in (select duplicate_address_id
1781: from ra_customer_merges m
1782: where m.customer_merge_header_id = l_header_id
1783: and m.duplicate_site_id = -99))
1784: );
1785:

Line 1788: UPDATE ra_customer_merges m

1784: );
1785:
1786: --Append location with C if same location already exists for merge-to customer
1787:
1788: UPDATE ra_customer_merges m
1789: SET customer_location = duplicate_location||'-C'
1790: WHERE m.customer_merge_header_id = l_header_id
1791: AND m.customer_createsame = 'Y'
1792: AND m.duplicate_site_id <> -99

Line 1813: FROM ra_customer_merges

1809: l_site_cnt := 0;
1810:
1811: BEGIN
1812: SELECT 1 INTO l_site_cnt
1813: FROM ra_customer_merges
1814: WHERE customer_merge_header_id = l_header_id
1815: AND rownum = 1;
1816: EXCEPTION
1817: WHEN NO_DATA_FOUND THEN

Line 1869: UPDATE ra_customer_merges

1865: UPDATE ra_customer_merge_headers
1866: SET request_id = x_account_merge_request_id
1867: WHERE customer_merge_header_id = l_header_id;
1868:
1869: UPDATE ra_customer_merges
1870: SET request_id = x_account_merge_request_id
1871: WHERE customer_merge_header_id = l_header_id;
1872:
1873: END IF;