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 STANDARD

Line 465: ,kpr.last_updated_by = arp_standard.profile.user_id

461: UPDATE okc_k_party_roles_b kpr
462: SET kpr.object1_id1 = l_target_party_id
463: ,kpr.object_version_number = kpr.object_version_number + 1
464: ,kpr.last_update_date = SYSDATE
465: ,kpr.last_updated_by = arp_standard.profile.user_id
466: ,kpr.last_update_login = arp_standard.profile.last_update_login
467: WHERE kpr.object1_id1 = l_source_party_id
468: AND kpr.dnz_chr_id = l_chr_id;
469:

Line 466: ,kpr.last_update_login = arp_standard.profile.last_update_login

462: SET kpr.object1_id1 = l_target_party_id
463: ,kpr.object_version_number = kpr.object_version_number + 1
464: ,kpr.last_update_date = SYSDATE
465: ,kpr.last_updated_by = arp_standard.profile.user_id
466: ,kpr.last_update_login = arp_standard.profile.last_update_login
467: WHERE kpr.object1_id1 = l_source_party_id
468: AND kpr.dnz_chr_id = l_chr_id;
469:
470: l_count := sql%rowcount;

Line 537: ,ver.last_updated_by = arp_standard.profile.user_id

533: UPDATE okc_k_vers_numbers ver
534: SET ver.minor_version = ver.minor_version + 1
535: ,ver.object_version_number = ver.object_version_number + 1
536: ,ver.last_update_date = SYSDATE
537: ,ver.last_updated_by = arp_standard.profile.user_id
538: ,ver.last_update_login = arp_standard.profile.last_update_login
539: WHERE chr_id = l_chr_id;
540: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
541:

Line 538: ,ver.last_update_login = arp_standard.profile.last_update_login

534: SET ver.minor_version = ver.minor_version + 1
535: ,ver.object_version_number = ver.object_version_number + 1
536: ,ver.last_update_date = SYSDATE
537: ,ver.last_updated_by = arp_standard.profile.user_id
538: ,ver.last_update_login = arp_standard.profile.last_update_login
539: WHERE chr_id = l_chr_id;
540: -- Updating okc_k_vers_numbers for Bug 3553330/3215231/3224957
541:
542: END IF;

Line 642: ,kpr.last_updated_by = arp_standard.profile.user_id

638: AND rcm.request_id = req_id
639: AND rcm.set_number = set_number)
640: ,kpr.object_version_number = kpr.object_version_number + 1
641: ,kpr.last_update_date = SYSDATE
642: ,kpr.last_updated_by = arp_standard.profile.user_id
643: ,kpr.last_update_login = arp_standard.profile.last_update_login
644: WHERE kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
645: FROM ra_customer_merges rcm
646: WHERE rcm.process_flag = 'N'

Line 643: ,kpr.last_update_login = arp_standard.profile.last_update_login

639: AND rcm.set_number = set_number)
640: ,kpr.object_version_number = kpr.object_version_number + 1
641: ,kpr.last_update_date = SYSDATE
642: ,kpr.last_updated_by = arp_standard.profile.user_id
643: ,kpr.last_update_login = arp_standard.profile.last_update_login
644: WHERE kpr.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
645: FROM ra_customer_merges rcm
646: WHERE rcm.process_flag = 'N'
647: AND rcm.request_id = req_id

Line 718: ,rle.last_updated_by = arp_standard.profile.user_id

714: AND rcm.request_id = req_id
715: AND rcm.set_number = set_number)
716: ,rle.object_version_number = rle.object_version_number + 1
717: ,rle.last_update_date = SYSDATE
718: ,rle.last_updated_by = arp_standard.profile.user_id
719: ,rle.last_update_login = arp_standard.profile.last_update_login
720: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
721: FROM ra_customer_merges rcm
722: WHERE rcm.process_flag = 'N'

Line 719: ,rle.last_update_login = arp_standard.profile.last_update_login

715: AND rcm.set_number = set_number)
716: ,rle.object_version_number = rle.object_version_number + 1
717: ,rle.last_update_date = SYSDATE
718: ,rle.last_updated_by = arp_standard.profile.user_id
719: ,rle.last_update_login = arp_standard.profile.last_update_login
720: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
721: FROM ra_customer_merges rcm
722: WHERE rcm.process_flag = 'N'
723: AND rcm.request_id = req_id

Line 795: ,rle.last_updated_by = arp_standard.profile.user_id

