APPS.OE_CUST_MERGE dependencies on HZ_UTILITY_PUB

Line 527: hz_utility_pub.CREATED_BY,

523: old_hdr_end_cust_id_tab(I),
524: decode(hdr_end_cust_id_tab(I),NULL,old_hdr_end_cust_id_tab(I),hdr_end_cust_id_tab(i)),
525: 'U',
526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY

Line 528: hz_utility_pub.CREATION_DATE,

524: decode(hdr_end_cust_id_tab(I),NULL,old_hdr_end_cust_id_tab(I),hdr_end_cust_id_tab(i)),
525: 'U',
526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );

Line 529: hz_utility_pub.LAST_UPDATE_LOGIN,

525: 'U',
526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );
533:

Line 530: hz_utility_pub.LAST_UPDATE_DATE,

526: req_id,
527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );
533:
534: end if;

Line 531: hz_utility_pub.LAST_UPDATED_BY

527: hz_utility_pub.CREATED_BY,
528: hz_utility_pub.CREATION_DATE,
529: hz_utility_pub.LAST_UPDATE_LOGIN,
530: hz_utility_pub.LAST_UPDATE_DATE,
531: hz_utility_pub.LAST_UPDATED_BY
532: );
533:
534: end if;
535: end if;

Line 1746: hz_utility_pub.CREATED_BY,

1742: h.ship_to_org_id,
1743: m.customer_site_id,
1744: 'U',
1745: req_id,
1746: hz_utility_pub.CREATED_BY,
1747: hz_utility_pub.CREATION_DATE,
1748: hz_utility_pub.LAST_UPDATE_LOGIN,
1749: hz_utility_pub.LAST_UPDATE_DATE,
1750: hz_utility_pub.LAST_UPDATED_BY

Line 1747: hz_utility_pub.CREATION_DATE,

1743: m.customer_site_id,
1744: 'U',
1745: req_id,
1746: hz_utility_pub.CREATED_BY,
1747: hz_utility_pub.CREATION_DATE,
1748: hz_utility_pub.LAST_UPDATE_LOGIN,
1749: hz_utility_pub.LAST_UPDATE_DATE,
1750: hz_utility_pub.LAST_UPDATED_BY
1751: from oe_header_acks h,

Line 1748: hz_utility_pub.LAST_UPDATE_LOGIN,

1744: 'U',
1745: req_id,
1746: hz_utility_pub.CREATED_BY,
1747: hz_utility_pub.CREATION_DATE,
1748: hz_utility_pub.LAST_UPDATE_LOGIN,
1749: hz_utility_pub.LAST_UPDATE_DATE,
1750: hz_utility_pub.LAST_UPDATED_BY
1751: from oe_header_acks h,
1752: ra_customer_merges m

Line 1749: hz_utility_pub.LAST_UPDATE_DATE,

1745: req_id,
1746: hz_utility_pub.CREATED_BY,
1747: hz_utility_pub.CREATION_DATE,
1748: hz_utility_pub.LAST_UPDATE_LOGIN,
1749: hz_utility_pub.LAST_UPDATE_DATE,
1750: hz_utility_pub.LAST_UPDATED_BY
1751: from oe_header_acks h,
1752: ra_customer_merges m
1753: where h.ship_to_org_id=m.duplicate_site_id

Line 1750: hz_utility_pub.LAST_UPDATED_BY

1746: hz_utility_pub.CREATED_BY,
1747: hz_utility_pub.CREATION_DATE,
1748: hz_utility_pub.LAST_UPDATE_LOGIN,
1749: hz_utility_pub.LAST_UPDATE_DATE,
1750: hz_utility_pub.LAST_UPDATED_BY
1751: from oe_header_acks h,
1752: ra_customer_merges m
1753: where h.ship_to_org_id=m.duplicate_site_id
1754: and m.process_flag = 'N'

Line 1813: hz_utility_pub.CREATED_BY,

1809: h.invoice_to_org_id,
1810: m.customer_site_id,
1811: 'U',
1812: req_id,
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: m.customer_site_id,
1811: 'U',
1812: req_id,
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 oe_header_acks h,

Line 1815: hz_utility_pub.LAST_UPDATE_LOGIN,

1811: 'U',
1812: req_id,
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 oe_header_acks h,
1819: ra_customer_merges m

Line 1816: hz_utility_pub.LAST_UPDATE_DATE,

1812: req_id,
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 oe_header_acks h,
1819: ra_customer_merges m
1820: where h.invoice_to_org_id=m.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 oe_header_acks h,
1819: ra_customer_merges m
1820: where h.invoice_to_org_id=m.duplicate_site_id
1821: and m.process_flag = 'N'

Line 1882: hz_utility_pub.CREATED_BY,

1878: h.deliver_to_org_id,
1879: m.customer_site_id,
1880: 'U',
1881: req_id,
1882: hz_utility_pub.CREATED_BY,
1883: hz_utility_pub.CREATION_DATE,
1884: hz_utility_pub.LAST_UPDATE_LOGIN,
1885: hz_utility_pub.LAST_UPDATE_DATE,
1886: hz_utility_pub.LAST_UPDATED_BY

Line 1883: hz_utility_pub.CREATION_DATE,

1879: m.customer_site_id,
1880: 'U',
1881: req_id,
1882: hz_utility_pub.CREATED_BY,
1883: hz_utility_pub.CREATION_DATE,
1884: hz_utility_pub.LAST_UPDATE_LOGIN,
1885: hz_utility_pub.LAST_UPDATE_DATE,
1886: hz_utility_pub.LAST_UPDATED_BY
1887: from oe_header_acks h,

Line 1884: hz_utility_pub.LAST_UPDATE_LOGIN,

1880: 'U',
1881: req_id,
1882: hz_utility_pub.CREATED_BY,
1883: hz_utility_pub.CREATION_DATE,
1884: hz_utility_pub.LAST_UPDATE_LOGIN,
1885: hz_utility_pub.LAST_UPDATE_DATE,
1886: hz_utility_pub.LAST_UPDATED_BY
1887: from oe_header_acks h,
1888: ra_customer_merges m

Line 1885: hz_utility_pub.LAST_UPDATE_DATE,

1881: req_id,
1882: hz_utility_pub.CREATED_BY,
1883: hz_utility_pub.CREATION_DATE,
1884: hz_utility_pub.LAST_UPDATE_LOGIN,
1885: hz_utility_pub.LAST_UPDATE_DATE,
1886: hz_utility_pub.LAST_UPDATED_BY
1887: from oe_header_acks h,
1888: ra_customer_merges m
1889: where h.deliver_to_org_id=m.duplicate_site_id

Line 1886: hz_utility_pub.LAST_UPDATED_BY

1882: hz_utility_pub.CREATED_BY,
1883: hz_utility_pub.CREATION_DATE,
1884: hz_utility_pub.LAST_UPDATE_LOGIN,
1885: hz_utility_pub.LAST_UPDATE_DATE,
1886: hz_utility_pub.LAST_UPDATED_BY
1887: from oe_header_acks h,
1888: ra_customer_merges m
1889: where h.deliver_to_org_id=m.duplicate_site_id
1890: and m.process_flag = 'N'

Line 1953: hz_utility_pub.CREATED_BY,

1949: h.sold_to_org_id,
1950: m.customer_site_id,
1951: 'U',
1952: req_id,
1953: hz_utility_pub.CREATED_BY,
1954: hz_utility_pub.CREATION_DATE,
1955: hz_utility_pub.LAST_UPDATE_LOGIN,
1956: hz_utility_pub.LAST_UPDATE_DATE,
1957: hz_utility_pub.LAST_UPDATED_BY

Line 1954: hz_utility_pub.CREATION_DATE,

1950: m.customer_site_id,
1951: 'U',
1952: req_id,
1953: hz_utility_pub.CREATED_BY,
1954: hz_utility_pub.CREATION_DATE,
1955: hz_utility_pub.LAST_UPDATE_LOGIN,
1956: hz_utility_pub.LAST_UPDATE_DATE,
1957: hz_utility_pub.LAST_UPDATED_BY
1958: from oe_header_acks h,

Line 1955: hz_utility_pub.LAST_UPDATE_LOGIN,

1951: 'U',
1952: req_id,
1953: hz_utility_pub.CREATED_BY,
1954: hz_utility_pub.CREATION_DATE,
1955: hz_utility_pub.LAST_UPDATE_LOGIN,
1956: hz_utility_pub.LAST_UPDATE_DATE,
1957: hz_utility_pub.LAST_UPDATED_BY
1958: from oe_header_acks h,
1959: ra_customer_merges m

Line 1956: hz_utility_pub.LAST_UPDATE_DATE,

1952: req_id,
1953: hz_utility_pub.CREATED_BY,
1954: hz_utility_pub.CREATION_DATE,
1955: hz_utility_pub.LAST_UPDATE_LOGIN,
1956: hz_utility_pub.LAST_UPDATE_DATE,
1957: hz_utility_pub.LAST_UPDATED_BY
1958: from oe_header_acks h,
1959: ra_customer_merges m
1960: where h.sold_to_org_id=m.duplicate_site_id

Line 1957: hz_utility_pub.LAST_UPDATED_BY

1953: hz_utility_pub.CREATED_BY,
1954: hz_utility_pub.CREATION_DATE,
1955: hz_utility_pub.LAST_UPDATE_LOGIN,
1956: hz_utility_pub.LAST_UPDATE_DATE,
1957: hz_utility_pub.LAST_UPDATED_BY
1958: from oe_header_acks h,
1959: ra_customer_merges m
1960: where h.sold_to_org_id=m.duplicate_site_id
1961: and m.process_flag = 'N'

Line 2025: hz_utility_pub.CREATED_BY,

2021: h.sold_to_site_use_id,
2022: m.customer_site_id,
2023: 'U',
2024: req_id,
2025: hz_utility_pub.CREATED_BY,
2026: hz_utility_pub.CREATION_DATE,
2027: hz_utility_pub.LAST_UPDATE_LOGIN,
2028: hz_utility_pub.LAST_UPDATE_DATE,
2029: hz_utility_pub.LAST_UPDATED_BY

Line 2026: hz_utility_pub.CREATION_DATE,

2022: m.customer_site_id,
2023: 'U',
2024: req_id,
2025: hz_utility_pub.CREATED_BY,
2026: hz_utility_pub.CREATION_DATE,
2027: hz_utility_pub.LAST_UPDATE_LOGIN,
2028: hz_utility_pub.LAST_UPDATE_DATE,
2029: hz_utility_pub.LAST_UPDATED_BY
2030: from oe_header_acks h,

Line 2027: hz_utility_pub.LAST_UPDATE_LOGIN,

2023: 'U',
2024: req_id,
2025: hz_utility_pub.CREATED_BY,
2026: hz_utility_pub.CREATION_DATE,
2027: hz_utility_pub.LAST_UPDATE_LOGIN,
2028: hz_utility_pub.LAST_UPDATE_DATE,
2029: hz_utility_pub.LAST_UPDATED_BY
2030: from oe_header_acks h,
2031: ra_customer_merges m

Line 2028: hz_utility_pub.LAST_UPDATE_DATE,

2024: req_id,
2025: hz_utility_pub.CREATED_BY,
2026: hz_utility_pub.CREATION_DATE,
2027: hz_utility_pub.LAST_UPDATE_LOGIN,
2028: hz_utility_pub.LAST_UPDATE_DATE,
2029: hz_utility_pub.LAST_UPDATED_BY
2030: from oe_header_acks h,
2031: ra_customer_merges m
2032: where

Line 2029: hz_utility_pub.LAST_UPDATED_BY

2025: hz_utility_pub.CREATED_BY,
2026: hz_utility_pub.CREATION_DATE,
2027: hz_utility_pub.LAST_UPDATE_LOGIN,
2028: hz_utility_pub.LAST_UPDATE_DATE,
2029: hz_utility_pub.LAST_UPDATED_BY
2030: from oe_header_acks h,
2031: ra_customer_merges m
2032: where
2033: h.sold_to_site_use_id=m.duplicate_site_id

Line 2098: hz_utility_pub.CREATED_BY,

2094: h.end_customer_site_use_id,
2095: m.customer_site_id,
2096: 'U',
2097: req_id,
2098: hz_utility_pub.CREATED_BY,
2099: hz_utility_pub.CREATION_DATE,
2100: hz_utility_pub.LAST_UPDATE_LOGIN,
2101: hz_utility_pub.LAST_UPDATE_DATE,
2102: hz_utility_pub.LAST_UPDATED_BY

Line 2099: hz_utility_pub.CREATION_DATE,

2095: m.customer_site_id,
2096: 'U',
2097: req_id,
2098: hz_utility_pub.CREATED_BY,
2099: hz_utility_pub.CREATION_DATE,
2100: hz_utility_pub.LAST_UPDATE_LOGIN,
2101: hz_utility_pub.LAST_UPDATE_DATE,
2102: hz_utility_pub.LAST_UPDATED_BY
2103: from oe_header_acks h,

Line 2100: hz_utility_pub.LAST_UPDATE_LOGIN,

2096: 'U',
2097: req_id,
2098: hz_utility_pub.CREATED_BY,
2099: hz_utility_pub.CREATION_DATE,
2100: hz_utility_pub.LAST_UPDATE_LOGIN,
2101: hz_utility_pub.LAST_UPDATE_DATE,
2102: hz_utility_pub.LAST_UPDATED_BY
2103: from oe_header_acks h,
2104: ra_customer_merges m

Line 2101: hz_utility_pub.LAST_UPDATE_DATE,

2097: req_id,
2098: hz_utility_pub.CREATED_BY,
2099: hz_utility_pub.CREATION_DATE,
2100: hz_utility_pub.LAST_UPDATE_LOGIN,
2101: hz_utility_pub.LAST_UPDATE_DATE,
2102: hz_utility_pub.LAST_UPDATED_BY
2103: from oe_header_acks h,
2104: ra_customer_merges m
2105: where

Line 2102: hz_utility_pub.LAST_UPDATED_BY

2098: hz_utility_pub.CREATED_BY,
2099: hz_utility_pub.CREATION_DATE,
2100: hz_utility_pub.LAST_UPDATE_LOGIN,
2101: hz_utility_pub.LAST_UPDATE_DATE,
2102: hz_utility_pub.LAST_UPDATED_BY
2103: from oe_header_acks h,
2104: ra_customer_merges m
2105: where
2106: h.end_customer_site_use_id=m.duplicate_site_id

Line 2171: hz_utility_pub.CREATED_BY,

2167: h.end_customer_id,
2168: m.customer_site_id,
2169: 'U',
2170: req_id,
2171: hz_utility_pub.CREATED_BY,
2172: hz_utility_pub.CREATION_DATE,
2173: hz_utility_pub.LAST_UPDATE_LOGIN,
2174: hz_utility_pub.LAST_UPDATE_DATE,
2175: hz_utility_pub.LAST_UPDATED_BY

