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.OE_CUST_MERGE dependencies on HZ_UTILITY_PUB

Line 363: hz_utility_pub.CREATED_BY,

359: old_hdr_end_cust_id_tab(I),
360: decode(hdr_end_cust_id_tab(I),NULL,old_hdr_end_cust_id_tab(I),hdr_end_cust_id_tab(i)),
361: 'U',
362: req_id,
363: hz_utility_pub.CREATED_BY,
364: hz_utility_pub.CREATION_DATE,
365: hz_utility_pub.LAST_UPDATE_LOGIN,
366: hz_utility_pub.LAST_UPDATE_DATE,
367: hz_utility_pub.LAST_UPDATED_BY

Line 364: hz_utility_pub.CREATION_DATE,

360: decode(hdr_end_cust_id_tab(I),NULL,old_hdr_end_cust_id_tab(I),hdr_end_cust_id_tab(i)),
361: 'U',
362: req_id,
363: hz_utility_pub.CREATED_BY,
364: hz_utility_pub.CREATION_DATE,
365: hz_utility_pub.LAST_UPDATE_LOGIN,
366: hz_utility_pub.LAST_UPDATE_DATE,
367: hz_utility_pub.LAST_UPDATED_BY
368: );

Line 365: hz_utility_pub.LAST_UPDATE_LOGIN,

361: 'U',
362: req_id,
363: hz_utility_pub.CREATED_BY,
364: hz_utility_pub.CREATION_DATE,
365: hz_utility_pub.LAST_UPDATE_LOGIN,
366: hz_utility_pub.LAST_UPDATE_DATE,
367: hz_utility_pub.LAST_UPDATED_BY
368: );
369:

Line 366: hz_utility_pub.LAST_UPDATE_DATE,

362: req_id,
363: hz_utility_pub.CREATED_BY,
364: hz_utility_pub.CREATION_DATE,
365: hz_utility_pub.LAST_UPDATE_LOGIN,
366: hz_utility_pub.LAST_UPDATE_DATE,
367: hz_utility_pub.LAST_UPDATED_BY
368: );
369:
370: end if;

Line 367: hz_utility_pub.LAST_UPDATED_BY

363: hz_utility_pub.CREATED_BY,
364: hz_utility_pub.CREATION_DATE,
365: hz_utility_pub.LAST_UPDATE_LOGIN,
366: hz_utility_pub.LAST_UPDATE_DATE,
367: hz_utility_pub.LAST_UPDATED_BY
368: );
369:
370: end if;
371: end if;

Line 1448: hz_utility_pub.CREATED_BY,

1444: h.ship_to_org_id,
1445: m.customer_site_id,
1446: 'U',
1447: req_id,
1448: hz_utility_pub.CREATED_BY,
1449: hz_utility_pub.CREATION_DATE,
1450: hz_utility_pub.LAST_UPDATE_LOGIN,
1451: hz_utility_pub.LAST_UPDATE_DATE,
1452: hz_utility_pub.LAST_UPDATED_BY

Line 1449: hz_utility_pub.CREATION_DATE,

1445: m.customer_site_id,
1446: 'U',
1447: req_id,
1448: hz_utility_pub.CREATED_BY,
1449: hz_utility_pub.CREATION_DATE,
1450: hz_utility_pub.LAST_UPDATE_LOGIN,
1451: hz_utility_pub.LAST_UPDATE_DATE,
1452: hz_utility_pub.LAST_UPDATED_BY
1453: from oe_header_acks h,

Line 1450: hz_utility_pub.LAST_UPDATE_LOGIN,

1446: 'U',
1447: req_id,
1448: hz_utility_pub.CREATED_BY,
1449: hz_utility_pub.CREATION_DATE,
1450: hz_utility_pub.LAST_UPDATE_LOGIN,
1451: hz_utility_pub.LAST_UPDATE_DATE,
1452: hz_utility_pub.LAST_UPDATED_BY
1453: from oe_header_acks h,
1454: ra_customer_merges m

Line 1451: hz_utility_pub.LAST_UPDATE_DATE,

1447: req_id,
1448: hz_utility_pub.CREATED_BY,
1449: hz_utility_pub.CREATION_DATE,
1450: hz_utility_pub.LAST_UPDATE_LOGIN,
1451: hz_utility_pub.LAST_UPDATE_DATE,
1452: hz_utility_pub.LAST_UPDATED_BY
1453: from oe_header_acks h,
1454: ra_customer_merges m
1455: where h.ship_to_org_id=m.duplicate_site_id

Line 1452: hz_utility_pub.LAST_UPDATED_BY

1448: hz_utility_pub.CREATED_BY,
1449: hz_utility_pub.CREATION_DATE,
1450: hz_utility_pub.LAST_UPDATE_LOGIN,
1451: hz_utility_pub.LAST_UPDATE_DATE,
1452: hz_utility_pub.LAST_UPDATED_BY
1453: from oe_header_acks h,
1454: ra_customer_merges m
1455: where h.ship_to_org_id=m.duplicate_site_id
1456: and m.process_flag = 'N'

Line 1515: hz_utility_pub.CREATED_BY,

1511: h.invoice_to_org_id,
1512: m.customer_site_id,
1513: 'U',
1514: req_id,
1515: hz_utility_pub.CREATED_BY,
1516: hz_utility_pub.CREATION_DATE,
1517: hz_utility_pub.LAST_UPDATE_LOGIN,
1518: hz_utility_pub.LAST_UPDATE_DATE,
1519: hz_utility_pub.LAST_UPDATED_BY

Line 1516: hz_utility_pub.CREATION_DATE,

1512: m.customer_site_id,
1513: 'U',
1514: req_id,
1515: hz_utility_pub.CREATED_BY,
1516: hz_utility_pub.CREATION_DATE,
1517: hz_utility_pub.LAST_UPDATE_LOGIN,
1518: hz_utility_pub.LAST_UPDATE_DATE,
1519: hz_utility_pub.LAST_UPDATED_BY
1520: from oe_header_acks h,

Line 1517: hz_utility_pub.LAST_UPDATE_LOGIN,

1513: 'U',
1514: req_id,
1515: hz_utility_pub.CREATED_BY,
1516: hz_utility_pub.CREATION_DATE,
1517: hz_utility_pub.LAST_UPDATE_LOGIN,
1518: hz_utility_pub.LAST_UPDATE_DATE,
1519: hz_utility_pub.LAST_UPDATED_BY
1520: from oe_header_acks h,
1521: ra_customer_merges m

Line 1518: hz_utility_pub.LAST_UPDATE_DATE,

1514: req_id,
1515: hz_utility_pub.CREATED_BY,
1516: hz_utility_pub.CREATION_DATE,
1517: hz_utility_pub.LAST_UPDATE_LOGIN,
1518: hz_utility_pub.LAST_UPDATE_DATE,
1519: hz_utility_pub.LAST_UPDATED_BY
1520: from oe_header_acks h,
1521: ra_customer_merges m
1522: where h.invoice_to_org_id=m.duplicate_site_id

Line 1519: hz_utility_pub.LAST_UPDATED_BY

1515: hz_utility_pub.CREATED_BY,
1516: hz_utility_pub.CREATION_DATE,
1517: hz_utility_pub.LAST_UPDATE_LOGIN,
1518: hz_utility_pub.LAST_UPDATE_DATE,
1519: hz_utility_pub.LAST_UPDATED_BY
1520: from oe_header_acks h,
1521: ra_customer_merges m
1522: where h.invoice_to_org_id=m.duplicate_site_id
1523: and m.process_flag = 'N'

Line 1584: hz_utility_pub.CREATED_BY,

1580: h.deliver_to_org_id,
1581: m.customer_site_id,
1582: 'U',
1583: req_id,
1584: hz_utility_pub.CREATED_BY,
1585: hz_utility_pub.CREATION_DATE,
1586: hz_utility_pub.LAST_UPDATE_LOGIN,
1587: hz_utility_pub.LAST_UPDATE_DATE,
1588: hz_utility_pub.LAST_UPDATED_BY

Line 1585: hz_utility_pub.CREATION_DATE,

1581: m.customer_site_id,
1582: 'U',
1583: req_id,
1584: hz_utility_pub.CREATED_BY,
1585: hz_utility_pub.CREATION_DATE,
1586: hz_utility_pub.LAST_UPDATE_LOGIN,
1587: hz_utility_pub.LAST_UPDATE_DATE,
1588: hz_utility_pub.LAST_UPDATED_BY
1589: from oe_header_acks h,

Line 1586: hz_utility_pub.LAST_UPDATE_LOGIN,

1582: 'U',
1583: req_id,
1584: hz_utility_pub.CREATED_BY,
1585: hz_utility_pub.CREATION_DATE,
1586: hz_utility_pub.LAST_UPDATE_LOGIN,
1587: hz_utility_pub.LAST_UPDATE_DATE,
1588: hz_utility_pub.LAST_UPDATED_BY
1589: from oe_header_acks h,
1590: ra_customer_merges m

Line 1587: hz_utility_pub.LAST_UPDATE_DATE,

1583: req_id,
1584: hz_utility_pub.CREATED_BY,
1585: hz_utility_pub.CREATION_DATE,
1586: hz_utility_pub.LAST_UPDATE_LOGIN,
1587: hz_utility_pub.LAST_UPDATE_DATE,
1588: hz_utility_pub.LAST_UPDATED_BY
1589: from oe_header_acks h,
1590: ra_customer_merges m
1591: where h.deliver_to_org_id=m.duplicate_site_id

Line 1588: hz_utility_pub.LAST_UPDATED_BY

1584: hz_utility_pub.CREATED_BY,
1585: hz_utility_pub.CREATION_DATE,
1586: hz_utility_pub.LAST_UPDATE_LOGIN,
1587: hz_utility_pub.LAST_UPDATE_DATE,
1588: hz_utility_pub.LAST_UPDATED_BY
1589: from oe_header_acks h,
1590: ra_customer_merges m
1591: where h.deliver_to_org_id=m.duplicate_site_id
1592: and m.process_flag = 'N'

Line 1655: hz_utility_pub.CREATED_BY,

1651: h.sold_to_org_id,
1652: m.customer_site_id,
1653: 'U',
1654: req_id,
1655: hz_utility_pub.CREATED_BY,
1656: hz_utility_pub.CREATION_DATE,
1657: hz_utility_pub.LAST_UPDATE_LOGIN,
1658: hz_utility_pub.LAST_UPDATE_DATE,
1659: hz_utility_pub.LAST_UPDATED_BY

Line 1656: hz_utility_pub.CREATION_DATE,

1652: m.customer_site_id,
1653: 'U',
1654: req_id,
1655: hz_utility_pub.CREATED_BY,
1656: hz_utility_pub.CREATION_DATE,
1657: hz_utility_pub.LAST_UPDATE_LOGIN,
1658: hz_utility_pub.LAST_UPDATE_DATE,
1659: hz_utility_pub.LAST_UPDATED_BY
1660: from oe_header_acks h,

Line 1657: hz_utility_pub.LAST_UPDATE_LOGIN,

1653: 'U',
1654: req_id,
1655: hz_utility_pub.CREATED_BY,
1656: hz_utility_pub.CREATION_DATE,
1657: hz_utility_pub.LAST_UPDATE_LOGIN,
1658: hz_utility_pub.LAST_UPDATE_DATE,
1659: hz_utility_pub.LAST_UPDATED_BY
1660: from oe_header_acks h,
1661: ra_customer_merges m

Line 1658: hz_utility_pub.LAST_UPDATE_DATE,

1654: req_id,
1655: hz_utility_pub.CREATED_BY,
1656: hz_utility_pub.CREATION_DATE,
1657: hz_utility_pub.LAST_UPDATE_LOGIN,
1658: hz_utility_pub.LAST_UPDATE_DATE,
1659: hz_utility_pub.LAST_UPDATED_BY
1660: from oe_header_acks h,
1661: ra_customer_merges m
1662: where h.sold_to_org_id=m.duplicate_site_id

Line 1659: hz_utility_pub.LAST_UPDATED_BY

1655: hz_utility_pub.CREATED_BY,
1656: hz_utility_pub.CREATION_DATE,
1657: hz_utility_pub.LAST_UPDATE_LOGIN,
1658: hz_utility_pub.LAST_UPDATE_DATE,
1659: hz_utility_pub.LAST_UPDATED_BY
1660: from oe_header_acks h,
1661: ra_customer_merges m
1662: where h.sold_to_org_id=m.duplicate_site_id
1663: and m.process_flag = 'N'

Line 1727: hz_utility_pub.CREATED_BY,

1723: h.sold_to_site_use_id,
1724: m.customer_site_id,
1725: 'U',
1726: req_id,
1727: hz_utility_pub.CREATED_BY,
1728: hz_utility_pub.CREATION_DATE,
1729: hz_utility_pub.LAST_UPDATE_LOGIN,
1730: hz_utility_pub.LAST_UPDATE_DATE,
1731: hz_utility_pub.LAST_UPDATED_BY

Line 1728: hz_utility_pub.CREATION_DATE,

1724: m.customer_site_id,
1725: 'U',
1726: req_id,
1727: hz_utility_pub.CREATED_BY,
1728: hz_utility_pub.CREATION_DATE,
1729: hz_utility_pub.LAST_UPDATE_LOGIN,
1730: hz_utility_pub.LAST_UPDATE_DATE,
1731: hz_utility_pub.LAST_UPDATED_BY
1732: from oe_header_acks h,

Line 1729: hz_utility_pub.LAST_UPDATE_LOGIN,

1725: 'U',
1726: req_id,
1727: hz_utility_pub.CREATED_BY,
1728: hz_utility_pub.CREATION_DATE,
1729: hz_utility_pub.LAST_UPDATE_LOGIN,
1730: hz_utility_pub.LAST_UPDATE_DATE,
1731: hz_utility_pub.LAST_UPDATED_BY
1732: from oe_header_acks h,
1733: ra_customer_merges m

Line 1730: hz_utility_pub.LAST_UPDATE_DATE,

1726: req_id,
1727: hz_utility_pub.CREATED_BY,
1728: hz_utility_pub.CREATION_DATE,
1729: hz_utility_pub.LAST_UPDATE_LOGIN,
1730: hz_utility_pub.LAST_UPDATE_DATE,
1731: hz_utility_pub.LAST_UPDATED_BY
1732: from oe_header_acks h,
1733: ra_customer_merges m
1734: where

Line 1731: hz_utility_pub.LAST_UPDATED_BY

1727: hz_utility_pub.CREATED_BY,
1728: hz_utility_pub.CREATION_DATE,
1729: hz_utility_pub.LAST_UPDATE_LOGIN,
1730: hz_utility_pub.LAST_UPDATE_DATE,
1731: hz_utility_pub.LAST_UPDATED_BY
1732: from oe_header_acks h,
1733: ra_customer_merges m
1734: where
1735: h.sold_to_site_use_id=m.duplicate_site_id

Line 1800: hz_utility_pub.CREATED_BY,

1796: h.end_customer_site_use_id,
1797: m.customer_site_id,
1798: 'U',
1799: req_id,
1800: hz_utility_pub.CREATED_BY,
1801: hz_utility_pub.CREATION_DATE,
1802: hz_utility_pub.LAST_UPDATE_LOGIN,
1803: hz_utility_pub.LAST_UPDATE_DATE,
1804: hz_utility_pub.LAST_UPDATED_BY