791: AND rcm.request_id = req_id
792: AND rcm.set_number = set_number)
793: ,rle.object_version_number = rle.object_version_number + 1
794: ,rle.last_update_date = SYSDATE
795: ,rle.last_updated_by = arp_standard.profile.user_id
796: ,rle.last_update_login = arp_standard.profile.last_update_login
797: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
798: FROM ra_customer_merges rcm
799: WHERE rcm.process_flag = 'N'

Line 796: ,rle.last_update_login = arp_standard.profile.last_update_login

792: AND rcm.set_number = set_number)
793: ,rle.object_version_number = rle.object_version_number + 1
794: ,rle.last_update_date = SYSDATE
795: ,rle.last_updated_by = arp_standard.profile.user_id
796: ,rle.last_update_login = arp_standard.profile.last_update_login
797: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_id)
798: FROM ra_customer_merges rcm
799: WHERE rcm.process_flag = 'N'
800: AND rcm.request_id = req_id

Line 872: ,rle.last_updated_by = arp_standard.profile.user_id

868: AND rcm.request_id = req_id
869: AND rcm.set_number = set_number)
870: ,rle.object_version_number = rle.object_version_number + 1
871: ,rle.last_update_date = SYSDATE
872: ,rle.last_updated_by = arp_standard.profile.user_id
873: ,rle.last_update_login = arp_standard.profile.last_update_login
874: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
875: FROM ra_customer_merges rcm
876: WHERE rcm.process_flag = 'N'

Line 873: ,rle.last_update_login = arp_standard.profile.last_update_login

869: AND rcm.set_number = set_number)
870: ,rle.object_version_number = rle.object_version_number + 1
871: ,rle.last_update_date = SYSDATE
872: ,rle.last_updated_by = arp_standard.profile.user_id
873: ,rle.last_update_login = arp_standard.profile.last_update_login
874: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_id)
875: FROM ra_customer_merges rcm
876: WHERE rcm.process_flag = 'N'
877: AND rcm.request_id = req_id

Line 947: ,okh.last_updated_by = arp_standard.profile.user_id

943: AND rcm.request_id = req_id
944: AND rcm.set_number = set_number)
945: ,okh.object_version_number = okh.object_version_number + 1
946: ,okh.last_update_date = SYSDATE
947: ,okh.last_updated_by = arp_standard.profile.user_id
948: ,okh.last_update_login = arp_standard.profile.last_update_login
949: WHERE okh.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
950: FROM ra_customer_merges rcm
951: WHERE rcm.process_flag = 'N'

Line 948: ,okh.last_update_login = arp_standard.profile.last_update_login

944: AND rcm.set_number = set_number)
945: ,okh.object_version_number = okh.object_version_number + 1
946: ,okh.last_update_date = SYSDATE
947: ,okh.last_updated_by = arp_standard.profile.user_id
948: ,okh.last_update_login = arp_standard.profile.last_update_login
949: WHERE okh.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
950: FROM ra_customer_merges rcm
951: WHERE rcm.process_flag = 'N'
952: AND rcm.request_id = req_id

Line 1018: ,okl.last_updated_by = arp_standard.profile.user_id

1014: AND rcm.request_id = req_id
1015: AND rcm.set_number = set_number)
1016: ,okl.object_version_number = okl.object_version_number + 1
1017: ,okl.last_update_date = SYSDATE
1018: ,okl.last_updated_by = arp_standard.profile.user_id
1019: ,okl.last_update_login = arp_standard.profile.last_update_login
1020: WHERE okl.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1021: FROM ra_customer_merges rcm
1022: WHERE rcm.process_flag = 'N'

Line 1019: ,okl.last_update_login = arp_standard.profile.last_update_login

1015: AND rcm.set_number = set_number)
1016: ,okl.object_version_number = okl.object_version_number + 1
1017: ,okl.last_update_date = SYSDATE
1018: ,okl.last_updated_by = arp_standard.profile.user_id
1019: ,okl.last_update_login = arp_standard.profile.last_update_login
1020: WHERE okl.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1021: FROM ra_customer_merges rcm
1022: WHERE rcm.process_flag = 'N'
1023: AND rcm.request_id = req_id

Line 1087: ,okpr.last_updated_by = arp_standard.profile.user_id