Line 2172: hz_utility_pub.CREATION_DATE,

2168: m.customer_site_id,
2169: 'U',
2170: req_id,
2171: hz_utility_pub.CREATED_BY,
2172: hz_utility_pub.CREATION_DATE,
2173: hz_utility_pub.LAST_UPDATE_LOGIN,
2174: hz_utility_pub.LAST_UPDATE_DATE,
2175: hz_utility_pub.LAST_UPDATED_BY
2176: from oe_header_acks h,

Line 2173: hz_utility_pub.LAST_UPDATE_LOGIN,

2169: 'U',
2170: req_id,
2171: hz_utility_pub.CREATED_BY,
2172: hz_utility_pub.CREATION_DATE,
2173: hz_utility_pub.LAST_UPDATE_LOGIN,
2174: hz_utility_pub.LAST_UPDATE_DATE,
2175: hz_utility_pub.LAST_UPDATED_BY
2176: from oe_header_acks h,
2177: ra_customer_merges m

Line 2174: hz_utility_pub.LAST_UPDATE_DATE,

2170: req_id,
2171: hz_utility_pub.CREATED_BY,
2172: hz_utility_pub.CREATION_DATE,
2173: hz_utility_pub.LAST_UPDATE_LOGIN,
2174: hz_utility_pub.LAST_UPDATE_DATE,
2175: hz_utility_pub.LAST_UPDATED_BY
2176: from oe_header_acks h,
2177: ra_customer_merges m
2178: where

Line 2175: hz_utility_pub.LAST_UPDATED_BY

2171: hz_utility_pub.CREATED_BY,
2172: hz_utility_pub.CREATION_DATE,
2173: hz_utility_pub.LAST_UPDATE_LOGIN,
2174: hz_utility_pub.LAST_UPDATE_DATE,
2175: hz_utility_pub.LAST_UPDATED_BY
2176: from oe_header_acks h,
2177: ra_customer_merges m
2178: where
2179: -----bug 13058345 h.end_customer_id=m.duplicate_site_id

Line 2742: hz_utility_pub.CREATED_BY,

2738: line_end_cust_id_tab(I),
2739: decode(line_end_cust_id_tab(I),NULL,old_line_end_cust_id_tab(I),line_end_cust_id_tab(i)),
2740: 'U',
2741: req_id,
2742: hz_utility_pub.CREATED_BY,
2743: hz_utility_pub.CREATION_DATE,
2744: hz_utility_pub.LAST_UPDATE_LOGIN,
2745: hz_utility_pub.LAST_UPDATE_DATE,
2746: hz_utility_pub.LAST_UPDATED_BY

Line 2743: hz_utility_pub.CREATION_DATE,

2739: decode(line_end_cust_id_tab(I),NULL,old_line_end_cust_id_tab(I),line_end_cust_id_tab(i)),
2740: 'U',
2741: req_id,
2742: hz_utility_pub.CREATED_BY,
2743: hz_utility_pub.CREATION_DATE,
2744: hz_utility_pub.LAST_UPDATE_LOGIN,
2745: hz_utility_pub.LAST_UPDATE_DATE,
2746: hz_utility_pub.LAST_UPDATED_BY
2747: );

Line 2744: hz_utility_pub.LAST_UPDATE_LOGIN,

2740: 'U',
2741: req_id,
2742: hz_utility_pub.CREATED_BY,
2743: hz_utility_pub.CREATION_DATE,
2744: hz_utility_pub.LAST_UPDATE_LOGIN,
2745: hz_utility_pub.LAST_UPDATE_DATE,
2746: hz_utility_pub.LAST_UPDATED_BY
2747: );
2748:

Line 2745: hz_utility_pub.LAST_UPDATE_DATE,

2741: req_id,
2742: hz_utility_pub.CREATED_BY,
2743: hz_utility_pub.CREATION_DATE,
2744: hz_utility_pub.LAST_UPDATE_LOGIN,
2745: hz_utility_pub.LAST_UPDATE_DATE,
2746: hz_utility_pub.LAST_UPDATED_BY
2747: );
2748:
2749: end if;

Line 2746: hz_utility_pub.LAST_UPDATED_BY

2742: hz_utility_pub.CREATED_BY,
2743: hz_utility_pub.CREATION_DATE,
2744: hz_utility_pub.LAST_UPDATE_LOGIN,
2745: hz_utility_pub.LAST_UPDATE_DATE,
2746: hz_utility_pub.LAST_UPDATED_BY
2747: );
2748:
2749: end if;
2750: end if;

Line 3617: hz_utility_pub.CREATED_BY,

3613: a.ship_to_org_id,
3614: m.customer_site_id,
3615: 'U',
3616: req_id,
3617: hz_utility_pub.CREATED_BY,
3618: hz_utility_pub.CREATION_DATE,
3619: hz_utility_pub.LAST_UPDATE_LOGIN,
3620: hz_utility_pub.LAST_UPDATE_DATE,
3621: hz_utility_pub.LAST_UPDATED_BY

Line 3618: hz_utility_pub.CREATION_DATE,

3614: m.customer_site_id,
3615: 'U',
3616: req_id,
3617: hz_utility_pub.CREATED_BY,
3618: hz_utility_pub.CREATION_DATE,
3619: hz_utility_pub.LAST_UPDATE_LOGIN,
3620: hz_utility_pub.LAST_UPDATE_DATE,
3621: hz_utility_pub.LAST_UPDATED_BY
3622: from oe_line_acks a,

Line 3619: hz_utility_pub.LAST_UPDATE_LOGIN,

3615: 'U',
3616: req_id,
3617: hz_utility_pub.CREATED_BY,
3618: hz_utility_pub.CREATION_DATE,
3619: hz_utility_pub.LAST_UPDATE_LOGIN,
3620: hz_utility_pub.LAST_UPDATE_DATE,
3621: hz_utility_pub.LAST_UPDATED_BY
3622: from oe_line_acks a,
3623: ra_customer_merges m

Line 3620: hz_utility_pub.LAST_UPDATE_DATE,

3616: req_id,
3617: hz_utility_pub.CREATED_BY,
3618: hz_utility_pub.CREATION_DATE,
3619: hz_utility_pub.LAST_UPDATE_LOGIN,
3620: hz_utility_pub.LAST_UPDATE_DATE,
3621: hz_utility_pub.LAST_UPDATED_BY
3622: from oe_line_acks a,
3623: ra_customer_merges m
3624: where m.process_flag = 'N'

Line 3621: hz_utility_pub.LAST_UPDATED_BY

3617: hz_utility_pub.CREATED_BY,
3618: hz_utility_pub.CREATION_DATE,
3619: hz_utility_pub.LAST_UPDATE_LOGIN,
3620: hz_utility_pub.LAST_UPDATE_DATE,
3621: hz_utility_pub.LAST_UPDATED_BY
3622: from oe_line_acks a,
3623: ra_customer_merges m
3624: where m.process_flag = 'N'
3625: and a.ship_to_org_id = m.duplicate_site_id

Line 3686: hz_utility_pub.CREATED_BY,

3682: a.invoice_to_org_id,
3683: m.customer_site_id,
3684: 'U',
3685: req_id,
3686: hz_utility_pub.CREATED_BY,
3687: hz_utility_pub.CREATION_DATE,
3688: hz_utility_pub.LAST_UPDATE_LOGIN,
3689: hz_utility_pub.LAST_UPDATE_DATE,
3690: hz_utility_pub.LAST_UPDATED_BY

Line 3687: hz_utility_pub.CREATION_DATE,

3683: m.customer_site_id,
3684: 'U',
3685: req_id,
3686: hz_utility_pub.CREATED_BY,
3687: hz_utility_pub.CREATION_DATE,
3688: hz_utility_pub.LAST_UPDATE_LOGIN,
3689: hz_utility_pub.LAST_UPDATE_DATE,
3690: hz_utility_pub.LAST_UPDATED_BY
3691: from oe_line_acks a,

Line 3688: hz_utility_pub.LAST_UPDATE_LOGIN,

3684: 'U',
3685: req_id,
3686: hz_utility_pub.CREATED_BY,
3687: hz_utility_pub.CREATION_DATE,
3688: hz_utility_pub.LAST_UPDATE_LOGIN,
3689: hz_utility_pub.LAST_UPDATE_DATE,
3690: hz_utility_pub.LAST_UPDATED_BY
3691: from oe_line_acks a,
3692: ra_customer_merges m

Line 3689: hz_utility_pub.LAST_UPDATE_DATE,

3685: req_id,
3686: hz_utility_pub.CREATED_BY,
3687: hz_utility_pub.CREATION_DATE,
3688: hz_utility_pub.LAST_UPDATE_LOGIN,
3689: hz_utility_pub.LAST_UPDATE_DATE,
3690: hz_utility_pub.LAST_UPDATED_BY
3691: from oe_line_acks a,
3692: ra_customer_merges m
3693: where m.process_flag = 'N'

Line 3690: hz_utility_pub.LAST_UPDATED_BY

3686: hz_utility_pub.CREATED_BY,
3687: hz_utility_pub.CREATION_DATE,
3688: hz_utility_pub.LAST_UPDATE_LOGIN,
3689: hz_utility_pub.LAST_UPDATE_DATE,
3690: hz_utility_pub.LAST_UPDATED_BY
3691: from oe_line_acks a,
3692: ra_customer_merges m
3693: where m.process_flag = 'N'
3694: and a.invoice_to_org_id = m.duplicate_site_id

Line 3754: hz_utility_pub.CREATED_BY,

3750: a.deliver_to_org_id,
3751: m.customer_site_id,
3752: 'U',
3753: req_id,
3754: hz_utility_pub.CREATED_BY,
3755: hz_utility_pub.CREATION_DATE,
3756: hz_utility_pub.LAST_UPDATE_LOGIN,
3757: hz_utility_pub.LAST_UPDATE_DATE,
3758: hz_utility_pub.LAST_UPDATED_BY

Line 3755: hz_utility_pub.CREATION_DATE,

3751: m.customer_site_id,
3752: 'U',
3753: req_id,
3754: hz_utility_pub.CREATED_BY,
3755: hz_utility_pub.CREATION_DATE,
3756: hz_utility_pub.LAST_UPDATE_LOGIN,
3757: hz_utility_pub.LAST_UPDATE_DATE,
3758: hz_utility_pub.LAST_UPDATED_BY
3759: from oe_line_acks a,

Line 3756: hz_utility_pub.LAST_UPDATE_LOGIN,

3752: 'U',
3753: req_id,
3754: hz_utility_pub.CREATED_BY,
3755: hz_utility_pub.CREATION_DATE,
3756: hz_utility_pub.LAST_UPDATE_LOGIN,
3757: hz_utility_pub.LAST_UPDATE_DATE,
3758: hz_utility_pub.LAST_UPDATED_BY
3759: from oe_line_acks a,
3760: ra_customer_merges m

Line 3757: hz_utility_pub.LAST_UPDATE_DATE,

3753: req_id,
3754: hz_utility_pub.CREATED_BY,
3755: hz_utility_pub.CREATION_DATE,
3756: hz_utility_pub.LAST_UPDATE_LOGIN,
3757: hz_utility_pub.LAST_UPDATE_DATE,
3758: hz_utility_pub.LAST_UPDATED_BY
3759: from oe_line_acks a,
3760: ra_customer_merges m
3761: where m.process_flag = 'N'

Line 3758: hz_utility_pub.LAST_UPDATED_BY

3754: hz_utility_pub.CREATED_BY,
3755: hz_utility_pub.CREATION_DATE,
3756: hz_utility_pub.LAST_UPDATE_LOGIN,
3757: hz_utility_pub.LAST_UPDATE_DATE,
3758: hz_utility_pub.LAST_UPDATED_BY
3759: from oe_line_acks a,
3760: ra_customer_merges m
3761: where m.process_flag = 'N'
3762: and a.deliver_to_org_id = m.duplicate_site_id

Line 3822: hz_utility_pub.CREATED_BY,

3818: a.intmed_ship_to_org_id,
3819: m.customer_site_id,
3820: 'U',
3821: req_id,
3822: hz_utility_pub.CREATED_BY,
3823: hz_utility_pub.CREATION_DATE,
3824: hz_utility_pub.LAST_UPDATE_LOGIN,
3825: hz_utility_pub.LAST_UPDATE_DATE,
3826: hz_utility_pub.LAST_UPDATED_BY

Line 3823: hz_utility_pub.CREATION_DATE,

3819: m.customer_site_id,
3820: 'U',
3821: req_id,
3822: hz_utility_pub.CREATED_BY,
3823: hz_utility_pub.CREATION_DATE,
3824: hz_utility_pub.LAST_UPDATE_LOGIN,
3825: hz_utility_pub.LAST_UPDATE_DATE,
3826: hz_utility_pub.LAST_UPDATED_BY
3827: from oe_line_acks a,

Line 3824: hz_utility_pub.LAST_UPDATE_LOGIN,

3820: 'U',
3821: req_id,
3822: hz_utility_pub.CREATED_BY,
3823: hz_utility_pub.CREATION_DATE,
3824: hz_utility_pub.LAST_UPDATE_LOGIN,
3825: hz_utility_pub.LAST_UPDATE_DATE,
3826: hz_utility_pub.LAST_UPDATED_BY
3827: from oe_line_acks a,
3828: ra_customer_merges m

Line 3825: hz_utility_pub.LAST_UPDATE_DATE,

3821: req_id,
3822: hz_utility_pub.CREATED_BY,
3823: hz_utility_pub.CREATION_DATE,
3824: hz_utility_pub.LAST_UPDATE_LOGIN,
3825: hz_utility_pub.LAST_UPDATE_DATE,
3826: hz_utility_pub.LAST_UPDATED_BY
3827: from oe_line_acks a,
3828: ra_customer_merges m
3829: where m.process_flag = 'N'

Line 3826: hz_utility_pub.LAST_UPDATED_BY

3822: hz_utility_pub.CREATED_BY,
3823: hz_utility_pub.CREATION_DATE,
3824: hz_utility_pub.LAST_UPDATE_LOGIN,
3825: hz_utility_pub.LAST_UPDATE_DATE,
3826: hz_utility_pub.LAST_UPDATED_BY
3827: from oe_line_acks a,
3828: ra_customer_merges m
3829: where m.process_flag = 'N'
3830: and a.intmed_ship_to_org_id = m.duplicate_site_id

Line 3896: hz_utility_pub.CREATED_BY,

3892: a.sold_to_org_id,
3893: m.customer_site_id,
3894: 'U',
3895: req_id,
3896: hz_utility_pub.CREATED_BY,
3897: hz_utility_pub.CREATION_DATE,
3898: hz_utility_pub.LAST_UPDATE_LOGIN,
3899: hz_utility_pub.LAST_UPDATE_DATE,
3900: hz_utility_pub.LAST_UPDATED_BY

