APPS.OKC_HZ_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 508: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY

504: and rcm.process_flag = 'N')
505: ,hz.VCHAR_COL1_ORIG = l_source_party_id
506: ,hz.VCHAR_COL1_NEW = l_target_party_id
507: ,hz.REQUEST_ID = req_id
508: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
509: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
510: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
511: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
512: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY

Line 509: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE

505: ,hz.VCHAR_COL1_ORIG = l_source_party_id
506: ,hz.VCHAR_COL1_NEW = l_target_party_id
507: ,hz.REQUEST_ID = req_id
508: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
509: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
510: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
511: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
512: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
513: ,hz.ACTION_FLAG = 'U'

Line 510: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN

506: ,hz.VCHAR_COL1_NEW = l_target_party_id
507: ,hz.REQUEST_ID = req_id
508: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
509: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
510: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
511: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
512: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
513: ,hz.ACTION_FLAG = 'U'
514: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;

Line 511: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE

507: ,hz.REQUEST_ID = req_id
508: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
509: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
510: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
511: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
512: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
513: ,hz.ACTION_FLAG = 'U'
514: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
515: END IF;

Line 512: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY

508: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
509: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
510: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
511: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
512: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
513: ,hz.ACTION_FLAG = 'U'
514: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
515: END IF;
516: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h

Line 629: hz_utility_pub.CREATED_BY,

625: kpr.object1_id1,
626: to_char(rcm.customer_id),
627: req_id,
628: 'U',
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY

Line 630: hz_utility_pub.CREATION_DATE,

626: to_char(rcm.customer_id),
627: req_id,
628: 'U',
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm

Line 631: hz_utility_pub.LAST_UPDATE_LOGIN,