Line 1801: hz_utility_pub.CREATION_DATE,

1797: m.customer_site_id,
1798: 'U',
1799: req_id,
1800: hz_utility_pub.CREATED_BY,
1801: hz_utility_pub.CREATION_DATE,
1802: hz_utility_pub.LAST_UPDATE_LOGIN,
1803: hz_utility_pub.LAST_UPDATE_DATE,
1804: hz_utility_pub.LAST_UPDATED_BY
1805: from oe_header_acks h,

Line 1802: hz_utility_pub.LAST_UPDATE_LOGIN,

1798: 'U',
1799: req_id,
1800: hz_utility_pub.CREATED_BY,
1801: hz_utility_pub.CREATION_DATE,
1802: hz_utility_pub.LAST_UPDATE_LOGIN,
1803: hz_utility_pub.LAST_UPDATE_DATE,
1804: hz_utility_pub.LAST_UPDATED_BY
1805: from oe_header_acks h,
1806: ra_customer_merges m

Line 1803: hz_utility_pub.LAST_UPDATE_DATE,

1799: req_id,
1800: hz_utility_pub.CREATED_BY,
1801: hz_utility_pub.CREATION_DATE,
1802: hz_utility_pub.LAST_UPDATE_LOGIN,
1803: hz_utility_pub.LAST_UPDATE_DATE,
1804: hz_utility_pub.LAST_UPDATED_BY
1805: from oe_header_acks h,
1806: ra_customer_merges m
1807: where

Line 1804: hz_utility_pub.LAST_UPDATED_BY

1800: hz_utility_pub.CREATED_BY,
1801: hz_utility_pub.CREATION_DATE,
1802: hz_utility_pub.LAST_UPDATE_LOGIN,
1803: hz_utility_pub.LAST_UPDATE_DATE,
1804: hz_utility_pub.LAST_UPDATED_BY
1805: from oe_header_acks h,
1806: ra_customer_merges m
1807: where
1808: h.end_customer_site_use_id=m.duplicate_site_id

Line 1873: hz_utility_pub.CREATED_BY,

1869: h.end_customer_id,
1870: m.customer_site_id,
1871: 'U',
1872: req_id,
1873: hz_utility_pub.CREATED_BY,
1874: hz_utility_pub.CREATION_DATE,
1875: hz_utility_pub.LAST_UPDATE_LOGIN,
1876: hz_utility_pub.LAST_UPDATE_DATE,
1877: hz_utility_pub.LAST_UPDATED_BY

Line 1874: hz_utility_pub.CREATION_DATE,

1870: m.customer_site_id,
1871: 'U',
1872: req_id,
1873: hz_utility_pub.CREATED_BY,
1874: hz_utility_pub.CREATION_DATE,
1875: hz_utility_pub.LAST_UPDATE_LOGIN,
1876: hz_utility_pub.LAST_UPDATE_DATE,
1877: hz_utility_pub.LAST_UPDATED_BY
1878: from oe_header_acks h,

Line 1875: hz_utility_pub.LAST_UPDATE_LOGIN,

1871: 'U',
1872: req_id,
1873: hz_utility_pub.CREATED_BY,
1874: hz_utility_pub.CREATION_DATE,
1875: hz_utility_pub.LAST_UPDATE_LOGIN,
1876: hz_utility_pub.LAST_UPDATE_DATE,
1877: hz_utility_pub.LAST_UPDATED_BY
1878: from oe_header_acks h,
1879: ra_customer_merges m

Line 1876: hz_utility_pub.LAST_UPDATE_DATE,

1872: req_id,
1873: hz_utility_pub.CREATED_BY,
1874: hz_utility_pub.CREATION_DATE,
1875: hz_utility_pub.LAST_UPDATE_LOGIN,
1876: hz_utility_pub.LAST_UPDATE_DATE,
1877: hz_utility_pub.LAST_UPDATED_BY
1878: from oe_header_acks h,
1879: ra_customer_merges m
1880: where

Line 1877: hz_utility_pub.LAST_UPDATED_BY

1873: hz_utility_pub.CREATED_BY,
1874: hz_utility_pub.CREATION_DATE,
1875: hz_utility_pub.LAST_UPDATE_LOGIN,
1876: hz_utility_pub.LAST_UPDATE_DATE,
1877: hz_utility_pub.LAST_UPDATED_BY
1878: from oe_header_acks h,
1879: ra_customer_merges m
1880: where
1881: h.end_customer_id=m.duplicate_site_id

Line 2326: hz_utility_pub.CREATED_BY,

2322: line_end_cust_id_tab(I),
2323: decode(line_end_cust_id_tab(I),NULL,old_line_end_cust_id_tab(I),line_end_cust_id_tab(i)),
2324: 'U',
2325: req_id,
2326: hz_utility_pub.CREATED_BY,
2327: hz_utility_pub.CREATION_DATE,
2328: hz_utility_pub.LAST_UPDATE_LOGIN,
2329: hz_utility_pub.LAST_UPDATE_DATE,
2330: hz_utility_pub.LAST_UPDATED_BY

Line 2327: hz_utility_pub.CREATION_DATE,

2323: decode(line_end_cust_id_tab(I),NULL,old_line_end_cust_id_tab(I),line_end_cust_id_tab(i)),
2324: 'U',
2325: req_id,
2326: hz_utility_pub.CREATED_BY,
2327: hz_utility_pub.CREATION_DATE,
2328: hz_utility_pub.LAST_UPDATE_LOGIN,
2329: hz_utility_pub.LAST_UPDATE_DATE,
2330: hz_utility_pub.LAST_UPDATED_BY
2331: );

Line 2328: hz_utility_pub.LAST_UPDATE_LOGIN,

2324: 'U',
2325: req_id,
2326: hz_utility_pub.CREATED_BY,
2327: hz_utility_pub.CREATION_DATE,
2328: hz_utility_pub.LAST_UPDATE_LOGIN,
2329: hz_utility_pub.LAST_UPDATE_DATE,
2330: hz_utility_pub.LAST_UPDATED_BY
2331: );
2332:

Line 2329: hz_utility_pub.LAST_UPDATE_DATE,

2325: req_id,
2326: hz_utility_pub.CREATED_BY,
2327: hz_utility_pub.CREATION_DATE,
2328: hz_utility_pub.LAST_UPDATE_LOGIN,
2329: hz_utility_pub.LAST_UPDATE_DATE,
2330: hz_utility_pub.LAST_UPDATED_BY
2331: );
2332:
2333: end if;

Line 2330: hz_utility_pub.LAST_UPDATED_BY

2326: hz_utility_pub.CREATED_BY,
2327: hz_utility_pub.CREATION_DATE,
2328: hz_utility_pub.LAST_UPDATE_LOGIN,
2329: hz_utility_pub.LAST_UPDATE_DATE,
2330: hz_utility_pub.LAST_UPDATED_BY
2331: );
2332:
2333: end if;
2334: end if;

Line 3078: hz_utility_pub.CREATED_BY,

3074: a.ship_to_org_id,
3075: m.customer_site_id,
3076: 'U',
3077: req_id,
3078: hz_utility_pub.CREATED_BY,
3079: hz_utility_pub.CREATION_DATE,
3080: hz_utility_pub.LAST_UPDATE_LOGIN,
3081: hz_utility_pub.LAST_UPDATE_DATE,
3082: hz_utility_pub.LAST_UPDATED_BY

Line 3079: hz_utility_pub.CREATION_DATE,

3075: m.customer_site_id,
3076: 'U',
3077: req_id,
3078: hz_utility_pub.CREATED_BY,
3079: hz_utility_pub.CREATION_DATE,
3080: hz_utility_pub.LAST_UPDATE_LOGIN,
3081: hz_utility_pub.LAST_UPDATE_DATE,
3082: hz_utility_pub.LAST_UPDATED_BY
3083: from oe_line_acks a,

Line 3080: hz_utility_pub.LAST_UPDATE_LOGIN,

3076: 'U',
3077: req_id,
3078: hz_utility_pub.CREATED_BY,
3079: hz_utility_pub.CREATION_DATE,
3080: hz_utility_pub.LAST_UPDATE_LOGIN,
3081: hz_utility_pub.LAST_UPDATE_DATE,
3082: hz_utility_pub.LAST_UPDATED_BY
3083: from oe_line_acks a,
3084: ra_customer_merges m

Line 3081: hz_utility_pub.LAST_UPDATE_DATE,

3077: req_id,
3078: hz_utility_pub.CREATED_BY,
3079: hz_utility_pub.CREATION_DATE,
3080: hz_utility_pub.LAST_UPDATE_LOGIN,
3081: hz_utility_pub.LAST_UPDATE_DATE,
3082: hz_utility_pub.LAST_UPDATED_BY
3083: from oe_line_acks a,
3084: ra_customer_merges m
3085: where m.process_flag = 'N'

Line 3082: hz_utility_pub.LAST_UPDATED_BY

3078: hz_utility_pub.CREATED_BY,
3079: hz_utility_pub.CREATION_DATE,
3080: hz_utility_pub.LAST_UPDATE_LOGIN,
3081: hz_utility_pub.LAST_UPDATE_DATE,
3082: hz_utility_pub.LAST_UPDATED_BY
3083: from oe_line_acks a,
3084: ra_customer_merges m
3085: where m.process_flag = 'N'
3086: and a.ship_to_org_id = m.duplicate_site_id

Line 3147: hz_utility_pub.CREATED_BY,

3143: a.invoice_to_org_id,
3144: m.customer_site_id,
3145: 'U',
3146: req_id,
3147: hz_utility_pub.CREATED_BY,
3148: hz_utility_pub.CREATION_DATE,
3149: hz_utility_pub.LAST_UPDATE_LOGIN,
3150: hz_utility_pub.LAST_UPDATE_DATE,
3151: hz_utility_pub.LAST_UPDATED_BY

Line 3148: hz_utility_pub.CREATION_DATE,

3144: m.customer_site_id,
3145: 'U',
3146: req_id,
3147: hz_utility_pub.CREATED_BY,
3148: hz_utility_pub.CREATION_DATE,
3149: hz_utility_pub.LAST_UPDATE_LOGIN,
3150: hz_utility_pub.LAST_UPDATE_DATE,
3151: hz_utility_pub.LAST_UPDATED_BY
3152: from oe_line_acks a,

Line 3149: hz_utility_pub.LAST_UPDATE_LOGIN,

3145: 'U',
3146: req_id,
3147: hz_utility_pub.CREATED_BY,
3148: hz_utility_pub.CREATION_DATE,
3149: hz_utility_pub.LAST_UPDATE_LOGIN,
3150: hz_utility_pub.LAST_UPDATE_DATE,
3151: hz_utility_pub.LAST_UPDATED_BY
3152: from oe_line_acks a,
3153: ra_customer_merges m

Line 3150: hz_utility_pub.LAST_UPDATE_DATE,

3146: req_id,
3147: hz_utility_pub.CREATED_BY,
3148: hz_utility_pub.CREATION_DATE,
3149: hz_utility_pub.LAST_UPDATE_LOGIN,
3150: hz_utility_pub.LAST_UPDATE_DATE,
3151: hz_utility_pub.LAST_UPDATED_BY
3152: from oe_line_acks a,
3153: ra_customer_merges m
3154: where m.process_flag = 'N'

Line 3151: hz_utility_pub.LAST_UPDATED_BY

3147: hz_utility_pub.CREATED_BY,
3148: hz_utility_pub.CREATION_DATE,
3149: hz_utility_pub.LAST_UPDATE_LOGIN,
3150: hz_utility_pub.LAST_UPDATE_DATE,
3151: hz_utility_pub.LAST_UPDATED_BY
3152: from oe_line_acks a,
3153: ra_customer_merges m
3154: where m.process_flag = 'N'
3155: and a.invoice_to_org_id = m.duplicate_site_id

Line 3215: hz_utility_pub.CREATED_BY,

3211: a.deliver_to_org_id,
3212: m.customer_site_id,
3213: 'U',
3214: req_id,
3215: hz_utility_pub.CREATED_BY,
3216: hz_utility_pub.CREATION_DATE,
3217: hz_utility_pub.LAST_UPDATE_LOGIN,
3218: hz_utility_pub.LAST_UPDATE_DATE,
3219: hz_utility_pub.LAST_UPDATED_BY

Line 3216: hz_utility_pub.CREATION_DATE,

3212: m.customer_site_id,
3213: 'U',
3214: req_id,
3215: hz_utility_pub.CREATED_BY,
3216: hz_utility_pub.CREATION_DATE,
3217: hz_utility_pub.LAST_UPDATE_LOGIN,
3218: hz_utility_pub.LAST_UPDATE_DATE,
3219: hz_utility_pub.LAST_UPDATED_BY
3220: from oe_line_acks a,

Line 3217: hz_utility_pub.LAST_UPDATE_LOGIN,

3213: 'U',
3214: req_id,
3215: hz_utility_pub.CREATED_BY,
3216: hz_utility_pub.CREATION_DATE,
3217: hz_utility_pub.LAST_UPDATE_LOGIN,
3218: hz_utility_pub.LAST_UPDATE_DATE,
3219: hz_utility_pub.LAST_UPDATED_BY
3220: from oe_line_acks a,
3221: ra_customer_merges m

Line 3218: hz_utility_pub.LAST_UPDATE_DATE,

3214: req_id,
3215: hz_utility_pub.CREATED_BY,
3216: hz_utility_pub.CREATION_DATE,
3217: hz_utility_pub.LAST_UPDATE_LOGIN,
3218: hz_utility_pub.LAST_UPDATE_DATE,
3219: hz_utility_pub.LAST_UPDATED_BY
3220: from oe_line_acks a,
3221: ra_customer_merges m
3222: where m.process_flag = 'N'

Line 3219: hz_utility_pub.LAST_UPDATED_BY

3215: hz_utility_pub.CREATED_BY,
3216: hz_utility_pub.CREATION_DATE,
3217: hz_utility_pub.LAST_UPDATE_LOGIN,
3218: hz_utility_pub.LAST_UPDATE_DATE,
3219: hz_utility_pub.LAST_UPDATED_BY
3220: from oe_line_acks a,
3221: ra_customer_merges m
3222: where m.process_flag = 'N'
3223: and a.deliver_to_org_id = m.duplicate_site_id

Line 3283: hz_utility_pub.CREATED_BY,

3279: a.intmed_ship_to_org_id,
3280: m.customer_site_id,
3281: 'U',
3282: req_id,
3283: hz_utility_pub.CREATED_BY,
3284: hz_utility_pub.CREATION_DATE,
3285: hz_utility_pub.LAST_UPDATE_LOGIN,
3286: hz_utility_pub.LAST_UPDATE_DATE,
3287: hz_utility_pub.LAST_UPDATED_BY

Line 3284: hz_utility_pub.CREATION_DATE,