Line 3897: hz_utility_pub.CREATION_DATE,

3893: m.customer_site_id,
3894: 'U',
3895: req_id,
3896: hz_utility_pub.CREATED_BY,
3897: hz_utility_pub.CREATION_DATE,
3898: hz_utility_pub.LAST_UPDATE_LOGIN,
3899: hz_utility_pub.LAST_UPDATE_DATE,
3900: hz_utility_pub.LAST_UPDATED_BY
3901: from oe_line_acks a,

Line 3898: hz_utility_pub.LAST_UPDATE_LOGIN,

3894: 'U',
3895: req_id,
3896: hz_utility_pub.CREATED_BY,
3897: hz_utility_pub.CREATION_DATE,
3898: hz_utility_pub.LAST_UPDATE_LOGIN,
3899: hz_utility_pub.LAST_UPDATE_DATE,
3900: hz_utility_pub.LAST_UPDATED_BY
3901: from oe_line_acks a,
3902: ra_customer_merges m

Line 3899: hz_utility_pub.LAST_UPDATE_DATE,

3895: req_id,
3896: hz_utility_pub.CREATED_BY,
3897: hz_utility_pub.CREATION_DATE,
3898: hz_utility_pub.LAST_UPDATE_LOGIN,
3899: hz_utility_pub.LAST_UPDATE_DATE,
3900: hz_utility_pub.LAST_UPDATED_BY
3901: from oe_line_acks a,
3902: ra_customer_merges m
3903: where m.process_flag = 'N'

Line 3900: hz_utility_pub.LAST_UPDATED_BY

3896: hz_utility_pub.CREATED_BY,
3897: hz_utility_pub.CREATION_DATE,
3898: hz_utility_pub.LAST_UPDATE_LOGIN,
3899: hz_utility_pub.LAST_UPDATE_DATE,
3900: hz_utility_pub.LAST_UPDATED_BY
3901: from oe_line_acks a,
3902: ra_customer_merges m
3903: where m.process_flag = 'N'
3904: and a.sold_to_org_id = m.duplicate_site_id

Line 3973: hz_utility_pub.CREATED_BY,

3969: a.end_customer_site_use_id,
3970: m.customer_site_id,
3971: 'U',
3972: req_id,
3973: hz_utility_pub.CREATED_BY,
3974: hz_utility_pub.CREATION_DATE,
3975: hz_utility_pub.LAST_UPDATE_LOGIN,
3976: hz_utility_pub.LAST_UPDATE_DATE,
3977: hz_utility_pub.LAST_UPDATED_BY

Line 3974: hz_utility_pub.CREATION_DATE,

3970: m.customer_site_id,
3971: 'U',
3972: req_id,
3973: hz_utility_pub.CREATED_BY,
3974: hz_utility_pub.CREATION_DATE,
3975: hz_utility_pub.LAST_UPDATE_LOGIN,
3976: hz_utility_pub.LAST_UPDATE_DATE,
3977: hz_utility_pub.LAST_UPDATED_BY
3978: from oe_line_acks a,

Line 3975: hz_utility_pub.LAST_UPDATE_LOGIN,

3971: 'U',
3972: req_id,
3973: hz_utility_pub.CREATED_BY,
3974: hz_utility_pub.CREATION_DATE,
3975: hz_utility_pub.LAST_UPDATE_LOGIN,
3976: hz_utility_pub.LAST_UPDATE_DATE,
3977: hz_utility_pub.LAST_UPDATED_BY
3978: from oe_line_acks a,
3979: ra_customer_merges m

Line 3976: hz_utility_pub.LAST_UPDATE_DATE,

3972: req_id,
3973: hz_utility_pub.CREATED_BY,
3974: hz_utility_pub.CREATION_DATE,
3975: hz_utility_pub.LAST_UPDATE_LOGIN,
3976: hz_utility_pub.LAST_UPDATE_DATE,
3977: hz_utility_pub.LAST_UPDATED_BY
3978: from oe_line_acks a,
3979: ra_customer_merges m
3980: where m.process_flag = 'N'

Line 3977: hz_utility_pub.LAST_UPDATED_BY

3973: hz_utility_pub.CREATED_BY,
3974: hz_utility_pub.CREATION_DATE,
3975: hz_utility_pub.LAST_UPDATE_LOGIN,
3976: hz_utility_pub.LAST_UPDATE_DATE,
3977: hz_utility_pub.LAST_UPDATED_BY
3978: from oe_line_acks a,
3979: ra_customer_merges m
3980: where m.process_flag = 'N'
3981: and a.sold_to_org_id = m.duplicate_site_id

Line 4048: hz_utility_pub.CREATED_BY,

4044: a.end_customer_id,
4045: m.customer_site_id,
4046: 'U',
4047: req_id,
4048: hz_utility_pub.CREATED_BY,
4049: hz_utility_pub.CREATION_DATE,
4050: hz_utility_pub.LAST_UPDATE_LOGIN,
4051: hz_utility_pub.LAST_UPDATE_DATE,
4052: hz_utility_pub.LAST_UPDATED_BY

Line 4049: hz_utility_pub.CREATION_DATE,

4045: m.customer_site_id,
4046: 'U',
4047: req_id,
4048: hz_utility_pub.CREATED_BY,
4049: hz_utility_pub.CREATION_DATE,
4050: hz_utility_pub.LAST_UPDATE_LOGIN,
4051: hz_utility_pub.LAST_UPDATE_DATE,
4052: hz_utility_pub.LAST_UPDATED_BY
4053: from oe_line_acks a,

Line 4050: hz_utility_pub.LAST_UPDATE_LOGIN,

4046: 'U',
4047: req_id,
4048: hz_utility_pub.CREATED_BY,
4049: hz_utility_pub.CREATION_DATE,
4050: hz_utility_pub.LAST_UPDATE_LOGIN,
4051: hz_utility_pub.LAST_UPDATE_DATE,
4052: hz_utility_pub.LAST_UPDATED_BY
4053: from oe_line_acks a,
4054: ra_customer_merges m

Line 4051: hz_utility_pub.LAST_UPDATE_DATE,

4047: req_id,
4048: hz_utility_pub.CREATED_BY,
4049: hz_utility_pub.CREATION_DATE,
4050: hz_utility_pub.LAST_UPDATE_LOGIN,
4051: hz_utility_pub.LAST_UPDATE_DATE,
4052: hz_utility_pub.LAST_UPDATED_BY
4053: from oe_line_acks a,
4054: ra_customer_merges m
4055: where m.process_flag = 'N'

Line 4052: hz_utility_pub.LAST_UPDATED_BY

4048: hz_utility_pub.CREATED_BY,
4049: hz_utility_pub.CREATION_DATE,
4050: hz_utility_pub.LAST_UPDATE_LOGIN,
4051: hz_utility_pub.LAST_UPDATE_DATE,
4052: hz_utility_pub.LAST_UPDATED_BY
4053: from oe_line_acks a,
4054: ra_customer_merges m
4055: where m.process_flag = 'N'
4056: and a.end_customer_id = m.duplicate_id ---replaced duplicate_site_id by duplicate_id bug 13058344

Line 4250: hz_utility_pub.CREATED_BY,

4246: a.attribute_value,
4247: to_char(m.customer_site_id),
4248: 'U',
4249: req_id,
4250: hz_utility_pub.CREATED_BY,
4251: hz_utility_pub.CREATION_DATE,
4252: hz_utility_pub.LAST_UPDATE_LOGIN,
4253: hz_utility_pub.LAST_UPDATE_DATE,
4254: hz_utility_pub.LAST_UPDATED_BY

Line 4251: hz_utility_pub.CREATION_DATE,

4247: to_char(m.customer_site_id),
4248: 'U',
4249: req_id,
4250: hz_utility_pub.CREATED_BY,
4251: hz_utility_pub.CREATION_DATE,
4252: hz_utility_pub.LAST_UPDATE_LOGIN,
4253: hz_utility_pub.LAST_UPDATE_DATE,
4254: hz_utility_pub.LAST_UPDATED_BY
4255: from OE_ATTACHMENT_RULE_ELEMENTS a,

Line 4252: hz_utility_pub.LAST_UPDATE_LOGIN,

4248: 'U',
4249: req_id,
4250: hz_utility_pub.CREATED_BY,
4251: hz_utility_pub.CREATION_DATE,
4252: hz_utility_pub.LAST_UPDATE_LOGIN,
4253: hz_utility_pub.LAST_UPDATE_DATE,
4254: hz_utility_pub.LAST_UPDATED_BY
4255: from OE_ATTACHMENT_RULE_ELEMENTS a,
4256: ra_customer_merges m

Line 4253: hz_utility_pub.LAST_UPDATE_DATE,

4249: req_id,
4250: hz_utility_pub.CREATED_BY,
4251: hz_utility_pub.CREATION_DATE,
4252: hz_utility_pub.LAST_UPDATE_LOGIN,
4253: hz_utility_pub.LAST_UPDATE_DATE,
4254: hz_utility_pub.LAST_UPDATED_BY
4255: from OE_ATTACHMENT_RULE_ELEMENTS a,
4256: ra_customer_merges m
4257: where a.attribute_value = to_char(m.duplicate_site_id)

Line 4254: hz_utility_pub.LAST_UPDATED_BY

4250: hz_utility_pub.CREATED_BY,
4251: hz_utility_pub.CREATION_DATE,
4252: hz_utility_pub.LAST_UPDATE_LOGIN,
4253: hz_utility_pub.LAST_UPDATE_DATE,
4254: hz_utility_pub.LAST_UPDATED_BY
4255: from OE_ATTACHMENT_RULE_ELEMENTS a,
4256: ra_customer_merges m
4257: where a.attribute_value = to_char(m.duplicate_site_id)
4258: and m.process_flag = 'N'

Line 4318: hz_utility_pub.CREATED_BY,

4314: a.attribute_value,
4315: to_char(m.customer_site_id),
4316: 'U',
4317: req_id,
4318: hz_utility_pub.CREATED_BY,
4319: hz_utility_pub.CREATION_DATE,
4320: hz_utility_pub.LAST_UPDATE_LOGIN,
4321: hz_utility_pub.LAST_UPDATE_DATE,
4322: hz_utility_pub.LAST_UPDATED_BY

Line 4319: hz_utility_pub.CREATION_DATE,

4315: to_char(m.customer_site_id),
4316: 'U',
4317: req_id,
4318: hz_utility_pub.CREATED_BY,
4319: hz_utility_pub.CREATION_DATE,
4320: hz_utility_pub.LAST_UPDATE_LOGIN,
4321: hz_utility_pub.LAST_UPDATE_DATE,
4322: hz_utility_pub.LAST_UPDATED_BY
4323: from OE_ATTACHMENT_RULE_ELEMENTS a,

Line 4320: hz_utility_pub.LAST_UPDATE_LOGIN,

4316: 'U',
4317: req_id,
4318: hz_utility_pub.CREATED_BY,
4319: hz_utility_pub.CREATION_DATE,
4320: hz_utility_pub.LAST_UPDATE_LOGIN,
4321: hz_utility_pub.LAST_UPDATE_DATE,
4322: hz_utility_pub.LAST_UPDATED_BY
4323: from OE_ATTACHMENT_RULE_ELEMENTS a,
4324: ra_customer_merges m

Line 4321: hz_utility_pub.LAST_UPDATE_DATE,

4317: req_id,
4318: hz_utility_pub.CREATED_BY,
4319: hz_utility_pub.CREATION_DATE,
4320: hz_utility_pub.LAST_UPDATE_LOGIN,
4321: hz_utility_pub.LAST_UPDATE_DATE,
4322: hz_utility_pub.LAST_UPDATED_BY
4323: from OE_ATTACHMENT_RULE_ELEMENTS a,
4324: ra_customer_merges m
4325: where a.attribute_value = to_char(m.duplicate_site_id)

Line 4322: hz_utility_pub.LAST_UPDATED_BY

4318: hz_utility_pub.CREATED_BY,
4319: hz_utility_pub.CREATION_DATE,
4320: hz_utility_pub.LAST_UPDATE_LOGIN,
4321: hz_utility_pub.LAST_UPDATE_DATE,
4322: hz_utility_pub.LAST_UPDATED_BY
4323: from OE_ATTACHMENT_RULE_ELEMENTS a,
4324: ra_customer_merges m
4325: where a.attribute_value = to_char(m.duplicate_site_id)
4326: and m.process_flag = 'N'

Line 4387: hz_utility_pub.CREATED_BY,

4383: a.attribute_value,
4384: to_char(m.customer_site_id),
4385: 'U',
4386: req_id,
4387: hz_utility_pub.CREATED_BY,
4388: hz_utility_pub.CREATION_DATE,
4389: hz_utility_pub.LAST_UPDATE_LOGIN,
4390: hz_utility_pub.LAST_UPDATE_DATE,
4391: hz_utility_pub.LAST_UPDATED_BY

Line 4388: hz_utility_pub.CREATION_DATE,

4384: to_char(m.customer_site_id),
4385: 'U',
4386: req_id,
4387: hz_utility_pub.CREATED_BY,
4388: hz_utility_pub.CREATION_DATE,
4389: hz_utility_pub.LAST_UPDATE_LOGIN,
4390: hz_utility_pub.LAST_UPDATE_DATE,
4391: hz_utility_pub.LAST_UPDATED_BY
4392: from OE_ATTACHMENT_RULE_ELEMENTS a,

Line 4389: hz_utility_pub.LAST_UPDATE_LOGIN,

4385: 'U',
4386: req_id,
4387: hz_utility_pub.CREATED_BY,
4388: hz_utility_pub.CREATION_DATE,
4389: hz_utility_pub.LAST_UPDATE_LOGIN,
4390: hz_utility_pub.LAST_UPDATE_DATE,
4391: hz_utility_pub.LAST_UPDATED_BY
4392: from OE_ATTACHMENT_RULE_ELEMENTS a,
4393: ra_customer_merges m

Line 4390: hz_utility_pub.LAST_UPDATE_DATE,

4386: req_id,
4387: hz_utility_pub.CREATED_BY,
4388: hz_utility_pub.CREATION_DATE,
4389: hz_utility_pub.LAST_UPDATE_LOGIN,
4390: hz_utility_pub.LAST_UPDATE_DATE,
4391: hz_utility_pub.LAST_UPDATED_BY
4392: from OE_ATTACHMENT_RULE_ELEMENTS a,
4393: ra_customer_merges m
4394: where a.attribute_value = to_char(m.duplicate_site_id)

Line 4391: hz_utility_pub.LAST_UPDATED_BY

4387: hz_utility_pub.CREATED_BY,
4388: hz_utility_pub.CREATION_DATE,
4389: hz_utility_pub.LAST_UPDATE_LOGIN,
4390: hz_utility_pub.LAST_UPDATE_DATE,
4391: hz_utility_pub.LAST_UPDATED_BY
4392: from OE_ATTACHMENT_RULE_ELEMENTS a,
4393: ra_customer_merges m
4394: where a.attribute_value = to_char(m.duplicate_site_id)
4395: and m.process_flag = 'N'

