APPS.OKC_HZ_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 501: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY

497: and rcm.process_flag = 'N')
498: ,hz.VCHAR_COL1_ORIG = l_source_party_id
499: ,hz.VCHAR_COL1_NEW = l_target_party_id
500: ,hz.REQUEST_ID = req_id
501: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
502: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
503: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
504: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
505: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY

Line 502: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE

498: ,hz.VCHAR_COL1_ORIG = l_source_party_id
499: ,hz.VCHAR_COL1_NEW = l_target_party_id
500: ,hz.REQUEST_ID = req_id
501: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
502: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
503: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
504: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
505: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
506: ,hz.ACTION_FLAG = 'U'

Line 503: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN

499: ,hz.VCHAR_COL1_NEW = l_target_party_id
500: ,hz.REQUEST_ID = req_id
501: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
502: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
503: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
504: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
505: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
506: ,hz.ACTION_FLAG = 'U'
507: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;

Line 504: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE

500: ,hz.REQUEST_ID = req_id
501: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
502: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
503: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
504: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
505: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
506: ,hz.ACTION_FLAG = 'U'
507: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
508: END IF;

Line 505: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY

501: ,hz.CREATED_BY = hz_utility_pub.CREATED_BY
502: ,hz.CREATION_DATE = hz_utility_pub.CREATION_DATE
503: ,hz.LAST_UPDATE_LOGIN = hz_utility_pub.LAST_UPDATE_LOGIN
504: ,hz.LAST_UPDATE_DATE = hz_utility_pub.LAST_UPDATE_DATE
505: ,hz.LAST_UPDATED_BY = hz_utility_pub.LAST_UPDATED_BY
506: ,hz.ACTION_FLAG = 'U'
507: WHERE hz.PRIMARY_KEY_ID1 = l_log_party_id;
508: END IF;
509: -- Fix for bug 4105272 Insert into okc_k_vers_numbers_h

Line 608: hz_utility_pub.CREATED_BY,

604: kpr.object1_id1,
605: to_char(rcm.customer_id),
606: req_id,
607: 'U',
608: hz_utility_pub.CREATED_BY,
609: hz_utility_pub.CREATION_DATE,
610: hz_utility_pub.LAST_UPDATE_LOGIN,
611: hz_utility_pub.LAST_UPDATE_DATE,
612: hz_utility_pub.LAST_UPDATED_BY

Line 609: hz_utility_pub.CREATION_DATE,

605: to_char(rcm.customer_id),
606: req_id,
607: 'U',
608: hz_utility_pub.CREATED_BY,
609: hz_utility_pub.CREATION_DATE,
610: hz_utility_pub.LAST_UPDATE_LOGIN,
611: hz_utility_pub.LAST_UPDATE_DATE,
612: hz_utility_pub.LAST_UPDATED_BY
613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm

Line 610: hz_utility_pub.LAST_UPDATE_LOGIN,