1083: AND rcm.request_id = req_id
1084: AND rcm.set_number = set_number)
1085: ,okpr.object_version_number = okpr.object_version_number + 1
1086: ,okpr.last_update_date = SYSDATE
1087: ,okpr.last_updated_by = arp_standard.profile.user_id
1088: ,okpr.last_update_login = arp_standard.profile.last_update_login
1089: WHERE okpr.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1090: FROM ra_customer_merges rcm
1091: WHERE rcm.process_flag = 'N'

Line 1088: ,okpr.last_update_login = arp_standard.profile.last_update_login

1084: AND rcm.set_number = set_number)
1085: ,okpr.object_version_number = okpr.object_version_number + 1
1086: ,okpr.last_update_date = SYSDATE
1087: ,okpr.last_updated_by = arp_standard.profile.user_id
1088: ,okpr.last_update_login = arp_standard.profile.last_update_login
1089: WHERE okpr.cust_acct_id IN (SELECT DISTINCT (rcm.duplicate_id)
1090: FROM ra_customer_merges rcm
1091: WHERE rcm.process_flag = 'N'
1092: AND rcm.request_id = req_id

Line 1160: ,cim.last_updated_by = arp_standard.profile.user_id

1156: AND rcm.request_id = req_id
1157: AND rcm.set_number = set_number)
1158: ,cim.object_version_number = cim.object_version_number + 1
1159: ,cim.last_update_date = SYSDATE
1160: ,cim.last_updated_by = arp_standard.profile.user_id
1161: ,cim.last_update_login = arp_standard.profile.last_update_login
1162: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1163: FROM ra_customer_merges rcm
1164: WHERE rcm.process_flag = 'N'

Line 1161: ,cim.last_update_login = arp_standard.profile.last_update_login

1157: AND rcm.set_number = set_number)
1158: ,cim.object_version_number = cim.object_version_number + 1
1159: ,cim.last_update_date = SYSDATE
1160: ,cim.last_updated_by = arp_standard.profile.user_id
1161: ,cim.last_update_login = arp_standard.profile.last_update_login
1162: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_id)
1163: FROM ra_customer_merges rcm
1164: WHERE rcm.process_flag = 'N'
1165: AND rcm.request_id = req_id

Line 1260: ,rle.last_updated_by = arp_standard.profile.user_id

1256: AND rcm.set_number = set_number
1257: AND ROWNUM=1)
1258: ,rle.object_version_number = rle.object_version_number + 1
1259: ,rle.last_update_date = SYSDATE
1260: ,rle.last_updated_by = arp_standard.profile.user_id
1261: ,rle.last_update_login = arp_standard.profile.last_update_login
1262: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1263: FROM ra_customer_merges rcm
1264: WHERE rcm.process_flag = 'N'

Line 1261: ,rle.last_update_login = arp_standard.profile.last_update_login

1257: AND ROWNUM=1)
1258: ,rle.object_version_number = rle.object_version_number + 1
1259: ,rle.last_update_date = SYSDATE
1260: ,rle.last_updated_by = arp_standard.profile.user_id
1261: ,rle.last_update_login = arp_standard.profile.last_update_login
1262: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1263: FROM ra_customer_merges rcm
1264: WHERE rcm.process_flag = 'N'
1265: AND rcm.request_id = req_id

Line 1338: ,rle.last_updated_by = arp_standard.profile.user_id

1334: AND rcm.set_number = set_number
1335: AND ROWNUM=1)
1336: ,rle.object_version_number = rle.object_version_number + 1
1337: ,rle.last_update_date = SYSDATE
1338: ,rle.last_updated_by = arp_standard.profile.user_id
1339: ,rle.last_update_login = arp_standard.profile.last_update_login
1340: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1341: FROM ra_customer_merges rcm
1342: WHERE rcm.process_flag = 'N'

Line 1339: ,rle.last_update_login = arp_standard.profile.last_update_login

1335: AND ROWNUM=1)
1336: ,rle.object_version_number = rle.object_version_number + 1
1337: ,rle.last_update_date = SYSDATE
1338: ,rle.last_updated_by = arp_standard.profile.user_id
1339: ,rle.last_update_login = arp_standard.profile.last_update_login
1340: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1341: FROM ra_customer_merges rcm
1342: WHERE rcm.process_flag = 'N'
1343: AND rcm.request_id = req_id

Line 1415: ,rle.last_updated_by = arp_standard.profile.user_id