Line 4607: hz_utility_pub.CREATED_BY,

4603: a.value_string,
4604: to_char(m.customer_site_id),
4605: 'U',
4606: req_id,
4607: hz_utility_pub.CREATED_BY,
4608: hz_utility_pub.CREATION_DATE,
4609: hz_utility_pub.LAST_UPDATE_LOGIN,
4610: hz_utility_pub.LAST_UPDATE_DATE,
4611: hz_utility_pub.LAST_UPDATED_BY

Line 4608: hz_utility_pub.CREATION_DATE,

4604: to_char(m.customer_site_id),
4605: 'U',
4606: req_id,
4607: hz_utility_pub.CREATED_BY,
4608: hz_utility_pub.CREATION_DATE,
4609: hz_utility_pub.LAST_UPDATE_LOGIN,
4610: hz_utility_pub.LAST_UPDATE_DATE,
4611: hz_utility_pub.LAST_UPDATED_BY
4612: from OE_DEF_CONDN_ELEMS a,

Line 4609: hz_utility_pub.LAST_UPDATE_LOGIN,

4605: 'U',
4606: req_id,
4607: hz_utility_pub.CREATED_BY,
4608: hz_utility_pub.CREATION_DATE,
4609: hz_utility_pub.LAST_UPDATE_LOGIN,
4610: hz_utility_pub.LAST_UPDATE_DATE,
4611: hz_utility_pub.LAST_UPDATED_BY
4612: from OE_DEF_CONDN_ELEMS a,
4613: ra_customer_merges m

Line 4610: hz_utility_pub.LAST_UPDATE_DATE,

4606: req_id,
4607: hz_utility_pub.CREATED_BY,
4608: hz_utility_pub.CREATION_DATE,
4609: hz_utility_pub.LAST_UPDATE_LOGIN,
4610: hz_utility_pub.LAST_UPDATE_DATE,
4611: hz_utility_pub.LAST_UPDATED_BY
4612: from OE_DEF_CONDN_ELEMS a,
4613: ra_customer_merges m
4614: where a.value_string = to_char(m.duplicate_site_id)

Line 4611: hz_utility_pub.LAST_UPDATED_BY

4607: hz_utility_pub.CREATED_BY,
4608: hz_utility_pub.CREATION_DATE,
4609: hz_utility_pub.LAST_UPDATE_LOGIN,
4610: hz_utility_pub.LAST_UPDATE_DATE,
4611: hz_utility_pub.LAST_UPDATED_BY
4612: from OE_DEF_CONDN_ELEMS a,
4613: ra_customer_merges m
4614: where a.value_string = to_char(m.duplicate_site_id)
4615: and m.process_flag = 'N'

Line 4674: hz_utility_pub.CREATED_BY,

4670: a.value_string,
4671: to_char(m.customer_site_id),
4672: 'U',
4673: req_id,
4674: hz_utility_pub.CREATED_BY,
4675: hz_utility_pub.CREATION_DATE,
4676: hz_utility_pub.LAST_UPDATE_LOGIN,
4677: hz_utility_pub.LAST_UPDATE_DATE,
4678: hz_utility_pub.LAST_UPDATED_BY

Line 4675: hz_utility_pub.CREATION_DATE,

4671: to_char(m.customer_site_id),
4672: 'U',
4673: req_id,
4674: hz_utility_pub.CREATED_BY,
4675: hz_utility_pub.CREATION_DATE,
4676: hz_utility_pub.LAST_UPDATE_LOGIN,
4677: hz_utility_pub.LAST_UPDATE_DATE,
4678: hz_utility_pub.LAST_UPDATED_BY
4679: from OE_DEF_CONDN_ELEMS a,

Line 4676: hz_utility_pub.LAST_UPDATE_LOGIN,

4672: 'U',
4673: req_id,
4674: hz_utility_pub.CREATED_BY,
4675: hz_utility_pub.CREATION_DATE,
4676: hz_utility_pub.LAST_UPDATE_LOGIN,
4677: hz_utility_pub.LAST_UPDATE_DATE,
4678: hz_utility_pub.LAST_UPDATED_BY
4679: from OE_DEF_CONDN_ELEMS a,
4680: ra_customer_merges m

Line 4677: hz_utility_pub.LAST_UPDATE_DATE,

4673: req_id,
4674: hz_utility_pub.CREATED_BY,
4675: hz_utility_pub.CREATION_DATE,
4676: hz_utility_pub.LAST_UPDATE_LOGIN,
4677: hz_utility_pub.LAST_UPDATE_DATE,
4678: hz_utility_pub.LAST_UPDATED_BY
4679: from OE_DEF_CONDN_ELEMS a,
4680: ra_customer_merges m
4681: where a.value_string = to_char(m.duplicate_site_id)

Line 4678: hz_utility_pub.LAST_UPDATED_BY

4674: hz_utility_pub.CREATED_BY,
4675: hz_utility_pub.CREATION_DATE,
4676: hz_utility_pub.LAST_UPDATE_LOGIN,
4677: hz_utility_pub.LAST_UPDATE_DATE,
4678: hz_utility_pub.LAST_UPDATED_BY
4679: from OE_DEF_CONDN_ELEMS a,
4680: ra_customer_merges m
4681: where a.value_string = to_char(m.duplicate_site_id)
4682: and m.process_flag = 'N'

Line 4743: hz_utility_pub.CREATED_BY,

4739: a.value_string,
4740: to_char(m.customer_site_id),
4741: 'U',
4742: req_id,
4743: hz_utility_pub.CREATED_BY,
4744: hz_utility_pub.CREATION_DATE,
4745: hz_utility_pub.LAST_UPDATE_LOGIN,
4746: hz_utility_pub.LAST_UPDATE_DATE,
4747: hz_utility_pub.LAST_UPDATED_BY

Line 4744: hz_utility_pub.CREATION_DATE,

4740: to_char(m.customer_site_id),
4741: 'U',
4742: req_id,
4743: hz_utility_pub.CREATED_BY,
4744: hz_utility_pub.CREATION_DATE,
4745: hz_utility_pub.LAST_UPDATE_LOGIN,
4746: hz_utility_pub.LAST_UPDATE_DATE,
4747: hz_utility_pub.LAST_UPDATED_BY
4748: from OE_DEF_CONDN_ELEMS a,

Line 4745: hz_utility_pub.LAST_UPDATE_LOGIN,

4741: 'U',
4742: req_id,
4743: hz_utility_pub.CREATED_BY,
4744: hz_utility_pub.CREATION_DATE,
4745: hz_utility_pub.LAST_UPDATE_LOGIN,
4746: hz_utility_pub.LAST_UPDATE_DATE,
4747: hz_utility_pub.LAST_UPDATED_BY
4748: from OE_DEF_CONDN_ELEMS a,
4749: ra_customer_merges m

Line 4746: hz_utility_pub.LAST_UPDATE_DATE,

4742: req_id,
4743: hz_utility_pub.CREATED_BY,
4744: hz_utility_pub.CREATION_DATE,
4745: hz_utility_pub.LAST_UPDATE_LOGIN,
4746: hz_utility_pub.LAST_UPDATE_DATE,
4747: hz_utility_pub.LAST_UPDATED_BY
4748: from OE_DEF_CONDN_ELEMS a,
4749: ra_customer_merges m
4750: where a.value_string = to_char(m.duplicate_site_id)

Line 4747: hz_utility_pub.LAST_UPDATED_BY

4743: hz_utility_pub.CREATED_BY,
4744: hz_utility_pub.CREATION_DATE,
4745: hz_utility_pub.LAST_UPDATE_LOGIN,
4746: hz_utility_pub.LAST_UPDATE_DATE,
4747: hz_utility_pub.LAST_UPDATED_BY
4748: from OE_DEF_CONDN_ELEMS a,
4749: ra_customer_merges m
4750: where a.value_string = to_char(m.duplicate_site_id)
4751: and m.process_flag = 'N'

Line 4811: hz_utility_pub.CREATED_BY,

4807: a.value_string,
4808: to_char(m.customer_id),
4809: 'U',
4810: req_id,
4811: hz_utility_pub.CREATED_BY,
4812: hz_utility_pub.CREATION_DATE,
4813: hz_utility_pub.LAST_UPDATE_LOGIN,
4814: hz_utility_pub.LAST_UPDATE_DATE,
4815: hz_utility_pub.LAST_UPDATED_BY

Line 4812: hz_utility_pub.CREATION_DATE,

4808: to_char(m.customer_id),
4809: 'U',
4810: req_id,
4811: hz_utility_pub.CREATED_BY,
4812: hz_utility_pub.CREATION_DATE,
4813: hz_utility_pub.LAST_UPDATE_LOGIN,
4814: hz_utility_pub.LAST_UPDATE_DATE,
4815: hz_utility_pub.LAST_UPDATED_BY
4816: from OE_DEF_CONDN_ELEMS a,

Line 4813: hz_utility_pub.LAST_UPDATE_LOGIN,

4809: 'U',
4810: req_id,
4811: hz_utility_pub.CREATED_BY,
4812: hz_utility_pub.CREATION_DATE,
4813: hz_utility_pub.LAST_UPDATE_LOGIN,
4814: hz_utility_pub.LAST_UPDATE_DATE,
4815: hz_utility_pub.LAST_UPDATED_BY
4816: from OE_DEF_CONDN_ELEMS a,
4817: ra_customer_merges m

Line 4814: hz_utility_pub.LAST_UPDATE_DATE,

4810: req_id,
4811: hz_utility_pub.CREATED_BY,
4812: hz_utility_pub.CREATION_DATE,
4813: hz_utility_pub.LAST_UPDATE_LOGIN,
4814: hz_utility_pub.LAST_UPDATE_DATE,
4815: hz_utility_pub.LAST_UPDATED_BY
4816: from OE_DEF_CONDN_ELEMS a,
4817: ra_customer_merges m
4818: where a.value_string = to_char(m.duplicate_id)

Line 4815: hz_utility_pub.LAST_UPDATED_BY

4811: hz_utility_pub.CREATED_BY,
4812: hz_utility_pub.CREATION_DATE,
4813: hz_utility_pub.LAST_UPDATE_LOGIN,
4814: hz_utility_pub.LAST_UPDATE_DATE,
4815: hz_utility_pub.LAST_UPDATED_BY
4816: from OE_DEF_CONDN_ELEMS a,
4817: ra_customer_merges m
4818: where a.value_string = to_char(m.duplicate_id)
4819: and m.process_flag = 'N'

Line 4881: hz_utility_pub.CREATED_BY,

4877: a.src_constant_value,
4878: to_char(m.customer_site_id),
4879: 'U',
4880: req_id,
4881: hz_utility_pub.CREATED_BY,
4882: hz_utility_pub.CREATION_DATE,
4883: hz_utility_pub.LAST_UPDATE_LOGIN,
4884: hz_utility_pub.LAST_UPDATE_DATE,
4885: hz_utility_pub.LAST_UPDATED_BY

Line 4882: hz_utility_pub.CREATION_DATE,

4878: to_char(m.customer_site_id),
4879: 'U',
4880: req_id,
4881: hz_utility_pub.CREATED_BY,
4882: hz_utility_pub.CREATION_DATE,
4883: hz_utility_pub.LAST_UPDATE_LOGIN,
4884: hz_utility_pub.LAST_UPDATE_DATE,
4885: hz_utility_pub.LAST_UPDATED_BY
4886: from OE_DEF_ATTR_DEF_RULES a,

Line 4883: hz_utility_pub.LAST_UPDATE_LOGIN,

4879: 'U',
4880: req_id,
4881: hz_utility_pub.CREATED_BY,
4882: hz_utility_pub.CREATION_DATE,
4883: hz_utility_pub.LAST_UPDATE_LOGIN,
4884: hz_utility_pub.LAST_UPDATE_DATE,
4885: hz_utility_pub.LAST_UPDATED_BY
4886: from OE_DEF_ATTR_DEF_RULES a,
4887: ra_customer_merges m

Line 4884: hz_utility_pub.LAST_UPDATE_DATE,

4880: req_id,
4881: hz_utility_pub.CREATED_BY,
4882: hz_utility_pub.CREATION_DATE,
4883: hz_utility_pub.LAST_UPDATE_LOGIN,
4884: hz_utility_pub.LAST_UPDATE_DATE,
4885: hz_utility_pub.LAST_UPDATED_BY
4886: from OE_DEF_ATTR_DEF_RULES a,
4887: ra_customer_merges m
4888: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 4885: hz_utility_pub.LAST_UPDATED_BY

4881: hz_utility_pub.CREATED_BY,
4882: hz_utility_pub.CREATION_DATE,
4883: hz_utility_pub.LAST_UPDATE_LOGIN,
4884: hz_utility_pub.LAST_UPDATE_DATE,
4885: hz_utility_pub.LAST_UPDATED_BY
4886: from OE_DEF_ATTR_DEF_RULES a,
4887: ra_customer_merges m
4888: where a.src_constant_value = to_char(m.duplicate_site_id)
4889: and m.process_flag = 'N'

Line 4951: hz_utility_pub.CREATED_BY,

4947: a.src_constant_value,
4948: to_char(m.customer_site_id),
4949: 'U',
4950: req_id,
4951: hz_utility_pub.CREATED_BY,
4952: hz_utility_pub.CREATION_DATE,
4953: hz_utility_pub.LAST_UPDATE_LOGIN,
4954: hz_utility_pub.LAST_UPDATE_DATE,
4955: hz_utility_pub.LAST_UPDATED_BY

Line 4952: hz_utility_pub.CREATION_DATE,

4948: to_char(m.customer_site_id),
4949: 'U',
4950: req_id,
4951: hz_utility_pub.CREATED_BY,
4952: hz_utility_pub.CREATION_DATE,
4953: hz_utility_pub.LAST_UPDATE_LOGIN,
4954: hz_utility_pub.LAST_UPDATE_DATE,
4955: hz_utility_pub.LAST_UPDATED_BY
4956: from OE_DEF_ATTR_DEF_RULES a,

Line 4953: hz_utility_pub.LAST_UPDATE_LOGIN,

4949: 'U',
4950: req_id,
4951: hz_utility_pub.CREATED_BY,
4952: hz_utility_pub.CREATION_DATE,
4953: hz_utility_pub.LAST_UPDATE_LOGIN,
4954: hz_utility_pub.LAST_UPDATE_DATE,
4955: hz_utility_pub.LAST_UPDATED_BY
4956: from OE_DEF_ATTR_DEF_RULES a,
4957: ra_customer_merges m

Line 4954: hz_utility_pub.LAST_UPDATE_DATE,

