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 483: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

479: CLOSE c_party_id_log;
480:
481: -- Insert into log table
482: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
483: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
484: MERGE_LOG_ID,
485: TABLE_NAME,
486: PRIMARY_KEY_ID1
487: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

Line 487: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

483: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
484: MERGE_LOG_ID,
485: TABLE_NAME,
486: PRIMARY_KEY_ID1
487: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
488: 'OKC_K_PARTY_ROLES_B',
489: l_log_party_id
490: FROM DUAL;
491:

Line 492: UPDATE HZ_CUSTOMER_MERGE_LOG hz

488: 'OKC_K_PARTY_ROLES_B',
489: l_log_party_id
490: FROM DUAL;
491:
492: UPDATE HZ_CUSTOMER_MERGE_LOG hz
493: SET hz.MERGE_HEADER_ID = (SELECT distinct CUSTOMER_MERGE_HEADER_ID
494: FROM ra_customer_merges rcm
495: WHERE rcm.request_id = req_id
496: and rcm.set_number = set_number

Line 586: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

582:
583: -- contract party roles
584: -- Insert into log table
585: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
586: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
587: MERGE_LOG_ID,
588: TABLE_NAME,
589: MERGE_HEADER_ID,
590: PRIMARY_KEY_ID1,

Line 600: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

596: CREATION_DATE,
597: LAST_UPDATE_LOGIN,
598: LAST_UPDATE_DATE,
599: LAST_UPDATED_BY
600: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
601: 'OKC_K_PARTY_ROLES_B',
602: CUSTOMER_MERGE_HEADER_ID,
603: kpr.ID,
604: kpr.object1_id1,

Line 662: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

658:
659: -- Rules ID1
660: -- Insert into log table
661: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
662: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
663: MERGE_LOG_ID,
664: TABLE_NAME,
665: MERGE_HEADER_ID,
666: PRIMARY_KEY_ID1,

Line 676: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

672: CREATION_DATE,
673: LAST_UPDATE_LOGIN,
674: LAST_UPDATE_DATE,
675: LAST_UPDATED_BY
676: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
677: 'OKC_RULES_B',
678: CUSTOMER_MERGE_HEADER_ID,
679: rle.ID,
680: rle.object1_id1,

Line 739: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

735:
736: -- Rules ID2
737: -- Insert into log table
738: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
739: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
740: MERGE_LOG_ID,
741: TABLE_NAME,
742: MERGE_HEADER_ID,
743: PRIMARY_KEY_ID1,

Line 753: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

749: CREATION_DATE,
750: LAST_UPDATE_LOGIN,
751: LAST_UPDATE_DATE,
752: LAST_UPDATED_BY
753: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
754: 'OKC_RULES_B',
755: CUSTOMER_MERGE_HEADER_ID,
756: rle.ID,
757: rle.object2_id1,

Line 816: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

812:
813: -- Rules ID3
814: -- Insert into log table
815: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
816: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
817: MERGE_LOG_ID,
818: TABLE_NAME,
819: MERGE_HEADER_ID,
820: PRIMARY_KEY_ID1,

Line 830: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

826: CREATION_DATE,
827: LAST_UPDATE_LOGIN,
828: LAST_UPDATE_DATE,
829: LAST_UPDATED_BY
830: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
831: 'OKC_RULES_B',
832: CUSTOMER_MERGE_HEADER_ID,
833: rle.ID,
834: rle.object3_id1,

Line 894: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

890: -- Updating okc_k_headers_b
891: -- Cust_Acct_Id
892: -- Insert into log table
893: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
894: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
895: MERGE_LOG_ID,
896: TABLE_NAME,
897: MERGE_HEADER_ID,
898: PRIMARY_KEY_ID1,

Line 908: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

904: CREATION_DATE,
905: LAST_UPDATE_LOGIN,
906: LAST_UPDATE_DATE,
907: LAST_UPDATED_BY
908: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
909: 'OKC_K_HEADERS_B',
910: CUSTOMER_MERGE_HEADER_ID,
911: okh.ID,
912: to_char(okh.cust_acct_id),

Line 965: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

961: -- Updating okc_k_lines_b
962: -- Cust_Acct_Id
963: -- Insert into log table
964: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
965: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
966: MERGE_LOG_ID,
967: TABLE_NAME,
968: MERGE_HEADER_ID,
969: PRIMARY_KEY_ID1,

Line 979: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

975: CREATION_DATE,
976: LAST_UPDATE_LOGIN,
977: LAST_UPDATE_DATE,
978: LAST_UPDATED_BY
979: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
980: 'OKC_K_LINES_B',
981: CUSTOMER_MERGE_HEADER_ID,
982: okl.ID,
983: to_char(okl.cust_acct_id),

Line 1034: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1030: -- Updating okc_k_party_roles_b
1031: -- Cust_Acct_Id
1032: -- Insert into log table
1033: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1034: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1035: MERGE_LOG_ID,
1036: TABLE_NAME,
1037: MERGE_HEADER_ID,
1038: PRIMARY_KEY_ID1,

Line 1048: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1044: CREATION_DATE,
1045: LAST_UPDATE_LOGIN,
1046: LAST_UPDATE_DATE,
1047: LAST_UPDATED_BY
1048: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1049: 'OKC_K_PARTY_ROLES_B',
1050: CUSTOMER_MERGE_HEADER_ID,
1051: okpr.ID,
1052: to_char(okpr.cust_acct_id),

Line 1104: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1100:
1101: -- contract items
1102: -- Insert into log table
1103: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1104: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1105: MERGE_LOG_ID,
1106: TABLE_NAME,
1107: MERGE_HEADER_ID,
1108: PRIMARY_KEY_ID1,

Line 1118: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1114: CREATION_DATE,
1115: LAST_UPDATE_LOGIN,
1116: LAST_UPDATE_DATE,
1117: LAST_UPDATED_BY
1118: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1119: 'OKC_K_ITEMS',
1120: CUSTOMER_MERGE_HEADER_ID,
1121: cim.ID,
1122: cim.object1_id1,

Line 1203: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1199:
1200: -- Rules ID1
1201: -- Insert into log table
1202: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1203: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1204: MERGE_LOG_ID,
1205: TABLE_NAME,
1206: MERGE_HEADER_ID,
1207: PRIMARY_KEY_ID1,

Line 1217: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1213: CREATION_DATE,
1214: LAST_UPDATE_LOGIN,
1215: LAST_UPDATE_DATE,
1216: LAST_UPDATED_BY
1217: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1218: 'OKC_RULES_B',
1219: CUSTOMER_MERGE_HEADER_ID,
1220: rle.ID,
1221: rle.object1_id1,

Line 1281: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1277:
1278: -- Rules ID2
1279: -- Insert into log table
1280: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1281: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1282: MERGE_LOG_ID,
1283: TABLE_NAME,
1284: MERGE_HEADER_ID,
1285: PRIMARY_KEY_ID1,

Line 1295: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1291: CREATION_DATE,
1292: LAST_UPDATE_LOGIN,
1293: LAST_UPDATE_DATE,
1294: LAST_UPDATED_BY
1295: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1296: 'OKC_RULES_B',
1297: CUSTOMER_MERGE_HEADER_ID,
1298: rle.ID,
1299: rle.object2_id1,

Line 1358: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1354:
1355: -- Rules ID3
1356: -- Insert into log table
1357: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1358: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1359: MERGE_LOG_ID,
1360: TABLE_NAME,
1361: MERGE_HEADER_ID,
1362: PRIMARY_KEY_ID1,

Line 1372: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1368: CREATION_DATE,
1369: LAST_UPDATE_LOGIN,
1370: LAST_UPDATE_DATE,
1371: LAST_UPDATED_BY
1372: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1373: 'OKC_RULES_B',
1374: CUSTOMER_MERGE_HEADER_ID,
1375: rle.ID,
1376: rle.object3_id1,

Line 1438: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1434: -- Account Sites in Items
1435: --
1436: -- Insert into log table
1437: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1438: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1439: MERGE_LOG_ID,
1440: TABLE_NAME,
1441: MERGE_HEADER_ID,
1442: PRIMARY_KEY_ID1,

Line 1452: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1448: CREATION_DATE,
1449: LAST_UPDATE_LOGIN,
1450: LAST_UPDATE_DATE,
1451: LAST_UPDATED_BY
1452: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1453: 'OKC_K_ITEMS',
1454: CUSTOMER_MERGE_HEADER_ID,
1455: cim.ID,
1456: cim.object1_id1,

Line 1525: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1521: --chkrishn 11/03/2004
1522: arp_message.set_line('Updating account site uses for OKE');
1523: -- Insert into log table
1524: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1525: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1526: MERGE_LOG_ID,
1527: TABLE_NAME,
1528: MERGE_HEADER_ID,
1529: PRIMARY_KEY_ID1,

Line 1539: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1535: CREATION_DATE,
1536: LAST_UPDATE_LOGIN,
1537: LAST_UPDATE_DATE,
1538: LAST_UPDATED_BY
1539: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1540: 'OKC_K_PARTY_ROLES_B',
1541: CUSTOMER_MERGE_HEADER_ID,
1542: rle.ID,
1543: rle.object1_id1,

Line 1618: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1614:
1615: -- Rules ID1
1616: -- Insert into log table
1617: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1618: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1619: MERGE_LOG_ID,
1620: TABLE_NAME,
1621: MERGE_HEADER_ID,
1622: PRIMARY_KEY_ID1,

Line 1632: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1628: CREATION_DATE,
1629: LAST_UPDATE_LOGIN,
1630: LAST_UPDATE_DATE,
1631: LAST_UPDATED_BY
1632: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1633: 'OKC_RULES_B',
1634: CUSTOMER_MERGE_HEADER_ID,
1635: rle.ID,
1636: rle.object1_id1,

Line 1694: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1690:
1691: -- Rules ID2
1692: -- Insert into log table
1693: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1694: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1695: MERGE_LOG_ID,
1696: TABLE_NAME,
1697: MERGE_HEADER_ID,
1698: PRIMARY_KEY_ID1,

Line 1708: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1704: CREATION_DATE,
1705: LAST_UPDATE_LOGIN,
1706: LAST_UPDATE_DATE,
1707: LAST_UPDATED_BY
1708: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1709: 'OKC_RULES_B',
1710: CUSTOMER_MERGE_HEADER_ID,
1711: rle.ID,
1712: rle.object2_id1,

Line 1771: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1767:
1768: -- Rules ID3
1769: -- Insert into log table
1770: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1771: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1772: MERGE_LOG_ID,
1773: TABLE_NAME,
1774: MERGE_HEADER_ID,
1775: PRIMARY_KEY_ID1,

Line 1785: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1781: CREATION_DATE,
1782: LAST_UPDATE_LOGIN,
1783: LAST_UPDATE_DATE,
1784: LAST_UPDATED_BY
1785: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1786: 'OKC_RULES_B',
1787: CUSTOMER_MERGE_HEADER_ID,
1788: rle.ID,
1789: rle.object3_id1,

Line 1849: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1845: -- Updating okc_k_headers_b
1846: -- Ship_to_site_use_id
1847: -- Insert into log table
1848: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1849: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1850: MERGE_LOG_ID,
1851: TABLE_NAME,
1852: MERGE_HEADER_ID,
1853: PRIMARY_KEY_ID1,

Line 1863: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1859: CREATION_DATE,
1860: LAST_UPDATE_LOGIN,
1861: LAST_UPDATE_DATE,
1862: LAST_UPDATED_BY
1863: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1864: 'OKC_K_HEADERS_B',
1865: CUSTOMER_MERGE_HEADER_ID,
1866: okh.ID,
1867: to_char(okh.ship_to_site_use_id),

Line 1918: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1914: -- Updating okc_k_headers_b
1915: -- Bill_to_site_use_id
1916: -- Insert into log table
1917: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1918: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1919: MERGE_LOG_ID,
1920: TABLE_NAME,
1921: MERGE_HEADER_ID,
1922: PRIMARY_KEY_ID1,

Line 1932: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1928: CREATION_DATE,
1929: LAST_UPDATE_LOGIN,
1930: LAST_UPDATE_DATE,
1931: LAST_UPDATED_BY
1932: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
1933: 'OKC_K_HEADERS_B',
1934: CUSTOMER_MERGE_HEADER_ID,
1935: okh.ID,
1936: to_char(okh.bill_to_site_use_id),

Line 1986: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

1982: -- Updating okc_k_lines_b
1983: -- Ship_to_site_use_id
1984: -- Insert into log table
1985: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1986: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1987: MERGE_LOG_ID,
1988: TABLE_NAME,
1989: MERGE_HEADER_ID,
1990: PRIMARY_KEY_ID1,

Line 2000: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

1996: CREATION_DATE,
1997: LAST_UPDATE_LOGIN,
1998: LAST_UPDATE_DATE,
1999: LAST_UPDATED_BY
2000: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2001: 'OKC_K_LINES_B',
2002: CUSTOMER_MERGE_HEADER_ID,
2003: okl.ID,
2004: to_char(okl.ship_to_site_use_id),

Line 2055: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2051: -- Updating okc_k_lines_b
2052: -- Bill_to_site_use_id
2053: -- Insert into log table
2054: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2055: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2056: MERGE_LOG_ID,
2057: TABLE_NAME,
2058: MERGE_HEADER_ID,
2059: PRIMARY_KEY_ID1,

Line 2069: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2065: CREATION_DATE,
2066: LAST_UPDATE_LOGIN,
2067: LAST_UPDATE_DATE,
2068: LAST_UPDATED_BY
2069: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2070: 'OKC_K_LINES_B',
2071: CUSTOMER_MERGE_HEADER_ID,
2072: okl.ID,
2073: to_char(okl.bill_to_site_use_id),

Line 2124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2120: -- Updating okc_k_party_roles_b
2121: -- Bill_to_site_use_id
2122: -- Insert into log table
2123: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2124: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2125: MERGE_LOG_ID,
2126: TABLE_NAME,
2127: MERGE_HEADER_ID,
2128: PRIMARY_KEY_ID1,

Line 2138: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2134: CREATION_DATE,
2135: LAST_UPDATE_LOGIN,
2136: LAST_UPDATE_DATE,
2137: LAST_UPDATED_BY
2138: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2139: 'OKC_K_PARTY_ROLES_B',
2140: CUSTOMER_MERGE_HEADER_ID,
2141: okpr.ID,
2142: to_char(okpr.bill_to_site_use_id),

Line 2195: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

2191: -- Account Sites Uses in Items
2192: --
2193: -- Insert into log table
2194: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2195: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2196: MERGE_LOG_ID,
2197: TABLE_NAME,
2198: MERGE_HEADER_ID,
2199: PRIMARY_KEY_ID1,

Line 2209: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,

2205: CREATION_DATE,
2206: LAST_UPDATE_LOGIN,
2207: LAST_UPDATE_DATE,
2208: LAST_UPDATED_BY
2209: ) SELECT HZ_CUSTOMER_MERGE_LOG_s.nextval,
2210: 'OKC_K_ITEMS',
2211: CUSTOMER_MERGE_HEADER_ID,
2212: cim.ID,
2213: cim.object1_id1,