1411: AND rcm.set_number = set_number
1412: AND ROWNUM=1)
1413: ,rle.object_version_number = rle.object_version_number + 1
1414: ,rle.last_update_date = SYSDATE
1415: ,rle.last_updated_by = arp_standard.profile.user_id
1416: ,rle.last_update_login = arp_standard.profile.last_update_login
1417: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1418: FROM ra_customer_merges rcm
1419: WHERE rcm.process_flag = 'N'

Line 1416: ,rle.last_update_login = arp_standard.profile.last_update_login

1412: AND ROWNUM=1)
1413: ,rle.object_version_number = rle.object_version_number + 1
1414: ,rle.last_update_date = SYSDATE
1415: ,rle.last_updated_by = arp_standard.profile.user_id
1416: ,rle.last_update_login = arp_standard.profile.last_update_login
1417: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1418: FROM ra_customer_merges rcm
1419: WHERE rcm.process_flag = 'N'
1420: AND rcm.request_id = req_id

Line 1495: ,cim.last_updated_by = arp_standard.profile.user_id

1491: AND rcm.set_number = set_number
1492: AND ROWNUM=1)
1493: ,cim.object_version_number = cim.object_version_number + 1
1494: ,cim.last_update_date = SYSDATE
1495: ,cim.last_updated_by = arp_standard.profile.user_id
1496: ,cim.last_update_login = arp_standard.profile.last_update_login
1497: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1498: FROM ra_customer_merges rcm
1499: WHERE rcm.process_flag = 'N'

Line 1496: ,cim.last_update_login = arp_standard.profile.last_update_login

1492: AND ROWNUM=1)
1493: ,cim.object_version_number = cim.object_version_number + 1
1494: ,cim.last_update_date = SYSDATE
1495: ,cim.last_updated_by = arp_standard.profile.user_id
1496: ,cim.last_update_login = arp_standard.profile.last_update_login
1497: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_address_id)
1498: FROM ra_customer_merges rcm
1499: WHERE rcm.process_flag = 'N'
1500: AND rcm.request_id = req_id

Line 1584: ,rle.last_updated_by = arp_standard.profile.user_id

1580: AND rcm.request_id = req_id
1581: AND rcm.set_number = set_number)
1582: ,rle.object_version_number = rle.object_version_number + 1
1583: ,rle.last_update_date = SYSDATE
1584: ,rle.last_updated_by = arp_standard.profile.user_id
1585: ,rle.last_update_login = arp_standard.profile.last_update_login
1586: WHERE rle.object1_id1 IN ( SELECT to_char(rcm.duplicate_site_id)
1587: FROM ra_customer_merges rcm
1588: WHERE rcm.process_flag = 'N'

Line 1585: ,rle.last_update_login = arp_standard.profile.last_update_login

1581: AND rcm.set_number = set_number)
1582: ,rle.object_version_number = rle.object_version_number + 1
1583: ,rle.last_update_date = SYSDATE
1584: ,rle.last_updated_by = arp_standard.profile.user_id
1585: ,rle.last_update_login = arp_standard.profile.last_update_login
1586: WHERE rle.object1_id1 IN ( SELECT to_char(rcm.duplicate_site_id)
1587: FROM ra_customer_merges rcm
1588: WHERE rcm.process_flag = 'N'
1589: AND rcm.request_id = req_id

Line 1674: ,rle.last_updated_by = arp_standard.profile.user_id

1670: AND rcm.request_id = req_id
1671: AND rcm.set_number = set_number)
1672: ,rle.object_version_number = rle.object_version_number + 1
1673: ,rle.last_update_date = SYSDATE
1674: ,rle.last_updated_by = arp_standard.profile.user_id
1675: ,rle.last_update_login = arp_standard.profile.last_update_login
1676: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1677: FROM ra_customer_merges rcm
1678: WHERE rcm.process_flag = 'N'

Line 1675: ,rle.last_update_login = arp_standard.profile.last_update_login

1671: AND rcm.set_number = set_number)
1672: ,rle.object_version_number = rle.object_version_number + 1
1673: ,rle.last_update_date = SYSDATE
1674: ,rle.last_updated_by = arp_standard.profile.user_id
1675: ,rle.last_update_login = arp_standard.profile.last_update_login
1676: WHERE rle.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1677: FROM ra_customer_merges rcm
1678: WHERE rcm.process_flag = 'N'
1679: AND rcm.request_id = req_id

Line 1750: ,rle.last_updated_by = arp_standard.profile.user_id