3280: m.customer_site_id,
3281: 'U',
3282: req_id,
3283: hz_utility_pub.CREATED_BY,
3284: hz_utility_pub.CREATION_DATE,
3285: hz_utility_pub.LAST_UPDATE_LOGIN,
3286: hz_utility_pub.LAST_UPDATE_DATE,
3287: hz_utility_pub.LAST_UPDATED_BY
3288: from oe_line_acks a,

Line 3285: hz_utility_pub.LAST_UPDATE_LOGIN,

3281: 'U',
3282: req_id,
3283: hz_utility_pub.CREATED_BY,
3284: hz_utility_pub.CREATION_DATE,
3285: hz_utility_pub.LAST_UPDATE_LOGIN,
3286: hz_utility_pub.LAST_UPDATE_DATE,
3287: hz_utility_pub.LAST_UPDATED_BY
3288: from oe_line_acks a,
3289: ra_customer_merges m

Line 3286: hz_utility_pub.LAST_UPDATE_DATE,

3282: req_id,
3283: hz_utility_pub.CREATED_BY,
3284: hz_utility_pub.CREATION_DATE,
3285: hz_utility_pub.LAST_UPDATE_LOGIN,
3286: hz_utility_pub.LAST_UPDATE_DATE,
3287: hz_utility_pub.LAST_UPDATED_BY
3288: from oe_line_acks a,
3289: ra_customer_merges m
3290: where m.process_flag = 'N'

Line 3287: hz_utility_pub.LAST_UPDATED_BY

3283: hz_utility_pub.CREATED_BY,
3284: hz_utility_pub.CREATION_DATE,
3285: hz_utility_pub.LAST_UPDATE_LOGIN,
3286: hz_utility_pub.LAST_UPDATE_DATE,
3287: hz_utility_pub.LAST_UPDATED_BY
3288: from oe_line_acks a,
3289: ra_customer_merges m
3290: where m.process_flag = 'N'
3291: and a.intmed_ship_to_org_id = m.duplicate_site_id

Line 3357: hz_utility_pub.CREATED_BY,

3353: a.sold_to_org_id,
3354: m.customer_site_id,
3355: 'U',
3356: req_id,
3357: hz_utility_pub.CREATED_BY,
3358: hz_utility_pub.CREATION_DATE,
3359: hz_utility_pub.LAST_UPDATE_LOGIN,
3360: hz_utility_pub.LAST_UPDATE_DATE,
3361: hz_utility_pub.LAST_UPDATED_BY

Line 3358: hz_utility_pub.CREATION_DATE,

3354: m.customer_site_id,
3355: 'U',
3356: req_id,
3357: hz_utility_pub.CREATED_BY,
3358: hz_utility_pub.CREATION_DATE,
3359: hz_utility_pub.LAST_UPDATE_LOGIN,
3360: hz_utility_pub.LAST_UPDATE_DATE,
3361: hz_utility_pub.LAST_UPDATED_BY
3362: from oe_line_acks a,

Line 3359: hz_utility_pub.LAST_UPDATE_LOGIN,

3355: 'U',
3356: req_id,
3357: hz_utility_pub.CREATED_BY,
3358: hz_utility_pub.CREATION_DATE,
3359: hz_utility_pub.LAST_UPDATE_LOGIN,
3360: hz_utility_pub.LAST_UPDATE_DATE,
3361: hz_utility_pub.LAST_UPDATED_BY
3362: from oe_line_acks a,
3363: ra_customer_merges m

Line 3360: hz_utility_pub.LAST_UPDATE_DATE,

3356: req_id,
3357: hz_utility_pub.CREATED_BY,
3358: hz_utility_pub.CREATION_DATE,
3359: hz_utility_pub.LAST_UPDATE_LOGIN,
3360: hz_utility_pub.LAST_UPDATE_DATE,
3361: hz_utility_pub.LAST_UPDATED_BY
3362: from oe_line_acks a,
3363: ra_customer_merges m
3364: where m.process_flag = 'N'

Line 3361: hz_utility_pub.LAST_UPDATED_BY

3357: hz_utility_pub.CREATED_BY,
3358: hz_utility_pub.CREATION_DATE,
3359: hz_utility_pub.LAST_UPDATE_LOGIN,
3360: hz_utility_pub.LAST_UPDATE_DATE,
3361: hz_utility_pub.LAST_UPDATED_BY
3362: from oe_line_acks a,
3363: ra_customer_merges m
3364: where m.process_flag = 'N'
3365: and a.sold_to_org_id = m.duplicate_site_id

Line 3434: hz_utility_pub.CREATED_BY,

3430: a.end_customer_site_use_id,
3431: m.customer_site_id,
3432: 'U',
3433: req_id,
3434: hz_utility_pub.CREATED_BY,
3435: hz_utility_pub.CREATION_DATE,
3436: hz_utility_pub.LAST_UPDATE_LOGIN,
3437: hz_utility_pub.LAST_UPDATE_DATE,
3438: hz_utility_pub.LAST_UPDATED_BY

Line 3435: hz_utility_pub.CREATION_DATE,

3431: m.customer_site_id,
3432: 'U',
3433: req_id,
3434: hz_utility_pub.CREATED_BY,
3435: hz_utility_pub.CREATION_DATE,
3436: hz_utility_pub.LAST_UPDATE_LOGIN,
3437: hz_utility_pub.LAST_UPDATE_DATE,
3438: hz_utility_pub.LAST_UPDATED_BY
3439: from oe_line_acks a,

Line 3436: hz_utility_pub.LAST_UPDATE_LOGIN,

3432: 'U',
3433: req_id,
3434: hz_utility_pub.CREATED_BY,
3435: hz_utility_pub.CREATION_DATE,
3436: hz_utility_pub.LAST_UPDATE_LOGIN,
3437: hz_utility_pub.LAST_UPDATE_DATE,
3438: hz_utility_pub.LAST_UPDATED_BY
3439: from oe_line_acks a,
3440: ra_customer_merges m

Line 3437: hz_utility_pub.LAST_UPDATE_DATE,

3433: req_id,
3434: hz_utility_pub.CREATED_BY,
3435: hz_utility_pub.CREATION_DATE,
3436: hz_utility_pub.LAST_UPDATE_LOGIN,
3437: hz_utility_pub.LAST_UPDATE_DATE,
3438: hz_utility_pub.LAST_UPDATED_BY
3439: from oe_line_acks a,
3440: ra_customer_merges m
3441: where m.process_flag = 'N'

Line 3438: hz_utility_pub.LAST_UPDATED_BY

3434: hz_utility_pub.CREATED_BY,
3435: hz_utility_pub.CREATION_DATE,
3436: hz_utility_pub.LAST_UPDATE_LOGIN,
3437: hz_utility_pub.LAST_UPDATE_DATE,
3438: hz_utility_pub.LAST_UPDATED_BY
3439: from oe_line_acks a,
3440: ra_customer_merges m
3441: where m.process_flag = 'N'
3442: and a.sold_to_org_id = m.duplicate_site_id

Line 3509: hz_utility_pub.CREATED_BY,

3505: a.end_customer_id,
3506: m.customer_site_id,
3507: 'U',
3508: req_id,
3509: hz_utility_pub.CREATED_BY,
3510: hz_utility_pub.CREATION_DATE,
3511: hz_utility_pub.LAST_UPDATE_LOGIN,
3512: hz_utility_pub.LAST_UPDATE_DATE,
3513: hz_utility_pub.LAST_UPDATED_BY

Line 3510: hz_utility_pub.CREATION_DATE,

3506: m.customer_site_id,
3507: 'U',
3508: req_id,
3509: hz_utility_pub.CREATED_BY,
3510: hz_utility_pub.CREATION_DATE,
3511: hz_utility_pub.LAST_UPDATE_LOGIN,
3512: hz_utility_pub.LAST_UPDATE_DATE,
3513: hz_utility_pub.LAST_UPDATED_BY
3514: from oe_line_acks a,

Line 3511: hz_utility_pub.LAST_UPDATE_LOGIN,

3507: 'U',
3508: req_id,
3509: hz_utility_pub.CREATED_BY,
3510: hz_utility_pub.CREATION_DATE,
3511: hz_utility_pub.LAST_UPDATE_LOGIN,
3512: hz_utility_pub.LAST_UPDATE_DATE,
3513: hz_utility_pub.LAST_UPDATED_BY
3514: from oe_line_acks a,
3515: ra_customer_merges m

Line 3512: hz_utility_pub.LAST_UPDATE_DATE,

3508: req_id,
3509: hz_utility_pub.CREATED_BY,
3510: hz_utility_pub.CREATION_DATE,
3511: hz_utility_pub.LAST_UPDATE_LOGIN,
3512: hz_utility_pub.LAST_UPDATE_DATE,
3513: hz_utility_pub.LAST_UPDATED_BY
3514: from oe_line_acks a,
3515: ra_customer_merges m
3516: where m.process_flag = 'N'

Line 3513: hz_utility_pub.LAST_UPDATED_BY

3509: hz_utility_pub.CREATED_BY,
3510: hz_utility_pub.CREATION_DATE,
3511: hz_utility_pub.LAST_UPDATE_LOGIN,
3512: hz_utility_pub.LAST_UPDATE_DATE,
3513: hz_utility_pub.LAST_UPDATED_BY
3514: from oe_line_acks a,
3515: ra_customer_merges m
3516: where m.process_flag = 'N'
3517: and a.end_customer_id = m.duplicate_site_id

Line 3707: hz_utility_pub.CREATED_BY,

3703: a.attribute_value,
3704: to_char(m.customer_site_id),
3705: 'U',
3706: req_id,
3707: hz_utility_pub.CREATED_BY,
3708: hz_utility_pub.CREATION_DATE,
3709: hz_utility_pub.LAST_UPDATE_LOGIN,
3710: hz_utility_pub.LAST_UPDATE_DATE,
3711: hz_utility_pub.LAST_UPDATED_BY

Line 3708: hz_utility_pub.CREATION_DATE,

3704: to_char(m.customer_site_id),
3705: 'U',
3706: req_id,
3707: hz_utility_pub.CREATED_BY,
3708: hz_utility_pub.CREATION_DATE,
3709: hz_utility_pub.LAST_UPDATE_LOGIN,
3710: hz_utility_pub.LAST_UPDATE_DATE,
3711: hz_utility_pub.LAST_UPDATED_BY
3712: from OE_ATTACHMENT_RULE_ELEMENTS a,

Line 3709: hz_utility_pub.LAST_UPDATE_LOGIN,

3705: 'U',
3706: req_id,
3707: hz_utility_pub.CREATED_BY,
3708: hz_utility_pub.CREATION_DATE,
3709: hz_utility_pub.LAST_UPDATE_LOGIN,
3710: hz_utility_pub.LAST_UPDATE_DATE,
3711: hz_utility_pub.LAST_UPDATED_BY
3712: from OE_ATTACHMENT_RULE_ELEMENTS a,
3713: ra_customer_merges m

Line 3710: hz_utility_pub.LAST_UPDATE_DATE,

3706: req_id,
3707: hz_utility_pub.CREATED_BY,
3708: hz_utility_pub.CREATION_DATE,
3709: hz_utility_pub.LAST_UPDATE_LOGIN,
3710: hz_utility_pub.LAST_UPDATE_DATE,
3711: hz_utility_pub.LAST_UPDATED_BY
3712: from OE_ATTACHMENT_RULE_ELEMENTS a,
3713: ra_customer_merges m
3714: where a.attribute_value = to_char(m.duplicate_site_id)

Line 3711: hz_utility_pub.LAST_UPDATED_BY

3707: hz_utility_pub.CREATED_BY,
3708: hz_utility_pub.CREATION_DATE,
3709: hz_utility_pub.LAST_UPDATE_LOGIN,
3710: hz_utility_pub.LAST_UPDATE_DATE,
3711: hz_utility_pub.LAST_UPDATED_BY
3712: from OE_ATTACHMENT_RULE_ELEMENTS a,
3713: ra_customer_merges m
3714: where a.attribute_value = to_char(m.duplicate_site_id)
3715: and m.process_flag = 'N'

Line 3775: hz_utility_pub.CREATED_BY,

3771: a.attribute_value,
3772: to_char(m.customer_site_id),
3773: 'U',
3774: req_id,
3775: hz_utility_pub.CREATED_BY,
3776: hz_utility_pub.CREATION_DATE,
3777: hz_utility_pub.LAST_UPDATE_LOGIN,
3778: hz_utility_pub.LAST_UPDATE_DATE,
3779: hz_utility_pub.LAST_UPDATED_BY

Line 3776: hz_utility_pub.CREATION_DATE,

3772: to_char(m.customer_site_id),
3773: 'U',
3774: req_id,
3775: hz_utility_pub.CREATED_BY,
3776: hz_utility_pub.CREATION_DATE,
3777: hz_utility_pub.LAST_UPDATE_LOGIN,
3778: hz_utility_pub.LAST_UPDATE_DATE,
3779: hz_utility_pub.LAST_UPDATED_BY
3780: from OE_ATTACHMENT_RULE_ELEMENTS a,

Line 3777: hz_utility_pub.LAST_UPDATE_LOGIN,

3773: 'U',
3774: req_id,
3775: hz_utility_pub.CREATED_BY,
3776: hz_utility_pub.CREATION_DATE,
3777: hz_utility_pub.LAST_UPDATE_LOGIN,
3778: hz_utility_pub.LAST_UPDATE_DATE,
3779: hz_utility_pub.LAST_UPDATED_BY
3780: from OE_ATTACHMENT_RULE_ELEMENTS a,
3781: ra_customer_merges m

Line 3778: hz_utility_pub.LAST_UPDATE_DATE,

3774: req_id,
3775: hz_utility_pub.CREATED_BY,
3776: hz_utility_pub.CREATION_DATE,
3777: hz_utility_pub.LAST_UPDATE_LOGIN,
3778: hz_utility_pub.LAST_UPDATE_DATE,
3779: hz_utility_pub.LAST_UPDATED_BY
3780: from OE_ATTACHMENT_RULE_ELEMENTS a,
3781: ra_customer_merges m
3782: where a.attribute_value = to_char(m.duplicate_site_id)

Line 3779: hz_utility_pub.LAST_UPDATED_BY

3775: hz_utility_pub.CREATED_BY,
3776: hz_utility_pub.CREATION_DATE,
3777: hz_utility_pub.LAST_UPDATE_LOGIN,
3778: hz_utility_pub.LAST_UPDATE_DATE,
3779: hz_utility_pub.LAST_UPDATED_BY
3780: from OE_ATTACHMENT_RULE_ELEMENTS a,
3781: ra_customer_merges m
3782: where a.attribute_value = to_char(m.duplicate_site_id)
3783: and m.process_flag = 'N'

Line 3844: hz_utility_pub.CREATED_BY,

3840: a.attribute_value,
3841: to_char(m.customer_site_id),
3842: 'U',
3843: req_id,
3844: hz_utility_pub.CREATED_BY,
3845: hz_utility_pub.CREATION_DATE,
3846: hz_utility_pub.LAST_UPDATE_LOGIN,
3847: hz_utility_pub.LAST_UPDATE_DATE,
3848: hz_utility_pub.LAST_UPDATED_BY

Line 3845: hz_utility_pub.CREATION_DATE,