4950: req_id,
4951: hz_utility_pub.CREATED_BY,
4952: hz_utility_pub.CREATION_DATE,
4953: hz_utility_pub.LAST_UPDATE_LOGIN,
4954: hz_utility_pub.LAST_UPDATE_DATE,
4955: hz_utility_pub.LAST_UPDATED_BY
4956: from OE_DEF_ATTR_DEF_RULES a,
4957: ra_customer_merges m
4958: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 4955: hz_utility_pub.LAST_UPDATED_BY

4951: hz_utility_pub.CREATED_BY,
4952: hz_utility_pub.CREATION_DATE,
4953: hz_utility_pub.LAST_UPDATE_LOGIN,
4954: hz_utility_pub.LAST_UPDATE_DATE,
4955: hz_utility_pub.LAST_UPDATED_BY
4956: from OE_DEF_ATTR_DEF_RULES a,
4957: ra_customer_merges m
4958: where a.src_constant_value = to_char(m.duplicate_site_id)
4959: and m.process_flag = 'N'

Line 5019: hz_utility_pub.CREATED_BY,

5015: a.src_constant_value,
5016: to_char(m.customer_site_id),
5017: 'U',
5018: req_id,
5019: hz_utility_pub.CREATED_BY,
5020: hz_utility_pub.CREATION_DATE,
5021: hz_utility_pub.LAST_UPDATE_LOGIN,
5022: hz_utility_pub.LAST_UPDATE_DATE,
5023: hz_utility_pub.LAST_UPDATED_BY

Line 5020: hz_utility_pub.CREATION_DATE,

5016: to_char(m.customer_site_id),
5017: 'U',
5018: req_id,
5019: hz_utility_pub.CREATED_BY,
5020: hz_utility_pub.CREATION_DATE,
5021: hz_utility_pub.LAST_UPDATE_LOGIN,
5022: hz_utility_pub.LAST_UPDATE_DATE,
5023: hz_utility_pub.LAST_UPDATED_BY
5024: from OE_DEF_ATTR_DEF_RULES a,

Line 5021: hz_utility_pub.LAST_UPDATE_LOGIN,

5017: 'U',
5018: req_id,
5019: hz_utility_pub.CREATED_BY,
5020: hz_utility_pub.CREATION_DATE,
5021: hz_utility_pub.LAST_UPDATE_LOGIN,
5022: hz_utility_pub.LAST_UPDATE_DATE,
5023: hz_utility_pub.LAST_UPDATED_BY
5024: from OE_DEF_ATTR_DEF_RULES a,
5025: ra_customer_merges m

Line 5022: hz_utility_pub.LAST_UPDATE_DATE,

5018: req_id,
5019: hz_utility_pub.CREATED_BY,
5020: hz_utility_pub.CREATION_DATE,
5021: hz_utility_pub.LAST_UPDATE_LOGIN,
5022: hz_utility_pub.LAST_UPDATE_DATE,
5023: hz_utility_pub.LAST_UPDATED_BY
5024: from OE_DEF_ATTR_DEF_RULES a,
5025: ra_customer_merges m
5026: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 5023: hz_utility_pub.LAST_UPDATED_BY

5019: hz_utility_pub.CREATED_BY,
5020: hz_utility_pub.CREATION_DATE,
5021: hz_utility_pub.LAST_UPDATE_LOGIN,
5022: hz_utility_pub.LAST_UPDATE_DATE,
5023: hz_utility_pub.LAST_UPDATED_BY
5024: from OE_DEF_ATTR_DEF_RULES a,
5025: ra_customer_merges m
5026: where a.src_constant_value = to_char(m.duplicate_site_id)
5027: and m.process_flag = 'N'

Line 5088: hz_utility_pub.CREATED_BY,

5084: a.src_constant_value,
5085: to_char(m.customer_site_id),
5086: 'U',
5087: req_id,
5088: hz_utility_pub.CREATED_BY,
5089: hz_utility_pub.CREATION_DATE,
5090: hz_utility_pub.LAST_UPDATE_LOGIN,
5091: hz_utility_pub.LAST_UPDATE_DATE,
5092: hz_utility_pub.LAST_UPDATED_BY

Line 5089: hz_utility_pub.CREATION_DATE,

5085: to_char(m.customer_site_id),
5086: 'U',
5087: req_id,
5088: hz_utility_pub.CREATED_BY,
5089: hz_utility_pub.CREATION_DATE,
5090: hz_utility_pub.LAST_UPDATE_LOGIN,
5091: hz_utility_pub.LAST_UPDATE_DATE,
5092: hz_utility_pub.LAST_UPDATED_BY
5093: from OE_DEF_ATTR_DEF_RULES a,

Line 5090: hz_utility_pub.LAST_UPDATE_LOGIN,

5086: 'U',
5087: req_id,
5088: hz_utility_pub.CREATED_BY,
5089: hz_utility_pub.CREATION_DATE,
5090: hz_utility_pub.LAST_UPDATE_LOGIN,
5091: hz_utility_pub.LAST_UPDATE_DATE,
5092: hz_utility_pub.LAST_UPDATED_BY
5093: from OE_DEF_ATTR_DEF_RULES a,
5094: ra_customer_merges m

Line 5091: hz_utility_pub.LAST_UPDATE_DATE,

5087: req_id,
5088: hz_utility_pub.CREATED_BY,
5089: hz_utility_pub.CREATION_DATE,
5090: hz_utility_pub.LAST_UPDATE_LOGIN,
5091: hz_utility_pub.LAST_UPDATE_DATE,
5092: hz_utility_pub.LAST_UPDATED_BY
5093: from OE_DEF_ATTR_DEF_RULES a,
5094: ra_customer_merges m
5095: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 5092: hz_utility_pub.LAST_UPDATED_BY

5088: hz_utility_pub.CREATED_BY,
5089: hz_utility_pub.CREATION_DATE,
5090: hz_utility_pub.LAST_UPDATE_LOGIN,
5091: hz_utility_pub.LAST_UPDATE_DATE,
5092: hz_utility_pub.LAST_UPDATED_BY
5093: from OE_DEF_ATTR_DEF_RULES a,
5094: ra_customer_merges m
5095: where a.src_constant_value = to_char(m.duplicate_site_id)
5096: and m.process_flag = 'N'

Line 5256: hz_utility_pub.CREATED_BY,

5252: a.value_string,
5253: to_char(m.customer_site_id),
5254: 'U',
5255: req_id,
5256: hz_utility_pub.CREATED_BY,
5257: hz_utility_pub.CREATION_DATE,
5258: hz_utility_pub.LAST_UPDATE_LOGIN,
5259: hz_utility_pub.LAST_UPDATE_DATE,
5260: hz_utility_pub.LAST_UPDATED_BY

Line 5257: hz_utility_pub.CREATION_DATE,

5253: to_char(m.customer_site_id),
5254: 'U',
5255: req_id,
5256: hz_utility_pub.CREATED_BY,
5257: hz_utility_pub.CREATION_DATE,
5258: hz_utility_pub.LAST_UPDATE_LOGIN,
5259: hz_utility_pub.LAST_UPDATE_DATE,
5260: hz_utility_pub.LAST_UPDATED_BY
5261: from OE_PC_VTMPLT_COLS a,

Line 5258: hz_utility_pub.LAST_UPDATE_LOGIN,

5254: 'U',
5255: req_id,
5256: hz_utility_pub.CREATED_BY,
5257: hz_utility_pub.CREATION_DATE,
5258: hz_utility_pub.LAST_UPDATE_LOGIN,
5259: hz_utility_pub.LAST_UPDATE_DATE,
5260: hz_utility_pub.LAST_UPDATED_BY
5261: from OE_PC_VTMPLT_COLS a,
5262: ra_customer_merges m

Line 5259: hz_utility_pub.LAST_UPDATE_DATE,

5255: req_id,
5256: hz_utility_pub.CREATED_BY,
5257: hz_utility_pub.CREATION_DATE,
5258: hz_utility_pub.LAST_UPDATE_LOGIN,
5259: hz_utility_pub.LAST_UPDATE_DATE,
5260: hz_utility_pub.LAST_UPDATED_BY
5261: from OE_PC_VTMPLT_COLS a,
5262: ra_customer_merges m
5263: where a.value_string = to_char(m.duplicate_site_id)

Line 5260: hz_utility_pub.LAST_UPDATED_BY

5256: hz_utility_pub.CREATED_BY,
5257: hz_utility_pub.CREATION_DATE,
5258: hz_utility_pub.LAST_UPDATE_LOGIN,
5259: hz_utility_pub.LAST_UPDATE_DATE,
5260: hz_utility_pub.LAST_UPDATED_BY
5261: from OE_PC_VTMPLT_COLS a,
5262: ra_customer_merges m
5263: where a.value_string = to_char(m.duplicate_site_id)
5264: and m.process_flag = 'N'

Line 5324: hz_utility_pub.CREATED_BY,

5320: a.value_string,
5321: to_char(m.customer_site_id),
5322: 'U',
5323: req_id,
5324: hz_utility_pub.CREATED_BY,
5325: hz_utility_pub.CREATION_DATE,
5326: hz_utility_pub.LAST_UPDATE_LOGIN,
5327: hz_utility_pub.LAST_UPDATE_DATE,
5328: hz_utility_pub.LAST_UPDATED_BY

Line 5325: hz_utility_pub.CREATION_DATE,

5321: to_char(m.customer_site_id),
5322: 'U',
5323: req_id,
5324: hz_utility_pub.CREATED_BY,
5325: hz_utility_pub.CREATION_DATE,
5326: hz_utility_pub.LAST_UPDATE_LOGIN,
5327: hz_utility_pub.LAST_UPDATE_DATE,
5328: hz_utility_pub.LAST_UPDATED_BY
5329: from OE_PC_VTMPLT_COLS a,

Line 5326: hz_utility_pub.LAST_UPDATE_LOGIN,

5322: 'U',
5323: req_id,
5324: hz_utility_pub.CREATED_BY,
5325: hz_utility_pub.CREATION_DATE,
5326: hz_utility_pub.LAST_UPDATE_LOGIN,
5327: hz_utility_pub.LAST_UPDATE_DATE,
5328: hz_utility_pub.LAST_UPDATED_BY
5329: from OE_PC_VTMPLT_COLS a,
5330: ra_customer_merges m

Line 5327: hz_utility_pub.LAST_UPDATE_DATE,

5323: req_id,
5324: hz_utility_pub.CREATED_BY,
5325: hz_utility_pub.CREATION_DATE,
5326: hz_utility_pub.LAST_UPDATE_LOGIN,
5327: hz_utility_pub.LAST_UPDATE_DATE,
5328: hz_utility_pub.LAST_UPDATED_BY
5329: from OE_PC_VTMPLT_COLS a,
5330: ra_customer_merges m
5331: where a.value_string = to_char(m.duplicate_site_id)

Line 5328: hz_utility_pub.LAST_UPDATED_BY

5324: hz_utility_pub.CREATED_BY,
5325: hz_utility_pub.CREATION_DATE,
5326: hz_utility_pub.LAST_UPDATE_LOGIN,
5327: hz_utility_pub.LAST_UPDATE_DATE,
5328: hz_utility_pub.LAST_UPDATED_BY
5329: from OE_PC_VTMPLT_COLS a,
5330: ra_customer_merges m
5331: where a.value_string = to_char(m.duplicate_site_id)
5332: and m.process_flag = 'N'

Line 5392: hz_utility_pub.CREATED_BY,

5388: a.value_string,
5389: to_char(m.customer_site_id),
5390: 'U',
5391: req_id,
5392: hz_utility_pub.CREATED_BY,
5393: hz_utility_pub.CREATION_DATE,
5394: hz_utility_pub.LAST_UPDATE_LOGIN,
5395: hz_utility_pub.LAST_UPDATE_DATE,
5396: hz_utility_pub.LAST_UPDATED_BY

Line 5393: hz_utility_pub.CREATION_DATE,

5389: to_char(m.customer_site_id),
5390: 'U',
5391: req_id,
5392: hz_utility_pub.CREATED_BY,
5393: hz_utility_pub.CREATION_DATE,
5394: hz_utility_pub.LAST_UPDATE_LOGIN,
5395: hz_utility_pub.LAST_UPDATE_DATE,
5396: hz_utility_pub.LAST_UPDATED_BY
5397: from OE_PC_VTMPLT_COLS a,

Line 5394: hz_utility_pub.LAST_UPDATE_LOGIN,

5390: 'U',
5391: req_id,
5392: hz_utility_pub.CREATED_BY,
5393: hz_utility_pub.CREATION_DATE,
5394: hz_utility_pub.LAST_UPDATE_LOGIN,
5395: hz_utility_pub.LAST_UPDATE_DATE,
5396: hz_utility_pub.LAST_UPDATED_BY
5397: from OE_PC_VTMPLT_COLS a,
5398: ra_customer_merges m

Line 5395: hz_utility_pub.LAST_UPDATE_DATE,

5391: req_id,
5392: hz_utility_pub.CREATED_BY,
5393: hz_utility_pub.CREATION_DATE,
5394: hz_utility_pub.LAST_UPDATE_LOGIN,
5395: hz_utility_pub.LAST_UPDATE_DATE,
5396: hz_utility_pub.LAST_UPDATED_BY
5397: from OE_PC_VTMPLT_COLS a,
5398: ra_customer_merges m
5399: where a.value_string = to_char(m.duplicate_site_id)

Line 5396: hz_utility_pub.LAST_UPDATED_BY

5392: hz_utility_pub.CREATED_BY,
5393: hz_utility_pub.CREATION_DATE,
5394: hz_utility_pub.LAST_UPDATE_LOGIN,
5395: hz_utility_pub.LAST_UPDATE_DATE,
5396: hz_utility_pub.LAST_UPDATED_BY
5397: from OE_PC_VTMPLT_COLS a,
5398: ra_customer_merges m
5399: where a.value_string = to_char(m.duplicate_site_id)
5400: and m.process_flag = 'N'

Line 5461: hz_utility_pub.CREATED_BY,

5457: a.value_string,
5458: to_char(m.customer_id),
5459: 'U',
5460: req_id,
5461: hz_utility_pub.CREATED_BY,
5462: hz_utility_pub.CREATION_DATE,
5463: hz_utility_pub.LAST_UPDATE_LOGIN,
5464: hz_utility_pub.LAST_UPDATE_DATE,
5465: hz_utility_pub.LAST_UPDATED_BY

Line 5462: hz_utility_pub.CREATION_DATE,

5458: to_char(m.customer_id),
5459: 'U',
5460: req_id,
5461: hz_utility_pub.CREATED_BY,
5462: hz_utility_pub.CREATION_DATE,
5463: hz_utility_pub.LAST_UPDATE_LOGIN,
5464: hz_utility_pub.LAST_UPDATE_DATE,
5465: hz_utility_pub.LAST_UPDATED_BY
5466: from OE_PC_VTMPLT_COLS a,

Line 5463: hz_utility_pub.LAST_UPDATE_LOGIN,