627: req_id,
628: 'U',
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
635: WHERE (

Line 632: hz_utility_pub.LAST_UPDATE_DATE,

628: 'U',
629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
635: WHERE (
636: kpr.object1_id1 = to_char(rcm.duplicate_id)

Line 633: hz_utility_pub.LAST_UPDATED_BY

629: hz_utility_pub.CREATED_BY,
630: hz_utility_pub.CREATION_DATE,
631: hz_utility_pub.LAST_UPDATE_LOGIN,
632: hz_utility_pub.LAST_UPDATE_DATE,
633: hz_utility_pub.LAST_UPDATED_BY
634: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
635: WHERE (
636: kpr.object1_id1 = to_char(rcm.duplicate_id)
637: ) AND rcm.process_flag = 'N'

Line 706: hz_utility_pub.CREATED_BY,

702: rle.object1_id1,
703: to_char(rcm.customer_id),
704: req_id,
705: 'U',
706: hz_utility_pub.CREATED_BY,
707: hz_utility_pub.CREATION_DATE,
708: hz_utility_pub.LAST_UPDATE_LOGIN,
709: hz_utility_pub.LAST_UPDATE_DATE,
710: hz_utility_pub.LAST_UPDATED_BY

Line 707: hz_utility_pub.CREATION_DATE,

703: to_char(rcm.customer_id),
704: req_id,
705: 'U',
706: hz_utility_pub.CREATED_BY,
707: hz_utility_pub.CREATION_DATE,
708: hz_utility_pub.LAST_UPDATE_LOGIN,
709: hz_utility_pub.LAST_UPDATE_DATE,
710: hz_utility_pub.LAST_UPDATED_BY
711: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 708: hz_utility_pub.LAST_UPDATE_LOGIN,

704: req_id,
705: 'U',
706: hz_utility_pub.CREATED_BY,
707: hz_utility_pub.CREATION_DATE,
708: hz_utility_pub.LAST_UPDATE_LOGIN,
709: hz_utility_pub.LAST_UPDATE_DATE,
710: hz_utility_pub.LAST_UPDATED_BY
711: FROM OKC_RULES_B rle, ra_customer_merges rcm
712: WHERE (

Line 709: hz_utility_pub.LAST_UPDATE_DATE,

705: 'U',
706: hz_utility_pub.CREATED_BY,
707: hz_utility_pub.CREATION_DATE,
708: hz_utility_pub.LAST_UPDATE_LOGIN,
709: hz_utility_pub.LAST_UPDATE_DATE,
710: hz_utility_pub.LAST_UPDATED_BY
711: FROM OKC_RULES_B rle, ra_customer_merges rcm
712: WHERE (
713: rle.object1_id1 = to_char(rcm.duplicate_id)

Line 710: hz_utility_pub.LAST_UPDATED_BY

706: hz_utility_pub.CREATED_BY,
707: hz_utility_pub.CREATION_DATE,
708: hz_utility_pub.LAST_UPDATE_LOGIN,
709: hz_utility_pub.LAST_UPDATE_DATE,
710: hz_utility_pub.LAST_UPDATED_BY
711: FROM OKC_RULES_B rle, ra_customer_merges rcm
712: WHERE (
713: rle.object1_id1 = to_char(rcm.duplicate_id)
714: ) AND rcm.process_flag = 'N'

Line 783: hz_utility_pub.CREATED_BY,

779: rle.object2_id1,
780: to_char(rcm.customer_id),
781: req_id,
782: 'U',
783: hz_utility_pub.CREATED_BY,
784: hz_utility_pub.CREATION_DATE,
785: hz_utility_pub.LAST_UPDATE_LOGIN,
786: hz_utility_pub.LAST_UPDATE_DATE,
787: hz_utility_pub.LAST_UPDATED_BY

Line 784: hz_utility_pub.CREATION_DATE,

780: to_char(rcm.customer_id),
781: req_id,
782: 'U',
783: hz_utility_pub.CREATED_BY,
784: hz_utility_pub.CREATION_DATE,
785: hz_utility_pub.LAST_UPDATE_LOGIN,
786: hz_utility_pub.LAST_UPDATE_DATE,
787: hz_utility_pub.LAST_UPDATED_BY
788: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 785: hz_utility_pub.LAST_UPDATE_LOGIN,

781: req_id,
782: 'U',
783: hz_utility_pub.CREATED_BY,
784: hz_utility_pub.CREATION_DATE,
785: hz_utility_pub.LAST_UPDATE_LOGIN,
786: hz_utility_pub.LAST_UPDATE_DATE,
787: hz_utility_pub.LAST_UPDATED_BY
788: FROM OKC_RULES_B rle, ra_customer_merges rcm
789: WHERE (

Line 786: hz_utility_pub.LAST_UPDATE_DATE,

782: 'U',
783: hz_utility_pub.CREATED_BY,
784: hz_utility_pub.CREATION_DATE,
785: hz_utility_pub.LAST_UPDATE_LOGIN,
786: hz_utility_pub.LAST_UPDATE_DATE,
787: hz_utility_pub.LAST_UPDATED_BY
788: FROM OKC_RULES_B rle, ra_customer_merges rcm
789: WHERE (
790: rle.object2_id1 = to_char(rcm.duplicate_id)

Line 787: hz_utility_pub.LAST_UPDATED_BY

783: hz_utility_pub.CREATED_BY,
784: hz_utility_pub.CREATION_DATE,
785: hz_utility_pub.LAST_UPDATE_LOGIN,
786: hz_utility_pub.LAST_UPDATE_DATE,
787: hz_utility_pub.LAST_UPDATED_BY
788: FROM OKC_RULES_B rle, ra_customer_merges rcm
789: WHERE (
790: rle.object2_id1 = to_char(rcm.duplicate_id)
791: ) AND rcm.process_flag = 'N'

Line 860: hz_utility_pub.CREATED_BY,

856: rle.object3_id1,
857: to_char(rcm.customer_id),
858: req_id,
859: 'U',
860: hz_utility_pub.CREATED_BY,
861: hz_utility_pub.CREATION_DATE,
862: hz_utility_pub.LAST_UPDATE_LOGIN,
863: hz_utility_pub.LAST_UPDATE_DATE,
864: hz_utility_pub.LAST_UPDATED_BY

Line 861: hz_utility_pub.CREATION_DATE,

857: to_char(rcm.customer_id),
858: req_id,
859: 'U',
860: hz_utility_pub.CREATED_BY,
861: hz_utility_pub.CREATION_DATE,
862: hz_utility_pub.LAST_UPDATE_LOGIN,
863: hz_utility_pub.LAST_UPDATE_DATE,
864: hz_utility_pub.LAST_UPDATED_BY
865: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 862: hz_utility_pub.LAST_UPDATE_LOGIN,

858: req_id,
859: 'U',
860: hz_utility_pub.CREATED_BY,
861: hz_utility_pub.CREATION_DATE,
862: hz_utility_pub.LAST_UPDATE_LOGIN,
863: hz_utility_pub.LAST_UPDATE_DATE,
864: hz_utility_pub.LAST_UPDATED_BY
865: FROM OKC_RULES_B rle, ra_customer_merges rcm
866: WHERE (

Line 863: hz_utility_pub.LAST_UPDATE_DATE,

859: 'U',
860: hz_utility_pub.CREATED_BY,
861: hz_utility_pub.CREATION_DATE,
862: hz_utility_pub.LAST_UPDATE_LOGIN,
863: hz_utility_pub.LAST_UPDATE_DATE,
864: hz_utility_pub.LAST_UPDATED_BY
865: FROM OKC_RULES_B rle, ra_customer_merges rcm
866: WHERE (
867: rle.object3_id1 = to_char(rcm.duplicate_id)

Line 864: hz_utility_pub.LAST_UPDATED_BY

860: hz_utility_pub.CREATED_BY,
861: hz_utility_pub.CREATION_DATE,
862: hz_utility_pub.LAST_UPDATE_LOGIN,
863: hz_utility_pub.LAST_UPDATE_DATE,
864: hz_utility_pub.LAST_UPDATED_BY
865: FROM OKC_RULES_B rle, ra_customer_merges rcm
866: WHERE (
867: rle.object3_id1 = to_char(rcm.duplicate_id)
868: ) AND rcm.process_flag = 'N'

Line 938: hz_utility_pub.CREATED_BY,

934: to_char(okh.cust_acct_id),
935: to_char(rcm.customer_id),
936: req_id,
937: 'U',
938: hz_utility_pub.CREATED_BY,
939: hz_utility_pub.CREATION_DATE,
940: hz_utility_pub.LAST_UPDATE_LOGIN,
941: hz_utility_pub.LAST_UPDATE_DATE,
942: hz_utility_pub.LAST_UPDATED_BY

Line 939: hz_utility_pub.CREATION_DATE,

935: to_char(rcm.customer_id),
936: req_id,
937: 'U',
938: hz_utility_pub.CREATED_BY,
939: hz_utility_pub.CREATION_DATE,
940: hz_utility_pub.LAST_UPDATE_LOGIN,
941: hz_utility_pub.LAST_UPDATE_DATE,
942: hz_utility_pub.LAST_UPDATED_BY
943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

Line 940: hz_utility_pub.LAST_UPDATE_LOGIN,

936: req_id,
937: 'U',
938: hz_utility_pub.CREATED_BY,
939: hz_utility_pub.CREATION_DATE,
940: hz_utility_pub.LAST_UPDATE_LOGIN,
941: hz_utility_pub.LAST_UPDATE_DATE,
942: hz_utility_pub.LAST_UPDATED_BY
943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
944: WHERE (

Line 941: hz_utility_pub.LAST_UPDATE_DATE,

937: 'U',
938: hz_utility_pub.CREATED_BY,
939: hz_utility_pub.CREATION_DATE,
940: hz_utility_pub.LAST_UPDATE_LOGIN,
941: hz_utility_pub.LAST_UPDATE_DATE,
942: hz_utility_pub.LAST_UPDATED_BY
943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
944: WHERE (
945: okh.cust_acct_id = rcm.duplicate_id

Line 942: hz_utility_pub.LAST_UPDATED_BY

938: hz_utility_pub.CREATED_BY,
939: hz_utility_pub.CREATION_DATE,
940: hz_utility_pub.LAST_UPDATE_LOGIN,
941: hz_utility_pub.LAST_UPDATE_DATE,
942: hz_utility_pub.LAST_UPDATED_BY
943: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
944: WHERE (
945: okh.cust_acct_id = rcm.duplicate_id
946: ) AND rcm.process_flag = 'N'

Line 1010: hz_utility_pub.CREATED_BY,

1006: to_char(okl.cust_acct_id),
1007: to_char(rcm.customer_id),
1008: req_id,
1009: 'U',
1010: hz_utility_pub.CREATED_BY,
1011: hz_utility_pub.CREATION_DATE,
1012: hz_utility_pub.LAST_UPDATE_LOGIN,
1013: hz_utility_pub.LAST_UPDATE_DATE,
1014: hz_utility_pub.LAST_UPDATED_BY

Line 1011: hz_utility_pub.CREATION_DATE,

1007: to_char(rcm.customer_id),
1008: req_id,
1009: 'U',
1010: hz_utility_pub.CREATED_BY,
1011: hz_utility_pub.CREATION_DATE,
1012: hz_utility_pub.LAST_UPDATE_LOGIN,
1013: hz_utility_pub.LAST_UPDATE_DATE,
1014: hz_utility_pub.LAST_UPDATED_BY
1015: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

Line 1012: hz_utility_pub.LAST_UPDATE_LOGIN,

1008: req_id,
1009: 'U',
1010: hz_utility_pub.CREATED_BY,
1011: hz_utility_pub.CREATION_DATE,
1012: hz_utility_pub.LAST_UPDATE_LOGIN,
1013: hz_utility_pub.LAST_UPDATE_DATE,
1014: hz_utility_pub.LAST_UPDATED_BY
1015: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
1016: WHERE (

Line 1013: hz_utility_pub.LAST_UPDATE_DATE,

1009: 'U',
1010: hz_utility_pub.CREATED_BY,
1011: hz_utility_pub.CREATION_DATE,
1012: hz_utility_pub.LAST_UPDATE_LOGIN,
1013: hz_utility_pub.LAST_UPDATE_DATE,
1014: hz_utility_pub.LAST_UPDATED_BY
1015: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
1016: WHERE (
1017: okl.cust_acct_id = rcm.duplicate_id

Line 1014: hz_utility_pub.LAST_UPDATED_BY

1010: hz_utility_pub.CREATED_BY,
1011: hz_utility_pub.CREATION_DATE,
1012: hz_utility_pub.LAST_UPDATE_LOGIN,
1013: hz_utility_pub.LAST_UPDATE_DATE,
1014: hz_utility_pub.LAST_UPDATED_BY
1015: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
1016: WHERE (
1017: okl.cust_acct_id = rcm.duplicate_id
1018: ) AND rcm.process_flag = 'N'

Line 1088: hz_utility_pub.CREATED_BY,

1084: to_char(okpr.cust_acct_id),
1085: to_char(rcm.customer_id),
1086: req_id,
1087: 'U',
1088: hz_utility_pub.CREATED_BY,
1089: hz_utility_pub.CREATION_DATE,
1090: hz_utility_pub.LAST_UPDATE_LOGIN,
1091: hz_utility_pub.LAST_UPDATE_DATE,
1092: hz_utility_pub.LAST_UPDATED_BY

Line 1089: hz_utility_pub.CREATION_DATE,

1085: to_char(rcm.customer_id),
1086: req_id,
1087: 'U',
1088: hz_utility_pub.CREATED_BY,
1089: hz_utility_pub.CREATION_DATE,
1090: hz_utility_pub.LAST_UPDATE_LOGIN,
1091: hz_utility_pub.LAST_UPDATE_DATE,
1092: hz_utility_pub.LAST_UPDATED_BY
1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

Line 1090: hz_utility_pub.LAST_UPDATE_LOGIN,

1086: req_id,
1087: 'U',
1088: hz_utility_pub.CREATED_BY,
1089: hz_utility_pub.CREATION_DATE,
1090: hz_utility_pub.LAST_UPDATE_LOGIN,
1091: hz_utility_pub.LAST_UPDATE_DATE,
1092: hz_utility_pub.LAST_UPDATED_BY
1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1094: WHERE (

Line 1091: hz_utility_pub.LAST_UPDATE_DATE,

1087: 'U',
1088: hz_utility_pub.CREATED_BY,
1089: hz_utility_pub.CREATION_DATE,
1090: hz_utility_pub.LAST_UPDATE_LOGIN,
1091: hz_utility_pub.LAST_UPDATE_DATE,
1092: hz_utility_pub.LAST_UPDATED_BY
1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1094: WHERE (
1095: okpr.cust_acct_id = rcm.duplicate_id

Line 1092: hz_utility_pub.LAST_UPDATED_BY

1088: hz_utility_pub.CREATED_BY,
1089: hz_utility_pub.CREATION_DATE,
1090: hz_utility_pub.LAST_UPDATE_LOGIN,
1091: hz_utility_pub.LAST_UPDATE_DATE,
1092: hz_utility_pub.LAST_UPDATED_BY
1093: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1094: WHERE (
1095: okpr.cust_acct_id = rcm.duplicate_id
1096: ) AND rcm.process_flag = 'N'

Line 1159: hz_utility_pub.CREATED_BY,

1155: cim.object1_id1,
1156: to_char(rcm.customer_id),
1157: req_id,
1158: 'U',
1159: hz_utility_pub.CREATED_BY,
1160: hz_utility_pub.CREATION_DATE,
1161: hz_utility_pub.LAST_UPDATE_LOGIN,
1162: hz_utility_pub.LAST_UPDATE_DATE,
1163: hz_utility_pub.LAST_UPDATED_BY

Line 1160: hz_utility_pub.CREATION_DATE,

1156: to_char(rcm.customer_id),
1157: req_id,
1158: 'U',
1159: hz_utility_pub.CREATED_BY,
1160: hz_utility_pub.CREATION_DATE,
1161: hz_utility_pub.LAST_UPDATE_LOGIN,
1162: hz_utility_pub.LAST_UPDATE_DATE,
1163: hz_utility_pub.LAST_UPDATED_BY
1164: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

Line 1161: hz_utility_pub.LAST_UPDATE_LOGIN,

1157: req_id,
1158: 'U',
1159: hz_utility_pub.CREATED_BY,
1160: hz_utility_pub.CREATION_DATE,
1161: hz_utility_pub.LAST_UPDATE_LOGIN,
1162: hz_utility_pub.LAST_UPDATE_DATE,
1163: hz_utility_pub.LAST_UPDATED_BY
1164: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1165: WHERE (

Line 1162: hz_utility_pub.LAST_UPDATE_DATE,

1158: 'U',
1159: hz_utility_pub.CREATED_BY,
1160: hz_utility_pub.CREATION_DATE,
1161: hz_utility_pub.LAST_UPDATE_LOGIN,
1162: hz_utility_pub.LAST_UPDATE_DATE,
1163: hz_utility_pub.LAST_UPDATED_BY
1164: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1165: WHERE (
1166: cim.object1_id1 = to_char(rcm.duplicate_id)

Line 1163: hz_utility_pub.LAST_UPDATED_BY

1159: hz_utility_pub.CREATED_BY,
1160: hz_utility_pub.CREATION_DATE,
1161: hz_utility_pub.LAST_UPDATE_LOGIN,
1162: hz_utility_pub.LAST_UPDATE_DATE,
1163: hz_utility_pub.LAST_UPDATED_BY
1164: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1165: WHERE (
1166: cim.object1_id1 = to_char(rcm.duplicate_id)
1167: ) AND rcm.process_flag = 'N'

Line 1322: hz_utility_pub.CREATED_BY,

1318: rle.object1_id1,
1319: to_char(customer_address_id),
1320: req_id,
1321: 'U',
1322: hz_utility_pub.CREATED_BY,
1323: hz_utility_pub.CREATION_DATE,
1324: hz_utility_pub.LAST_UPDATE_LOGIN,
1325: hz_utility_pub.LAST_UPDATE_DATE,
1326: hz_utility_pub.LAST_UPDATED_BY

Line 1323: hz_utility_pub.CREATION_DATE,

1319: to_char(customer_address_id),
1320: req_id,
1321: 'U',
1322: hz_utility_pub.CREATED_BY,
1323: hz_utility_pub.CREATION_DATE,
1324: hz_utility_pub.LAST_UPDATE_LOGIN,
1325: hz_utility_pub.LAST_UPDATE_DATE,
1326: hz_utility_pub.LAST_UPDATED_BY
1327: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1324: hz_utility_pub.LAST_UPDATE_LOGIN,

1320: req_id,
1321: 'U',
1322: hz_utility_pub.CREATED_BY,
1323: hz_utility_pub.CREATION_DATE,
1324: hz_utility_pub.LAST_UPDATE_LOGIN,
1325: hz_utility_pub.LAST_UPDATE_DATE,
1326: hz_utility_pub.LAST_UPDATED_BY
1327: FROM OKC_RULES_B rle, ra_customer_merges rcm
1328: WHERE (

Line 1325: hz_utility_pub.LAST_UPDATE_DATE,

1321: 'U',
1322: hz_utility_pub.CREATED_BY,
1323: hz_utility_pub.CREATION_DATE,
1324: hz_utility_pub.LAST_UPDATE_LOGIN,
1325: hz_utility_pub.LAST_UPDATE_DATE,
1326: hz_utility_pub.LAST_UPDATED_BY
1327: FROM OKC_RULES_B rle, ra_customer_merges rcm
1328: WHERE (
1329: rle.object1_id1 = to_char(rcm.duplicate_address_id)

Line 1326: hz_utility_pub.LAST_UPDATED_BY

1322: hz_utility_pub.CREATED_BY,
1323: hz_utility_pub.CREATION_DATE,
1324: hz_utility_pub.LAST_UPDATE_LOGIN,
1325: hz_utility_pub.LAST_UPDATE_DATE,
1326: hz_utility_pub.LAST_UPDATED_BY
1327: FROM OKC_RULES_B rle, ra_customer_merges rcm
1328: WHERE (
1329: rle.object1_id1 = to_char(rcm.duplicate_address_id)
1330: ) AND rcm.process_flag = 'N'

Line 1400: hz_utility_pub.CREATED_BY,

1396: rle.object2_id1,
1397: to_char(customer_address_id),
1398: req_id,
1399: 'U',
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY

Line 1401: hz_utility_pub.CREATION_DATE,

1397: to_char(customer_address_id),
1398: req_id,
1399: 'U',
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1402: hz_utility_pub.LAST_UPDATE_LOGIN,

1398: req_id,
1399: 'U',
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: FROM OKC_RULES_B rle, ra_customer_merges rcm
1406: WHERE (

Line 1403: hz_utility_pub.LAST_UPDATE_DATE,

1399: 'U',
1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: FROM OKC_RULES_B rle, ra_customer_merges rcm
1406: WHERE (
1407: rle.object2_id1 = to_char(rcm.duplicate_address_id)

Line 1404: hz_utility_pub.LAST_UPDATED_BY

1400: hz_utility_pub.CREATED_BY,
1401: hz_utility_pub.CREATION_DATE,
1402: hz_utility_pub.LAST_UPDATE_LOGIN,
1403: hz_utility_pub.LAST_UPDATE_DATE,
1404: hz_utility_pub.LAST_UPDATED_BY
1405: FROM OKC_RULES_B rle, ra_customer_merges rcm
1406: WHERE (
1407: rle.object2_id1 = to_char(rcm.duplicate_address_id)
1408: ) AND rcm.process_flag = 'N'

Line 1477: hz_utility_pub.CREATED_BY,

1473: rle.object3_id1,
1474: to_char(customer_address_id),
1475: req_id,
1476: 'U',
1477: hz_utility_pub.CREATED_BY,
1478: hz_utility_pub.CREATION_DATE,
1479: hz_utility_pub.LAST_UPDATE_LOGIN,
1480: hz_utility_pub.LAST_UPDATE_DATE,
1481: hz_utility_pub.LAST_UPDATED_BY

Line 1478: hz_utility_pub.CREATION_DATE,

1474: to_char(customer_address_id),
1475: req_id,
1476: 'U',
1477: hz_utility_pub.CREATED_BY,
1478: hz_utility_pub.CREATION_DATE,
1479: hz_utility_pub.LAST_UPDATE_LOGIN,
1480: hz_utility_pub.LAST_UPDATE_DATE,
1481: hz_utility_pub.LAST_UPDATED_BY
1482: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1479: hz_utility_pub.LAST_UPDATE_LOGIN,

1475: req_id,
1476: 'U',
1477: hz_utility_pub.CREATED_BY,
1478: hz_utility_pub.CREATION_DATE,
1479: hz_utility_pub.LAST_UPDATE_LOGIN,
1480: hz_utility_pub.LAST_UPDATE_DATE,
1481: hz_utility_pub.LAST_UPDATED_BY
1482: FROM OKC_RULES_B rle, ra_customer_merges rcm
1483: WHERE (

Line 1480: hz_utility_pub.LAST_UPDATE_DATE,

1476: 'U',
1477: hz_utility_pub.CREATED_BY,
1478: hz_utility_pub.CREATION_DATE,
1479: hz_utility_pub.LAST_UPDATE_LOGIN,
1480: hz_utility_pub.LAST_UPDATE_DATE,
1481: hz_utility_pub.LAST_UPDATED_BY
1482: FROM OKC_RULES_B rle, ra_customer_merges rcm
1483: WHERE (
1484: rle.object3_id1 = to_char(rcm.duplicate_address_id)

Line 1481: hz_utility_pub.LAST_UPDATED_BY

1477: hz_utility_pub.CREATED_BY,
1478: hz_utility_pub.CREATION_DATE,
1479: hz_utility_pub.LAST_UPDATE_LOGIN,
1480: hz_utility_pub.LAST_UPDATE_DATE,
1481: hz_utility_pub.LAST_UPDATED_BY
1482: FROM OKC_RULES_B rle, ra_customer_merges rcm
1483: WHERE (
1484: rle.object3_id1 = to_char(rcm.duplicate_address_id)
1485: ) AND rcm.process_flag = 'N'

Line 1557: hz_utility_pub.CREATED_BY,

1553: cim.object1_id1,
1554: to_char(rcm.customer_address_id),
1555: req_id,
1556: 'U',
1557: hz_utility_pub.CREATED_BY,
1558: hz_utility_pub.CREATION_DATE,
1559: hz_utility_pub.LAST_UPDATE_LOGIN,
1560: hz_utility_pub.LAST_UPDATE_DATE,
1561: hz_utility_pub.LAST_UPDATED_BY

Line 1558: hz_utility_pub.CREATION_DATE,

1554: to_char(rcm.customer_address_id),
1555: req_id,
1556: 'U',
1557: hz_utility_pub.CREATED_BY,
1558: hz_utility_pub.CREATION_DATE,
1559: hz_utility_pub.LAST_UPDATE_LOGIN,
1560: hz_utility_pub.LAST_UPDATE_DATE,
1561: hz_utility_pub.LAST_UPDATED_BY
1562: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

Line 1559: hz_utility_pub.LAST_UPDATE_LOGIN,

1555: req_id,
1556: 'U',
1557: hz_utility_pub.CREATED_BY,
1558: hz_utility_pub.CREATION_DATE,
1559: hz_utility_pub.LAST_UPDATE_LOGIN,
1560: hz_utility_pub.LAST_UPDATE_DATE,
1561: hz_utility_pub.LAST_UPDATED_BY
1562: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1563: WHERE (

Line 1560: hz_utility_pub.LAST_UPDATE_DATE,

1556: 'U',
1557: hz_utility_pub.CREATED_BY,
1558: hz_utility_pub.CREATION_DATE,
1559: hz_utility_pub.LAST_UPDATE_LOGIN,
1560: hz_utility_pub.LAST_UPDATE_DATE,
1561: hz_utility_pub.LAST_UPDATED_BY
1562: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1563: WHERE (
1564: cim.object1_id1 = to_char(rcm.duplicate_address_id)

Line 1561: hz_utility_pub.LAST_UPDATED_BY

1557: hz_utility_pub.CREATED_BY,
1558: hz_utility_pub.CREATION_DATE,
1559: hz_utility_pub.LAST_UPDATE_LOGIN,
1560: hz_utility_pub.LAST_UPDATE_DATE,
1561: hz_utility_pub.LAST_UPDATED_BY
1562: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1563: WHERE (
1564: cim.object1_id1 = to_char(rcm.duplicate_address_id)
1565: ) AND rcm.process_flag = 'N'

Line 1644: hz_utility_pub.CREATED_BY,

1640: rle.object1_id1,
1641: to_char(rcm.customer_site_id),
1642: req_id,
1643: 'U',
1644: hz_utility_pub.CREATED_BY,
1645: hz_utility_pub.CREATION_DATE,
1646: hz_utility_pub.LAST_UPDATE_LOGIN,
1647: hz_utility_pub.LAST_UPDATE_DATE,
1648: hz_utility_pub.LAST_UPDATED_BY

Line 1645: hz_utility_pub.CREATION_DATE,

1641: to_char(rcm.customer_site_id),
1642: req_id,
1643: 'U',
1644: hz_utility_pub.CREATED_BY,
1645: hz_utility_pub.CREATION_DATE,
1646: hz_utility_pub.LAST_UPDATE_LOGIN,
1647: hz_utility_pub.LAST_UPDATE_DATE,
1648: hz_utility_pub.LAST_UPDATED_BY
1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm

Line 1646: hz_utility_pub.LAST_UPDATE_LOGIN,

1642: req_id,
1643: 'U',
1644: hz_utility_pub.CREATED_BY,
1645: hz_utility_pub.CREATION_DATE,
1646: hz_utility_pub.LAST_UPDATE_LOGIN,
1647: hz_utility_pub.LAST_UPDATE_DATE,
1648: hz_utility_pub.LAST_UPDATED_BY
1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1650: WHERE (

Line 1647: hz_utility_pub.LAST_UPDATE_DATE,

1643: 'U',
1644: hz_utility_pub.CREATED_BY,
1645: hz_utility_pub.CREATION_DATE,
1646: hz_utility_pub.LAST_UPDATE_LOGIN,
1647: hz_utility_pub.LAST_UPDATE_DATE,
1648: hz_utility_pub.LAST_UPDATED_BY
1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1650: WHERE (
1651: rle.object1_id1 = to_char(rcm.duplicate_site_id)

Line 1648: hz_utility_pub.LAST_UPDATED_BY

1644: hz_utility_pub.CREATED_BY,
1645: hz_utility_pub.CREATION_DATE,
1646: hz_utility_pub.LAST_UPDATE_LOGIN,
1647: hz_utility_pub.LAST_UPDATE_DATE,
1648: hz_utility_pub.LAST_UPDATED_BY
1649: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1650: WHERE (
1651: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1652: ) AND rcm.process_flag = 'N'

Line 1737: hz_utility_pub.CREATED_BY,

1733: rle.object1_id1,
1734: to_char(rcm.customer_site_id),
1735: req_id,
1736: 'U',
1737: hz_utility_pub.CREATED_BY,
1738: hz_utility_pub.CREATION_DATE,
1739: hz_utility_pub.LAST_UPDATE_LOGIN,
1740: hz_utility_pub.LAST_UPDATE_DATE,
1741: hz_utility_pub.LAST_UPDATED_BY

Line 1738: hz_utility_pub.CREATION_DATE,

1734: to_char(rcm.customer_site_id),
1735: req_id,
1736: 'U',
1737: hz_utility_pub.CREATED_BY,
1738: hz_utility_pub.CREATION_DATE,
1739: hz_utility_pub.LAST_UPDATE_LOGIN,
1740: hz_utility_pub.LAST_UPDATE_DATE,
1741: hz_utility_pub.LAST_UPDATED_BY
1742: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1739: hz_utility_pub.LAST_UPDATE_LOGIN,

1735: req_id,
1736: 'U',
1737: hz_utility_pub.CREATED_BY,
1738: hz_utility_pub.CREATION_DATE,
1739: hz_utility_pub.LAST_UPDATE_LOGIN,
1740: hz_utility_pub.LAST_UPDATE_DATE,
1741: hz_utility_pub.LAST_UPDATED_BY
1742: FROM OKC_RULES_B rle, ra_customer_merges rcm
1743: WHERE (

Line 1740: hz_utility_pub.LAST_UPDATE_DATE,

1736: 'U',
1737: hz_utility_pub.CREATED_BY,
1738: hz_utility_pub.CREATION_DATE,
1739: hz_utility_pub.LAST_UPDATE_LOGIN,
1740: hz_utility_pub.LAST_UPDATE_DATE,
1741: hz_utility_pub.LAST_UPDATED_BY
1742: FROM OKC_RULES_B rle, ra_customer_merges rcm
1743: WHERE (
1744: rle.object1_id1 = to_char(rcm.duplicate_site_id)

Line 1741: hz_utility_pub.LAST_UPDATED_BY

1737: hz_utility_pub.CREATED_BY,
1738: hz_utility_pub.CREATION_DATE,
1739: hz_utility_pub.LAST_UPDATE_LOGIN,
1740: hz_utility_pub.LAST_UPDATE_DATE,
1741: hz_utility_pub.LAST_UPDATED_BY
1742: FROM OKC_RULES_B rle, ra_customer_merges rcm
1743: WHERE (
1744: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1745: ) AND rcm.process_flag = 'N'

Line 1813: hz_utility_pub.CREATED_BY,

1809: rle.object2_id1,
1810: to_char(rcm.customer_site_id),
1811: req_id,
1812: 'U',
1813: hz_utility_pub.CREATED_BY,
1814: hz_utility_pub.CREATION_DATE,
1815: hz_utility_pub.LAST_UPDATE_LOGIN,
1816: hz_utility_pub.LAST_UPDATE_DATE,
1817: hz_utility_pub.LAST_UPDATED_BY

Line 1814: hz_utility_pub.CREATION_DATE,

1810: to_char(rcm.customer_site_id),
1811: req_id,
1812: 'U',
1813: hz_utility_pub.CREATED_BY,
1814: hz_utility_pub.CREATION_DATE,
1815: hz_utility_pub.LAST_UPDATE_LOGIN,
1816: hz_utility_pub.LAST_UPDATE_DATE,
1817: hz_utility_pub.LAST_UPDATED_BY
1818: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1815: hz_utility_pub.LAST_UPDATE_LOGIN,

1811: req_id,
1812: 'U',
1813: hz_utility_pub.CREATED_BY,
1814: hz_utility_pub.CREATION_DATE,
1815: hz_utility_pub.LAST_UPDATE_LOGIN,
1816: hz_utility_pub.LAST_UPDATE_DATE,
1817: hz_utility_pub.LAST_UPDATED_BY
1818: FROM OKC_RULES_B rle, ra_customer_merges rcm
1819: WHERE (

Line 1816: hz_utility_pub.LAST_UPDATE_DATE,

1812: 'U',
1813: hz_utility_pub.CREATED_BY,
1814: hz_utility_pub.CREATION_DATE,
1815: hz_utility_pub.LAST_UPDATE_LOGIN,
1816: hz_utility_pub.LAST_UPDATE_DATE,
1817: hz_utility_pub.LAST_UPDATED_BY
1818: FROM OKC_RULES_B rle, ra_customer_merges rcm
1819: WHERE (
1820: rle.object2_id1 = to_char(rcm.duplicate_site_id)

Line 1817: hz_utility_pub.LAST_UPDATED_BY

1813: hz_utility_pub.CREATED_BY,
1814: hz_utility_pub.CREATION_DATE,
1815: hz_utility_pub.LAST_UPDATE_LOGIN,
1816: hz_utility_pub.LAST_UPDATE_DATE,
1817: hz_utility_pub.LAST_UPDATED_BY
1818: FROM OKC_RULES_B rle, ra_customer_merges rcm
1819: WHERE (
1820: rle.object2_id1 = to_char(rcm.duplicate_site_id)
1821: ) AND rcm.process_flag = 'N'

Line 1890: hz_utility_pub.CREATED_BY,

1886: rle.object3_id1,
1887: to_char(rcm.customer_site_id),
1888: req_id,
1889: 'U',
1890: hz_utility_pub.CREATED_BY,
1891: hz_utility_pub.CREATION_DATE,
1892: hz_utility_pub.LAST_UPDATE_LOGIN,
1893: hz_utility_pub.LAST_UPDATE_DATE,
1894: hz_utility_pub.LAST_UPDATED_BY

Line 1891: hz_utility_pub.CREATION_DATE,

1887: to_char(rcm.customer_site_id),
1888: req_id,
1889: 'U',
1890: hz_utility_pub.CREATED_BY,
1891: hz_utility_pub.CREATION_DATE,
1892: hz_utility_pub.LAST_UPDATE_LOGIN,
1893: hz_utility_pub.LAST_UPDATE_DATE,
1894: hz_utility_pub.LAST_UPDATED_BY
1895: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1892: hz_utility_pub.LAST_UPDATE_LOGIN,

1888: req_id,
1889: 'U',
1890: hz_utility_pub.CREATED_BY,
1891: hz_utility_pub.CREATION_DATE,
1892: hz_utility_pub.LAST_UPDATE_LOGIN,
1893: hz_utility_pub.LAST_UPDATE_DATE,
1894: hz_utility_pub.LAST_UPDATED_BY
1895: FROM OKC_RULES_B rle, ra_customer_merges rcm
1896: WHERE (

Line 1893: hz_utility_pub.LAST_UPDATE_DATE,

1889: 'U',
1890: hz_utility_pub.CREATED_BY,
1891: hz_utility_pub.CREATION_DATE,
1892: hz_utility_pub.LAST_UPDATE_LOGIN,
1893: hz_utility_pub.LAST_UPDATE_DATE,
1894: hz_utility_pub.LAST_UPDATED_BY
1895: FROM OKC_RULES_B rle, ra_customer_merges rcm
1896: WHERE (
1897: rle.object3_id1 = to_char(rcm.duplicate_site_id)

Line 1894: hz_utility_pub.LAST_UPDATED_BY

1890: hz_utility_pub.CREATED_BY,
1891: hz_utility_pub.CREATION_DATE,
1892: hz_utility_pub.LAST_UPDATE_LOGIN,
1893: hz_utility_pub.LAST_UPDATE_DATE,
1894: hz_utility_pub.LAST_UPDATED_BY
1895: FROM OKC_RULES_B rle, ra_customer_merges rcm
1896: WHERE (
1897: rle.object3_id1 = to_char(rcm.duplicate_site_id)
1898: ) AND rcm.process_flag = 'N'

Line 1968: hz_utility_pub.CREATED_BY,

1964: to_char(okh.ship_to_site_use_id),
1965: to_char(rcm.customer_site_id),
1966: req_id,
1967: 'U',
1968: hz_utility_pub.CREATED_BY,
1969: hz_utility_pub.CREATION_DATE,
1970: hz_utility_pub.LAST_UPDATE_LOGIN,
1971: hz_utility_pub.LAST_UPDATE_DATE,
1972: hz_utility_pub.LAST_UPDATED_BY

Line 1969: hz_utility_pub.CREATION_DATE,

1965: to_char(rcm.customer_site_id),
1966: req_id,
1967: 'U',
1968: hz_utility_pub.CREATED_BY,
1969: hz_utility_pub.CREATION_DATE,
1970: hz_utility_pub.LAST_UPDATE_LOGIN,
1971: hz_utility_pub.LAST_UPDATE_DATE,
1972: hz_utility_pub.LAST_UPDATED_BY
1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

Line 1970: hz_utility_pub.LAST_UPDATE_LOGIN,

1966: req_id,
1967: 'U',
1968: hz_utility_pub.CREATED_BY,
1969: hz_utility_pub.CREATION_DATE,
1970: hz_utility_pub.LAST_UPDATE_LOGIN,
1971: hz_utility_pub.LAST_UPDATE_DATE,
1972: hz_utility_pub.LAST_UPDATED_BY
1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1974: WHERE (

Line 1971: hz_utility_pub.LAST_UPDATE_DATE,

1967: 'U',
1968: hz_utility_pub.CREATED_BY,
1969: hz_utility_pub.CREATION_DATE,
1970: hz_utility_pub.LAST_UPDATE_LOGIN,
1971: hz_utility_pub.LAST_UPDATE_DATE,
1972: hz_utility_pub.LAST_UPDATED_BY
1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1974: WHERE (
1975: okh.ship_to_site_use_id = rcm.duplicate_site_id

Line 1972: hz_utility_pub.LAST_UPDATED_BY

1968: hz_utility_pub.CREATED_BY,
1969: hz_utility_pub.CREATION_DATE,
1970: hz_utility_pub.LAST_UPDATE_LOGIN,
1971: hz_utility_pub.LAST_UPDATE_DATE,
1972: hz_utility_pub.LAST_UPDATED_BY
1973: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1974: WHERE (
1975: okh.ship_to_site_use_id = rcm.duplicate_site_id
1976: ) AND rcm.process_flag = 'N'

Line 2038: hz_utility_pub.CREATED_BY,

2034: to_char(okh.bill_to_site_use_id),
2035: to_char(rcm.customer_site_id),
2036: req_id,
2037: 'U',
2038: hz_utility_pub.CREATED_BY,
2039: hz_utility_pub.CREATION_DATE,
2040: hz_utility_pub.LAST_UPDATE_LOGIN,
2041: hz_utility_pub.LAST_UPDATE_DATE,
2042: hz_utility_pub.LAST_UPDATED_BY

Line 2039: hz_utility_pub.CREATION_DATE,

2035: to_char(rcm.customer_site_id),
2036: req_id,
2037: 'U',
2038: hz_utility_pub.CREATED_BY,
2039: hz_utility_pub.CREATION_DATE,
2040: hz_utility_pub.LAST_UPDATE_LOGIN,
2041: hz_utility_pub.LAST_UPDATE_DATE,
2042: hz_utility_pub.LAST_UPDATED_BY
2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

Line 2040: hz_utility_pub.LAST_UPDATE_LOGIN,

2036: req_id,
2037: 'U',
2038: hz_utility_pub.CREATED_BY,
2039: hz_utility_pub.CREATION_DATE,
2040: hz_utility_pub.LAST_UPDATE_LOGIN,
2041: hz_utility_pub.LAST_UPDATE_DATE,
2042: hz_utility_pub.LAST_UPDATED_BY
2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
2044: WHERE (

Line 2041: hz_utility_pub.LAST_UPDATE_DATE,

2037: 'U',
2038: hz_utility_pub.CREATED_BY,
2039: hz_utility_pub.CREATION_DATE,
2040: hz_utility_pub.LAST_UPDATE_LOGIN,
2041: hz_utility_pub.LAST_UPDATE_DATE,
2042: hz_utility_pub.LAST_UPDATED_BY
2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
2044: WHERE (
2045: okh.bill_to_site_use_id = rcm.duplicate_site_id

Line 2042: hz_utility_pub.LAST_UPDATED_BY

2038: hz_utility_pub.CREATED_BY,
2039: hz_utility_pub.CREATION_DATE,
2040: hz_utility_pub.LAST_UPDATE_LOGIN,
2041: hz_utility_pub.LAST_UPDATE_DATE,
2042: hz_utility_pub.LAST_UPDATED_BY
2043: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
2044: WHERE (
2045: okh.bill_to_site_use_id = rcm.duplicate_site_id
2046: ) AND rcm.process_flag = 'N'

Line 2107: hz_utility_pub.CREATED_BY,

2103: to_char(okl.ship_to_site_use_id),
2104: to_char(rcm.customer_site_id),
2105: req_id,
2106: 'U',
2107: hz_utility_pub.CREATED_BY,
2108: hz_utility_pub.CREATION_DATE,
2109: hz_utility_pub.LAST_UPDATE_LOGIN,
2110: hz_utility_pub.LAST_UPDATE_DATE,
2111: hz_utility_pub.LAST_UPDATED_BY

Line 2108: hz_utility_pub.CREATION_DATE,

2104: to_char(rcm.customer_site_id),
2105: req_id,
2106: 'U',
2107: hz_utility_pub.CREATED_BY,
2108: hz_utility_pub.CREATION_DATE,
2109: hz_utility_pub.LAST_UPDATE_LOGIN,
2110: hz_utility_pub.LAST_UPDATE_DATE,
2111: hz_utility_pub.LAST_UPDATED_BY
2112: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

Line 2109: hz_utility_pub.LAST_UPDATE_LOGIN,

2105: req_id,
2106: 'U',
2107: hz_utility_pub.CREATED_BY,
2108: hz_utility_pub.CREATION_DATE,
2109: hz_utility_pub.LAST_UPDATE_LOGIN,
2110: hz_utility_pub.LAST_UPDATE_DATE,
2111: hz_utility_pub.LAST_UPDATED_BY
2112: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2113: WHERE (

Line 2110: hz_utility_pub.LAST_UPDATE_DATE,

2106: 'U',
2107: hz_utility_pub.CREATED_BY,
2108: hz_utility_pub.CREATION_DATE,
2109: hz_utility_pub.LAST_UPDATE_LOGIN,
2110: hz_utility_pub.LAST_UPDATE_DATE,
2111: hz_utility_pub.LAST_UPDATED_BY
2112: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2113: WHERE (
2114: okl.ship_to_site_use_id = rcm.duplicate_site_id

Line 2111: hz_utility_pub.LAST_UPDATED_BY

2107: hz_utility_pub.CREATED_BY,
2108: hz_utility_pub.CREATION_DATE,
2109: hz_utility_pub.LAST_UPDATE_LOGIN,
2110: hz_utility_pub.LAST_UPDATE_DATE,
2111: hz_utility_pub.LAST_UPDATED_BY
2112: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2113: WHERE (
2114: okl.ship_to_site_use_id = rcm.duplicate_site_id
2115: ) AND rcm.process_flag = 'N'

Line 2185: hz_utility_pub.CREATED_BY,

2181: to_char(okl.bill_to_site_use_id),
2182: to_char(rcm.customer_site_id),
2183: req_id,
2184: 'U',
2185: hz_utility_pub.CREATED_BY,
2186: hz_utility_pub.CREATION_DATE,
2187: hz_utility_pub.LAST_UPDATE_LOGIN,
2188: hz_utility_pub.LAST_UPDATE_DATE,
2189: hz_utility_pub.LAST_UPDATED_BY

Line 2186: hz_utility_pub.CREATION_DATE,

2182: to_char(rcm.customer_site_id),
2183: req_id,
2184: 'U',
2185: hz_utility_pub.CREATED_BY,
2186: hz_utility_pub.CREATION_DATE,
2187: hz_utility_pub.LAST_UPDATE_LOGIN,
2188: hz_utility_pub.LAST_UPDATE_DATE,
2189: hz_utility_pub.LAST_UPDATED_BY
2190: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

Line 2187: hz_utility_pub.LAST_UPDATE_LOGIN,

2183: req_id,
2184: 'U',
2185: hz_utility_pub.CREATED_BY,
2186: hz_utility_pub.CREATION_DATE,
2187: hz_utility_pub.LAST_UPDATE_LOGIN,
2188: hz_utility_pub.LAST_UPDATE_DATE,
2189: hz_utility_pub.LAST_UPDATED_BY
2190: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2191: WHERE (

Line 2188: hz_utility_pub.LAST_UPDATE_DATE,

2184: 'U',
2185: hz_utility_pub.CREATED_BY,
2186: hz_utility_pub.CREATION_DATE,
2187: hz_utility_pub.LAST_UPDATE_LOGIN,
2188: hz_utility_pub.LAST_UPDATE_DATE,
2189: hz_utility_pub.LAST_UPDATED_BY
2190: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2191: WHERE (
2192: okl.bill_to_site_use_id = rcm.duplicate_site_id

Line 2189: hz_utility_pub.LAST_UPDATED_BY

2185: hz_utility_pub.CREATED_BY,
2186: hz_utility_pub.CREATION_DATE,
2187: hz_utility_pub.LAST_UPDATE_LOGIN,
2188: hz_utility_pub.LAST_UPDATE_DATE,
2189: hz_utility_pub.LAST_UPDATED_BY
2190: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2191: WHERE (
2192: okl.bill_to_site_use_id = rcm.duplicate_site_id
2193: ) AND rcm.process_flag = 'N'

Line 2255: hz_utility_pub.CREATED_BY,

2251: to_char(okpr.bill_to_site_use_id),
2252: to_char(rcm.customer_site_id),
2253: req_id,
2254: 'U',
2255: hz_utility_pub.CREATED_BY,
2256: hz_utility_pub.CREATION_DATE,
2257: hz_utility_pub.LAST_UPDATE_LOGIN,
2258: hz_utility_pub.LAST_UPDATE_DATE,
2259: hz_utility_pub.LAST_UPDATED_BY

Line 2256: hz_utility_pub.CREATION_DATE,

2252: to_char(rcm.customer_site_id),
2253: req_id,
2254: 'U',
2255: hz_utility_pub.CREATED_BY,
2256: hz_utility_pub.CREATION_DATE,
2257: hz_utility_pub.LAST_UPDATE_LOGIN,
2258: hz_utility_pub.LAST_UPDATE_DATE,
2259: hz_utility_pub.LAST_UPDATED_BY
2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

Line 2257: hz_utility_pub.LAST_UPDATE_LOGIN,

2253: req_id,
2254: 'U',
2255: hz_utility_pub.CREATED_BY,
2256: hz_utility_pub.CREATION_DATE,
2257: hz_utility_pub.LAST_UPDATE_LOGIN,
2258: hz_utility_pub.LAST_UPDATE_DATE,
2259: hz_utility_pub.LAST_UPDATED_BY
2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2261: WHERE (

Line 2258: hz_utility_pub.LAST_UPDATE_DATE,

2254: 'U',
2255: hz_utility_pub.CREATED_BY,
2256: hz_utility_pub.CREATION_DATE,
2257: hz_utility_pub.LAST_UPDATE_LOGIN,
2258: hz_utility_pub.LAST_UPDATE_DATE,
2259: hz_utility_pub.LAST_UPDATED_BY
2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2261: WHERE (
2262: okpr.bill_to_site_use_id = rcm.duplicate_site_id

Line 2259: hz_utility_pub.LAST_UPDATED_BY

2255: hz_utility_pub.CREATED_BY,
2256: hz_utility_pub.CREATION_DATE,
2257: hz_utility_pub.LAST_UPDATE_LOGIN,
2258: hz_utility_pub.LAST_UPDATE_DATE,
2259: hz_utility_pub.LAST_UPDATED_BY
2260: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2261: WHERE (
2262: okpr.bill_to_site_use_id = rcm.duplicate_site_id
2263: ) AND rcm.process_flag = 'N'

Line 2327: hz_utility_pub.CREATED_BY,

2323: cim.object1_id1,
2324: to_char(rcm.customer_site_id),
2325: req_id,
2326: 'U',
2327: hz_utility_pub.CREATED_BY,
2328: hz_utility_pub.CREATION_DATE,
2329: hz_utility_pub.LAST_UPDATE_LOGIN,
2330: hz_utility_pub.LAST_UPDATE_DATE,
2331: hz_utility_pub.LAST_UPDATED_BY

Line 2328: hz_utility_pub.CREATION_DATE,

2324: to_char(rcm.customer_site_id),
2325: req_id,
2326: 'U',
2327: hz_utility_pub.CREATED_BY,
2328: hz_utility_pub.CREATION_DATE,
2329: hz_utility_pub.LAST_UPDATE_LOGIN,
2330: hz_utility_pub.LAST_UPDATE_DATE,
2331: hz_utility_pub.LAST_UPDATED_BY
2332: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

Line 2329: hz_utility_pub.LAST_UPDATE_LOGIN,

2325: req_id,
2326: 'U',
2327: hz_utility_pub.CREATED_BY,
2328: hz_utility_pub.CREATION_DATE,
2329: hz_utility_pub.LAST_UPDATE_LOGIN,
2330: hz_utility_pub.LAST_UPDATE_DATE,
2331: hz_utility_pub.LAST_UPDATED_BY
2332: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2333: WHERE (

Line 2330: hz_utility_pub.LAST_UPDATE_DATE,

2326: 'U',
2327: hz_utility_pub.CREATED_BY,
2328: hz_utility_pub.CREATION_DATE,
2329: hz_utility_pub.LAST_UPDATE_LOGIN,
2330: hz_utility_pub.LAST_UPDATE_DATE,
2331: hz_utility_pub.LAST_UPDATED_BY
2332: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2333: WHERE (
2334: cim.object1_id1 = to_char(rcm.duplicate_site_id)

Line 2331: hz_utility_pub.LAST_UPDATED_BY

2327: hz_utility_pub.CREATED_BY,
2328: hz_utility_pub.CREATION_DATE,
2329: hz_utility_pub.LAST_UPDATE_LOGIN,
2330: hz_utility_pub.LAST_UPDATE_DATE,
2331: hz_utility_pub.LAST_UPDATED_BY
2332: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2333: WHERE (
2334: cim.object1_id1 = to_char(rcm.duplicate_site_id)
2335: ) AND rcm.process_flag = 'N'