3841: to_char(m.customer_site_id),
3842: 'U',
3843: req_id,
3844: hz_utility_pub.CREATED_BY,
3845: hz_utility_pub.CREATION_DATE,
3846: hz_utility_pub.LAST_UPDATE_LOGIN,
3847: hz_utility_pub.LAST_UPDATE_DATE,
3848: hz_utility_pub.LAST_UPDATED_BY
3849: from OE_ATTACHMENT_RULE_ELEMENTS a,

Line 3846: hz_utility_pub.LAST_UPDATE_LOGIN,

3842: 'U',
3843: req_id,
3844: hz_utility_pub.CREATED_BY,
3845: hz_utility_pub.CREATION_DATE,
3846: hz_utility_pub.LAST_UPDATE_LOGIN,
3847: hz_utility_pub.LAST_UPDATE_DATE,
3848: hz_utility_pub.LAST_UPDATED_BY
3849: from OE_ATTACHMENT_RULE_ELEMENTS a,
3850: ra_customer_merges m

Line 3847: hz_utility_pub.LAST_UPDATE_DATE,

3843: req_id,
3844: hz_utility_pub.CREATED_BY,
3845: hz_utility_pub.CREATION_DATE,
3846: hz_utility_pub.LAST_UPDATE_LOGIN,
3847: hz_utility_pub.LAST_UPDATE_DATE,
3848: hz_utility_pub.LAST_UPDATED_BY
3849: from OE_ATTACHMENT_RULE_ELEMENTS a,
3850: ra_customer_merges m
3851: where a.attribute_value = to_char(m.duplicate_site_id)

Line 3848: hz_utility_pub.LAST_UPDATED_BY

3844: hz_utility_pub.CREATED_BY,
3845: hz_utility_pub.CREATION_DATE,
3846: hz_utility_pub.LAST_UPDATE_LOGIN,
3847: hz_utility_pub.LAST_UPDATE_DATE,
3848: hz_utility_pub.LAST_UPDATED_BY
3849: from OE_ATTACHMENT_RULE_ELEMENTS a,
3850: ra_customer_merges m
3851: where a.attribute_value = to_char(m.duplicate_site_id)
3852: and m.process_flag = 'N'

Line 4064: hz_utility_pub.CREATED_BY,

4060: a.value_string,
4061: to_char(m.customer_site_id),
4062: 'U',
4063: req_id,
4064: hz_utility_pub.CREATED_BY,
4065: hz_utility_pub.CREATION_DATE,
4066: hz_utility_pub.LAST_UPDATE_LOGIN,
4067: hz_utility_pub.LAST_UPDATE_DATE,
4068: hz_utility_pub.LAST_UPDATED_BY

Line 4065: hz_utility_pub.CREATION_DATE,

4061: to_char(m.customer_site_id),
4062: 'U',
4063: req_id,
4064: hz_utility_pub.CREATED_BY,
4065: hz_utility_pub.CREATION_DATE,
4066: hz_utility_pub.LAST_UPDATE_LOGIN,
4067: hz_utility_pub.LAST_UPDATE_DATE,
4068: hz_utility_pub.LAST_UPDATED_BY
4069: from OE_DEF_CONDN_ELEMS a,

Line 4066: hz_utility_pub.LAST_UPDATE_LOGIN,

4062: 'U',
4063: req_id,
4064: hz_utility_pub.CREATED_BY,
4065: hz_utility_pub.CREATION_DATE,
4066: hz_utility_pub.LAST_UPDATE_LOGIN,
4067: hz_utility_pub.LAST_UPDATE_DATE,
4068: hz_utility_pub.LAST_UPDATED_BY
4069: from OE_DEF_CONDN_ELEMS a,
4070: ra_customer_merges m

Line 4067: hz_utility_pub.LAST_UPDATE_DATE,

4063: req_id,
4064: hz_utility_pub.CREATED_BY,
4065: hz_utility_pub.CREATION_DATE,
4066: hz_utility_pub.LAST_UPDATE_LOGIN,
4067: hz_utility_pub.LAST_UPDATE_DATE,
4068: hz_utility_pub.LAST_UPDATED_BY
4069: from OE_DEF_CONDN_ELEMS a,
4070: ra_customer_merges m
4071: where a.value_string = to_char(m.duplicate_site_id)

Line 4068: hz_utility_pub.LAST_UPDATED_BY

4064: hz_utility_pub.CREATED_BY,
4065: hz_utility_pub.CREATION_DATE,
4066: hz_utility_pub.LAST_UPDATE_LOGIN,
4067: hz_utility_pub.LAST_UPDATE_DATE,
4068: hz_utility_pub.LAST_UPDATED_BY
4069: from OE_DEF_CONDN_ELEMS a,
4070: ra_customer_merges m
4071: where a.value_string = to_char(m.duplicate_site_id)
4072: and m.process_flag = 'N'

Line 4131: hz_utility_pub.CREATED_BY,

4127: a.value_string,
4128: to_char(m.customer_site_id),
4129: 'U',
4130: req_id,
4131: hz_utility_pub.CREATED_BY,
4132: hz_utility_pub.CREATION_DATE,
4133: hz_utility_pub.LAST_UPDATE_LOGIN,
4134: hz_utility_pub.LAST_UPDATE_DATE,
4135: hz_utility_pub.LAST_UPDATED_BY

Line 4132: hz_utility_pub.CREATION_DATE,

4128: to_char(m.customer_site_id),
4129: 'U',
4130: req_id,
4131: hz_utility_pub.CREATED_BY,
4132: hz_utility_pub.CREATION_DATE,
4133: hz_utility_pub.LAST_UPDATE_LOGIN,
4134: hz_utility_pub.LAST_UPDATE_DATE,
4135: hz_utility_pub.LAST_UPDATED_BY
4136: from OE_DEF_CONDN_ELEMS a,

Line 4133: hz_utility_pub.LAST_UPDATE_LOGIN,

4129: 'U',
4130: req_id,
4131: hz_utility_pub.CREATED_BY,
4132: hz_utility_pub.CREATION_DATE,
4133: hz_utility_pub.LAST_UPDATE_LOGIN,
4134: hz_utility_pub.LAST_UPDATE_DATE,
4135: hz_utility_pub.LAST_UPDATED_BY
4136: from OE_DEF_CONDN_ELEMS a,
4137: ra_customer_merges m

Line 4134: hz_utility_pub.LAST_UPDATE_DATE,

4130: req_id,
4131: hz_utility_pub.CREATED_BY,
4132: hz_utility_pub.CREATION_DATE,
4133: hz_utility_pub.LAST_UPDATE_LOGIN,
4134: hz_utility_pub.LAST_UPDATE_DATE,
4135: hz_utility_pub.LAST_UPDATED_BY
4136: from OE_DEF_CONDN_ELEMS a,
4137: ra_customer_merges m
4138: where a.value_string = to_char(m.duplicate_site_id)

Line 4135: hz_utility_pub.LAST_UPDATED_BY

4131: hz_utility_pub.CREATED_BY,
4132: hz_utility_pub.CREATION_DATE,
4133: hz_utility_pub.LAST_UPDATE_LOGIN,
4134: hz_utility_pub.LAST_UPDATE_DATE,
4135: hz_utility_pub.LAST_UPDATED_BY
4136: from OE_DEF_CONDN_ELEMS a,
4137: ra_customer_merges m
4138: where a.value_string = to_char(m.duplicate_site_id)
4139: and m.process_flag = 'N'

Line 4200: hz_utility_pub.CREATED_BY,

4196: a.value_string,
4197: to_char(m.customer_site_id),
4198: 'U',
4199: req_id,
4200: hz_utility_pub.CREATED_BY,
4201: hz_utility_pub.CREATION_DATE,
4202: hz_utility_pub.LAST_UPDATE_LOGIN,
4203: hz_utility_pub.LAST_UPDATE_DATE,
4204: hz_utility_pub.LAST_UPDATED_BY

Line 4201: hz_utility_pub.CREATION_DATE,

4197: to_char(m.customer_site_id),
4198: 'U',
4199: req_id,
4200: hz_utility_pub.CREATED_BY,
4201: hz_utility_pub.CREATION_DATE,
4202: hz_utility_pub.LAST_UPDATE_LOGIN,
4203: hz_utility_pub.LAST_UPDATE_DATE,
4204: hz_utility_pub.LAST_UPDATED_BY
4205: from OE_DEF_CONDN_ELEMS a,

Line 4202: hz_utility_pub.LAST_UPDATE_LOGIN,

4198: 'U',
4199: req_id,
4200: hz_utility_pub.CREATED_BY,
4201: hz_utility_pub.CREATION_DATE,
4202: hz_utility_pub.LAST_UPDATE_LOGIN,
4203: hz_utility_pub.LAST_UPDATE_DATE,
4204: hz_utility_pub.LAST_UPDATED_BY
4205: from OE_DEF_CONDN_ELEMS a,
4206: ra_customer_merges m

Line 4203: hz_utility_pub.LAST_UPDATE_DATE,

4199: req_id,
4200: hz_utility_pub.CREATED_BY,
4201: hz_utility_pub.CREATION_DATE,
4202: hz_utility_pub.LAST_UPDATE_LOGIN,
4203: hz_utility_pub.LAST_UPDATE_DATE,
4204: hz_utility_pub.LAST_UPDATED_BY
4205: from OE_DEF_CONDN_ELEMS a,
4206: ra_customer_merges m
4207: where a.value_string = to_char(m.duplicate_site_id)

Line 4204: hz_utility_pub.LAST_UPDATED_BY

4200: hz_utility_pub.CREATED_BY,
4201: hz_utility_pub.CREATION_DATE,
4202: hz_utility_pub.LAST_UPDATE_LOGIN,
4203: hz_utility_pub.LAST_UPDATE_DATE,
4204: hz_utility_pub.LAST_UPDATED_BY
4205: from OE_DEF_CONDN_ELEMS a,
4206: ra_customer_merges m
4207: where a.value_string = to_char(m.duplicate_site_id)
4208: and m.process_flag = 'N'

Line 4268: hz_utility_pub.CREATED_BY,

4264: a.value_string,
4265: to_char(m.customer_id),
4266: 'U',
4267: req_id,
4268: hz_utility_pub.CREATED_BY,
4269: hz_utility_pub.CREATION_DATE,
4270: hz_utility_pub.LAST_UPDATE_LOGIN,
4271: hz_utility_pub.LAST_UPDATE_DATE,
4272: hz_utility_pub.LAST_UPDATED_BY

Line 4269: hz_utility_pub.CREATION_DATE,

4265: to_char(m.customer_id),
4266: 'U',
4267: req_id,
4268: hz_utility_pub.CREATED_BY,
4269: hz_utility_pub.CREATION_DATE,
4270: hz_utility_pub.LAST_UPDATE_LOGIN,
4271: hz_utility_pub.LAST_UPDATE_DATE,
4272: hz_utility_pub.LAST_UPDATED_BY
4273: from OE_DEF_CONDN_ELEMS a,

Line 4270: hz_utility_pub.LAST_UPDATE_LOGIN,

4266: 'U',
4267: req_id,
4268: hz_utility_pub.CREATED_BY,
4269: hz_utility_pub.CREATION_DATE,
4270: hz_utility_pub.LAST_UPDATE_LOGIN,
4271: hz_utility_pub.LAST_UPDATE_DATE,
4272: hz_utility_pub.LAST_UPDATED_BY
4273: from OE_DEF_CONDN_ELEMS a,
4274: ra_customer_merges m

Line 4271: hz_utility_pub.LAST_UPDATE_DATE,

4267: req_id,
4268: hz_utility_pub.CREATED_BY,
4269: hz_utility_pub.CREATION_DATE,
4270: hz_utility_pub.LAST_UPDATE_LOGIN,
4271: hz_utility_pub.LAST_UPDATE_DATE,
4272: hz_utility_pub.LAST_UPDATED_BY
4273: from OE_DEF_CONDN_ELEMS a,
4274: ra_customer_merges m
4275: where a.value_string = to_char(m.duplicate_id)

Line 4272: hz_utility_pub.LAST_UPDATED_BY

4268: hz_utility_pub.CREATED_BY,
4269: hz_utility_pub.CREATION_DATE,
4270: hz_utility_pub.LAST_UPDATE_LOGIN,
4271: hz_utility_pub.LAST_UPDATE_DATE,
4272: hz_utility_pub.LAST_UPDATED_BY
4273: from OE_DEF_CONDN_ELEMS a,
4274: ra_customer_merges m
4275: where a.value_string = to_char(m.duplicate_id)
4276: and m.process_flag = 'N'

Line 4338: hz_utility_pub.CREATED_BY,

4334: a.src_constant_value,
4335: to_char(m.customer_site_id),
4336: 'U',
4337: req_id,
4338: hz_utility_pub.CREATED_BY,
4339: hz_utility_pub.CREATION_DATE,
4340: hz_utility_pub.LAST_UPDATE_LOGIN,
4341: hz_utility_pub.LAST_UPDATE_DATE,
4342: hz_utility_pub.LAST_UPDATED_BY

Line 4339: hz_utility_pub.CREATION_DATE,

4335: to_char(m.customer_site_id),
4336: 'U',
4337: req_id,
4338: hz_utility_pub.CREATED_BY,
4339: hz_utility_pub.CREATION_DATE,
4340: hz_utility_pub.LAST_UPDATE_LOGIN,
4341: hz_utility_pub.LAST_UPDATE_DATE,
4342: hz_utility_pub.LAST_UPDATED_BY
4343: from OE_DEF_ATTR_DEF_RULES a,

Line 4340: hz_utility_pub.LAST_UPDATE_LOGIN,

4336: 'U',
4337: req_id,
4338: hz_utility_pub.CREATED_BY,
4339: hz_utility_pub.CREATION_DATE,
4340: hz_utility_pub.LAST_UPDATE_LOGIN,
4341: hz_utility_pub.LAST_UPDATE_DATE,
4342: hz_utility_pub.LAST_UPDATED_BY
4343: from OE_DEF_ATTR_DEF_RULES a,
4344: ra_customer_merges m

Line 4341: hz_utility_pub.LAST_UPDATE_DATE,

4337: req_id,
4338: hz_utility_pub.CREATED_BY,
4339: hz_utility_pub.CREATION_DATE,
4340: hz_utility_pub.LAST_UPDATE_LOGIN,
4341: hz_utility_pub.LAST_UPDATE_DATE,
4342: hz_utility_pub.LAST_UPDATED_BY
4343: from OE_DEF_ATTR_DEF_RULES a,
4344: ra_customer_merges m
4345: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 4342: hz_utility_pub.LAST_UPDATED_BY

4338: hz_utility_pub.CREATED_BY,
4339: hz_utility_pub.CREATION_DATE,
4340: hz_utility_pub.LAST_UPDATE_LOGIN,
4341: hz_utility_pub.LAST_UPDATE_DATE,
4342: hz_utility_pub.LAST_UPDATED_BY
4343: from OE_DEF_ATTR_DEF_RULES a,
4344: ra_customer_merges m
4345: where a.src_constant_value = to_char(m.duplicate_site_id)
4346: and m.process_flag = 'N'

Line 4408: hz_utility_pub.CREATED_BY,