1746: AND rcm.request_id = req_id
1747: AND rcm.set_number = set_number)
1748: ,rle.object_version_number = rle.object_version_number + 1
1749: ,rle.last_update_date = SYSDATE
1750: ,rle.last_updated_by = arp_standard.profile.user_id
1751: ,rle.last_update_login = arp_standard.profile.last_update_login
1752: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1753: FROM ra_customer_merges rcm
1754: WHERE rcm.process_flag = 'N'

Line 1751: ,rle.last_update_login = arp_standard.profile.last_update_login

1747: AND rcm.set_number = set_number)
1748: ,rle.object_version_number = rle.object_version_number + 1
1749: ,rle.last_update_date = SYSDATE
1750: ,rle.last_updated_by = arp_standard.profile.user_id
1751: ,rle.last_update_login = arp_standard.profile.last_update_login
1752: WHERE rle.object2_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1753: FROM ra_customer_merges rcm
1754: WHERE rcm.process_flag = 'N'
1755: AND rcm.request_id = req_id

Line 1827: ,rle.last_updated_by = arp_standard.profile.user_id

1823: AND rcm.request_id = req_id
1824: AND rcm.set_number = set_number)
1825: ,rle.object_version_number = rle.object_version_number + 1
1826: ,rle.last_update_date = SYSDATE
1827: ,rle.last_updated_by = arp_standard.profile.user_id
1828: ,rle.last_update_login = arp_standard.profile.last_update_login
1829: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1830: FROM ra_customer_merges rcm
1831: WHERE rcm.process_flag = 'N'

Line 1828: ,rle.last_update_login = arp_standard.profile.last_update_login

1824: AND rcm.set_number = set_number)
1825: ,rle.object_version_number = rle.object_version_number + 1
1826: ,rle.last_update_date = SYSDATE
1827: ,rle.last_updated_by = arp_standard.profile.user_id
1828: ,rle.last_update_login = arp_standard.profile.last_update_login
1829: WHERE rle.object3_id1 IN (SELECT to_char(rcm.duplicate_site_id)
1830: FROM ra_customer_merges rcm
1831: WHERE rcm.process_flag = 'N'
1832: AND rcm.request_id = req_id

Line 1902: ,okh.last_updated_by = arp_standard.profile.user_id

1898: AND rcm.request_id = req_id
1899: AND rcm.set_number = set_number)
1900: ,okh.object_version_number = okh.object_version_number + 1
1901: ,okh.last_update_date = SYSDATE
1902: ,okh.last_updated_by = arp_standard.profile.user_id
1903: ,okh.last_update_login = arp_standard.profile.last_update_login
1904: WHERE okh.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1905: FROM ra_customer_merges rcm
1906: WHERE rcm.process_flag = 'N'

Line 1903: ,okh.last_update_login = arp_standard.profile.last_update_login

1899: AND rcm.set_number = set_number)
1900: ,okh.object_version_number = okh.object_version_number + 1
1901: ,okh.last_update_date = SYSDATE
1902: ,okh.last_updated_by = arp_standard.profile.user_id
1903: ,okh.last_update_login = arp_standard.profile.last_update_login
1904: WHERE okh.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1905: FROM ra_customer_merges rcm
1906: WHERE rcm.process_flag = 'N'
1907: AND rcm.request_id = req_id

Line 1971: ,okh.last_updated_by = arp_standard.profile.user_id

1967: AND rcm.request_id = req_id
1968: AND rcm.set_number = set_number)
1969: ,okh.object_version_number = okh.object_version_number + 1
1970: ,okh.last_update_date = SYSDATE
1971: ,okh.last_updated_by = arp_standard.profile.user_id
1972: ,okh.last_update_login = arp_standard.profile.last_update_login
1973: WHERE okh.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1974: FROM ra_customer_merges rcm
1975: WHERE rcm.process_flag = 'N'

Line 1972: ,okh.last_update_login = arp_standard.profile.last_update_login

1968: AND rcm.set_number = set_number)
1969: ,okh.object_version_number = okh.object_version_number + 1
1970: ,okh.last_update_date = SYSDATE
1971: ,okh.last_updated_by = arp_standard.profile.user_id
1972: ,okh.last_update_login = arp_standard.profile.last_update_login
1973: WHERE okh.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
1974: FROM ra_customer_merges rcm
1975: WHERE rcm.process_flag = 'N'
1976: AND rcm.request_id = req_id

Line 2039: ,okl.last_updated_by = arp_standard.profile.user_id