5459: 'U',
5460: req_id,
5461: hz_utility_pub.CREATED_BY,
5462: hz_utility_pub.CREATION_DATE,
5463: hz_utility_pub.LAST_UPDATE_LOGIN,
5464: hz_utility_pub.LAST_UPDATE_DATE,
5465: hz_utility_pub.LAST_UPDATED_BY
5466: from OE_PC_VTMPLT_COLS a,
5467: ra_customer_merges m

Line 5464: hz_utility_pub.LAST_UPDATE_DATE,

5460: req_id,
5461: hz_utility_pub.CREATED_BY,
5462: hz_utility_pub.CREATION_DATE,
5463: hz_utility_pub.LAST_UPDATE_LOGIN,
5464: hz_utility_pub.LAST_UPDATE_DATE,
5465: hz_utility_pub.LAST_UPDATED_BY
5466: from OE_PC_VTMPLT_COLS a,
5467: ra_customer_merges m
5468: where a.value_string = to_char(m.duplicate_id)

Line 5465: hz_utility_pub.LAST_UPDATED_BY

5461: hz_utility_pub.CREATED_BY,
5462: hz_utility_pub.CREATION_DATE,
5463: hz_utility_pub.LAST_UPDATE_LOGIN,
5464: hz_utility_pub.LAST_UPDATE_DATE,
5465: hz_utility_pub.LAST_UPDATED_BY
5466: from OE_PC_VTMPLT_COLS a,
5467: ra_customer_merges m
5468: where a.value_string = to_char(m.duplicate_id)
5469: and m.process_flag = 'N'

Line 5613: hz_utility_pub.CREATED_BY,

5609: to_char(a.hold_entity_id),
5610: to_char(m.customer_site_id),
5611: 'U',
5612: req_id,
5613: hz_utility_pub.CREATED_BY,
5614: hz_utility_pub.CREATION_DATE,
5615: hz_utility_pub.LAST_UPDATE_LOGIN,
5616: hz_utility_pub.LAST_UPDATE_DATE,
5617: hz_utility_pub.LAST_UPDATED_BY

Line 5614: hz_utility_pub.CREATION_DATE,

5610: to_char(m.customer_site_id),
5611: 'U',
5612: req_id,
5613: hz_utility_pub.CREATED_BY,
5614: hz_utility_pub.CREATION_DATE,
5615: hz_utility_pub.LAST_UPDATE_LOGIN,
5616: hz_utility_pub.LAST_UPDATE_DATE,
5617: hz_utility_pub.LAST_UPDATED_BY
5618: from OE_HOLD_SOURCES a,

Line 5615: hz_utility_pub.LAST_UPDATE_LOGIN,

5611: 'U',
5612: req_id,
5613: hz_utility_pub.CREATED_BY,
5614: hz_utility_pub.CREATION_DATE,
5615: hz_utility_pub.LAST_UPDATE_LOGIN,
5616: hz_utility_pub.LAST_UPDATE_DATE,
5617: hz_utility_pub.LAST_UPDATED_BY
5618: from OE_HOLD_SOURCES a,
5619: ra_customer_merges m

Line 5616: hz_utility_pub.LAST_UPDATE_DATE,

5612: req_id,
5613: hz_utility_pub.CREATED_BY,
5614: hz_utility_pub.CREATION_DATE,
5615: hz_utility_pub.LAST_UPDATE_LOGIN,
5616: hz_utility_pub.LAST_UPDATE_DATE,
5617: hz_utility_pub.LAST_UPDATED_BY
5618: from OE_HOLD_SOURCES a,
5619: ra_customer_merges m
5620: where a.hold_entity_id = to_char(m.duplicate_site_id)

Line 5617: hz_utility_pub.LAST_UPDATED_BY

5613: hz_utility_pub.CREATED_BY,
5614: hz_utility_pub.CREATION_DATE,
5615: hz_utility_pub.LAST_UPDATE_LOGIN,
5616: hz_utility_pub.LAST_UPDATE_DATE,
5617: hz_utility_pub.LAST_UPDATED_BY
5618: from OE_HOLD_SOURCES a,
5619: ra_customer_merges m
5620: where a.hold_entity_id = to_char(m.duplicate_site_id)
5621: and m.process_flag = 'N'

Line 5681: hz_utility_pub.CREATED_BY,

5677: to_char(a.hold_entity_id),
5678: to_char(m.customer_site_id),
5679: 'U',
5680: req_id,
5681: hz_utility_pub.CREATED_BY,
5682: hz_utility_pub.CREATION_DATE,
5683: hz_utility_pub.LAST_UPDATE_LOGIN,
5684: hz_utility_pub.LAST_UPDATE_DATE,
5685: hz_utility_pub.LAST_UPDATED_BY

Line 5682: hz_utility_pub.CREATION_DATE,

5678: to_char(m.customer_site_id),
5679: 'U',
5680: req_id,
5681: hz_utility_pub.CREATED_BY,
5682: hz_utility_pub.CREATION_DATE,
5683: hz_utility_pub.LAST_UPDATE_LOGIN,
5684: hz_utility_pub.LAST_UPDATE_DATE,
5685: hz_utility_pub.LAST_UPDATED_BY
5686: from OE_HOLD_SOURCES a,

Line 5683: hz_utility_pub.LAST_UPDATE_LOGIN,

5679: 'U',
5680: req_id,
5681: hz_utility_pub.CREATED_BY,
5682: hz_utility_pub.CREATION_DATE,
5683: hz_utility_pub.LAST_UPDATE_LOGIN,
5684: hz_utility_pub.LAST_UPDATE_DATE,
5685: hz_utility_pub.LAST_UPDATED_BY
5686: from OE_HOLD_SOURCES a,
5687: ra_customer_merges m

Line 5684: hz_utility_pub.LAST_UPDATE_DATE,

5680: req_id,
5681: hz_utility_pub.CREATED_BY,
5682: hz_utility_pub.CREATION_DATE,
5683: hz_utility_pub.LAST_UPDATE_LOGIN,
5684: hz_utility_pub.LAST_UPDATE_DATE,
5685: hz_utility_pub.LAST_UPDATED_BY
5686: from OE_HOLD_SOURCES a,
5687: ra_customer_merges m
5688: where a.hold_entity_id = to_char(m.duplicate_site_id)

Line 5685: hz_utility_pub.LAST_UPDATED_BY

5681: hz_utility_pub.CREATED_BY,
5682: hz_utility_pub.CREATION_DATE,
5683: hz_utility_pub.LAST_UPDATE_LOGIN,
5684: hz_utility_pub.LAST_UPDATE_DATE,
5685: hz_utility_pub.LAST_UPDATED_BY
5686: from OE_HOLD_SOURCES a,
5687: ra_customer_merges m
5688: where a.hold_entity_id = to_char(m.duplicate_site_id)
5689: and m.process_flag = 'N'

Line 5752: hz_utility_pub.CREATED_BY,

5748: to_char(a.hold_entity_id),
5749: to_char(m.customer_id),
5750: 'U',
5751: req_id,
5752: hz_utility_pub.CREATED_BY,
5753: hz_utility_pub.CREATION_DATE,
5754: hz_utility_pub.LAST_UPDATE_LOGIN,
5755: hz_utility_pub.LAST_UPDATE_DATE,
5756: hz_utility_pub.LAST_UPDATED_BY

Line 5753: hz_utility_pub.CREATION_DATE,

5749: to_char(m.customer_id),
5750: 'U',
5751: req_id,
5752: hz_utility_pub.CREATED_BY,
5753: hz_utility_pub.CREATION_DATE,
5754: hz_utility_pub.LAST_UPDATE_LOGIN,
5755: hz_utility_pub.LAST_UPDATE_DATE,
5756: hz_utility_pub.LAST_UPDATED_BY
5757: from OE_HOLD_SOURCES a,

Line 5754: hz_utility_pub.LAST_UPDATE_LOGIN,

5750: 'U',
5751: req_id,
5752: hz_utility_pub.CREATED_BY,
5753: hz_utility_pub.CREATION_DATE,
5754: hz_utility_pub.LAST_UPDATE_LOGIN,
5755: hz_utility_pub.LAST_UPDATE_DATE,
5756: hz_utility_pub.LAST_UPDATED_BY
5757: from OE_HOLD_SOURCES a,
5758: ra_customer_merges m

Line 5755: hz_utility_pub.LAST_UPDATE_DATE,

5751: req_id,
5752: hz_utility_pub.CREATED_BY,
5753: hz_utility_pub.CREATION_DATE,
5754: hz_utility_pub.LAST_UPDATE_LOGIN,
5755: hz_utility_pub.LAST_UPDATE_DATE,
5756: hz_utility_pub.LAST_UPDATED_BY
5757: from OE_HOLD_SOURCES a,
5758: ra_customer_merges m
5759: where a.hold_entity_id = to_char(m.duplicate_id)

Line 5756: hz_utility_pub.LAST_UPDATED_BY

5752: hz_utility_pub.CREATED_BY,
5753: hz_utility_pub.CREATION_DATE,
5754: hz_utility_pub.LAST_UPDATE_LOGIN,
5755: hz_utility_pub.LAST_UPDATE_DATE,
5756: hz_utility_pub.LAST_UPDATED_BY
5757: from OE_HOLD_SOURCES a,
5758: ra_customer_merges m
5759: where a.hold_entity_id = to_char(m.duplicate_id)
5760: and m.process_flag = 'N'

Line 5869: hz_utility_pub.CREATED_BY,

5865: to_char(a.line_location_id),
5866: to_char(m.customer_site_id),
5867: 'U',
5868: req_id,
5869: hz_utility_pub.CREATED_BY,
5870: hz_utility_pub.CREATION_DATE,
5871: hz_utility_pub.LAST_UPDATE_LOGIN,
5872: hz_utility_pub.LAST_UPDATE_DATE,
5873: hz_utility_pub.LAST_UPDATED_BY

Line 5870: hz_utility_pub.CREATION_DATE,

5866: to_char(m.customer_site_id),
5867: 'U',
5868: req_id,
5869: hz_utility_pub.CREATED_BY,
5870: hz_utility_pub.CREATION_DATE,
5871: hz_utility_pub.LAST_UPDATE_LOGIN,
5872: hz_utility_pub.LAST_UPDATE_DATE,
5873: hz_utility_pub.LAST_UPDATED_BY
5874: from OE_DROP_SHIP_SOURCES a,

Line 5871: hz_utility_pub.LAST_UPDATE_LOGIN,

5867: 'U',
5868: req_id,
5869: hz_utility_pub.CREATED_BY,
5870: hz_utility_pub.CREATION_DATE,
5871: hz_utility_pub.LAST_UPDATE_LOGIN,
5872: hz_utility_pub.LAST_UPDATE_DATE,
5873: hz_utility_pub.LAST_UPDATED_BY
5874: from OE_DROP_SHIP_SOURCES a,
5875: ra_customer_merges m

Line 5872: hz_utility_pub.LAST_UPDATE_DATE,

5868: req_id,
5869: hz_utility_pub.CREATED_BY,
5870: hz_utility_pub.CREATION_DATE,
5871: hz_utility_pub.LAST_UPDATE_LOGIN,
5872: hz_utility_pub.LAST_UPDATE_DATE,
5873: hz_utility_pub.LAST_UPDATED_BY
5874: from OE_DROP_SHIP_SOURCES a,
5875: ra_customer_merges m
5876: where a.line_location_id = to_char(m.duplicate_site_id)

Line 5873: hz_utility_pub.LAST_UPDATED_BY

5869: hz_utility_pub.CREATED_BY,
5870: hz_utility_pub.CREATION_DATE,
5871: hz_utility_pub.LAST_UPDATE_LOGIN,
5872: hz_utility_pub.LAST_UPDATE_DATE,
5873: hz_utility_pub.LAST_UPDATED_BY
5874: from OE_DROP_SHIP_SOURCES a,
5875: ra_customer_merges m
5876: where a.line_location_id = to_char(m.duplicate_site_id)
5877: and m.process_flag = 'N'

Line 5993: hz_utility_pub.CREATED_BY,

5989: a.site_use_id,
5990: m.customer_site_id,
5991: 'U',
5992: req_id,
5993: hz_utility_pub.CREATED_BY,
5994: hz_utility_pub.CREATION_DATE,
5995: hz_utility_pub.LAST_UPDATE_LOGIN,
5996: hz_utility_pub.LAST_UPDATE_DATE,
5997: hz_utility_pub.LAST_UPDATED_BY

Line 5994: hz_utility_pub.CREATION_DATE,

5990: m.customer_site_id,
5991: 'U',
5992: req_id,
5993: hz_utility_pub.CREATED_BY,
5994: hz_utility_pub.CREATION_DATE,
5995: hz_utility_pub.LAST_UPDATE_LOGIN,
5996: hz_utility_pub.LAST_UPDATE_DATE,
5997: hz_utility_pub.LAST_UPDATED_BY
5998: from OE_CUST_ITEM_SETTINGS a,

Line 5995: hz_utility_pub.LAST_UPDATE_LOGIN,

5991: 'U',
5992: req_id,
5993: hz_utility_pub.CREATED_BY,
5994: hz_utility_pub.CREATION_DATE,
5995: hz_utility_pub.LAST_UPDATE_LOGIN,
5996: hz_utility_pub.LAST_UPDATE_DATE,
5997: hz_utility_pub.LAST_UPDATED_BY
5998: from OE_CUST_ITEM_SETTINGS a,
5999: ra_customer_merges m

Line 5996: hz_utility_pub.LAST_UPDATE_DATE,

5992: req_id,
5993: hz_utility_pub.CREATED_BY,
5994: hz_utility_pub.CREATION_DATE,
5995: hz_utility_pub.LAST_UPDATE_LOGIN,
5996: hz_utility_pub.LAST_UPDATE_DATE,
5997: hz_utility_pub.LAST_UPDATED_BY
5998: from OE_CUST_ITEM_SETTINGS a,
5999: ra_customer_merges m
6000: where a.site_use_id = m.duplicate_site_id

Line 5997: hz_utility_pub.LAST_UPDATED_BY

5993: hz_utility_pub.CREATED_BY,
5994: hz_utility_pub.CREATION_DATE,
5995: hz_utility_pub.LAST_UPDATE_LOGIN,
5996: hz_utility_pub.LAST_UPDATE_DATE,
5997: hz_utility_pub.LAST_UPDATED_BY
5998: from OE_CUST_ITEM_SETTINGS a,
5999: ra_customer_merges m
6000: where a.site_use_id = m.duplicate_site_id
6001: and m.process_flag = 'N'

Line 6055: hz_utility_pub.CREATED_BY,

6051: a.customer_id,
6052: m.customer_id,
6053: 'U',
6054: req_id,
6055: hz_utility_pub.CREATED_BY,
6056: hz_utility_pub.CREATION_DATE,
6057: hz_utility_pub.LAST_UPDATE_LOGIN,
6058: hz_utility_pub.LAST_UPDATE_DATE,
6059: hz_utility_pub.LAST_UPDATED_BY