4404: a.src_constant_value,
4405: to_char(m.customer_site_id),
4406: 'U',
4407: req_id,
4408: hz_utility_pub.CREATED_BY,
4409: hz_utility_pub.CREATION_DATE,
4410: hz_utility_pub.LAST_UPDATE_LOGIN,
4411: hz_utility_pub.LAST_UPDATE_DATE,
4412: hz_utility_pub.LAST_UPDATED_BY

Line 4409: hz_utility_pub.CREATION_DATE,

4405: to_char(m.customer_site_id),
4406: 'U',
4407: req_id,
4408: hz_utility_pub.CREATED_BY,
4409: hz_utility_pub.CREATION_DATE,
4410: hz_utility_pub.LAST_UPDATE_LOGIN,
4411: hz_utility_pub.LAST_UPDATE_DATE,
4412: hz_utility_pub.LAST_UPDATED_BY
4413: from OE_DEF_ATTR_DEF_RULES a,

Line 4410: hz_utility_pub.LAST_UPDATE_LOGIN,

4406: 'U',
4407: req_id,
4408: hz_utility_pub.CREATED_BY,
4409: hz_utility_pub.CREATION_DATE,
4410: hz_utility_pub.LAST_UPDATE_LOGIN,
4411: hz_utility_pub.LAST_UPDATE_DATE,
4412: hz_utility_pub.LAST_UPDATED_BY
4413: from OE_DEF_ATTR_DEF_RULES a,
4414: ra_customer_merges m

Line 4411: hz_utility_pub.LAST_UPDATE_DATE,

4407: req_id,
4408: hz_utility_pub.CREATED_BY,
4409: hz_utility_pub.CREATION_DATE,
4410: hz_utility_pub.LAST_UPDATE_LOGIN,
4411: hz_utility_pub.LAST_UPDATE_DATE,
4412: hz_utility_pub.LAST_UPDATED_BY
4413: from OE_DEF_ATTR_DEF_RULES a,
4414: ra_customer_merges m
4415: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 4412: hz_utility_pub.LAST_UPDATED_BY

4408: hz_utility_pub.CREATED_BY,
4409: hz_utility_pub.CREATION_DATE,
4410: hz_utility_pub.LAST_UPDATE_LOGIN,
4411: hz_utility_pub.LAST_UPDATE_DATE,
4412: hz_utility_pub.LAST_UPDATED_BY
4413: from OE_DEF_ATTR_DEF_RULES a,
4414: ra_customer_merges m
4415: where a.src_constant_value = to_char(m.duplicate_site_id)
4416: and m.process_flag = 'N'

Line 4476: hz_utility_pub.CREATED_BY,

4472: a.src_constant_value,
4473: to_char(m.customer_site_id),
4474: 'U',
4475: req_id,
4476: hz_utility_pub.CREATED_BY,
4477: hz_utility_pub.CREATION_DATE,
4478: hz_utility_pub.LAST_UPDATE_LOGIN,
4479: hz_utility_pub.LAST_UPDATE_DATE,
4480: hz_utility_pub.LAST_UPDATED_BY

Line 4477: hz_utility_pub.CREATION_DATE,

4473: to_char(m.customer_site_id),
4474: 'U',
4475: req_id,
4476: hz_utility_pub.CREATED_BY,
4477: hz_utility_pub.CREATION_DATE,
4478: hz_utility_pub.LAST_UPDATE_LOGIN,
4479: hz_utility_pub.LAST_UPDATE_DATE,
4480: hz_utility_pub.LAST_UPDATED_BY
4481: from OE_DEF_ATTR_DEF_RULES a,

Line 4478: hz_utility_pub.LAST_UPDATE_LOGIN,

4474: 'U',
4475: req_id,
4476: hz_utility_pub.CREATED_BY,
4477: hz_utility_pub.CREATION_DATE,
4478: hz_utility_pub.LAST_UPDATE_LOGIN,
4479: hz_utility_pub.LAST_UPDATE_DATE,
4480: hz_utility_pub.LAST_UPDATED_BY
4481: from OE_DEF_ATTR_DEF_RULES a,
4482: ra_customer_merges m

Line 4479: hz_utility_pub.LAST_UPDATE_DATE,

4475: req_id,
4476: hz_utility_pub.CREATED_BY,
4477: hz_utility_pub.CREATION_DATE,
4478: hz_utility_pub.LAST_UPDATE_LOGIN,
4479: hz_utility_pub.LAST_UPDATE_DATE,
4480: hz_utility_pub.LAST_UPDATED_BY
4481: from OE_DEF_ATTR_DEF_RULES a,
4482: ra_customer_merges m
4483: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 4480: hz_utility_pub.LAST_UPDATED_BY

4476: hz_utility_pub.CREATED_BY,
4477: hz_utility_pub.CREATION_DATE,
4478: hz_utility_pub.LAST_UPDATE_LOGIN,
4479: hz_utility_pub.LAST_UPDATE_DATE,
4480: hz_utility_pub.LAST_UPDATED_BY
4481: from OE_DEF_ATTR_DEF_RULES a,
4482: ra_customer_merges m
4483: where a.src_constant_value = to_char(m.duplicate_site_id)
4484: and m.process_flag = 'N'

Line 4545: hz_utility_pub.CREATED_BY,

4541: a.src_constant_value,
4542: to_char(m.customer_site_id),
4543: 'U',
4544: req_id,
4545: hz_utility_pub.CREATED_BY,
4546: hz_utility_pub.CREATION_DATE,
4547: hz_utility_pub.LAST_UPDATE_LOGIN,
4548: hz_utility_pub.LAST_UPDATE_DATE,
4549: hz_utility_pub.LAST_UPDATED_BY

Line 4546: hz_utility_pub.CREATION_DATE,

4542: to_char(m.customer_site_id),
4543: 'U',
4544: req_id,
4545: hz_utility_pub.CREATED_BY,
4546: hz_utility_pub.CREATION_DATE,
4547: hz_utility_pub.LAST_UPDATE_LOGIN,
4548: hz_utility_pub.LAST_UPDATE_DATE,
4549: hz_utility_pub.LAST_UPDATED_BY
4550: from OE_DEF_ATTR_DEF_RULES a,

Line 4547: hz_utility_pub.LAST_UPDATE_LOGIN,

4543: 'U',
4544: req_id,
4545: hz_utility_pub.CREATED_BY,
4546: hz_utility_pub.CREATION_DATE,
4547: hz_utility_pub.LAST_UPDATE_LOGIN,
4548: hz_utility_pub.LAST_UPDATE_DATE,
4549: hz_utility_pub.LAST_UPDATED_BY
4550: from OE_DEF_ATTR_DEF_RULES a,
4551: ra_customer_merges m

Line 4548: hz_utility_pub.LAST_UPDATE_DATE,

4544: req_id,
4545: hz_utility_pub.CREATED_BY,
4546: hz_utility_pub.CREATION_DATE,
4547: hz_utility_pub.LAST_UPDATE_LOGIN,
4548: hz_utility_pub.LAST_UPDATE_DATE,
4549: hz_utility_pub.LAST_UPDATED_BY
4550: from OE_DEF_ATTR_DEF_RULES a,
4551: ra_customer_merges m
4552: where a.src_constant_value = to_char(m.duplicate_site_id)

Line 4549: hz_utility_pub.LAST_UPDATED_BY

4545: hz_utility_pub.CREATED_BY,
4546: hz_utility_pub.CREATION_DATE,
4547: hz_utility_pub.LAST_UPDATE_LOGIN,
4548: hz_utility_pub.LAST_UPDATE_DATE,
4549: hz_utility_pub.LAST_UPDATED_BY
4550: from OE_DEF_ATTR_DEF_RULES a,
4551: ra_customer_merges m
4552: where a.src_constant_value = to_char(m.duplicate_site_id)
4553: and m.process_flag = 'N'

Line 4713: hz_utility_pub.CREATED_BY,

4709: a.value_string,
4710: to_char(m.customer_site_id),
4711: 'U',
4712: req_id,
4713: hz_utility_pub.CREATED_BY,
4714: hz_utility_pub.CREATION_DATE,
4715: hz_utility_pub.LAST_UPDATE_LOGIN,
4716: hz_utility_pub.LAST_UPDATE_DATE,
4717: hz_utility_pub.LAST_UPDATED_BY

Line 4714: hz_utility_pub.CREATION_DATE,

4710: to_char(m.customer_site_id),
4711: 'U',
4712: req_id,
4713: hz_utility_pub.CREATED_BY,
4714: hz_utility_pub.CREATION_DATE,
4715: hz_utility_pub.LAST_UPDATE_LOGIN,
4716: hz_utility_pub.LAST_UPDATE_DATE,
4717: hz_utility_pub.LAST_UPDATED_BY
4718: from OE_PC_VTMPLT_COLS a,

Line 4715: hz_utility_pub.LAST_UPDATE_LOGIN,

4711: 'U',
4712: req_id,
4713: hz_utility_pub.CREATED_BY,
4714: hz_utility_pub.CREATION_DATE,
4715: hz_utility_pub.LAST_UPDATE_LOGIN,
4716: hz_utility_pub.LAST_UPDATE_DATE,
4717: hz_utility_pub.LAST_UPDATED_BY
4718: from OE_PC_VTMPLT_COLS a,
4719: ra_customer_merges m

Line 4716: hz_utility_pub.LAST_UPDATE_DATE,

4712: req_id,
4713: hz_utility_pub.CREATED_BY,
4714: hz_utility_pub.CREATION_DATE,
4715: hz_utility_pub.LAST_UPDATE_LOGIN,
4716: hz_utility_pub.LAST_UPDATE_DATE,
4717: hz_utility_pub.LAST_UPDATED_BY
4718: from OE_PC_VTMPLT_COLS a,
4719: ra_customer_merges m
4720: where a.value_string = to_char(m.duplicate_site_id)

Line 4717: hz_utility_pub.LAST_UPDATED_BY

4713: hz_utility_pub.CREATED_BY,
4714: hz_utility_pub.CREATION_DATE,
4715: hz_utility_pub.LAST_UPDATE_LOGIN,
4716: hz_utility_pub.LAST_UPDATE_DATE,
4717: hz_utility_pub.LAST_UPDATED_BY
4718: from OE_PC_VTMPLT_COLS a,
4719: ra_customer_merges m
4720: where a.value_string = to_char(m.duplicate_site_id)
4721: and m.process_flag = 'N'

Line 4781: hz_utility_pub.CREATED_BY,

4777: a.value_string,
4778: to_char(m.customer_site_id),
4779: 'U',
4780: req_id,
4781: hz_utility_pub.CREATED_BY,
4782: hz_utility_pub.CREATION_DATE,
4783: hz_utility_pub.LAST_UPDATE_LOGIN,
4784: hz_utility_pub.LAST_UPDATE_DATE,
4785: hz_utility_pub.LAST_UPDATED_BY

Line 4782: hz_utility_pub.CREATION_DATE,

4778: to_char(m.customer_site_id),
4779: 'U',
4780: req_id,
4781: hz_utility_pub.CREATED_BY,
4782: hz_utility_pub.CREATION_DATE,
4783: hz_utility_pub.LAST_UPDATE_LOGIN,
4784: hz_utility_pub.LAST_UPDATE_DATE,
4785: hz_utility_pub.LAST_UPDATED_BY
4786: from OE_PC_VTMPLT_COLS a,

Line 4783: hz_utility_pub.LAST_UPDATE_LOGIN,

4779: 'U',
4780: req_id,
4781: hz_utility_pub.CREATED_BY,
4782: hz_utility_pub.CREATION_DATE,
4783: hz_utility_pub.LAST_UPDATE_LOGIN,
4784: hz_utility_pub.LAST_UPDATE_DATE,
4785: hz_utility_pub.LAST_UPDATED_BY
4786: from OE_PC_VTMPLT_COLS a,
4787: ra_customer_merges m

Line 4784: hz_utility_pub.LAST_UPDATE_DATE,

4780: req_id,
4781: hz_utility_pub.CREATED_BY,
4782: hz_utility_pub.CREATION_DATE,
4783: hz_utility_pub.LAST_UPDATE_LOGIN,
4784: hz_utility_pub.LAST_UPDATE_DATE,
4785: hz_utility_pub.LAST_UPDATED_BY
4786: from OE_PC_VTMPLT_COLS a,
4787: ra_customer_merges m
4788: where a.value_string = to_char(m.duplicate_site_id)

Line 4785: hz_utility_pub.LAST_UPDATED_BY

4781: hz_utility_pub.CREATED_BY,
4782: hz_utility_pub.CREATION_DATE,
4783: hz_utility_pub.LAST_UPDATE_LOGIN,
4784: hz_utility_pub.LAST_UPDATE_DATE,
4785: hz_utility_pub.LAST_UPDATED_BY
4786: from OE_PC_VTMPLT_COLS a,
4787: ra_customer_merges m
4788: where a.value_string = to_char(m.duplicate_site_id)
4789: and m.process_flag = 'N'

Line 4849: hz_utility_pub.CREATED_BY,

4845: a.value_string,
4846: to_char(m.customer_site_id),
4847: 'U',
4848: req_id,
4849: hz_utility_pub.CREATED_BY,
4850: hz_utility_pub.CREATION_DATE,
4851: hz_utility_pub.LAST_UPDATE_LOGIN,
4852: hz_utility_pub.LAST_UPDATE_DATE,
4853: hz_utility_pub.LAST_UPDATED_BY

Line 4850: hz_utility_pub.CREATION_DATE,

4846: to_char(m.customer_site_id),
4847: 'U',
4848: req_id,
4849: hz_utility_pub.CREATED_BY,
4850: hz_utility_pub.CREATION_DATE,
4851: hz_utility_pub.LAST_UPDATE_LOGIN,
4852: hz_utility_pub.LAST_UPDATE_DATE,
4853: hz_utility_pub.LAST_UPDATED_BY
4854: from OE_PC_VTMPLT_COLS a,

Line 4851: hz_utility_pub.LAST_UPDATE_LOGIN,

4847: 'U',
4848: req_id,
4849: hz_utility_pub.CREATED_BY,
4850: hz_utility_pub.CREATION_DATE,
4851: hz_utility_pub.LAST_UPDATE_LOGIN,
4852: hz_utility_pub.LAST_UPDATE_DATE,
4853: hz_utility_pub.LAST_UPDATED_BY
4854: from OE_PC_VTMPLT_COLS a,
4855: ra_customer_merges m

Line 4852: hz_utility_pub.LAST_UPDATE_DATE,

4848: req_id,
4849: hz_utility_pub.CREATED_BY,
4850: hz_utility_pub.CREATION_DATE,
4851: hz_utility_pub.LAST_UPDATE_LOGIN,
4852: hz_utility_pub.LAST_UPDATE_DATE,
4853: hz_utility_pub.LAST_UPDATED_BY
4854: from OE_PC_VTMPLT_COLS a,
4855: ra_customer_merges m
4856: where a.value_string = to_char(m.duplicate_site_id)

Line 4853: hz_utility_pub.LAST_UPDATED_BY