2035: AND rcm.request_id = req_id
2036: AND rcm.set_number = set_number)
2037: ,okl.object_version_number = okl.object_version_number + 1
2038: ,okl.last_update_date = SYSDATE
2039: ,okl.last_updated_by = arp_standard.profile.user_id
2040: ,okl.last_update_login = arp_standard.profile.last_update_login
2041: WHERE okl.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2042: FROM ra_customer_merges rcm
2043: WHERE rcm.process_flag = 'N'

Line 2040: ,okl.last_update_login = arp_standard.profile.last_update_login

2036: AND rcm.set_number = set_number)
2037: ,okl.object_version_number = okl.object_version_number + 1
2038: ,okl.last_update_date = SYSDATE
2039: ,okl.last_updated_by = arp_standard.profile.user_id
2040: ,okl.last_update_login = arp_standard.profile.last_update_login
2041: WHERE okl.ship_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2042: FROM ra_customer_merges rcm
2043: WHERE rcm.process_flag = 'N'
2044: AND rcm.request_id = req_id

Line 2108: ,okl.last_updated_by = arp_standard.profile.user_id

2104: AND rcm.request_id = req_id
2105: AND rcm.set_number = set_number)
2106: ,okl.object_version_number = okl.object_version_number + 1
2107: ,okl.last_update_date = SYSDATE
2108: ,okl.last_updated_by = arp_standard.profile.user_id
2109: ,okl.last_update_login = arp_standard.profile.last_update_login
2110: WHERE okl.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2111: FROM ra_customer_merges rcm
2112: WHERE rcm.process_flag = 'N'

Line 2109: ,okl.last_update_login = arp_standard.profile.last_update_login

2105: AND rcm.set_number = set_number)
2106: ,okl.object_version_number = okl.object_version_number + 1
2107: ,okl.last_update_date = SYSDATE
2108: ,okl.last_updated_by = arp_standard.profile.user_id
2109: ,okl.last_update_login = arp_standard.profile.last_update_login
2110: WHERE okl.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2111: FROM ra_customer_merges rcm
2112: WHERE rcm.process_flag = 'N'
2113: AND rcm.request_id = req_id

Line 2177: ,okpr.last_updated_by = arp_standard.profile.user_id

2173: AND rcm.request_id = req_id
2174: AND rcm.set_number = set_number)
2175: ,okpr.object_version_number = okpr.object_version_number + 1
2176: ,okpr.last_update_date = SYSDATE
2177: ,okpr.last_updated_by = arp_standard.profile.user_id
2178: ,okpr.last_update_login = arp_standard.profile.last_update_login
2179: WHERE okpr.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2180: FROM ra_customer_merges rcm
2181: WHERE rcm.process_flag = 'N'

Line 2178: ,okpr.last_update_login = arp_standard.profile.last_update_login

2174: AND rcm.set_number = set_number)
2175: ,okpr.object_version_number = okpr.object_version_number + 1
2176: ,okpr.last_update_date = SYSDATE
2177: ,okpr.last_updated_by = arp_standard.profile.user_id
2178: ,okpr.last_update_login = arp_standard.profile.last_update_login
2179: WHERE okpr.bill_to_site_use_id IN (SELECT DISTINCT (rcm.duplicate_site_id)
2180: FROM ra_customer_merges rcm
2181: WHERE rcm.process_flag = 'N'
2182: AND rcm.request_id = req_id

Line 2251: ,cim.last_updated_by = arp_standard.profile.user_id

2247: AND rcm.request_id = req_id
2248: AND rcm.set_number = set_number)
2249: ,cim.object_version_number = cim.object_version_number + 1
2250: ,cim.last_update_date = SYSDATE
2251: ,cim.last_updated_by = arp_standard.profile.user_id
2252: ,cim.last_update_login = arp_standard.profile.last_update_login
2253: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2254: FROM ra_customer_merges rcm
2255: WHERE rcm.process_flag = 'N'

Line 2252: ,cim.last_update_login = arp_standard.profile.last_update_login

2248: AND rcm.set_number = set_number)
2249: ,cim.object_version_number = cim.object_version_number + 1
2250: ,cim.last_update_date = SYSDATE
2251: ,cim.last_updated_by = arp_standard.profile.user_id
2252: ,cim.last_update_login = arp_standard.profile.last_update_login
2253: WHERE cim.object1_id1 IN (SELECT to_char(rcm.duplicate_site_id)
2254: FROM ra_customer_merges rcm
2255: WHERE rcm.process_flag = 'N'
2256: AND rcm.request_id = req_id