Line 6056: hz_utility_pub.CREATION_DATE,

6052: m.customer_id,
6053: 'U',
6054: req_id,
6055: hz_utility_pub.CREATED_BY,
6056: hz_utility_pub.CREATION_DATE,
6057: hz_utility_pub.LAST_UPDATE_LOGIN,
6058: hz_utility_pub.LAST_UPDATE_DATE,
6059: hz_utility_pub.LAST_UPDATED_BY
6060: from OE_CUST_ITEM_SETTINGS a,

Line 6057: hz_utility_pub.LAST_UPDATE_LOGIN,

6053: 'U',
6054: req_id,
6055: hz_utility_pub.CREATED_BY,
6056: hz_utility_pub.CREATION_DATE,
6057: hz_utility_pub.LAST_UPDATE_LOGIN,
6058: hz_utility_pub.LAST_UPDATE_DATE,
6059: hz_utility_pub.LAST_UPDATED_BY
6060: from OE_CUST_ITEM_SETTINGS a,
6061: ra_customer_merges m

Line 6058: hz_utility_pub.LAST_UPDATE_DATE,

6054: req_id,
6055: hz_utility_pub.CREATED_BY,
6056: hz_utility_pub.CREATION_DATE,
6057: hz_utility_pub.LAST_UPDATE_LOGIN,
6058: hz_utility_pub.LAST_UPDATE_DATE,
6059: hz_utility_pub.LAST_UPDATED_BY
6060: from OE_CUST_ITEM_SETTINGS a,
6061: ra_customer_merges m
6062: where a.customer_id = m.duplicate_id

Line 6059: hz_utility_pub.LAST_UPDATED_BY

6055: hz_utility_pub.CREATED_BY,
6056: hz_utility_pub.CREATION_DATE,
6057: hz_utility_pub.LAST_UPDATE_LOGIN,
6058: hz_utility_pub.LAST_UPDATE_DATE,
6059: hz_utility_pub.LAST_UPDATED_BY
6060: from OE_CUST_ITEM_SETTINGS a,
6061: ra_customer_merges m
6062: where a.customer_id = m.duplicate_id
6063: and m.process_flag = 'N'

Line 6219: hz_utility_pub.CREATED_BY,

6215: sets_ship_to_org_id_tab(I),
6216: sets_ship_to_org_id_tab(I),
6217: 'U',
6218: req_id,
6219: hz_utility_pub.CREATED_BY,
6220: hz_utility_pub.CREATION_DATE,
6221: hz_utility_pub.LAST_UPDATE_LOGIN,
6222: hz_utility_pub.LAST_UPDATE_DATE,
6223: hz_utility_pub.LAST_UPDATED_BY

Line 6220: hz_utility_pub.CREATION_DATE,

6216: sets_ship_to_org_id_tab(I),
6217: 'U',
6218: req_id,
6219: hz_utility_pub.CREATED_BY,
6220: hz_utility_pub.CREATION_DATE,
6221: hz_utility_pub.LAST_UPDATE_LOGIN,
6222: hz_utility_pub.LAST_UPDATE_DATE,
6223: hz_utility_pub.LAST_UPDATED_BY
6224: );

Line 6221: hz_utility_pub.LAST_UPDATE_LOGIN,

6217: 'U',
6218: req_id,
6219: hz_utility_pub.CREATED_BY,
6220: hz_utility_pub.CREATION_DATE,
6221: hz_utility_pub.LAST_UPDATE_LOGIN,
6222: hz_utility_pub.LAST_UPDATE_DATE,
6223: hz_utility_pub.LAST_UPDATED_BY
6224: );
6225: end if;

Line 6222: hz_utility_pub.LAST_UPDATE_DATE,

6218: req_id,
6219: hz_utility_pub.CREATED_BY,
6220: hz_utility_pub.CREATION_DATE,
6221: hz_utility_pub.LAST_UPDATE_LOGIN,
6222: hz_utility_pub.LAST_UPDATE_DATE,
6223: hz_utility_pub.LAST_UPDATED_BY
6224: );
6225: end if;
6226: end if;

Line 6223: hz_utility_pub.LAST_UPDATED_BY

6219: hz_utility_pub.CREATED_BY,
6220: hz_utility_pub.CREATION_DATE,
6221: hz_utility_pub.LAST_UPDATE_LOGIN,
6222: hz_utility_pub.LAST_UPDATE_DATE,
6223: hz_utility_pub.LAST_UPDATED_BY
6224: );
6225: end if;
6226: end if;
6227:

Line 6395: hz_utility_pub.CREATED_BY,

6391: pricing_attr_value_from_tab(I),
6392: to_char(attrib_value_from_tab(I)),
6393: 'U',
6394: req_id,
6395: hz_utility_pub.CREATED_BY,
6396: hz_utility_pub.CREATION_DATE,
6397: hz_utility_pub.LAST_UPDATE_LOGIN,
6398: hz_utility_pub.LAST_UPDATE_DATE,
6399: hz_utility_pub.LAST_UPDATED_BY

Line 6396: hz_utility_pub.CREATION_DATE,

6392: to_char(attrib_value_from_tab(I)),
6393: 'U',
6394: req_id,
6395: hz_utility_pub.CREATED_BY,
6396: hz_utility_pub.CREATION_DATE,
6397: hz_utility_pub.LAST_UPDATE_LOGIN,
6398: hz_utility_pub.LAST_UPDATE_DATE,
6399: hz_utility_pub.LAST_UPDATED_BY
6400: );

Line 6397: hz_utility_pub.LAST_UPDATE_LOGIN,

6393: 'U',
6394: req_id,
6395: hz_utility_pub.CREATED_BY,
6396: hz_utility_pub.CREATION_DATE,
6397: hz_utility_pub.LAST_UPDATE_LOGIN,
6398: hz_utility_pub.LAST_UPDATE_DATE,
6399: hz_utility_pub.LAST_UPDATED_BY
6400: );
6401:

Line 6398: hz_utility_pub.LAST_UPDATE_DATE,

6394: req_id,
6395: hz_utility_pub.CREATED_BY,
6396: hz_utility_pub.CREATION_DATE,
6397: hz_utility_pub.LAST_UPDATE_LOGIN,
6398: hz_utility_pub.LAST_UPDATE_DATE,
6399: hz_utility_pub.LAST_UPDATED_BY
6400: );
6401:
6402: END IF;

Line 6399: hz_utility_pub.LAST_UPDATED_BY

6395: hz_utility_pub.CREATED_BY,
6396: hz_utility_pub.CREATION_DATE,
6397: hz_utility_pub.LAST_UPDATE_LOGIN,
6398: hz_utility_pub.LAST_UPDATE_DATE,
6399: hz_utility_pub.LAST_UPDATED_BY
6400: );
6401:
6402: END IF;
6403: end if;

Line 6782: hz_utility_pub.CREATED_BY,

6778: old_hdr_sold_to_site_id_tab(I),
6779: decode(hdr_sold_to_site_use_id_tab(I),NULL,old_hdr_sold_to_site_id_tab(I),hdr_sold_to_site_use_id_tab(i)),
6780: 'U',
6781: req_id,
6782: hz_utility_pub.CREATED_BY,
6783: hz_utility_pub.CREATION_DATE,
6784: hz_utility_pub.LAST_UPDATE_LOGIN,
6785: hz_utility_pub.LAST_UPDATE_DATE,
6786: hz_utility_pub.LAST_UPDATED_BY

Line 6783: hz_utility_pub.CREATION_DATE,

6779: decode(hdr_sold_to_site_use_id_tab(I),NULL,old_hdr_sold_to_site_id_tab(I),hdr_sold_to_site_use_id_tab(i)),
6780: 'U',
6781: req_id,
6782: hz_utility_pub.CREATED_BY,
6783: hz_utility_pub.CREATION_DATE,
6784: hz_utility_pub.LAST_UPDATE_LOGIN,
6785: hz_utility_pub.LAST_UPDATE_DATE,
6786: hz_utility_pub.LAST_UPDATED_BY
6787: );

Line 6784: hz_utility_pub.LAST_UPDATE_LOGIN,

6780: 'U',
6781: req_id,
6782: hz_utility_pub.CREATED_BY,
6783: hz_utility_pub.CREATION_DATE,
6784: hz_utility_pub.LAST_UPDATE_LOGIN,
6785: hz_utility_pub.LAST_UPDATE_DATE,
6786: hz_utility_pub.LAST_UPDATED_BY
6787: );
6788:

Line 6785: hz_utility_pub.LAST_UPDATE_DATE,

6781: req_id,
6782: hz_utility_pub.CREATED_BY,
6783: hz_utility_pub.CREATION_DATE,
6784: hz_utility_pub.LAST_UPDATE_LOGIN,
6785: hz_utility_pub.LAST_UPDATE_DATE,
6786: hz_utility_pub.LAST_UPDATED_BY
6787: );
6788:
6789: end if;

Line 6786: hz_utility_pub.LAST_UPDATED_BY

6782: hz_utility_pub.CREATED_BY,
6783: hz_utility_pub.CREATION_DATE,
6784: hz_utility_pub.LAST_UPDATE_LOGIN,
6785: hz_utility_pub.LAST_UPDATE_DATE,
6786: hz_utility_pub.LAST_UPDATED_BY
6787: );
6788:
6789: end if;
6790: end if;

Line 7006: hz_utility_pub.CREATED_BY,

7002: h.ship_to_org_id,
7003: m.customer_site_id,
7004: 'U',
7005: req_id,
7006: hz_utility_pub.CREATED_BY,
7007: hz_utility_pub.CREATION_DATE,
7008: hz_utility_pub.LAST_UPDATE_LOGIN,
7009: hz_utility_pub.LAST_UPDATE_DATE,
7010: hz_utility_pub.LAST_UPDATED_BY

Line 7007: hz_utility_pub.CREATION_DATE,

7003: m.customer_site_id,
7004: 'U',
7005: req_id,
7006: hz_utility_pub.CREATED_BY,
7007: hz_utility_pub.CREATION_DATE,
7008: hz_utility_pub.LAST_UPDATE_LOGIN,
7009: hz_utility_pub.LAST_UPDATE_DATE,
7010: hz_utility_pub.LAST_UPDATED_BY
7011: from oe_blanket_headers_hist h,

Line 7008: hz_utility_pub.LAST_UPDATE_LOGIN,

7004: 'U',
7005: req_id,
7006: hz_utility_pub.CREATED_BY,
7007: hz_utility_pub.CREATION_DATE,
7008: hz_utility_pub.LAST_UPDATE_LOGIN,
7009: hz_utility_pub.LAST_UPDATE_DATE,
7010: hz_utility_pub.LAST_UPDATED_BY
7011: from oe_blanket_headers_hist h,
7012: ra_customer_merges m

Line 7009: hz_utility_pub.LAST_UPDATE_DATE,

7005: req_id,
7006: hz_utility_pub.CREATED_BY,
7007: hz_utility_pub.CREATION_DATE,
7008: hz_utility_pub.LAST_UPDATE_LOGIN,
7009: hz_utility_pub.LAST_UPDATE_DATE,
7010: hz_utility_pub.LAST_UPDATED_BY
7011: from oe_blanket_headers_hist h,
7012: ra_customer_merges m
7013: where h.ship_to_org_id=m.duplicate_site_id

Line 7010: hz_utility_pub.LAST_UPDATED_BY

7006: hz_utility_pub.CREATED_BY,
7007: hz_utility_pub.CREATION_DATE,
7008: hz_utility_pub.LAST_UPDATE_LOGIN,
7009: hz_utility_pub.LAST_UPDATE_DATE,
7010: hz_utility_pub.LAST_UPDATED_BY
7011: from oe_blanket_headers_hist h,
7012: ra_customer_merges m
7013: where h.ship_to_org_id=m.duplicate_site_id
7014: and m.process_flag = 'N'

Line 7073: hz_utility_pub.CREATED_BY,

7069: h.invoice_to_org_id,
7070: m.customer_site_id,
7071: 'U',
7072: req_id,
7073: hz_utility_pub.CREATED_BY,
7074: hz_utility_pub.CREATION_DATE,
7075: hz_utility_pub.LAST_UPDATE_LOGIN,
7076: hz_utility_pub.LAST_UPDATE_DATE,
7077: hz_utility_pub.LAST_UPDATED_BY

Line 7074: hz_utility_pub.CREATION_DATE,

7070: m.customer_site_id,
7071: 'U',
7072: req_id,
7073: hz_utility_pub.CREATED_BY,
7074: hz_utility_pub.CREATION_DATE,
7075: hz_utility_pub.LAST_UPDATE_LOGIN,
7076: hz_utility_pub.LAST_UPDATE_DATE,
7077: hz_utility_pub.LAST_UPDATED_BY
7078: from oe_blanket_headers_hist h,

Line 7075: hz_utility_pub.LAST_UPDATE_LOGIN,

7071: 'U',
7072: req_id,
7073: hz_utility_pub.CREATED_BY,
7074: hz_utility_pub.CREATION_DATE,
7075: hz_utility_pub.LAST_UPDATE_LOGIN,
7076: hz_utility_pub.LAST_UPDATE_DATE,
7077: hz_utility_pub.LAST_UPDATED_BY
7078: from oe_blanket_headers_hist h,
7079: ra_customer_merges m

Line 7076: hz_utility_pub.LAST_UPDATE_DATE,

7072: req_id,
7073: hz_utility_pub.CREATED_BY,
7074: hz_utility_pub.CREATION_DATE,
7075: hz_utility_pub.LAST_UPDATE_LOGIN,
7076: hz_utility_pub.LAST_UPDATE_DATE,
7077: hz_utility_pub.LAST_UPDATED_BY
7078: from oe_blanket_headers_hist h,
7079: ra_customer_merges m
7080: where h.invoice_to_org_id=m.duplicate_site_id

Line 7077: hz_utility_pub.LAST_UPDATED_BY

7073: hz_utility_pub.CREATED_BY,
7074: hz_utility_pub.CREATION_DATE,
7075: hz_utility_pub.LAST_UPDATE_LOGIN,
7076: hz_utility_pub.LAST_UPDATE_DATE,
7077: hz_utility_pub.LAST_UPDATED_BY
7078: from oe_blanket_headers_hist h,
7079: ra_customer_merges m
7080: where h.invoice_to_org_id=m.duplicate_site_id
7081: and m.process_flag = 'N'

Line 7140: hz_utility_pub.CREATED_BY,

7136: h.deliver_to_org_id,
7137: m.customer_site_id,
7138: 'U',
7139: req_id,
7140: hz_utility_pub.CREATED_BY,
7141: hz_utility_pub.CREATION_DATE,
7142: hz_utility_pub.LAST_UPDATE_LOGIN,
7143: hz_utility_pub.LAST_UPDATE_DATE,
7144: hz_utility_pub.LAST_UPDATED_BY