4849: hz_utility_pub.CREATED_BY,
4850: hz_utility_pub.CREATION_DATE,
4851: hz_utility_pub.LAST_UPDATE_LOGIN,
4852: hz_utility_pub.LAST_UPDATE_DATE,
4853: hz_utility_pub.LAST_UPDATED_BY
4854: from OE_PC_VTMPLT_COLS a,
4855: ra_customer_merges m
4856: where a.value_string = to_char(m.duplicate_site_id)
4857: and m.process_flag = 'N'

Line 4918: hz_utility_pub.CREATED_BY,

4914: a.value_string,
4915: to_char(m.customer_id),
4916: 'U',
4917: req_id,
4918: hz_utility_pub.CREATED_BY,
4919: hz_utility_pub.CREATION_DATE,
4920: hz_utility_pub.LAST_UPDATE_LOGIN,
4921: hz_utility_pub.LAST_UPDATE_DATE,
4922: hz_utility_pub.LAST_UPDATED_BY

Line 4919: hz_utility_pub.CREATION_DATE,

4915: to_char(m.customer_id),
4916: 'U',
4917: req_id,
4918: hz_utility_pub.CREATED_BY,
4919: hz_utility_pub.CREATION_DATE,
4920: hz_utility_pub.LAST_UPDATE_LOGIN,
4921: hz_utility_pub.LAST_UPDATE_DATE,
4922: hz_utility_pub.LAST_UPDATED_BY
4923: from OE_PC_VTMPLT_COLS a,

Line 4920: hz_utility_pub.LAST_UPDATE_LOGIN,

4916: 'U',
4917: req_id,
4918: hz_utility_pub.CREATED_BY,
4919: hz_utility_pub.CREATION_DATE,
4920: hz_utility_pub.LAST_UPDATE_LOGIN,
4921: hz_utility_pub.LAST_UPDATE_DATE,
4922: hz_utility_pub.LAST_UPDATED_BY
4923: from OE_PC_VTMPLT_COLS a,
4924: ra_customer_merges m

Line 4921: hz_utility_pub.LAST_UPDATE_DATE,

4917: req_id,
4918: hz_utility_pub.CREATED_BY,
4919: hz_utility_pub.CREATION_DATE,
4920: hz_utility_pub.LAST_UPDATE_LOGIN,
4921: hz_utility_pub.LAST_UPDATE_DATE,
4922: hz_utility_pub.LAST_UPDATED_BY
4923: from OE_PC_VTMPLT_COLS a,
4924: ra_customer_merges m
4925: where a.value_string = to_char(m.duplicate_id)

Line 4922: hz_utility_pub.LAST_UPDATED_BY

4918: hz_utility_pub.CREATED_BY,
4919: hz_utility_pub.CREATION_DATE,
4920: hz_utility_pub.LAST_UPDATE_LOGIN,
4921: hz_utility_pub.LAST_UPDATE_DATE,
4922: hz_utility_pub.LAST_UPDATED_BY
4923: from OE_PC_VTMPLT_COLS a,
4924: ra_customer_merges m
4925: where a.value_string = to_char(m.duplicate_id)
4926: and m.process_flag = 'N'

Line 5070: hz_utility_pub.CREATED_BY,

5066: to_char(a.hold_entity_id),
5067: to_char(m.customer_site_id),
5068: 'U',
5069: req_id,
5070: hz_utility_pub.CREATED_BY,
5071: hz_utility_pub.CREATION_DATE,
5072: hz_utility_pub.LAST_UPDATE_LOGIN,
5073: hz_utility_pub.LAST_UPDATE_DATE,
5074: hz_utility_pub.LAST_UPDATED_BY

Line 5071: hz_utility_pub.CREATION_DATE,

5067: to_char(m.customer_site_id),
5068: 'U',
5069: req_id,
5070: hz_utility_pub.CREATED_BY,
5071: hz_utility_pub.CREATION_DATE,
5072: hz_utility_pub.LAST_UPDATE_LOGIN,
5073: hz_utility_pub.LAST_UPDATE_DATE,
5074: hz_utility_pub.LAST_UPDATED_BY
5075: from OE_HOLD_SOURCES a,

Line 5072: hz_utility_pub.LAST_UPDATE_LOGIN,

5068: 'U',
5069: req_id,
5070: hz_utility_pub.CREATED_BY,
5071: hz_utility_pub.CREATION_DATE,
5072: hz_utility_pub.LAST_UPDATE_LOGIN,
5073: hz_utility_pub.LAST_UPDATE_DATE,
5074: hz_utility_pub.LAST_UPDATED_BY
5075: from OE_HOLD_SOURCES a,
5076: ra_customer_merges m

Line 5073: hz_utility_pub.LAST_UPDATE_DATE,

5069: req_id,
5070: hz_utility_pub.CREATED_BY,
5071: hz_utility_pub.CREATION_DATE,
5072: hz_utility_pub.LAST_UPDATE_LOGIN,
5073: hz_utility_pub.LAST_UPDATE_DATE,
5074: hz_utility_pub.LAST_UPDATED_BY
5075: from OE_HOLD_SOURCES a,
5076: ra_customer_merges m
5077: where a.hold_entity_id = to_char(m.duplicate_site_id)

Line 5074: hz_utility_pub.LAST_UPDATED_BY

5070: hz_utility_pub.CREATED_BY,
5071: hz_utility_pub.CREATION_DATE,
5072: hz_utility_pub.LAST_UPDATE_LOGIN,
5073: hz_utility_pub.LAST_UPDATE_DATE,
5074: hz_utility_pub.LAST_UPDATED_BY
5075: from OE_HOLD_SOURCES a,
5076: ra_customer_merges m
5077: where a.hold_entity_id = to_char(m.duplicate_site_id)
5078: and m.process_flag = 'N'

Line 5138: hz_utility_pub.CREATED_BY,

5134: to_char(a.hold_entity_id),
5135: to_char(m.customer_site_id),
5136: 'U',
5137: req_id,
5138: hz_utility_pub.CREATED_BY,
5139: hz_utility_pub.CREATION_DATE,
5140: hz_utility_pub.LAST_UPDATE_LOGIN,
5141: hz_utility_pub.LAST_UPDATE_DATE,
5142: hz_utility_pub.LAST_UPDATED_BY

Line 5139: hz_utility_pub.CREATION_DATE,

5135: to_char(m.customer_site_id),
5136: 'U',
5137: req_id,
5138: hz_utility_pub.CREATED_BY,
5139: hz_utility_pub.CREATION_DATE,
5140: hz_utility_pub.LAST_UPDATE_LOGIN,
5141: hz_utility_pub.LAST_UPDATE_DATE,
5142: hz_utility_pub.LAST_UPDATED_BY
5143: from OE_HOLD_SOURCES a,

Line 5140: hz_utility_pub.LAST_UPDATE_LOGIN,

5136: 'U',
5137: req_id,
5138: hz_utility_pub.CREATED_BY,
5139: hz_utility_pub.CREATION_DATE,
5140: hz_utility_pub.LAST_UPDATE_LOGIN,
5141: hz_utility_pub.LAST_UPDATE_DATE,
5142: hz_utility_pub.LAST_UPDATED_BY
5143: from OE_HOLD_SOURCES a,
5144: ra_customer_merges m

Line 5141: hz_utility_pub.LAST_UPDATE_DATE,

5137: req_id,
5138: hz_utility_pub.CREATED_BY,
5139: hz_utility_pub.CREATION_DATE,
5140: hz_utility_pub.LAST_UPDATE_LOGIN,
5141: hz_utility_pub.LAST_UPDATE_DATE,
5142: hz_utility_pub.LAST_UPDATED_BY
5143: from OE_HOLD_SOURCES a,
5144: ra_customer_merges m
5145: where a.hold_entity_id = to_char(m.duplicate_site_id)

Line 5142: hz_utility_pub.LAST_UPDATED_BY

5138: hz_utility_pub.CREATED_BY,
5139: hz_utility_pub.CREATION_DATE,
5140: hz_utility_pub.LAST_UPDATE_LOGIN,
5141: hz_utility_pub.LAST_UPDATE_DATE,
5142: hz_utility_pub.LAST_UPDATED_BY
5143: from OE_HOLD_SOURCES a,
5144: ra_customer_merges m
5145: where a.hold_entity_id = to_char(m.duplicate_site_id)
5146: and m.process_flag = 'N'

Line 5207: hz_utility_pub.CREATED_BY,

5203: to_char(a.hold_entity_id),
5204: to_char(m.customer_id),
5205: 'U',
5206: req_id,
5207: hz_utility_pub.CREATED_BY,
5208: hz_utility_pub.CREATION_DATE,
5209: hz_utility_pub.LAST_UPDATE_LOGIN,
5210: hz_utility_pub.LAST_UPDATE_DATE,
5211: hz_utility_pub.LAST_UPDATED_BY

Line 5208: hz_utility_pub.CREATION_DATE,

5204: to_char(m.customer_id),
5205: 'U',
5206: req_id,
5207: hz_utility_pub.CREATED_BY,
5208: hz_utility_pub.CREATION_DATE,
5209: hz_utility_pub.LAST_UPDATE_LOGIN,
5210: hz_utility_pub.LAST_UPDATE_DATE,
5211: hz_utility_pub.LAST_UPDATED_BY
5212: from OE_HOLD_SOURCES a,

Line 5209: hz_utility_pub.LAST_UPDATE_LOGIN,

5205: 'U',
5206: req_id,
5207: hz_utility_pub.CREATED_BY,
5208: hz_utility_pub.CREATION_DATE,
5209: hz_utility_pub.LAST_UPDATE_LOGIN,
5210: hz_utility_pub.LAST_UPDATE_DATE,
5211: hz_utility_pub.LAST_UPDATED_BY
5212: from OE_HOLD_SOURCES a,
5213: ra_customer_merges m

Line 5210: hz_utility_pub.LAST_UPDATE_DATE,

5206: req_id,
5207: hz_utility_pub.CREATED_BY,
5208: hz_utility_pub.CREATION_DATE,
5209: hz_utility_pub.LAST_UPDATE_LOGIN,
5210: hz_utility_pub.LAST_UPDATE_DATE,
5211: hz_utility_pub.LAST_UPDATED_BY
5212: from OE_HOLD_SOURCES a,
5213: ra_customer_merges m
5214: where a.hold_entity_id = to_char(m.duplicate_id)

Line 5211: hz_utility_pub.LAST_UPDATED_BY

5207: hz_utility_pub.CREATED_BY,
5208: hz_utility_pub.CREATION_DATE,
5209: hz_utility_pub.LAST_UPDATE_LOGIN,
5210: hz_utility_pub.LAST_UPDATE_DATE,
5211: hz_utility_pub.LAST_UPDATED_BY
5212: from OE_HOLD_SOURCES a,
5213: ra_customer_merges m
5214: where a.hold_entity_id = to_char(m.duplicate_id)
5215: and m.process_flag = 'N'

Line 5321: hz_utility_pub.CREATED_BY,

5317: to_char(a.line_location_id),
5318: to_char(m.customer_site_id),
5319: 'U',
5320: req_id,
5321: hz_utility_pub.CREATED_BY,
5322: hz_utility_pub.CREATION_DATE,
5323: hz_utility_pub.LAST_UPDATE_LOGIN,
5324: hz_utility_pub.LAST_UPDATE_DATE,
5325: hz_utility_pub.LAST_UPDATED_BY

Line 5322: hz_utility_pub.CREATION_DATE,

5318: to_char(m.customer_site_id),
5319: 'U',
5320: req_id,
5321: hz_utility_pub.CREATED_BY,
5322: hz_utility_pub.CREATION_DATE,
5323: hz_utility_pub.LAST_UPDATE_LOGIN,
5324: hz_utility_pub.LAST_UPDATE_DATE,
5325: hz_utility_pub.LAST_UPDATED_BY
5326: from OE_DROP_SHIP_SOURCES a,

Line 5323: hz_utility_pub.LAST_UPDATE_LOGIN,

5319: 'U',
5320: req_id,
5321: hz_utility_pub.CREATED_BY,
5322: hz_utility_pub.CREATION_DATE,
5323: hz_utility_pub.LAST_UPDATE_LOGIN,
5324: hz_utility_pub.LAST_UPDATE_DATE,
5325: hz_utility_pub.LAST_UPDATED_BY
5326: from OE_DROP_SHIP_SOURCES a,
5327: ra_customer_merges m

Line 5324: hz_utility_pub.LAST_UPDATE_DATE,

5320: req_id,
5321: hz_utility_pub.CREATED_BY,
5322: hz_utility_pub.CREATION_DATE,
5323: hz_utility_pub.LAST_UPDATE_LOGIN,
5324: hz_utility_pub.LAST_UPDATE_DATE,
5325: hz_utility_pub.LAST_UPDATED_BY
5326: from OE_DROP_SHIP_SOURCES a,
5327: ra_customer_merges m
5328: where a.line_location_id = to_char(m.duplicate_site_id)

Line 5325: hz_utility_pub.LAST_UPDATED_BY

5321: hz_utility_pub.CREATED_BY,
5322: hz_utility_pub.CREATION_DATE,
5323: hz_utility_pub.LAST_UPDATE_LOGIN,
5324: hz_utility_pub.LAST_UPDATE_DATE,
5325: hz_utility_pub.LAST_UPDATED_BY
5326: from OE_DROP_SHIP_SOURCES a,
5327: ra_customer_merges m
5328: where a.line_location_id = to_char(m.duplicate_site_id)
5329: and m.process_flag = 'N'

Line 5445: hz_utility_pub.CREATED_BY,

5441: a.site_use_id,
5442: m.customer_site_id,
5443: 'U',
5444: req_id,
5445: hz_utility_pub.CREATED_BY,
5446: hz_utility_pub.CREATION_DATE,
5447: hz_utility_pub.LAST_UPDATE_LOGIN,
5448: hz_utility_pub.LAST_UPDATE_DATE,
5449: hz_utility_pub.LAST_UPDATED_BY

Line 5446: hz_utility_pub.CREATION_DATE,

5442: m.customer_site_id,
5443: 'U',
5444: req_id,
5445: hz_utility_pub.CREATED_BY,
5446: hz_utility_pub.CREATION_DATE,
5447: hz_utility_pub.LAST_UPDATE_LOGIN,
5448: hz_utility_pub.LAST_UPDATE_DATE,
5449: hz_utility_pub.LAST_UPDATED_BY
5450: from OE_CUST_ITEM_SETTINGS a,

Line 5447: hz_utility_pub.LAST_UPDATE_LOGIN,

5443: 'U',
5444: req_id,
5445: hz_utility_pub.CREATED_BY,
5446: hz_utility_pub.CREATION_DATE,
5447: hz_utility_pub.LAST_UPDATE_LOGIN,
5448: hz_utility_pub.LAST_UPDATE_DATE,
5449: hz_utility_pub.LAST_UPDATED_BY
5450: from OE_CUST_ITEM_SETTINGS a,
5451: ra_customer_merges m

Line 5448: hz_utility_pub.LAST_UPDATE_DATE,

5444: req_id,
5445: hz_utility_pub.CREATED_BY,
5446: hz_utility_pub.CREATION_DATE,
5447: hz_utility_pub.LAST_UPDATE_LOGIN,
5448: hz_utility_pub.LAST_UPDATE_DATE,
5449: hz_utility_pub.LAST_UPDATED_BY
5450: from OE_CUST_ITEM_SETTINGS a,
5451: ra_customer_merges m
5452: where a.site_use_id = m.duplicate_site_id

