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.OKC_HZ_MERGE_PUB dependencies on HZ_CUSTOMER_MERGE_LOG

Line 20: -- hz_customer_merge_log insert statement

16: -- under two different parties when a predefined set of
17: -- conditions were satisfied
18: -- 14-JAN-03 rbhandar Bug 2446945 - Auditing during account merge
19: -- 04-01-03 rbhandar Bug 2446945 Added who columns and action_flag to
20: -- hz_customer_merge_log insert statement
21: -- 29-MAY-04 amhanda Bug 3555739 Added code in party_merge,account_merge and
22: -- account_site_merge procedure to take care of 11.5.10 rule
23: -- migration changes for OKS
24: -- 01-NOV-04 who Bug 3950642 Added code to take care of site use merge for OKE

Line 490: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

486: CLOSE c_party_id_log;
487:
488: -- Insert into log table
489: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
490: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
491: MERGE_LOG_ID,
492: TABLE_NAME,
493: PRIMARY_KEY_ID1
494: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

Line 494: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

490: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
491: MERGE_LOG_ID,
492: TABLE_NAME,
493: PRIMARY_KEY_ID1
494: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
495: 'OKC_K_PARTY_ROLES_B',
496: l_log_party_id
497: FROM DUAL;
498:

Line 499: UPDATE HZ_CUSTOMER_MERGE_LOG hz