Line 7141: hz_utility_pub.CREATION_DATE,

7137: m.customer_site_id,
7138: 'U',
7139: req_id,
7140: hz_utility_pub.CREATED_BY,
7141: hz_utility_pub.CREATION_DATE,
7142: hz_utility_pub.LAST_UPDATE_LOGIN,
7143: hz_utility_pub.LAST_UPDATE_DATE,
7144: hz_utility_pub.LAST_UPDATED_BY
7145: from oe_blanket_headers_hist h,

Line 7142: hz_utility_pub.LAST_UPDATE_LOGIN,

7138: 'U',
7139: req_id,
7140: hz_utility_pub.CREATED_BY,
7141: hz_utility_pub.CREATION_DATE,
7142: hz_utility_pub.LAST_UPDATE_LOGIN,
7143: hz_utility_pub.LAST_UPDATE_DATE,
7144: hz_utility_pub.LAST_UPDATED_BY
7145: from oe_blanket_headers_hist h,
7146: ra_customer_merges m

Line 7143: hz_utility_pub.LAST_UPDATE_DATE,

7139: req_id,
7140: hz_utility_pub.CREATED_BY,
7141: hz_utility_pub.CREATION_DATE,
7142: hz_utility_pub.LAST_UPDATE_LOGIN,
7143: hz_utility_pub.LAST_UPDATE_DATE,
7144: hz_utility_pub.LAST_UPDATED_BY
7145: from oe_blanket_headers_hist h,
7146: ra_customer_merges m
7147: where h.deliver_to_org_id=m.duplicate_site_id

Line 7144: hz_utility_pub.LAST_UPDATED_BY

7140: hz_utility_pub.CREATED_BY,
7141: hz_utility_pub.CREATION_DATE,
7142: hz_utility_pub.LAST_UPDATE_LOGIN,
7143: hz_utility_pub.LAST_UPDATE_DATE,
7144: hz_utility_pub.LAST_UPDATED_BY
7145: from oe_blanket_headers_hist h,
7146: ra_customer_merges m
7147: where h.deliver_to_org_id=m.duplicate_site_id
7148: and m.process_flag = 'N'

Line 7209: hz_utility_pub.CREATED_BY,

7205: h.sold_to_org_id,
7206: m.customer_site_id,
7207: 'U',
7208: req_id,
7209: hz_utility_pub.CREATED_BY,
7210: hz_utility_pub.CREATION_DATE,
7211: hz_utility_pub.LAST_UPDATE_LOGIN,
7212: hz_utility_pub.LAST_UPDATE_DATE,
7213: hz_utility_pub.LAST_UPDATED_BY

Line 7210: hz_utility_pub.CREATION_DATE,

7206: m.customer_site_id,
7207: 'U',
7208: req_id,
7209: hz_utility_pub.CREATED_BY,
7210: hz_utility_pub.CREATION_DATE,
7211: hz_utility_pub.LAST_UPDATE_LOGIN,
7212: hz_utility_pub.LAST_UPDATE_DATE,
7213: hz_utility_pub.LAST_UPDATED_BY
7214: from oe_blanket_headers_hist h,

Line 7211: hz_utility_pub.LAST_UPDATE_LOGIN,

7207: 'U',
7208: req_id,
7209: hz_utility_pub.CREATED_BY,
7210: hz_utility_pub.CREATION_DATE,
7211: hz_utility_pub.LAST_UPDATE_LOGIN,
7212: hz_utility_pub.LAST_UPDATE_DATE,
7213: hz_utility_pub.LAST_UPDATED_BY
7214: from oe_blanket_headers_hist h,
7215: ra_customer_merges m

Line 7212: hz_utility_pub.LAST_UPDATE_DATE,

7208: req_id,
7209: hz_utility_pub.CREATED_BY,
7210: hz_utility_pub.CREATION_DATE,
7211: hz_utility_pub.LAST_UPDATE_LOGIN,
7212: hz_utility_pub.LAST_UPDATE_DATE,
7213: hz_utility_pub.LAST_UPDATED_BY
7214: from oe_blanket_headers_hist h,
7215: ra_customer_merges m
7216: where h.sold_to_org_id=m.duplicate_site_id

Line 7213: hz_utility_pub.LAST_UPDATED_BY

7209: hz_utility_pub.CREATED_BY,
7210: hz_utility_pub.CREATION_DATE,
7211: hz_utility_pub.LAST_UPDATE_LOGIN,
7212: hz_utility_pub.LAST_UPDATE_DATE,
7213: hz_utility_pub.LAST_UPDATED_BY
7214: from oe_blanket_headers_hist h,
7215: ra_customer_merges m
7216: where h.sold_to_org_id=m.duplicate_site_id
7217: and m.process_flag = 'N'

Line 7282: hz_utility_pub.CREATED_BY,

7278: h.sold_to_site_use_id,
7279: m.customer_site_id,
7280: 'U',
7281: req_id,
7282: hz_utility_pub.CREATED_BY,
7283: hz_utility_pub.CREATION_DATE,
7284: hz_utility_pub.LAST_UPDATE_LOGIN,
7285: hz_utility_pub.LAST_UPDATE_DATE,
7286: hz_utility_pub.LAST_UPDATED_BY

Line 7283: hz_utility_pub.CREATION_DATE,

7279: m.customer_site_id,
7280: 'U',
7281: req_id,
7282: hz_utility_pub.CREATED_BY,
7283: hz_utility_pub.CREATION_DATE,
7284: hz_utility_pub.LAST_UPDATE_LOGIN,
7285: hz_utility_pub.LAST_UPDATE_DATE,
7286: hz_utility_pub.LAST_UPDATED_BY
7287: from oe_blanket_headers_hist h,

Line 7284: hz_utility_pub.LAST_UPDATE_LOGIN,

7280: 'U',
7281: req_id,
7282: hz_utility_pub.CREATED_BY,
7283: hz_utility_pub.CREATION_DATE,
7284: hz_utility_pub.LAST_UPDATE_LOGIN,
7285: hz_utility_pub.LAST_UPDATE_DATE,
7286: hz_utility_pub.LAST_UPDATED_BY
7287: from oe_blanket_headers_hist h,
7288: ra_customer_merges m

Line 7285: hz_utility_pub.LAST_UPDATE_DATE,

7281: req_id,
7282: hz_utility_pub.CREATED_BY,
7283: hz_utility_pub.CREATION_DATE,
7284: hz_utility_pub.LAST_UPDATE_LOGIN,
7285: hz_utility_pub.LAST_UPDATE_DATE,
7286: hz_utility_pub.LAST_UPDATED_BY
7287: from oe_blanket_headers_hist h,
7288: ra_customer_merges m
7289: where h.sold_to_org_id=m.duplicate_site_id

Line 7286: hz_utility_pub.LAST_UPDATED_BY

7282: hz_utility_pub.CREATED_BY,
7283: hz_utility_pub.CREATION_DATE,
7284: hz_utility_pub.LAST_UPDATE_LOGIN,
7285: hz_utility_pub.LAST_UPDATE_DATE,
7286: hz_utility_pub.LAST_UPDATED_BY
7287: from oe_blanket_headers_hist h,
7288: ra_customer_merges m
7289: where h.sold_to_org_id=m.duplicate_site_id
7290: and m.process_flag = 'N'

Line 7677: hz_utility_pub.CREATED_BY,

7673: line_deliver_to_org_id_tab(I),
7674: decode(line_deliver_to_org_id_tab(I),NULL,old_line_deliver_to_org_id_tab(I),line_deliver_to_org_id_tab(i)),
7675: 'U',
7676: req_id,
7677: hz_utility_pub.CREATED_BY,
7678: hz_utility_pub.CREATION_DATE,
7679: hz_utility_pub.LAST_UPDATE_LOGIN,
7680: hz_utility_pub.LAST_UPDATE_DATE,
7681: hz_utility_pub.LAST_UPDATED_BY

Line 7678: hz_utility_pub.CREATION_DATE,

7674: decode(line_deliver_to_org_id_tab(I),NULL,old_line_deliver_to_org_id_tab(I),line_deliver_to_org_id_tab(i)),
7675: 'U',
7676: req_id,
7677: hz_utility_pub.CREATED_BY,
7678: hz_utility_pub.CREATION_DATE,
7679: hz_utility_pub.LAST_UPDATE_LOGIN,
7680: hz_utility_pub.LAST_UPDATE_DATE,
7681: hz_utility_pub.LAST_UPDATED_BY
7682: );

Line 7679: hz_utility_pub.LAST_UPDATE_LOGIN,

7675: 'U',
7676: req_id,
7677: hz_utility_pub.CREATED_BY,
7678: hz_utility_pub.CREATION_DATE,
7679: hz_utility_pub.LAST_UPDATE_LOGIN,
7680: hz_utility_pub.LAST_UPDATE_DATE,
7681: hz_utility_pub.LAST_UPDATED_BY
7682: );
7683:

Line 7680: hz_utility_pub.LAST_UPDATE_DATE,

7676: req_id,
7677: hz_utility_pub.CREATED_BY,
7678: hz_utility_pub.CREATION_DATE,
7679: hz_utility_pub.LAST_UPDATE_LOGIN,
7680: hz_utility_pub.LAST_UPDATE_DATE,
7681: hz_utility_pub.LAST_UPDATED_BY
7682: );
7683:
7684: end if;

Line 7681: hz_utility_pub.LAST_UPDATED_BY

7677: hz_utility_pub.CREATED_BY,
7678: hz_utility_pub.CREATION_DATE,
7679: hz_utility_pub.LAST_UPDATE_LOGIN,
7680: hz_utility_pub.LAST_UPDATE_DATE,
7681: hz_utility_pub.LAST_UPDATED_BY
7682: );
7683:
7684: end if;
7685: end if;

Line 8107: hz_utility_pub.CREATED_BY,

8103: lhst_deliver_to_org_id_tab(I),
8104: decode(lhst_deliver_to_org_id_tab(I),NULL,old_lhst_deliver_to_org_id_tab(I),lhst_deliver_to_org_id_tab(i)),
8105: 'U',
8106: req_id,
8107: hz_utility_pub.CREATED_BY,
8108: hz_utility_pub.CREATION_DATE,
8109: hz_utility_pub.LAST_UPDATE_LOGIN,
8110: hz_utility_pub.LAST_UPDATE_DATE,
8111: hz_utility_pub.LAST_UPDATED_BY

Line 8108: hz_utility_pub.CREATION_DATE,

8104: decode(lhst_deliver_to_org_id_tab(I),NULL,old_lhst_deliver_to_org_id_tab(I),lhst_deliver_to_org_id_tab(i)),
8105: 'U',
8106: req_id,
8107: hz_utility_pub.CREATED_BY,
8108: hz_utility_pub.CREATION_DATE,
8109: hz_utility_pub.LAST_UPDATE_LOGIN,
8110: hz_utility_pub.LAST_UPDATE_DATE,
8111: hz_utility_pub.LAST_UPDATED_BY
8112: );

Line 8109: hz_utility_pub.LAST_UPDATE_LOGIN,

8105: 'U',
8106: req_id,
8107: hz_utility_pub.CREATED_BY,
8108: hz_utility_pub.CREATION_DATE,
8109: hz_utility_pub.LAST_UPDATE_LOGIN,
8110: hz_utility_pub.LAST_UPDATE_DATE,
8111: hz_utility_pub.LAST_UPDATED_BY
8112: );
8113:

Line 8110: hz_utility_pub.LAST_UPDATE_DATE,

8106: req_id,
8107: hz_utility_pub.CREATED_BY,
8108: hz_utility_pub.CREATION_DATE,
8109: hz_utility_pub.LAST_UPDATE_LOGIN,
8110: hz_utility_pub.LAST_UPDATE_DATE,
8111: hz_utility_pub.LAST_UPDATED_BY
8112: );
8113:
8114: end if;

Line 8111: hz_utility_pub.LAST_UPDATED_BY

8107: hz_utility_pub.CREATED_BY,
8108: hz_utility_pub.CREATION_DATE,
8109: hz_utility_pub.LAST_UPDATE_LOGIN,
8110: hz_utility_pub.LAST_UPDATE_DATE,
8111: hz_utility_pub.LAST_UPDATED_BY
8112: );
8113:
8114: end if;
8115: end if;

Line 8270: hz_utility_pub.CREATED_BY,

8266: h.sold_to_org_id,
8267: m.customer_site_id,
8268: 'U',
8269: req_id,
8270: hz_utility_pub.CREATED_BY,
8271: hz_utility_pub.CREATION_DATE,
8272: hz_utility_pub.LAST_UPDATE_LOGIN,
8273: hz_utility_pub.LAST_UPDATE_DATE,
8274: hz_utility_pub.LAST_UPDATED_BY

Line 8271: hz_utility_pub.CREATION_DATE,

8267: m.customer_site_id,
8268: 'U',
8269: req_id,
8270: hz_utility_pub.CREATED_BY,
8271: hz_utility_pub.CREATION_DATE,
8272: hz_utility_pub.LAST_UPDATE_LOGIN,
8273: hz_utility_pub.LAST_UPDATE_DATE,
8274: hz_utility_pub.LAST_UPDATED_BY
8275: from oe_em_information_All h,

Line 8272: hz_utility_pub.LAST_UPDATE_LOGIN,

8268: 'U',
8269: req_id,
8270: hz_utility_pub.CREATED_BY,
8271: hz_utility_pub.CREATION_DATE,
8272: hz_utility_pub.LAST_UPDATE_LOGIN,
8273: hz_utility_pub.LAST_UPDATE_DATE,
8274: hz_utility_pub.LAST_UPDATED_BY
8275: from oe_em_information_All h,
8276: ra_customer_merges m

Line 8273: hz_utility_pub.LAST_UPDATE_DATE,

8269: req_id,
8270: hz_utility_pub.CREATED_BY,
8271: hz_utility_pub.CREATION_DATE,
8272: hz_utility_pub.LAST_UPDATE_LOGIN,
8273: hz_utility_pub.LAST_UPDATE_DATE,
8274: hz_utility_pub.LAST_UPDATED_BY
8275: from oe_em_information_All h,
8276: ra_customer_merges m
8277: where h.sold_to_org_id=m.duplicate_site_id

Line 8274: hz_utility_pub.LAST_UPDATED_BY

8270: hz_utility_pub.CREATED_BY,
8271: hz_utility_pub.CREATION_DATE,
8272: hz_utility_pub.LAST_UPDATE_LOGIN,
8273: hz_utility_pub.LAST_UPDATE_DATE,
8274: hz_utility_pub.LAST_UPDATED_BY
8275: from oe_em_information_All h,
8276: ra_customer_merges m
8277: where h.sold_to_org_id=m.duplicate_site_id
8278: and m.process_flag = 'N'