Line 5449: hz_utility_pub.LAST_UPDATED_BY

5445: hz_utility_pub.CREATED_BY,
5446: hz_utility_pub.CREATION_DATE,
5447: hz_utility_pub.LAST_UPDATE_LOGIN,
5448: hz_utility_pub.LAST_UPDATE_DATE,
5449: hz_utility_pub.LAST_UPDATED_BY
5450: from OE_CUST_ITEM_SETTINGS a,
5451: ra_customer_merges m
5452: where a.site_use_id = m.duplicate_site_id
5453: and m.process_flag = 'N'

Line 5507: hz_utility_pub.CREATED_BY,

5503: a.customer_id,
5504: m.customer_id,
5505: 'U',
5506: req_id,
5507: hz_utility_pub.CREATED_BY,
5508: hz_utility_pub.CREATION_DATE,
5509: hz_utility_pub.LAST_UPDATE_LOGIN,
5510: hz_utility_pub.LAST_UPDATE_DATE,
5511: hz_utility_pub.LAST_UPDATED_BY

Line 5508: hz_utility_pub.CREATION_DATE,

5504: m.customer_id,
5505: 'U',
5506: req_id,
5507: hz_utility_pub.CREATED_BY,
5508: hz_utility_pub.CREATION_DATE,
5509: hz_utility_pub.LAST_UPDATE_LOGIN,
5510: hz_utility_pub.LAST_UPDATE_DATE,
5511: hz_utility_pub.LAST_UPDATED_BY
5512: from OE_CUST_ITEM_SETTINGS a,

Line 5509: hz_utility_pub.LAST_UPDATE_LOGIN,

5505: 'U',
5506: req_id,
5507: hz_utility_pub.CREATED_BY,
5508: hz_utility_pub.CREATION_DATE,
5509: hz_utility_pub.LAST_UPDATE_LOGIN,
5510: hz_utility_pub.LAST_UPDATE_DATE,
5511: hz_utility_pub.LAST_UPDATED_BY
5512: from OE_CUST_ITEM_SETTINGS a,
5513: ra_customer_merges m

Line 5510: hz_utility_pub.LAST_UPDATE_DATE,

5506: req_id,
5507: hz_utility_pub.CREATED_BY,
5508: hz_utility_pub.CREATION_DATE,
5509: hz_utility_pub.LAST_UPDATE_LOGIN,
5510: hz_utility_pub.LAST_UPDATE_DATE,
5511: hz_utility_pub.LAST_UPDATED_BY
5512: from OE_CUST_ITEM_SETTINGS a,
5513: ra_customer_merges m
5514: where a.customer_id = m.duplicate_id

Line 5511: hz_utility_pub.LAST_UPDATED_BY

5507: hz_utility_pub.CREATED_BY,
5508: hz_utility_pub.CREATION_DATE,
5509: hz_utility_pub.LAST_UPDATE_LOGIN,
5510: hz_utility_pub.LAST_UPDATE_DATE,
5511: hz_utility_pub.LAST_UPDATED_BY
5512: from OE_CUST_ITEM_SETTINGS a,
5513: ra_customer_merges m
5514: where a.customer_id = m.duplicate_id
5515: and m.process_flag = 'N'

Line 5646: hz_utility_pub.CREATED_BY,

5642: sets_ship_to_org_id_tab(I),
5643: sets_ship_to_org_id_tab(I),
5644: 'U',
5645: req_id,
5646: hz_utility_pub.CREATED_BY,
5647: hz_utility_pub.CREATION_DATE,
5648: hz_utility_pub.LAST_UPDATE_LOGIN,
5649: hz_utility_pub.LAST_UPDATE_DATE,
5650: hz_utility_pub.LAST_UPDATED_BY

Line 5647: hz_utility_pub.CREATION_DATE,

5643: sets_ship_to_org_id_tab(I),
5644: 'U',
5645: req_id,
5646: hz_utility_pub.CREATED_BY,
5647: hz_utility_pub.CREATION_DATE,
5648: hz_utility_pub.LAST_UPDATE_LOGIN,
5649: hz_utility_pub.LAST_UPDATE_DATE,
5650: hz_utility_pub.LAST_UPDATED_BY
5651: );

Line 5648: hz_utility_pub.LAST_UPDATE_LOGIN,

5644: 'U',
5645: req_id,
5646: hz_utility_pub.CREATED_BY,
5647: hz_utility_pub.CREATION_DATE,
5648: hz_utility_pub.LAST_UPDATE_LOGIN,
5649: hz_utility_pub.LAST_UPDATE_DATE,
5650: hz_utility_pub.LAST_UPDATED_BY
5651: );
5652: end if;

Line 5649: hz_utility_pub.LAST_UPDATE_DATE,

5645: req_id,
5646: hz_utility_pub.CREATED_BY,
5647: hz_utility_pub.CREATION_DATE,
5648: hz_utility_pub.LAST_UPDATE_LOGIN,
5649: hz_utility_pub.LAST_UPDATE_DATE,
5650: hz_utility_pub.LAST_UPDATED_BY
5651: );
5652: end if;
5653: end if;

Line 5650: hz_utility_pub.LAST_UPDATED_BY

5646: hz_utility_pub.CREATED_BY,
5647: hz_utility_pub.CREATION_DATE,
5648: hz_utility_pub.LAST_UPDATE_LOGIN,
5649: hz_utility_pub.LAST_UPDATE_DATE,
5650: hz_utility_pub.LAST_UPDATED_BY
5651: );
5652: end if;
5653: end if;
5654:

Line 5814: hz_utility_pub.CREATED_BY,

5810: pricing_attr_value_from_tab(I),
5811: to_char(attrib_value_from_tab(I)),
5812: 'U',
5813: req_id,
5814: hz_utility_pub.CREATED_BY,
5815: hz_utility_pub.CREATION_DATE,
5816: hz_utility_pub.LAST_UPDATE_LOGIN,
5817: hz_utility_pub.LAST_UPDATE_DATE,
5818: hz_utility_pub.LAST_UPDATED_BY

Line 5815: hz_utility_pub.CREATION_DATE,

5811: to_char(attrib_value_from_tab(I)),
5812: 'U',
5813: req_id,
5814: hz_utility_pub.CREATED_BY,
5815: hz_utility_pub.CREATION_DATE,
5816: hz_utility_pub.LAST_UPDATE_LOGIN,
5817: hz_utility_pub.LAST_UPDATE_DATE,
5818: hz_utility_pub.LAST_UPDATED_BY
5819: );

Line 5816: hz_utility_pub.LAST_UPDATE_LOGIN,

5812: 'U',
5813: req_id,
5814: hz_utility_pub.CREATED_BY,
5815: hz_utility_pub.CREATION_DATE,
5816: hz_utility_pub.LAST_UPDATE_LOGIN,
5817: hz_utility_pub.LAST_UPDATE_DATE,
5818: hz_utility_pub.LAST_UPDATED_BY
5819: );
5820:

Line 5817: hz_utility_pub.LAST_UPDATE_DATE,

5813: req_id,
5814: hz_utility_pub.CREATED_BY,
5815: hz_utility_pub.CREATION_DATE,
5816: hz_utility_pub.LAST_UPDATE_LOGIN,
5817: hz_utility_pub.LAST_UPDATE_DATE,
5818: hz_utility_pub.LAST_UPDATED_BY
5819: );
5820:
5821: END IF;

Line 5818: hz_utility_pub.LAST_UPDATED_BY

5814: hz_utility_pub.CREATED_BY,
5815: hz_utility_pub.CREATION_DATE,
5816: hz_utility_pub.LAST_UPDATE_LOGIN,
5817: hz_utility_pub.LAST_UPDATE_DATE,
5818: hz_utility_pub.LAST_UPDATED_BY
5819: );
5820:
5821: END IF;
5822: end if;

Line 6124: hz_utility_pub.CREATED_BY,

6120: old_hdr_sold_to_site_id_tab(I),
6121: 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)),
6122: 'U',
6123: req_id,
6124: hz_utility_pub.CREATED_BY,
6125: hz_utility_pub.CREATION_DATE,
6126: hz_utility_pub.LAST_UPDATE_LOGIN,
6127: hz_utility_pub.LAST_UPDATE_DATE,
6128: hz_utility_pub.LAST_UPDATED_BY

Line 6125: hz_utility_pub.CREATION_DATE,

6121: 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)),
6122: 'U',
6123: req_id,
6124: hz_utility_pub.CREATED_BY,
6125: hz_utility_pub.CREATION_DATE,
6126: hz_utility_pub.LAST_UPDATE_LOGIN,
6127: hz_utility_pub.LAST_UPDATE_DATE,
6128: hz_utility_pub.LAST_UPDATED_BY
6129: );

Line 6126: hz_utility_pub.LAST_UPDATE_LOGIN,

6122: 'U',
6123: req_id,
6124: hz_utility_pub.CREATED_BY,
6125: hz_utility_pub.CREATION_DATE,
6126: hz_utility_pub.LAST_UPDATE_LOGIN,
6127: hz_utility_pub.LAST_UPDATE_DATE,
6128: hz_utility_pub.LAST_UPDATED_BY
6129: );
6130:

Line 6127: hz_utility_pub.LAST_UPDATE_DATE,

6123: req_id,
6124: hz_utility_pub.CREATED_BY,
6125: hz_utility_pub.CREATION_DATE,
6126: hz_utility_pub.LAST_UPDATE_LOGIN,
6127: hz_utility_pub.LAST_UPDATE_DATE,
6128: hz_utility_pub.LAST_UPDATED_BY
6129: );
6130:
6131: end if;

Line 6128: hz_utility_pub.LAST_UPDATED_BY

6124: hz_utility_pub.CREATED_BY,
6125: hz_utility_pub.CREATION_DATE,
6126: hz_utility_pub.LAST_UPDATE_LOGIN,
6127: hz_utility_pub.LAST_UPDATE_DATE,
6128: hz_utility_pub.LAST_UPDATED_BY
6129: );
6130:
6131: end if;
6132: end if;

Line 6337: hz_utility_pub.CREATED_BY,

6333: h.ship_to_org_id,
6334: m.customer_site_id,
6335: 'U',
6336: req_id,
6337: hz_utility_pub.CREATED_BY,
6338: hz_utility_pub.CREATION_DATE,
6339: hz_utility_pub.LAST_UPDATE_LOGIN,
6340: hz_utility_pub.LAST_UPDATE_DATE,
6341: hz_utility_pub.LAST_UPDATED_BY

Line 6338: hz_utility_pub.CREATION_DATE,

6334: m.customer_site_id,
6335: 'U',
6336: req_id,
6337: hz_utility_pub.CREATED_BY,
6338: hz_utility_pub.CREATION_DATE,
6339: hz_utility_pub.LAST_UPDATE_LOGIN,
6340: hz_utility_pub.LAST_UPDATE_DATE,
6341: hz_utility_pub.LAST_UPDATED_BY
6342: from oe_blanket_headers_hist h,

Line 6339: hz_utility_pub.LAST_UPDATE_LOGIN,

6335: 'U',
6336: req_id,
6337: hz_utility_pub.CREATED_BY,
6338: hz_utility_pub.CREATION_DATE,
6339: hz_utility_pub.LAST_UPDATE_LOGIN,
6340: hz_utility_pub.LAST_UPDATE_DATE,
6341: hz_utility_pub.LAST_UPDATED_BY
6342: from oe_blanket_headers_hist h,
6343: ra_customer_merges m

Line 6340: hz_utility_pub.LAST_UPDATE_DATE,

6336: req_id,
6337: hz_utility_pub.CREATED_BY,
6338: hz_utility_pub.CREATION_DATE,
6339: hz_utility_pub.LAST_UPDATE_LOGIN,
6340: hz_utility_pub.LAST_UPDATE_DATE,
6341: hz_utility_pub.LAST_UPDATED_BY
6342: from oe_blanket_headers_hist h,
6343: ra_customer_merges m
6344: where h.ship_to_org_id=m.duplicate_site_id

Line 6341: hz_utility_pub.LAST_UPDATED_BY

6337: hz_utility_pub.CREATED_BY,
6338: hz_utility_pub.CREATION_DATE,
6339: hz_utility_pub.LAST_UPDATE_LOGIN,
6340: hz_utility_pub.LAST_UPDATE_DATE,
6341: hz_utility_pub.LAST_UPDATED_BY
6342: from oe_blanket_headers_hist h,
6343: ra_customer_merges m
6344: where h.ship_to_org_id=m.duplicate_site_id
6345: and m.process_flag = 'N'

Line 6404: hz_utility_pub.CREATED_BY,

6400: h.invoice_to_org_id,
6401: m.customer_site_id,
6402: 'U',
6403: req_id,
6404: hz_utility_pub.CREATED_BY,
6405: hz_utility_pub.CREATION_DATE,
6406: hz_utility_pub.LAST_UPDATE_LOGIN,
6407: hz_utility_pub.LAST_UPDATE_DATE,
6408: hz_utility_pub.LAST_UPDATED_BY

Line 6405: hz_utility_pub.CREATION_DATE,

6401: m.customer_site_id,
6402: 'U',
6403: req_id,
6404: hz_utility_pub.CREATED_BY,
6405: hz_utility_pub.CREATION_DATE,
6406: hz_utility_pub.LAST_UPDATE_LOGIN,
6407: hz_utility_pub.LAST_UPDATE_DATE,
6408: hz_utility_pub.LAST_UPDATED_BY
6409: from oe_blanket_headers_hist h,

Line 6406: hz_utility_pub.LAST_UPDATE_LOGIN,

6402: 'U',
6403: req_id,
6404: hz_utility_pub.CREATED_BY,
6405: hz_utility_pub.CREATION_DATE,
6406: hz_utility_pub.LAST_UPDATE_LOGIN,
6407: hz_utility_pub.LAST_UPDATE_DATE,
6408: hz_utility_pub.LAST_UPDATED_BY
6409: from oe_blanket_headers_hist h,
6410: ra_customer_merges m

Line 6407: hz_utility_pub.LAST_UPDATE_DATE,

6403: req_id,
6404: hz_utility_pub.CREATED_BY,
6405: hz_utility_pub.CREATION_DATE,
6406: hz_utility_pub.LAST_UPDATE_LOGIN,
6407: hz_utility_pub.LAST_UPDATE_DATE,
6408: hz_utility_pub.LAST_UPDATED_BY
6409: from oe_blanket_headers_hist h,
6410: ra_customer_merges m
6411: where h.invoice_to_org_id=m.duplicate_site_id

Line 6408: hz_utility_pub.LAST_UPDATED_BY

6404: hz_utility_pub.CREATED_BY,
6405: hz_utility_pub.CREATION_DATE,
6406: hz_utility_pub.LAST_UPDATE_LOGIN,
6407: hz_utility_pub.LAST_UPDATE_DATE,
6408: hz_utility_pub.LAST_UPDATED_BY
6409: from oe_blanket_headers_hist h,
6410: ra_customer_merges m
6411: where h.invoice_to_org_id=m.duplicate_site_id
6412: and m.process_flag = 'N'