606: req_id,
607: 'U',
608: hz_utility_pub.CREATED_BY,
609: hz_utility_pub.CREATION_DATE,
610: hz_utility_pub.LAST_UPDATE_LOGIN,
611: hz_utility_pub.LAST_UPDATE_DATE,
612: hz_utility_pub.LAST_UPDATED_BY
613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
614: WHERE (

Line 611: hz_utility_pub.LAST_UPDATE_DATE,

607: 'U',
608: hz_utility_pub.CREATED_BY,
609: hz_utility_pub.CREATION_DATE,
610: hz_utility_pub.LAST_UPDATE_LOGIN,
611: hz_utility_pub.LAST_UPDATE_DATE,
612: hz_utility_pub.LAST_UPDATED_BY
613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
614: WHERE (
615: kpr.object1_id1 = to_char(rcm.duplicate_id)

Line 612: hz_utility_pub.LAST_UPDATED_BY

608: hz_utility_pub.CREATED_BY,
609: hz_utility_pub.CREATION_DATE,
610: hz_utility_pub.LAST_UPDATE_LOGIN,
611: hz_utility_pub.LAST_UPDATE_DATE,
612: hz_utility_pub.LAST_UPDATED_BY
613: FROM OKC_K_PARTY_ROLES_B kpr, ra_customer_merges rcm
614: WHERE (
615: kpr.object1_id1 = to_char(rcm.duplicate_id)
616: ) AND rcm.process_flag = 'N'

Line 684: hz_utility_pub.CREATED_BY,

680: rle.object1_id1,
681: to_char(rcm.customer_id),
682: req_id,
683: 'U',
684: hz_utility_pub.CREATED_BY,
685: hz_utility_pub.CREATION_DATE,
686: hz_utility_pub.LAST_UPDATE_LOGIN,
687: hz_utility_pub.LAST_UPDATE_DATE,
688: hz_utility_pub.LAST_UPDATED_BY

Line 685: hz_utility_pub.CREATION_DATE,

681: to_char(rcm.customer_id),
682: req_id,
683: 'U',
684: hz_utility_pub.CREATED_BY,
685: hz_utility_pub.CREATION_DATE,
686: hz_utility_pub.LAST_UPDATE_LOGIN,
687: hz_utility_pub.LAST_UPDATE_DATE,
688: hz_utility_pub.LAST_UPDATED_BY
689: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 686: hz_utility_pub.LAST_UPDATE_LOGIN,

682: req_id,
683: 'U',
684: hz_utility_pub.CREATED_BY,
685: hz_utility_pub.CREATION_DATE,
686: hz_utility_pub.LAST_UPDATE_LOGIN,
687: hz_utility_pub.LAST_UPDATE_DATE,
688: hz_utility_pub.LAST_UPDATED_BY
689: FROM OKC_RULES_B rle, ra_customer_merges rcm
690: WHERE (

Line 687: hz_utility_pub.LAST_UPDATE_DATE,

683: 'U',
684: hz_utility_pub.CREATED_BY,
685: hz_utility_pub.CREATION_DATE,
686: hz_utility_pub.LAST_UPDATE_LOGIN,
687: hz_utility_pub.LAST_UPDATE_DATE,
688: hz_utility_pub.LAST_UPDATED_BY
689: FROM OKC_RULES_B rle, ra_customer_merges rcm
690: WHERE (
691: rle.object1_id1 = to_char(rcm.duplicate_id)

Line 688: hz_utility_pub.LAST_UPDATED_BY

684: hz_utility_pub.CREATED_BY,
685: hz_utility_pub.CREATION_DATE,
686: hz_utility_pub.LAST_UPDATE_LOGIN,
687: hz_utility_pub.LAST_UPDATE_DATE,
688: hz_utility_pub.LAST_UPDATED_BY
689: FROM OKC_RULES_B rle, ra_customer_merges rcm
690: WHERE (
691: rle.object1_id1 = to_char(rcm.duplicate_id)
692: ) AND rcm.process_flag = 'N'

Line 761: hz_utility_pub.CREATED_BY,

757: rle.object2_id1,
758: to_char(rcm.customer_id),
759: req_id,
760: 'U',
761: hz_utility_pub.CREATED_BY,
762: hz_utility_pub.CREATION_DATE,
763: hz_utility_pub.LAST_UPDATE_LOGIN,
764: hz_utility_pub.LAST_UPDATE_DATE,
765: hz_utility_pub.LAST_UPDATED_BY

Line 762: hz_utility_pub.CREATION_DATE,

758: to_char(rcm.customer_id),
759: req_id,
760: 'U',
761: hz_utility_pub.CREATED_BY,
762: hz_utility_pub.CREATION_DATE,
763: hz_utility_pub.LAST_UPDATE_LOGIN,
764: hz_utility_pub.LAST_UPDATE_DATE,
765: hz_utility_pub.LAST_UPDATED_BY
766: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 763: hz_utility_pub.LAST_UPDATE_LOGIN,

759: req_id,
760: 'U',
761: hz_utility_pub.CREATED_BY,
762: hz_utility_pub.CREATION_DATE,
763: hz_utility_pub.LAST_UPDATE_LOGIN,
764: hz_utility_pub.LAST_UPDATE_DATE,
765: hz_utility_pub.LAST_UPDATED_BY
766: FROM OKC_RULES_B rle, ra_customer_merges rcm
767: WHERE (

Line 764: hz_utility_pub.LAST_UPDATE_DATE,

760: 'U',
761: hz_utility_pub.CREATED_BY,
762: hz_utility_pub.CREATION_DATE,
763: hz_utility_pub.LAST_UPDATE_LOGIN,
764: hz_utility_pub.LAST_UPDATE_DATE,
765: hz_utility_pub.LAST_UPDATED_BY
766: FROM OKC_RULES_B rle, ra_customer_merges rcm
767: WHERE (
768: rle.object2_id1 = to_char(rcm.duplicate_id)

Line 765: hz_utility_pub.LAST_UPDATED_BY

761: hz_utility_pub.CREATED_BY,
762: hz_utility_pub.CREATION_DATE,
763: hz_utility_pub.LAST_UPDATE_LOGIN,
764: hz_utility_pub.LAST_UPDATE_DATE,
765: hz_utility_pub.LAST_UPDATED_BY
766: FROM OKC_RULES_B rle, ra_customer_merges rcm
767: WHERE (
768: rle.object2_id1 = to_char(rcm.duplicate_id)
769: ) AND rcm.process_flag = 'N'

Line 838: hz_utility_pub.CREATED_BY,

834: rle.object3_id1,
835: to_char(rcm.customer_id),
836: req_id,
837: 'U',
838: hz_utility_pub.CREATED_BY,
839: hz_utility_pub.CREATION_DATE,
840: hz_utility_pub.LAST_UPDATE_LOGIN,
841: hz_utility_pub.LAST_UPDATE_DATE,
842: hz_utility_pub.LAST_UPDATED_BY

Line 839: hz_utility_pub.CREATION_DATE,

835: to_char(rcm.customer_id),
836: req_id,
837: 'U',
838: hz_utility_pub.CREATED_BY,
839: hz_utility_pub.CREATION_DATE,
840: hz_utility_pub.LAST_UPDATE_LOGIN,
841: hz_utility_pub.LAST_UPDATE_DATE,
842: hz_utility_pub.LAST_UPDATED_BY
843: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 840: hz_utility_pub.LAST_UPDATE_LOGIN,

836: req_id,
837: 'U',
838: hz_utility_pub.CREATED_BY,
839: hz_utility_pub.CREATION_DATE,
840: hz_utility_pub.LAST_UPDATE_LOGIN,
841: hz_utility_pub.LAST_UPDATE_DATE,
842: hz_utility_pub.LAST_UPDATED_BY
843: FROM OKC_RULES_B rle, ra_customer_merges rcm
844: WHERE (

Line 841: hz_utility_pub.LAST_UPDATE_DATE,

837: 'U',
838: hz_utility_pub.CREATED_BY,
839: hz_utility_pub.CREATION_DATE,
840: hz_utility_pub.LAST_UPDATE_LOGIN,
841: hz_utility_pub.LAST_UPDATE_DATE,
842: hz_utility_pub.LAST_UPDATED_BY
843: FROM OKC_RULES_B rle, ra_customer_merges rcm
844: WHERE (
845: rle.object3_id1 = to_char(rcm.duplicate_id)

Line 842: hz_utility_pub.LAST_UPDATED_BY

838: hz_utility_pub.CREATED_BY,
839: hz_utility_pub.CREATION_DATE,
840: hz_utility_pub.LAST_UPDATE_LOGIN,
841: hz_utility_pub.LAST_UPDATE_DATE,
842: hz_utility_pub.LAST_UPDATED_BY
843: FROM OKC_RULES_B rle, ra_customer_merges rcm
844: WHERE (
845: rle.object3_id1 = to_char(rcm.duplicate_id)
846: ) AND rcm.process_flag = 'N'

Line 916: hz_utility_pub.CREATED_BY,

912: to_char(okh.cust_acct_id),
913: to_char(rcm.customer_id),
914: req_id,
915: 'U',
916: hz_utility_pub.CREATED_BY,
917: hz_utility_pub.CREATION_DATE,
918: hz_utility_pub.LAST_UPDATE_LOGIN,
919: hz_utility_pub.LAST_UPDATE_DATE,
920: hz_utility_pub.LAST_UPDATED_BY

Line 917: hz_utility_pub.CREATION_DATE,

913: to_char(rcm.customer_id),
914: req_id,
915: 'U',
916: hz_utility_pub.CREATED_BY,
917: hz_utility_pub.CREATION_DATE,
918: hz_utility_pub.LAST_UPDATE_LOGIN,
919: hz_utility_pub.LAST_UPDATE_DATE,
920: hz_utility_pub.LAST_UPDATED_BY
921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

Line 918: hz_utility_pub.LAST_UPDATE_LOGIN,

914: req_id,
915: 'U',
916: hz_utility_pub.CREATED_BY,
917: hz_utility_pub.CREATION_DATE,
918: hz_utility_pub.LAST_UPDATE_LOGIN,
919: hz_utility_pub.LAST_UPDATE_DATE,
920: hz_utility_pub.LAST_UPDATED_BY
921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
922: WHERE (

Line 919: hz_utility_pub.LAST_UPDATE_DATE,

915: 'U',
916: hz_utility_pub.CREATED_BY,
917: hz_utility_pub.CREATION_DATE,
918: hz_utility_pub.LAST_UPDATE_LOGIN,
919: hz_utility_pub.LAST_UPDATE_DATE,
920: hz_utility_pub.LAST_UPDATED_BY
921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
922: WHERE (
923: okh.cust_acct_id = rcm.duplicate_id

Line 920: hz_utility_pub.LAST_UPDATED_BY

916: hz_utility_pub.CREATED_BY,
917: hz_utility_pub.CREATION_DATE,
918: hz_utility_pub.LAST_UPDATE_LOGIN,
919: hz_utility_pub.LAST_UPDATE_DATE,
920: hz_utility_pub.LAST_UPDATED_BY
921: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
922: WHERE (
923: okh.cust_acct_id = rcm.duplicate_id
924: ) AND rcm.process_flag = 'N'

Line 987: hz_utility_pub.CREATED_BY,

983: to_char(okl.cust_acct_id),
984: to_char(rcm.customer_id),
985: req_id,
986: 'U',
987: hz_utility_pub.CREATED_BY,
988: hz_utility_pub.CREATION_DATE,
989: hz_utility_pub.LAST_UPDATE_LOGIN,
990: hz_utility_pub.LAST_UPDATE_DATE,
991: hz_utility_pub.LAST_UPDATED_BY

Line 988: hz_utility_pub.CREATION_DATE,

984: to_char(rcm.customer_id),
985: req_id,
986: 'U',
987: hz_utility_pub.CREATED_BY,
988: hz_utility_pub.CREATION_DATE,
989: hz_utility_pub.LAST_UPDATE_LOGIN,
990: hz_utility_pub.LAST_UPDATE_DATE,
991: hz_utility_pub.LAST_UPDATED_BY
992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

Line 989: hz_utility_pub.LAST_UPDATE_LOGIN,

985: req_id,
986: 'U',
987: hz_utility_pub.CREATED_BY,
988: hz_utility_pub.CREATION_DATE,
989: hz_utility_pub.LAST_UPDATE_LOGIN,
990: hz_utility_pub.LAST_UPDATE_DATE,
991: hz_utility_pub.LAST_UPDATED_BY
992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
993: WHERE (

Line 990: hz_utility_pub.LAST_UPDATE_DATE,

986: 'U',
987: hz_utility_pub.CREATED_BY,
988: hz_utility_pub.CREATION_DATE,
989: hz_utility_pub.LAST_UPDATE_LOGIN,
990: hz_utility_pub.LAST_UPDATE_DATE,
991: hz_utility_pub.LAST_UPDATED_BY
992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
993: WHERE (
994: okl.cust_acct_id = rcm.duplicate_id

Line 991: hz_utility_pub.LAST_UPDATED_BY

987: hz_utility_pub.CREATED_BY,
988: hz_utility_pub.CREATION_DATE,
989: hz_utility_pub.LAST_UPDATE_LOGIN,
990: hz_utility_pub.LAST_UPDATE_DATE,
991: hz_utility_pub.LAST_UPDATED_BY
992: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
993: WHERE (
994: okl.cust_acct_id = rcm.duplicate_id
995: ) AND rcm.process_flag = 'N'

Line 1056: hz_utility_pub.CREATED_BY,

1052: to_char(okpr.cust_acct_id),
1053: to_char(rcm.customer_id),
1054: req_id,
1055: 'U',
1056: hz_utility_pub.CREATED_BY,
1057: hz_utility_pub.CREATION_DATE,
1058: hz_utility_pub.LAST_UPDATE_LOGIN,
1059: hz_utility_pub.LAST_UPDATE_DATE,
1060: hz_utility_pub.LAST_UPDATED_BY

Line 1057: hz_utility_pub.CREATION_DATE,

1053: to_char(rcm.customer_id),
1054: req_id,
1055: 'U',
1056: hz_utility_pub.CREATED_BY,
1057: hz_utility_pub.CREATION_DATE,
1058: hz_utility_pub.LAST_UPDATE_LOGIN,
1059: hz_utility_pub.LAST_UPDATE_DATE,
1060: hz_utility_pub.LAST_UPDATED_BY
1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

Line 1058: hz_utility_pub.LAST_UPDATE_LOGIN,

1054: req_id,
1055: 'U',
1056: hz_utility_pub.CREATED_BY,
1057: hz_utility_pub.CREATION_DATE,
1058: hz_utility_pub.LAST_UPDATE_LOGIN,
1059: hz_utility_pub.LAST_UPDATE_DATE,
1060: hz_utility_pub.LAST_UPDATED_BY
1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1062: WHERE (

Line 1059: hz_utility_pub.LAST_UPDATE_DATE,

1055: 'U',
1056: hz_utility_pub.CREATED_BY,
1057: hz_utility_pub.CREATION_DATE,
1058: hz_utility_pub.LAST_UPDATE_LOGIN,
1059: hz_utility_pub.LAST_UPDATE_DATE,
1060: hz_utility_pub.LAST_UPDATED_BY
1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1062: WHERE (
1063: okpr.cust_acct_id = rcm.duplicate_id

Line 1060: hz_utility_pub.LAST_UPDATED_BY

1056: hz_utility_pub.CREATED_BY,
1057: hz_utility_pub.CREATION_DATE,
1058: hz_utility_pub.LAST_UPDATE_LOGIN,
1059: hz_utility_pub.LAST_UPDATE_DATE,
1060: hz_utility_pub.LAST_UPDATED_BY
1061: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
1062: WHERE (
1063: okpr.cust_acct_id = rcm.duplicate_id
1064: ) AND rcm.process_flag = 'N'

Line 1126: hz_utility_pub.CREATED_BY,

1122: cim.object1_id1,
1123: to_char(rcm.customer_id),
1124: req_id,
1125: 'U',
1126: hz_utility_pub.CREATED_BY,
1127: hz_utility_pub.CREATION_DATE,
1128: hz_utility_pub.LAST_UPDATE_LOGIN,
1129: hz_utility_pub.LAST_UPDATE_DATE,
1130: hz_utility_pub.LAST_UPDATED_BY

Line 1127: hz_utility_pub.CREATION_DATE,

1123: to_char(rcm.customer_id),
1124: req_id,
1125: 'U',
1126: hz_utility_pub.CREATED_BY,
1127: hz_utility_pub.CREATION_DATE,
1128: hz_utility_pub.LAST_UPDATE_LOGIN,
1129: hz_utility_pub.LAST_UPDATE_DATE,
1130: hz_utility_pub.LAST_UPDATED_BY
1131: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

Line 1128: hz_utility_pub.LAST_UPDATE_LOGIN,

1124: req_id,
1125: 'U',
1126: hz_utility_pub.CREATED_BY,
1127: hz_utility_pub.CREATION_DATE,
1128: hz_utility_pub.LAST_UPDATE_LOGIN,
1129: hz_utility_pub.LAST_UPDATE_DATE,
1130: hz_utility_pub.LAST_UPDATED_BY
1131: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1132: WHERE (

Line 1129: hz_utility_pub.LAST_UPDATE_DATE,

1125: 'U',
1126: hz_utility_pub.CREATED_BY,
1127: hz_utility_pub.CREATION_DATE,
1128: hz_utility_pub.LAST_UPDATE_LOGIN,
1129: hz_utility_pub.LAST_UPDATE_DATE,
1130: hz_utility_pub.LAST_UPDATED_BY
1131: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1132: WHERE (
1133: cim.object1_id1 = to_char(rcm.duplicate_id)

Line 1130: hz_utility_pub.LAST_UPDATED_BY

1126: hz_utility_pub.CREATED_BY,
1127: hz_utility_pub.CREATION_DATE,
1128: hz_utility_pub.LAST_UPDATE_LOGIN,
1129: hz_utility_pub.LAST_UPDATE_DATE,
1130: hz_utility_pub.LAST_UPDATED_BY
1131: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1132: WHERE (
1133: cim.object1_id1 = to_char(rcm.duplicate_id)
1134: ) AND rcm.process_flag = 'N'

Line 1225: hz_utility_pub.CREATED_BY,

1221: rle.object1_id1,
1222: to_char(customer_address_id),
1223: req_id,
1224: 'U',
1225: hz_utility_pub.CREATED_BY,
1226: hz_utility_pub.CREATION_DATE,
1227: hz_utility_pub.LAST_UPDATE_LOGIN,
1228: hz_utility_pub.LAST_UPDATE_DATE,
1229: hz_utility_pub.LAST_UPDATED_BY

Line 1226: hz_utility_pub.CREATION_DATE,

1222: to_char(customer_address_id),
1223: req_id,
1224: 'U',
1225: hz_utility_pub.CREATED_BY,
1226: hz_utility_pub.CREATION_DATE,
1227: hz_utility_pub.LAST_UPDATE_LOGIN,
1228: hz_utility_pub.LAST_UPDATE_DATE,
1229: hz_utility_pub.LAST_UPDATED_BY
1230: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1227: hz_utility_pub.LAST_UPDATE_LOGIN,

1223: req_id,
1224: 'U',
1225: hz_utility_pub.CREATED_BY,
1226: hz_utility_pub.CREATION_DATE,
1227: hz_utility_pub.LAST_UPDATE_LOGIN,
1228: hz_utility_pub.LAST_UPDATE_DATE,
1229: hz_utility_pub.LAST_UPDATED_BY
1230: FROM OKC_RULES_B rle, ra_customer_merges rcm
1231: WHERE (

Line 1228: hz_utility_pub.LAST_UPDATE_DATE,

1224: 'U',
1225: hz_utility_pub.CREATED_BY,
1226: hz_utility_pub.CREATION_DATE,
1227: hz_utility_pub.LAST_UPDATE_LOGIN,
1228: hz_utility_pub.LAST_UPDATE_DATE,
1229: hz_utility_pub.LAST_UPDATED_BY
1230: FROM OKC_RULES_B rle, ra_customer_merges rcm
1231: WHERE (
1232: rle.object1_id1 = to_char(rcm.duplicate_address_id)

Line 1229: hz_utility_pub.LAST_UPDATED_BY

1225: hz_utility_pub.CREATED_BY,
1226: hz_utility_pub.CREATION_DATE,
1227: hz_utility_pub.LAST_UPDATE_LOGIN,
1228: hz_utility_pub.LAST_UPDATE_DATE,
1229: hz_utility_pub.LAST_UPDATED_BY
1230: FROM OKC_RULES_B rle, ra_customer_merges rcm
1231: WHERE (
1232: rle.object1_id1 = to_char(rcm.duplicate_address_id)
1233: ) AND rcm.process_flag = 'N'

Line 1303: hz_utility_pub.CREATED_BY,

1299: rle.object2_id1,
1300: to_char(customer_address_id),
1301: req_id,
1302: 'U',
1303: hz_utility_pub.CREATED_BY,
1304: hz_utility_pub.CREATION_DATE,
1305: hz_utility_pub.LAST_UPDATE_LOGIN,
1306: hz_utility_pub.LAST_UPDATE_DATE,
1307: hz_utility_pub.LAST_UPDATED_BY

Line 1304: hz_utility_pub.CREATION_DATE,

1300: to_char(customer_address_id),
1301: req_id,
1302: 'U',
1303: hz_utility_pub.CREATED_BY,
1304: hz_utility_pub.CREATION_DATE,
1305: hz_utility_pub.LAST_UPDATE_LOGIN,
1306: hz_utility_pub.LAST_UPDATE_DATE,
1307: hz_utility_pub.LAST_UPDATED_BY
1308: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1305: hz_utility_pub.LAST_UPDATE_LOGIN,

1301: req_id,
1302: 'U',
1303: hz_utility_pub.CREATED_BY,
1304: hz_utility_pub.CREATION_DATE,
1305: hz_utility_pub.LAST_UPDATE_LOGIN,
1306: hz_utility_pub.LAST_UPDATE_DATE,
1307: hz_utility_pub.LAST_UPDATED_BY
1308: FROM OKC_RULES_B rle, ra_customer_merges rcm
1309: WHERE (

Line 1306: hz_utility_pub.LAST_UPDATE_DATE,

1302: 'U',
1303: hz_utility_pub.CREATED_BY,
1304: hz_utility_pub.CREATION_DATE,
1305: hz_utility_pub.LAST_UPDATE_LOGIN,
1306: hz_utility_pub.LAST_UPDATE_DATE,
1307: hz_utility_pub.LAST_UPDATED_BY
1308: FROM OKC_RULES_B rle, ra_customer_merges rcm
1309: WHERE (
1310: rle.object2_id1 = to_char(rcm.duplicate_address_id)

Line 1307: hz_utility_pub.LAST_UPDATED_BY

1303: hz_utility_pub.CREATED_BY,
1304: hz_utility_pub.CREATION_DATE,
1305: hz_utility_pub.LAST_UPDATE_LOGIN,
1306: hz_utility_pub.LAST_UPDATE_DATE,
1307: hz_utility_pub.LAST_UPDATED_BY
1308: FROM OKC_RULES_B rle, ra_customer_merges rcm
1309: WHERE (
1310: rle.object2_id1 = to_char(rcm.duplicate_address_id)
1311: ) AND rcm.process_flag = 'N'

Line 1380: hz_utility_pub.CREATED_BY,

1376: rle.object3_id1,
1377: to_char(customer_address_id),
1378: req_id,
1379: 'U',
1380: hz_utility_pub.CREATED_BY,
1381: hz_utility_pub.CREATION_DATE,
1382: hz_utility_pub.LAST_UPDATE_LOGIN,
1383: hz_utility_pub.LAST_UPDATE_DATE,
1384: hz_utility_pub.LAST_UPDATED_BY

Line 1381: hz_utility_pub.CREATION_DATE,

1377: to_char(customer_address_id),
1378: req_id,
1379: 'U',
1380: hz_utility_pub.CREATED_BY,
1381: hz_utility_pub.CREATION_DATE,
1382: hz_utility_pub.LAST_UPDATE_LOGIN,
1383: hz_utility_pub.LAST_UPDATE_DATE,
1384: hz_utility_pub.LAST_UPDATED_BY
1385: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1382: hz_utility_pub.LAST_UPDATE_LOGIN,

1378: req_id,
1379: 'U',
1380: hz_utility_pub.CREATED_BY,
1381: hz_utility_pub.CREATION_DATE,
1382: hz_utility_pub.LAST_UPDATE_LOGIN,
1383: hz_utility_pub.LAST_UPDATE_DATE,
1384: hz_utility_pub.LAST_UPDATED_BY
1385: FROM OKC_RULES_B rle, ra_customer_merges rcm
1386: WHERE (

Line 1383: hz_utility_pub.LAST_UPDATE_DATE,

1379: 'U',
1380: hz_utility_pub.CREATED_BY,
1381: hz_utility_pub.CREATION_DATE,
1382: hz_utility_pub.LAST_UPDATE_LOGIN,
1383: hz_utility_pub.LAST_UPDATE_DATE,
1384: hz_utility_pub.LAST_UPDATED_BY
1385: FROM OKC_RULES_B rle, ra_customer_merges rcm
1386: WHERE (
1387: rle.object3_id1 = to_char(rcm.duplicate_address_id)

Line 1384: hz_utility_pub.LAST_UPDATED_BY

1380: hz_utility_pub.CREATED_BY,
1381: hz_utility_pub.CREATION_DATE,
1382: hz_utility_pub.LAST_UPDATE_LOGIN,
1383: hz_utility_pub.LAST_UPDATE_DATE,
1384: hz_utility_pub.LAST_UPDATED_BY
1385: FROM OKC_RULES_B rle, ra_customer_merges rcm
1386: WHERE (
1387: rle.object3_id1 = to_char(rcm.duplicate_address_id)
1388: ) AND rcm.process_flag = 'N'

Line 1460: hz_utility_pub.CREATED_BY,

1456: cim.object1_id1,
1457: to_char(rcm.customer_address_id),
1458: req_id,
1459: 'U',
1460: hz_utility_pub.CREATED_BY,
1461: hz_utility_pub.CREATION_DATE,
1462: hz_utility_pub.LAST_UPDATE_LOGIN,
1463: hz_utility_pub.LAST_UPDATE_DATE,
1464: hz_utility_pub.LAST_UPDATED_BY

Line 1461: hz_utility_pub.CREATION_DATE,

1457: to_char(rcm.customer_address_id),
1458: req_id,
1459: 'U',
1460: hz_utility_pub.CREATED_BY,
1461: hz_utility_pub.CREATION_DATE,
1462: hz_utility_pub.LAST_UPDATE_LOGIN,
1463: hz_utility_pub.LAST_UPDATE_DATE,
1464: hz_utility_pub.LAST_UPDATED_BY
1465: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

Line 1462: hz_utility_pub.LAST_UPDATE_LOGIN,

1458: req_id,
1459: 'U',
1460: hz_utility_pub.CREATED_BY,
1461: hz_utility_pub.CREATION_DATE,
1462: hz_utility_pub.LAST_UPDATE_LOGIN,
1463: hz_utility_pub.LAST_UPDATE_DATE,
1464: hz_utility_pub.LAST_UPDATED_BY
1465: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1466: WHERE (

Line 1463: hz_utility_pub.LAST_UPDATE_DATE,

1459: 'U',
1460: hz_utility_pub.CREATED_BY,
1461: hz_utility_pub.CREATION_DATE,
1462: hz_utility_pub.LAST_UPDATE_LOGIN,
1463: hz_utility_pub.LAST_UPDATE_DATE,
1464: hz_utility_pub.LAST_UPDATED_BY
1465: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1466: WHERE (
1467: cim.object1_id1 = to_char(rcm.duplicate_address_id)

Line 1464: hz_utility_pub.LAST_UPDATED_BY

1460: hz_utility_pub.CREATED_BY,
1461: hz_utility_pub.CREATION_DATE,
1462: hz_utility_pub.LAST_UPDATE_LOGIN,
1463: hz_utility_pub.LAST_UPDATE_DATE,
1464: hz_utility_pub.LAST_UPDATED_BY
1465: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
1466: WHERE (
1467: cim.object1_id1 = to_char(rcm.duplicate_address_id)
1468: ) AND rcm.process_flag = 'N'

Line 1547: hz_utility_pub.CREATED_BY,

1543: rle.object1_id1,
1544: to_char(rcm.customer_site_id),
1545: req_id,
1546: 'U',
1547: hz_utility_pub.CREATED_BY,
1548: hz_utility_pub.CREATION_DATE,
1549: hz_utility_pub.LAST_UPDATE_LOGIN,
1550: hz_utility_pub.LAST_UPDATE_DATE,
1551: hz_utility_pub.LAST_UPDATED_BY

Line 1548: hz_utility_pub.CREATION_DATE,

1544: to_char(rcm.customer_site_id),
1545: req_id,
1546: 'U',
1547: hz_utility_pub.CREATED_BY,
1548: hz_utility_pub.CREATION_DATE,
1549: hz_utility_pub.LAST_UPDATE_LOGIN,
1550: hz_utility_pub.LAST_UPDATE_DATE,
1551: hz_utility_pub.LAST_UPDATED_BY
1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm

Line 1549: hz_utility_pub.LAST_UPDATE_LOGIN,

1545: req_id,
1546: 'U',
1547: hz_utility_pub.CREATED_BY,
1548: hz_utility_pub.CREATION_DATE,
1549: hz_utility_pub.LAST_UPDATE_LOGIN,
1550: hz_utility_pub.LAST_UPDATE_DATE,
1551: hz_utility_pub.LAST_UPDATED_BY
1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1553: WHERE (

Line 1550: hz_utility_pub.LAST_UPDATE_DATE,

1546: 'U',
1547: hz_utility_pub.CREATED_BY,
1548: hz_utility_pub.CREATION_DATE,
1549: hz_utility_pub.LAST_UPDATE_LOGIN,
1550: hz_utility_pub.LAST_UPDATE_DATE,
1551: hz_utility_pub.LAST_UPDATED_BY
1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1553: WHERE (
1554: rle.object1_id1 = to_char(rcm.duplicate_site_id)

Line 1551: hz_utility_pub.LAST_UPDATED_BY

1547: hz_utility_pub.CREATED_BY,
1548: hz_utility_pub.CREATION_DATE,
1549: hz_utility_pub.LAST_UPDATE_LOGIN,
1550: hz_utility_pub.LAST_UPDATE_DATE,
1551: hz_utility_pub.LAST_UPDATED_BY
1552: FROM OKC_K_PARTY_ROLES_B rle, ra_customer_merges rcm
1553: WHERE (
1554: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1555: ) AND rcm.process_flag = 'N'

Line 1640: hz_utility_pub.CREATED_BY,

1636: rle.object1_id1,
1637: to_char(rcm.customer_site_id),
1638: req_id,
1639: 'U',
1640: hz_utility_pub.CREATED_BY,
1641: hz_utility_pub.CREATION_DATE,
1642: hz_utility_pub.LAST_UPDATE_LOGIN,
1643: hz_utility_pub.LAST_UPDATE_DATE,
1644: hz_utility_pub.LAST_UPDATED_BY

Line 1641: hz_utility_pub.CREATION_DATE,

1637: to_char(rcm.customer_site_id),
1638: req_id,
1639: 'U',
1640: hz_utility_pub.CREATED_BY,
1641: hz_utility_pub.CREATION_DATE,
1642: hz_utility_pub.LAST_UPDATE_LOGIN,
1643: hz_utility_pub.LAST_UPDATE_DATE,
1644: hz_utility_pub.LAST_UPDATED_BY
1645: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1642: hz_utility_pub.LAST_UPDATE_LOGIN,

1638: req_id,
1639: 'U',
1640: hz_utility_pub.CREATED_BY,
1641: hz_utility_pub.CREATION_DATE,
1642: hz_utility_pub.LAST_UPDATE_LOGIN,
1643: hz_utility_pub.LAST_UPDATE_DATE,
1644: hz_utility_pub.LAST_UPDATED_BY
1645: FROM OKC_RULES_B rle, ra_customer_merges rcm
1646: WHERE (

Line 1643: hz_utility_pub.LAST_UPDATE_DATE,

1639: 'U',
1640: hz_utility_pub.CREATED_BY,
1641: hz_utility_pub.CREATION_DATE,
1642: hz_utility_pub.LAST_UPDATE_LOGIN,
1643: hz_utility_pub.LAST_UPDATE_DATE,
1644: hz_utility_pub.LAST_UPDATED_BY
1645: FROM OKC_RULES_B rle, ra_customer_merges rcm
1646: WHERE (
1647: rle.object1_id1 = to_char(rcm.duplicate_site_id)

Line 1644: hz_utility_pub.LAST_UPDATED_BY

1640: hz_utility_pub.CREATED_BY,
1641: hz_utility_pub.CREATION_DATE,
1642: hz_utility_pub.LAST_UPDATE_LOGIN,
1643: hz_utility_pub.LAST_UPDATE_DATE,
1644: hz_utility_pub.LAST_UPDATED_BY
1645: FROM OKC_RULES_B rle, ra_customer_merges rcm
1646: WHERE (
1647: rle.object1_id1 = to_char(rcm.duplicate_site_id)
1648: ) AND rcm.process_flag = 'N'

Line 1716: hz_utility_pub.CREATED_BY,

1712: rle.object2_id1,
1713: to_char(rcm.customer_site_id),
1714: req_id,
1715: 'U',
1716: hz_utility_pub.CREATED_BY,
1717: hz_utility_pub.CREATION_DATE,
1718: hz_utility_pub.LAST_UPDATE_LOGIN,
1719: hz_utility_pub.LAST_UPDATE_DATE,
1720: hz_utility_pub.LAST_UPDATED_BY

Line 1717: hz_utility_pub.CREATION_DATE,

1713: to_char(rcm.customer_site_id),
1714: req_id,
1715: 'U',
1716: hz_utility_pub.CREATED_BY,
1717: hz_utility_pub.CREATION_DATE,
1718: hz_utility_pub.LAST_UPDATE_LOGIN,
1719: hz_utility_pub.LAST_UPDATE_DATE,
1720: hz_utility_pub.LAST_UPDATED_BY
1721: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1718: hz_utility_pub.LAST_UPDATE_LOGIN,

1714: req_id,
1715: 'U',
1716: hz_utility_pub.CREATED_BY,
1717: hz_utility_pub.CREATION_DATE,
1718: hz_utility_pub.LAST_UPDATE_LOGIN,
1719: hz_utility_pub.LAST_UPDATE_DATE,
1720: hz_utility_pub.LAST_UPDATED_BY
1721: FROM OKC_RULES_B rle, ra_customer_merges rcm
1722: WHERE (

Line 1719: hz_utility_pub.LAST_UPDATE_DATE,

1715: 'U',
1716: hz_utility_pub.CREATED_BY,
1717: hz_utility_pub.CREATION_DATE,
1718: hz_utility_pub.LAST_UPDATE_LOGIN,
1719: hz_utility_pub.LAST_UPDATE_DATE,
1720: hz_utility_pub.LAST_UPDATED_BY
1721: FROM OKC_RULES_B rle, ra_customer_merges rcm
1722: WHERE (
1723: rle.object2_id1 = to_char(rcm.duplicate_site_id)

Line 1720: hz_utility_pub.LAST_UPDATED_BY

1716: hz_utility_pub.CREATED_BY,
1717: hz_utility_pub.CREATION_DATE,
1718: hz_utility_pub.LAST_UPDATE_LOGIN,
1719: hz_utility_pub.LAST_UPDATE_DATE,
1720: hz_utility_pub.LAST_UPDATED_BY
1721: FROM OKC_RULES_B rle, ra_customer_merges rcm
1722: WHERE (
1723: rle.object2_id1 = to_char(rcm.duplicate_site_id)
1724: ) AND rcm.process_flag = 'N'

Line 1793: hz_utility_pub.CREATED_BY,

1789: rle.object3_id1,
1790: to_char(rcm.customer_site_id),
1791: req_id,
1792: 'U',
1793: hz_utility_pub.CREATED_BY,
1794: hz_utility_pub.CREATION_DATE,
1795: hz_utility_pub.LAST_UPDATE_LOGIN,
1796: hz_utility_pub.LAST_UPDATE_DATE,
1797: hz_utility_pub.LAST_UPDATED_BY

Line 1794: hz_utility_pub.CREATION_DATE,

1790: to_char(rcm.customer_site_id),
1791: req_id,
1792: 'U',
1793: hz_utility_pub.CREATED_BY,
1794: hz_utility_pub.CREATION_DATE,
1795: hz_utility_pub.LAST_UPDATE_LOGIN,
1796: hz_utility_pub.LAST_UPDATE_DATE,
1797: hz_utility_pub.LAST_UPDATED_BY
1798: FROM OKC_RULES_B rle, ra_customer_merges rcm

Line 1795: hz_utility_pub.LAST_UPDATE_LOGIN,

1791: req_id,
1792: 'U',
1793: hz_utility_pub.CREATED_BY,
1794: hz_utility_pub.CREATION_DATE,
1795: hz_utility_pub.LAST_UPDATE_LOGIN,
1796: hz_utility_pub.LAST_UPDATE_DATE,
1797: hz_utility_pub.LAST_UPDATED_BY
1798: FROM OKC_RULES_B rle, ra_customer_merges rcm
1799: WHERE (

Line 1796: hz_utility_pub.LAST_UPDATE_DATE,

1792: 'U',
1793: hz_utility_pub.CREATED_BY,
1794: hz_utility_pub.CREATION_DATE,
1795: hz_utility_pub.LAST_UPDATE_LOGIN,
1796: hz_utility_pub.LAST_UPDATE_DATE,
1797: hz_utility_pub.LAST_UPDATED_BY
1798: FROM OKC_RULES_B rle, ra_customer_merges rcm
1799: WHERE (
1800: rle.object3_id1 = to_char(rcm.duplicate_site_id)

Line 1797: hz_utility_pub.LAST_UPDATED_BY

1793: hz_utility_pub.CREATED_BY,
1794: hz_utility_pub.CREATION_DATE,
1795: hz_utility_pub.LAST_UPDATE_LOGIN,
1796: hz_utility_pub.LAST_UPDATE_DATE,
1797: hz_utility_pub.LAST_UPDATED_BY
1798: FROM OKC_RULES_B rle, ra_customer_merges rcm
1799: WHERE (
1800: rle.object3_id1 = to_char(rcm.duplicate_site_id)
1801: ) AND rcm.process_flag = 'N'

Line 1871: hz_utility_pub.CREATED_BY,

1867: to_char(okh.ship_to_site_use_id),
1868: to_char(rcm.customer_site_id),
1869: req_id,
1870: 'U',
1871: hz_utility_pub.CREATED_BY,
1872: hz_utility_pub.CREATION_DATE,
1873: hz_utility_pub.LAST_UPDATE_LOGIN,
1874: hz_utility_pub.LAST_UPDATE_DATE,
1875: hz_utility_pub.LAST_UPDATED_BY

Line 1872: hz_utility_pub.CREATION_DATE,

1868: to_char(rcm.customer_site_id),
1869: req_id,
1870: 'U',
1871: hz_utility_pub.CREATED_BY,
1872: hz_utility_pub.CREATION_DATE,
1873: hz_utility_pub.LAST_UPDATE_LOGIN,
1874: hz_utility_pub.LAST_UPDATE_DATE,
1875: hz_utility_pub.LAST_UPDATED_BY
1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

Line 1873: hz_utility_pub.LAST_UPDATE_LOGIN,

1869: req_id,
1870: 'U',
1871: hz_utility_pub.CREATED_BY,
1872: hz_utility_pub.CREATION_DATE,
1873: hz_utility_pub.LAST_UPDATE_LOGIN,
1874: hz_utility_pub.LAST_UPDATE_DATE,
1875: hz_utility_pub.LAST_UPDATED_BY
1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1877: WHERE (

Line 1874: hz_utility_pub.LAST_UPDATE_DATE,

1870: 'U',
1871: hz_utility_pub.CREATED_BY,
1872: hz_utility_pub.CREATION_DATE,
1873: hz_utility_pub.LAST_UPDATE_LOGIN,
1874: hz_utility_pub.LAST_UPDATE_DATE,
1875: hz_utility_pub.LAST_UPDATED_BY
1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1877: WHERE (
1878: okh.ship_to_site_use_id = rcm.duplicate_site_id

Line 1875: hz_utility_pub.LAST_UPDATED_BY

1871: hz_utility_pub.CREATED_BY,
1872: hz_utility_pub.CREATION_DATE,
1873: hz_utility_pub.LAST_UPDATE_LOGIN,
1874: hz_utility_pub.LAST_UPDATE_DATE,
1875: hz_utility_pub.LAST_UPDATED_BY
1876: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1877: WHERE (
1878: okh.ship_to_site_use_id = rcm.duplicate_site_id
1879: ) AND rcm.process_flag = 'N'

Line 1940: hz_utility_pub.CREATED_BY,

1936: to_char(okh.bill_to_site_use_id),
1937: to_char(rcm.customer_site_id),
1938: req_id,
1939: 'U',
1940: hz_utility_pub.CREATED_BY,
1941: hz_utility_pub.CREATION_DATE,
1942: hz_utility_pub.LAST_UPDATE_LOGIN,
1943: hz_utility_pub.LAST_UPDATE_DATE,
1944: hz_utility_pub.LAST_UPDATED_BY

Line 1941: hz_utility_pub.CREATION_DATE,

1937: to_char(rcm.customer_site_id),
1938: req_id,
1939: 'U',
1940: hz_utility_pub.CREATED_BY,
1941: hz_utility_pub.CREATION_DATE,
1942: hz_utility_pub.LAST_UPDATE_LOGIN,
1943: hz_utility_pub.LAST_UPDATE_DATE,
1944: hz_utility_pub.LAST_UPDATED_BY
1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm

Line 1942: hz_utility_pub.LAST_UPDATE_LOGIN,

1938: req_id,
1939: 'U',
1940: hz_utility_pub.CREATED_BY,
1941: hz_utility_pub.CREATION_DATE,
1942: hz_utility_pub.LAST_UPDATE_LOGIN,
1943: hz_utility_pub.LAST_UPDATE_DATE,
1944: hz_utility_pub.LAST_UPDATED_BY
1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1946: WHERE (

Line 1943: hz_utility_pub.LAST_UPDATE_DATE,

1939: 'U',
1940: hz_utility_pub.CREATED_BY,
1941: hz_utility_pub.CREATION_DATE,
1942: hz_utility_pub.LAST_UPDATE_LOGIN,
1943: hz_utility_pub.LAST_UPDATE_DATE,
1944: hz_utility_pub.LAST_UPDATED_BY
1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1946: WHERE (
1947: okh.bill_to_site_use_id = rcm.duplicate_site_id

Line 1944: hz_utility_pub.LAST_UPDATED_BY

1940: hz_utility_pub.CREATED_BY,
1941: hz_utility_pub.CREATION_DATE,
1942: hz_utility_pub.LAST_UPDATE_LOGIN,
1943: hz_utility_pub.LAST_UPDATE_DATE,
1944: hz_utility_pub.LAST_UPDATED_BY
1945: FROM OKC_K_HEADERS_B okh, ra_customer_merges rcm
1946: WHERE (
1947: okh.bill_to_site_use_id = rcm.duplicate_site_id
1948: ) AND rcm.process_flag = 'N'

Line 2008: hz_utility_pub.CREATED_BY,

2004: to_char(okl.ship_to_site_use_id),
2005: to_char(rcm.customer_site_id),
2006: req_id,
2007: 'U',
2008: hz_utility_pub.CREATED_BY,
2009: hz_utility_pub.CREATION_DATE,
2010: hz_utility_pub.LAST_UPDATE_LOGIN,
2011: hz_utility_pub.LAST_UPDATE_DATE,
2012: hz_utility_pub.LAST_UPDATED_BY

Line 2009: hz_utility_pub.CREATION_DATE,

2005: to_char(rcm.customer_site_id),
2006: req_id,
2007: 'U',
2008: hz_utility_pub.CREATED_BY,
2009: hz_utility_pub.CREATION_DATE,
2010: hz_utility_pub.LAST_UPDATE_LOGIN,
2011: hz_utility_pub.LAST_UPDATE_DATE,
2012: hz_utility_pub.LAST_UPDATED_BY
2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

Line 2010: hz_utility_pub.LAST_UPDATE_LOGIN,

2006: req_id,
2007: 'U',
2008: hz_utility_pub.CREATED_BY,
2009: hz_utility_pub.CREATION_DATE,
2010: hz_utility_pub.LAST_UPDATE_LOGIN,
2011: hz_utility_pub.LAST_UPDATE_DATE,
2012: hz_utility_pub.LAST_UPDATED_BY
2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2014: WHERE (

Line 2011: hz_utility_pub.LAST_UPDATE_DATE,

2007: 'U',
2008: hz_utility_pub.CREATED_BY,
2009: hz_utility_pub.CREATION_DATE,
2010: hz_utility_pub.LAST_UPDATE_LOGIN,
2011: hz_utility_pub.LAST_UPDATE_DATE,
2012: hz_utility_pub.LAST_UPDATED_BY
2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2014: WHERE (
2015: okl.ship_to_site_use_id = rcm.duplicate_site_id

Line 2012: hz_utility_pub.LAST_UPDATED_BY

2008: hz_utility_pub.CREATED_BY,
2009: hz_utility_pub.CREATION_DATE,
2010: hz_utility_pub.LAST_UPDATE_LOGIN,
2011: hz_utility_pub.LAST_UPDATE_DATE,
2012: hz_utility_pub.LAST_UPDATED_BY
2013: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2014: WHERE (
2015: okl.ship_to_site_use_id = rcm.duplicate_site_id
2016: ) AND rcm.process_flag = 'N'

Line 2077: hz_utility_pub.CREATED_BY,

2073: to_char(okl.bill_to_site_use_id),
2074: to_char(rcm.customer_site_id),
2075: req_id,
2076: 'U',
2077: hz_utility_pub.CREATED_BY,
2078: hz_utility_pub.CREATION_DATE,
2079: hz_utility_pub.LAST_UPDATE_LOGIN,
2080: hz_utility_pub.LAST_UPDATE_DATE,
2081: hz_utility_pub.LAST_UPDATED_BY

Line 2078: hz_utility_pub.CREATION_DATE,

2074: to_char(rcm.customer_site_id),
2075: req_id,
2076: 'U',
2077: hz_utility_pub.CREATED_BY,
2078: hz_utility_pub.CREATION_DATE,
2079: hz_utility_pub.LAST_UPDATE_LOGIN,
2080: hz_utility_pub.LAST_UPDATE_DATE,
2081: hz_utility_pub.LAST_UPDATED_BY
2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm

Line 2079: hz_utility_pub.LAST_UPDATE_LOGIN,

2075: req_id,
2076: 'U',
2077: hz_utility_pub.CREATED_BY,
2078: hz_utility_pub.CREATION_DATE,
2079: hz_utility_pub.LAST_UPDATE_LOGIN,
2080: hz_utility_pub.LAST_UPDATE_DATE,
2081: hz_utility_pub.LAST_UPDATED_BY
2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2083: WHERE (

Line 2080: hz_utility_pub.LAST_UPDATE_DATE,

2076: 'U',
2077: hz_utility_pub.CREATED_BY,
2078: hz_utility_pub.CREATION_DATE,
2079: hz_utility_pub.LAST_UPDATE_LOGIN,
2080: hz_utility_pub.LAST_UPDATE_DATE,
2081: hz_utility_pub.LAST_UPDATED_BY
2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2083: WHERE (
2084: okl.bill_to_site_use_id = rcm.duplicate_site_id

Line 2081: hz_utility_pub.LAST_UPDATED_BY

2077: hz_utility_pub.CREATED_BY,
2078: hz_utility_pub.CREATION_DATE,
2079: hz_utility_pub.LAST_UPDATE_LOGIN,
2080: hz_utility_pub.LAST_UPDATE_DATE,
2081: hz_utility_pub.LAST_UPDATED_BY
2082: FROM OKC_K_LINES_B okl, ra_customer_merges rcm
2083: WHERE (
2084: okl.bill_to_site_use_id = rcm.duplicate_site_id
2085: ) AND rcm.process_flag = 'N'

Line 2146: hz_utility_pub.CREATED_BY,

2142: to_char(okpr.bill_to_site_use_id),
2143: to_char(rcm.customer_site_id),
2144: req_id,
2145: 'U',
2146: hz_utility_pub.CREATED_BY,
2147: hz_utility_pub.CREATION_DATE,
2148: hz_utility_pub.LAST_UPDATE_LOGIN,
2149: hz_utility_pub.LAST_UPDATE_DATE,
2150: hz_utility_pub.LAST_UPDATED_BY

Line 2147: hz_utility_pub.CREATION_DATE,

2143: to_char(rcm.customer_site_id),
2144: req_id,
2145: 'U',
2146: hz_utility_pub.CREATED_BY,
2147: hz_utility_pub.CREATION_DATE,
2148: hz_utility_pub.LAST_UPDATE_LOGIN,
2149: hz_utility_pub.LAST_UPDATE_DATE,
2150: hz_utility_pub.LAST_UPDATED_BY
2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm

Line 2148: hz_utility_pub.LAST_UPDATE_LOGIN,

2144: req_id,
2145: 'U',
2146: hz_utility_pub.CREATED_BY,
2147: hz_utility_pub.CREATION_DATE,
2148: hz_utility_pub.LAST_UPDATE_LOGIN,
2149: hz_utility_pub.LAST_UPDATE_DATE,
2150: hz_utility_pub.LAST_UPDATED_BY
2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2152: WHERE (

Line 2149: hz_utility_pub.LAST_UPDATE_DATE,

2145: 'U',
2146: hz_utility_pub.CREATED_BY,
2147: hz_utility_pub.CREATION_DATE,
2148: hz_utility_pub.LAST_UPDATE_LOGIN,
2149: hz_utility_pub.LAST_UPDATE_DATE,
2150: hz_utility_pub.LAST_UPDATED_BY
2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2152: WHERE (
2153: okpr.bill_to_site_use_id = rcm.duplicate_site_id

Line 2150: hz_utility_pub.LAST_UPDATED_BY

2146: hz_utility_pub.CREATED_BY,
2147: hz_utility_pub.CREATION_DATE,
2148: hz_utility_pub.LAST_UPDATE_LOGIN,
2149: hz_utility_pub.LAST_UPDATE_DATE,
2150: hz_utility_pub.LAST_UPDATED_BY
2151: FROM OKC_K_PARTY_ROLES_B okpr, ra_customer_merges rcm
2152: WHERE (
2153: okpr.bill_to_site_use_id = rcm.duplicate_site_id
2154: ) AND rcm.process_flag = 'N'

Line 2217: hz_utility_pub.CREATED_BY,

2213: cim.object1_id1,
2214: to_char(rcm.customer_site_id),
2215: req_id,
2216: 'U',
2217: hz_utility_pub.CREATED_BY,
2218: hz_utility_pub.CREATION_DATE,
2219: hz_utility_pub.LAST_UPDATE_LOGIN,
2220: hz_utility_pub.LAST_UPDATE_DATE,
2221: hz_utility_pub.LAST_UPDATED_BY

Line 2218: hz_utility_pub.CREATION_DATE,

2214: to_char(rcm.customer_site_id),
2215: req_id,
2216: 'U',
2217: hz_utility_pub.CREATED_BY,
2218: hz_utility_pub.CREATION_DATE,
2219: hz_utility_pub.LAST_UPDATE_LOGIN,
2220: hz_utility_pub.LAST_UPDATE_DATE,
2221: hz_utility_pub.LAST_UPDATED_BY
2222: FROM OKC_K_ITEMS cim, ra_customer_merges rcm

Line 2219: hz_utility_pub.LAST_UPDATE_LOGIN,

2215: req_id,
2216: 'U',
2217: hz_utility_pub.CREATED_BY,
2218: hz_utility_pub.CREATION_DATE,
2219: hz_utility_pub.LAST_UPDATE_LOGIN,
2220: hz_utility_pub.LAST_UPDATE_DATE,
2221: hz_utility_pub.LAST_UPDATED_BY
2222: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2223: WHERE (

Line 2220: hz_utility_pub.LAST_UPDATE_DATE,

2216: 'U',
2217: hz_utility_pub.CREATED_BY,
2218: hz_utility_pub.CREATION_DATE,
2219: hz_utility_pub.LAST_UPDATE_LOGIN,
2220: hz_utility_pub.LAST_UPDATE_DATE,
2221: hz_utility_pub.LAST_UPDATED_BY
2222: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2223: WHERE (
2224: cim.object1_id1 = to_char(rcm.duplicate_site_id)

Line 2221: hz_utility_pub.LAST_UPDATED_BY

2217: hz_utility_pub.CREATED_BY,
2218: hz_utility_pub.CREATION_DATE,
2219: hz_utility_pub.LAST_UPDATE_LOGIN,
2220: hz_utility_pub.LAST_UPDATE_DATE,
2221: hz_utility_pub.LAST_UPDATED_BY
2222: FROM OKC_K_ITEMS cim, ra_customer_merges rcm
2223: WHERE (
2224: cim.object1_id1 = to_char(rcm.duplicate_site_id)
2225: ) AND rcm.process_flag = 'N'