495: 'OKC_K_PARTY_ROLES_B',
496: l_log_party_id
497: FROM DUAL;
498:
499: UPDATE HZ_CUSTOMER_MERGE_LOG hz
500: SET hz.MERGE_HEADER_ID = (SELECT distinct CUSTOMER_MERGE_HEADER_ID
501: FROM ra_customer_merges rcm
502: WHERE rcm.request_id = req_id
503: and rcm.set_number = set_number

Line 607: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

603:
604: -- contract party roles
605: -- Insert into log table
606: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
607: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
608: MERGE_LOG_ID,
609: TABLE_NAME,
610: MERGE_HEADER_ID,
611: PRIMARY_KEY_ID1,

Line 621: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

617: CREATION_DATE,
618: LAST_UPDATE_LOGIN,
619: LAST_UPDATE_DATE,
620: LAST_UPDATED_BY
621: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
622: 'OKC_K_PARTY_ROLES_B',
623: CUSTOMER_MERGE_HEADER_ID,
624: kpr.ID,
625: kpr.object1_id1,

Line 684: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

680:
681: -- Rules ID1
682: -- Insert into log table
683: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
684: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
685: MERGE_LOG_ID,
686: TABLE_NAME,
687: MERGE_HEADER_ID,
688: PRIMARY_KEY_ID1,

Line 698: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

694: CREATION_DATE,
695: LAST_UPDATE_LOGIN,
696: LAST_UPDATE_DATE,
697: LAST_UPDATED_BY
698: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
699: 'OKC_RULES_B',
700: CUSTOMER_MERGE_HEADER_ID,
701: rle.ID,
702: rle.object1_id1,

Line 761: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

757:
758: -- Rules ID2
759: -- Insert into log table
760: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
761: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
762: MERGE_LOG_ID,
763: TABLE_NAME,
764: MERGE_HEADER_ID,
765: PRIMARY_KEY_ID1,

Line 775: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

771: CREATION_DATE,
772: LAST_UPDATE_LOGIN,
773: LAST_UPDATE_DATE,
774: LAST_UPDATED_BY
775: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
776: 'OKC_RULES_B',
777: CUSTOMER_MERGE_HEADER_ID,
778: rle.ID,
779: rle.object2_id1,

Line 838: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

834:
835: -- Rules ID3
836: -- Insert into log table
837: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
838: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
839: MERGE_LOG_ID,
840: TABLE_NAME,
841: MERGE_HEADER_ID,
842: PRIMARY_KEY_ID1,

Line 852: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

848: CREATION_DATE,
849: LAST_UPDATE_LOGIN,
850: LAST_UPDATE_DATE,
851: LAST_UPDATED_BY
852: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
853: 'OKC_RULES_B',
854: CUSTOMER_MERGE_HEADER_ID,
855: rle.ID,
856: rle.object3_id1,

Line 916: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

912: -- Updating okc_k_headers_b
913: -- Cust_Acct_Id
914: -- Insert into log table
915: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
916: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
917: MERGE_LOG_ID,
918: TABLE_NAME,
919: MERGE_HEADER_ID,
920: PRIMARY_KEY_ID1,

Line 930: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

926: CREATION_DATE,
927: LAST_UPDATE_LOGIN,
928: LAST_UPDATE_DATE,
929: LAST_UPDATED_BY
930: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
931: 'OKC_K_HEADERS_B',
932: CUSTOMER_MERGE_HEADER_ID,
933: okh.ID,
934: to_char(okh.cust_acct_id),

Line 988: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

984: -- Updating okc_k_lines_b
985: -- Cust_Acct_Id
986: -- Insert into log table
987: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
988: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
989: MERGE_LOG_ID,
990: TABLE_NAME,
991: MERGE_HEADER_ID,
992: PRIMARY_KEY_ID1,

Line 1002: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

998: CREATION_DATE,
999: LAST_UPDATE_LOGIN,
1000: LAST_UPDATE_DATE,
1001: LAST_UPDATED_BY
1002: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1003: 'OKC_K_LINES_B',
1004: CUSTOMER_MERGE_HEADER_ID,
1005: okl.ID,
1006: to_char(okl.cust_acct_id),

Line 1066: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1062: -- Updating okc_k_party_roles_b
1063: -- Cust_Acct_Id
1064: -- Insert into log table
1065: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1066: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1067: MERGE_LOG_ID,
1068: TABLE_NAME,
1069: MERGE_HEADER_ID,
1070: PRIMARY_KEY_ID1,

Line 1080: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1076: CREATION_DATE,
1077: LAST_UPDATE_LOGIN,
1078: LAST_UPDATE_DATE,
1079: LAST_UPDATED_BY
1080: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1081: 'OKC_K_PARTY_ROLES_B',
1082: CUSTOMER_MERGE_HEADER_ID,
1083: okpr.ID,
1084: to_char(okpr.cust_acct_id),

Line 1137: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1133:
1134: -- contract items
1135: -- Insert into log table
1136: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1137: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1138: MERGE_LOG_ID,
1139: TABLE_NAME,
1140: MERGE_HEADER_ID,
1141: PRIMARY_KEY_ID1,

Line 1151: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1147: CREATION_DATE,
1148: LAST_UPDATE_LOGIN,
1149: LAST_UPDATE_DATE,
1150: LAST_UPDATED_BY
1151: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1152: 'OKC_K_ITEMS',
1153: CUSTOMER_MERGE_HEADER_ID,
1154: cim.ID,
1155: cim.object1_id1,

Line 1300: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1296:
1297: -- Rules ID1
1298: -- Insert into log table
1299: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1300: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1301: MERGE_LOG_ID,
1302: TABLE_NAME,
1303: MERGE_HEADER_ID,
1304: PRIMARY_KEY_ID1,

Line 1314: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1310: CREATION_DATE,
1311: LAST_UPDATE_LOGIN,
1312: LAST_UPDATE_DATE,
1313: LAST_UPDATED_BY
1314: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1315: 'OKC_RULES_B',
1316: CUSTOMER_MERGE_HEADER_ID,
1317: rle.ID,
1318: rle.object1_id1,

Line 1378: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1374:
1375: -- Rules ID2
1376: -- Insert into log table
1377: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1378: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1379: MERGE_LOG_ID,
1380: TABLE_NAME,
1381: MERGE_HEADER_ID,
1382: PRIMARY_KEY_ID1,

Line 1392: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1388: CREATION_DATE,
1389: LAST_UPDATE_LOGIN,
1390: LAST_UPDATE_DATE,
1391: LAST_UPDATED_BY
1392: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1393: 'OKC_RULES_B',
1394: CUSTOMER_MERGE_HEADER_ID,
1395: rle.ID,
1396: rle.object2_id1,

Line 1455: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1451:
1452: -- Rules ID3
1453: -- Insert into log table
1454: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1455: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1456: MERGE_LOG_ID,
1457: TABLE_NAME,
1458: MERGE_HEADER_ID,
1459: PRIMARY_KEY_ID1,

Line 1469: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1465: CREATION_DATE,
1466: LAST_UPDATE_LOGIN,
1467: LAST_UPDATE_DATE,
1468: LAST_UPDATED_BY
1469: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1470: 'OKC_RULES_B',
1471: CUSTOMER_MERGE_HEADER_ID,
1472: rle.ID,
1473: rle.object3_id1,

Line 1535: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1531: -- Account Sites in Items
1532: --
1533: -- Insert into log table
1534: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1535: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1536: MERGE_LOG_ID,
1537: TABLE_NAME,
1538: MERGE_HEADER_ID,
1539: PRIMARY_KEY_ID1,

Line 1549: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1545: CREATION_DATE,
1546: LAST_UPDATE_LOGIN,
1547: LAST_UPDATE_DATE,
1548: LAST_UPDATED_BY
1549: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1550: 'OKC_K_ITEMS',
1551: CUSTOMER_MERGE_HEADER_ID,
1552: cim.ID,
1553: cim.object1_id1,

Line 1622: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1618: --chkrishn 11/03/2004
1619: arp_message.set_line('Updating account site uses for OKE');
1620: -- Insert into log table
1621: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1622: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1623: MERGE_LOG_ID,
1624: TABLE_NAME,
1625: MERGE_HEADER_ID,
1626: PRIMARY_KEY_ID1,

Line 1636: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1632: CREATION_DATE,
1633: LAST_UPDATE_LOGIN,
1634: LAST_UPDATE_DATE,
1635: LAST_UPDATED_BY
1636: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1637: 'OKC_K_PARTY_ROLES_B',
1638: CUSTOMER_MERGE_HEADER_ID,
1639: rle.ID,
1640: rle.object1_id1,

Line 1715: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1711:
1712: -- Rules ID1
1713: -- Insert into log table
1714: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1715: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1716: MERGE_LOG_ID,
1717: TABLE_NAME,
1718: MERGE_HEADER_ID,
1719: PRIMARY_KEY_ID1,

Line 1729: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1725: CREATION_DATE,
1726: LAST_UPDATE_LOGIN,
1727: LAST_UPDATE_DATE,
1728: LAST_UPDATED_BY
1729: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1730: 'OKC_RULES_B',
1731: CUSTOMER_MERGE_HEADER_ID,
1732: rle.ID,
1733: rle.object1_id1,

Line 1791: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1787:
1788: -- Rules ID2
1789: -- Insert into log table
1790: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1791: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1792: MERGE_LOG_ID,
1793: TABLE_NAME,
1794: MERGE_HEADER_ID,
1795: PRIMARY_KEY_ID1,

Line 1805: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1801: CREATION_DATE,
1802: LAST_UPDATE_LOGIN,
1803: LAST_UPDATE_DATE,
1804: LAST_UPDATED_BY
1805: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1806: 'OKC_RULES_B',
1807: CUSTOMER_MERGE_HEADER_ID,
1808: rle.ID,
1809: rle.object2_id1,

Line 1868: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1864:
1865: -- Rules ID3
1866: -- Insert into log table
1867: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1868: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1869: MERGE_LOG_ID,
1870: TABLE_NAME,
1871: MERGE_HEADER_ID,
1872: PRIMARY_KEY_ID1,

Line 1882: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1878: CREATION_DATE,
1879: LAST_UPDATE_LOGIN,
1880: LAST_UPDATE_DATE,
1881: LAST_UPDATED_BY
1882: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1883: 'OKC_RULES_B',
1884: CUSTOMER_MERGE_HEADER_ID,
1885: rle.ID,
1886: rle.object3_id1,

Line 1946: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1942: -- Updating okc_k_headers_b
1943: -- Ship_to_site_use_id
1944: -- Insert into log table
1945: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1946: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1947: MERGE_LOG_ID,
1948: TABLE_NAME,
1949: MERGE_HEADER_ID,
1950: PRIMARY_KEY_ID1,

Line 1960: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1956: CREATION_DATE,
1957: LAST_UPDATE_LOGIN,
1958: LAST_UPDATE_DATE,
1959: LAST_UPDATED_BY
1960: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1961: 'OKC_K_HEADERS_B',
1962: CUSTOMER_MERGE_HEADER_ID,
1963: okh.ID,
1964: to_char(okh.ship_to_site_use_id),

Line 2016: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2012: -- Updating okc_k_headers_b
2013: -- Bill_to_site_use_id
2014: -- Insert into log table
2015: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2016: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2017: MERGE_LOG_ID,
2018: TABLE_NAME,
2019: MERGE_HEADER_ID,
2020: PRIMARY_KEY_ID1,

Line 2030: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2026: CREATION_DATE,
2027: LAST_UPDATE_LOGIN,
2028: LAST_UPDATE_DATE,
2029: LAST_UPDATED_BY
2030: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2031: 'OKC_K_HEADERS_B',
2032: CUSTOMER_MERGE_HEADER_ID,
2033: okh.ID,
2034: to_char(okh.bill_to_site_use_id),

Line 2085: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2081: -- Updating okc_k_lines_b
2082: -- Ship_to_site_use_id
2083: -- Insert into log table
2084: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2085: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2086: MERGE_LOG_ID,
2087: TABLE_NAME,
2088: MERGE_HEADER_ID,
2089: PRIMARY_KEY_ID1,

Line 2099: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2095: CREATION_DATE,
2096: LAST_UPDATE_LOGIN,
2097: LAST_UPDATE_DATE,
2098: LAST_UPDATED_BY
2099: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2100: 'OKC_K_LINES_B',
2101: CUSTOMER_MERGE_HEADER_ID,
2102: okl.ID,
2103: to_char(okl.ship_to_site_use_id),

Line 2163: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2159: -- Updating okc_k_lines_b
2160: -- Bill_to_site_use_id
2161: -- Insert into log table
2162: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2163: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2164: MERGE_LOG_ID,
2165: TABLE_NAME,
2166: MERGE_HEADER_ID,
2167: PRIMARY_KEY_ID1,

Line 2177: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2173: CREATION_DATE,
2174: LAST_UPDATE_LOGIN,
2175: LAST_UPDATE_DATE,
2176: LAST_UPDATED_BY
2177: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2178: 'OKC_K_LINES_B',
2179: CUSTOMER_MERGE_HEADER_ID,
2180: okl.ID,
2181: to_char(okl.bill_to_site_use_id),

Line 2233: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2229: -- Updating okc_k_party_roles_b
2230: -- Bill_to_site_use_id
2231: -- Insert into log table
2232: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2233: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2234: MERGE_LOG_ID,
2235: TABLE_NAME,
2236: MERGE_HEADER_ID,
2237: PRIMARY_KEY_ID1,

Line 2247: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2243: CREATION_DATE,
2244: LAST_UPDATE_LOGIN,
2245: LAST_UPDATE_DATE,
2246: LAST_UPDATED_BY
2247: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2248: 'OKC_K_PARTY_ROLES_B',
2249: CUSTOMER_MERGE_HEADER_ID,
2250: okpr.ID,
2251: to_char(okpr.bill_to_site_use_id),

Line 2305: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2301: -- Account Sites Uses in Items
2302: --
2303: -- Insert into log table
2304: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2305: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2306: MERGE_LOG_ID,
2307: TABLE_NAME,
2308: MERGE_HEADER_ID,
2309: PRIMARY_KEY_ID1,

Line 2319: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2315: CREATION_DATE,
2316: LAST_UPDATE_LOGIN,
2317: LAST_UPDATE_DATE,
2318: LAST_UPDATED_BY
2319: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2320: 'OKC_K_ITEMS',
2321: CUSTOMER_MERGE_HEADER_ID,
2322: cim.ID,
2323: cim.object1_id1,