Line 6471: hz_utility_pub.CREATED_BY,

6467: h.deliver_to_org_id,
6468: m.customer_site_id,
6469: 'U',
6470: req_id,
6471: hz_utility_pub.CREATED_BY,
6472: hz_utility_pub.CREATION_DATE,
6473: hz_utility_pub.LAST_UPDATE_LOGIN,
6474: hz_utility_pub.LAST_UPDATE_DATE,
6475: hz_utility_pub.LAST_UPDATED_BY

Line 6472: hz_utility_pub.CREATION_DATE,

6468: m.customer_site_id,
6469: 'U',
6470: req_id,
6471: hz_utility_pub.CREATED_BY,
6472: hz_utility_pub.CREATION_DATE,
6473: hz_utility_pub.LAST_UPDATE_LOGIN,
6474: hz_utility_pub.LAST_UPDATE_DATE,
6475: hz_utility_pub.LAST_UPDATED_BY
6476: from oe_blanket_headers_hist h,

Line 6473: hz_utility_pub.LAST_UPDATE_LOGIN,

6469: 'U',
6470: req_id,
6471: hz_utility_pub.CREATED_BY,
6472: hz_utility_pub.CREATION_DATE,
6473: hz_utility_pub.LAST_UPDATE_LOGIN,
6474: hz_utility_pub.LAST_UPDATE_DATE,
6475: hz_utility_pub.LAST_UPDATED_BY
6476: from oe_blanket_headers_hist h,
6477: ra_customer_merges m

Line 6474: hz_utility_pub.LAST_UPDATE_DATE,

6470: req_id,
6471: hz_utility_pub.CREATED_BY,
6472: hz_utility_pub.CREATION_DATE,
6473: hz_utility_pub.LAST_UPDATE_LOGIN,
6474: hz_utility_pub.LAST_UPDATE_DATE,
6475: hz_utility_pub.LAST_UPDATED_BY
6476: from oe_blanket_headers_hist h,
6477: ra_customer_merges m
6478: where h.deliver_to_org_id=m.duplicate_site_id

Line 6475: hz_utility_pub.LAST_UPDATED_BY

6471: hz_utility_pub.CREATED_BY,
6472: hz_utility_pub.CREATION_DATE,
6473: hz_utility_pub.LAST_UPDATE_LOGIN,
6474: hz_utility_pub.LAST_UPDATE_DATE,
6475: hz_utility_pub.LAST_UPDATED_BY
6476: from oe_blanket_headers_hist h,
6477: ra_customer_merges m
6478: where h.deliver_to_org_id=m.duplicate_site_id
6479: and m.process_flag = 'N'

Line 6540: hz_utility_pub.CREATED_BY,

6536: h.sold_to_org_id,
6537: m.customer_site_id,
6538: 'U',
6539: req_id,
6540: hz_utility_pub.CREATED_BY,
6541: hz_utility_pub.CREATION_DATE,
6542: hz_utility_pub.LAST_UPDATE_LOGIN,
6543: hz_utility_pub.LAST_UPDATE_DATE,
6544: hz_utility_pub.LAST_UPDATED_BY

Line 6541: hz_utility_pub.CREATION_DATE,

6537: m.customer_site_id,
6538: 'U',
6539: req_id,
6540: hz_utility_pub.CREATED_BY,
6541: hz_utility_pub.CREATION_DATE,
6542: hz_utility_pub.LAST_UPDATE_LOGIN,
6543: hz_utility_pub.LAST_UPDATE_DATE,
6544: hz_utility_pub.LAST_UPDATED_BY
6545: from oe_blanket_headers_hist h,

Line 6542: hz_utility_pub.LAST_UPDATE_LOGIN,

6538: 'U',
6539: req_id,
6540: hz_utility_pub.CREATED_BY,
6541: hz_utility_pub.CREATION_DATE,
6542: hz_utility_pub.LAST_UPDATE_LOGIN,
6543: hz_utility_pub.LAST_UPDATE_DATE,
6544: hz_utility_pub.LAST_UPDATED_BY
6545: from oe_blanket_headers_hist h,
6546: ra_customer_merges m

Line 6543: hz_utility_pub.LAST_UPDATE_DATE,

6539: req_id,
6540: hz_utility_pub.CREATED_BY,
6541: hz_utility_pub.CREATION_DATE,
6542: hz_utility_pub.LAST_UPDATE_LOGIN,
6543: hz_utility_pub.LAST_UPDATE_DATE,
6544: hz_utility_pub.LAST_UPDATED_BY
6545: from oe_blanket_headers_hist h,
6546: ra_customer_merges m
6547: where h.sold_to_org_id=m.duplicate_site_id

Line 6544: hz_utility_pub.LAST_UPDATED_BY

6540: hz_utility_pub.CREATED_BY,
6541: hz_utility_pub.CREATION_DATE,
6542: hz_utility_pub.LAST_UPDATE_LOGIN,
6543: hz_utility_pub.LAST_UPDATE_DATE,
6544: hz_utility_pub.LAST_UPDATED_BY
6545: from oe_blanket_headers_hist h,
6546: ra_customer_merges m
6547: where h.sold_to_org_id=m.duplicate_site_id
6548: and m.process_flag = 'N'

Line 6613: hz_utility_pub.CREATED_BY,

6609: h.sold_to_site_use_id,
6610: m.customer_site_id,
6611: 'U',
6612: req_id,
6613: hz_utility_pub.CREATED_BY,
6614: hz_utility_pub.CREATION_DATE,
6615: hz_utility_pub.LAST_UPDATE_LOGIN,
6616: hz_utility_pub.LAST_UPDATE_DATE,
6617: hz_utility_pub.LAST_UPDATED_BY

Line 6614: hz_utility_pub.CREATION_DATE,

6610: m.customer_site_id,
6611: 'U',
6612: req_id,
6613: hz_utility_pub.CREATED_BY,
6614: hz_utility_pub.CREATION_DATE,
6615: hz_utility_pub.LAST_UPDATE_LOGIN,
6616: hz_utility_pub.LAST_UPDATE_DATE,
6617: hz_utility_pub.LAST_UPDATED_BY
6618: from oe_blanket_headers_hist h,

Line 6615: hz_utility_pub.LAST_UPDATE_LOGIN,

6611: 'U',
6612: req_id,
6613: hz_utility_pub.CREATED_BY,
6614: hz_utility_pub.CREATION_DATE,
6615: hz_utility_pub.LAST_UPDATE_LOGIN,
6616: hz_utility_pub.LAST_UPDATE_DATE,
6617: hz_utility_pub.LAST_UPDATED_BY
6618: from oe_blanket_headers_hist h,
6619: ra_customer_merges m

Line 6616: hz_utility_pub.LAST_UPDATE_DATE,

6612: req_id,
6613: hz_utility_pub.CREATED_BY,
6614: hz_utility_pub.CREATION_DATE,
6615: hz_utility_pub.LAST_UPDATE_LOGIN,
6616: hz_utility_pub.LAST_UPDATE_DATE,
6617: hz_utility_pub.LAST_UPDATED_BY
6618: from oe_blanket_headers_hist h,
6619: ra_customer_merges m
6620: where h.sold_to_org_id=m.duplicate_site_id

Line 6617: hz_utility_pub.LAST_UPDATED_BY

6613: hz_utility_pub.CREATED_BY,
6614: hz_utility_pub.CREATION_DATE,
6615: hz_utility_pub.LAST_UPDATE_LOGIN,
6616: hz_utility_pub.LAST_UPDATE_DATE,
6617: hz_utility_pub.LAST_UPDATED_BY
6618: from oe_blanket_headers_hist h,
6619: ra_customer_merges m
6620: where h.sold_to_org_id=m.duplicate_site_id
6621: and m.process_flag = 'N'

Line 6921: hz_utility_pub.CREATED_BY,

6917: line_deliver_to_org_id_tab(I),
6918: decode(line_deliver_to_org_id_tab(I),NULL,old_line_deliver_to_org_id_tab(I),line_deliver_to_org_id_tab(i)),
6919: 'U',
6920: req_id,
6921: hz_utility_pub.CREATED_BY,
6922: hz_utility_pub.CREATION_DATE,
6923: hz_utility_pub.LAST_UPDATE_LOGIN,
6924: hz_utility_pub.LAST_UPDATE_DATE,
6925: hz_utility_pub.LAST_UPDATED_BY

Line 6922: hz_utility_pub.CREATION_DATE,

6918: decode(line_deliver_to_org_id_tab(I),NULL,old_line_deliver_to_org_id_tab(I),line_deliver_to_org_id_tab(i)),
6919: 'U',
6920: req_id,
6921: hz_utility_pub.CREATED_BY,
6922: hz_utility_pub.CREATION_DATE,
6923: hz_utility_pub.LAST_UPDATE_LOGIN,
6924: hz_utility_pub.LAST_UPDATE_DATE,
6925: hz_utility_pub.LAST_UPDATED_BY
6926: );

Line 6923: hz_utility_pub.LAST_UPDATE_LOGIN,

6919: 'U',
6920: req_id,
6921: hz_utility_pub.CREATED_BY,
6922: hz_utility_pub.CREATION_DATE,
6923: hz_utility_pub.LAST_UPDATE_LOGIN,
6924: hz_utility_pub.LAST_UPDATE_DATE,
6925: hz_utility_pub.LAST_UPDATED_BY
6926: );
6927:

Line 6924: hz_utility_pub.LAST_UPDATE_DATE,

6920: req_id,
6921: hz_utility_pub.CREATED_BY,
6922: hz_utility_pub.CREATION_DATE,
6923: hz_utility_pub.LAST_UPDATE_LOGIN,
6924: hz_utility_pub.LAST_UPDATE_DATE,
6925: hz_utility_pub.LAST_UPDATED_BY
6926: );
6927:
6928: end if;

Line 6925: hz_utility_pub.LAST_UPDATED_BY

6921: hz_utility_pub.CREATED_BY,
6922: hz_utility_pub.CREATION_DATE,
6923: hz_utility_pub.LAST_UPDATE_LOGIN,
6924: hz_utility_pub.LAST_UPDATE_DATE,
6925: hz_utility_pub.LAST_UPDATED_BY
6926: );
6927:
6928: end if;
6929: end if;

Line 7259: hz_utility_pub.CREATED_BY,

7255: lhst_deliver_to_org_id_tab(I),
7256: decode(lhst_deliver_to_org_id_tab(I),NULL,old_lhst_deliver_to_org_id_tab(I),lhst_deliver_to_org_id_tab(i)),
7257: 'U',
7258: req_id,
7259: hz_utility_pub.CREATED_BY,
7260: hz_utility_pub.CREATION_DATE,
7261: hz_utility_pub.LAST_UPDATE_LOGIN,
7262: hz_utility_pub.LAST_UPDATE_DATE,
7263: hz_utility_pub.LAST_UPDATED_BY

Line 7260: hz_utility_pub.CREATION_DATE,

7256: decode(lhst_deliver_to_org_id_tab(I),NULL,old_lhst_deliver_to_org_id_tab(I),lhst_deliver_to_org_id_tab(i)),
7257: 'U',
7258: req_id,
7259: hz_utility_pub.CREATED_BY,
7260: hz_utility_pub.CREATION_DATE,
7261: hz_utility_pub.LAST_UPDATE_LOGIN,
7262: hz_utility_pub.LAST_UPDATE_DATE,
7263: hz_utility_pub.LAST_UPDATED_BY
7264: );

Line 7261: hz_utility_pub.LAST_UPDATE_LOGIN,

7257: 'U',
7258: req_id,
7259: hz_utility_pub.CREATED_BY,
7260: hz_utility_pub.CREATION_DATE,
7261: hz_utility_pub.LAST_UPDATE_LOGIN,
7262: hz_utility_pub.LAST_UPDATE_DATE,
7263: hz_utility_pub.LAST_UPDATED_BY
7264: );
7265:

Line 7262: hz_utility_pub.LAST_UPDATE_DATE,

7258: req_id,
7259: hz_utility_pub.CREATED_BY,
7260: hz_utility_pub.CREATION_DATE,
7261: hz_utility_pub.LAST_UPDATE_LOGIN,
7262: hz_utility_pub.LAST_UPDATE_DATE,
7263: hz_utility_pub.LAST_UPDATED_BY
7264: );
7265:
7266: end if;

Line 7263: hz_utility_pub.LAST_UPDATED_BY

7259: hz_utility_pub.CREATED_BY,
7260: hz_utility_pub.CREATION_DATE,
7261: hz_utility_pub.LAST_UPDATE_LOGIN,
7262: hz_utility_pub.LAST_UPDATE_DATE,
7263: hz_utility_pub.LAST_UPDATED_BY
7264: );
7265:
7266: end if;
7267: end if;

Line 7409: hz_utility_pub.CREATED_BY,

7405: h.sold_to_org_id,
7406: m.customer_site_id,
7407: 'U',
7408: req_id,
7409: hz_utility_pub.CREATED_BY,
7410: hz_utility_pub.CREATION_DATE,
7411: hz_utility_pub.LAST_UPDATE_LOGIN,
7412: hz_utility_pub.LAST_UPDATE_DATE,
7413: hz_utility_pub.LAST_UPDATED_BY

Line 7410: hz_utility_pub.CREATION_DATE,

7406: m.customer_site_id,
7407: 'U',
7408: req_id,
7409: hz_utility_pub.CREATED_BY,
7410: hz_utility_pub.CREATION_DATE,
7411: hz_utility_pub.LAST_UPDATE_LOGIN,
7412: hz_utility_pub.LAST_UPDATE_DATE,
7413: hz_utility_pub.LAST_UPDATED_BY
7414: from oe_em_information_All h,

Line 7411: hz_utility_pub.LAST_UPDATE_LOGIN,

7407: 'U',
7408: req_id,
7409: hz_utility_pub.CREATED_BY,
7410: hz_utility_pub.CREATION_DATE,
7411: hz_utility_pub.LAST_UPDATE_LOGIN,
7412: hz_utility_pub.LAST_UPDATE_DATE,
7413: hz_utility_pub.LAST_UPDATED_BY
7414: from oe_em_information_All h,
7415: ra_customer_merges m

Line 7412: hz_utility_pub.LAST_UPDATE_DATE,

7408: req_id,
7409: hz_utility_pub.CREATED_BY,
7410: hz_utility_pub.CREATION_DATE,
7411: hz_utility_pub.LAST_UPDATE_LOGIN,
7412: hz_utility_pub.LAST_UPDATE_DATE,
7413: hz_utility_pub.LAST_UPDATED_BY
7414: from oe_em_information_All h,
7415: ra_customer_merges m
7416: where h.sold_to_org_id=m.duplicate_site_id

Line 7413: hz_utility_pub.LAST_UPDATED_BY

7409: hz_utility_pub.CREATED_BY,
7410: hz_utility_pub.CREATION_DATE,
7411: hz_utility_pub.LAST_UPDATE_LOGIN,
7412: hz_utility_pub.LAST_UPDATE_DATE,
7413: hz_utility_pub.LAST_UPDATED_BY
7414: from oe_em_information_All h,
7415: ra_customer_merges m
7416: where h.sold_to_org_id=m.duplicate_site_id
7417: and m.process_flag = 'N'