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 OE_HEADER_ACKS

Line 1295: from OE_HEADER_ACKS

1291: Process_Mode IN VARCHAR2)
1292: IS
1293: CURSOR c1 is
1294: select HEADER_ID
1295: from OE_HEADER_ACKS
1296: where ship_to_org_id in
1297: (select m.duplicate_site_id
1298: from ra_customer_merges m
1299: where m.process_flag = 'N'

Line 1308: from OE_HEADER_ACKS

1304:
1305:
1306: CURSOR c2 is
1307: select HEADER_ID
1308: from OE_HEADER_ACKS
1309: where invoice_to_org_id in
1310: (select m.duplicate_site_id
1311: from ra_customer_merges m
1312: where m.process_flag = 'N'

Line 1321: from OE_HEADER_ACKS

1317:
1318:
1319: CURSOR c3 is
1320: select HEADER_ID
1321: from OE_HEADER_ACKS
1322: where deliver_to_org_id in
1323: (select m.duplicate_site_id
1324: from ra_customer_merges m
1325: where m.process_flag = 'N'

Line 1334: from OE_HEADER_ACKS a, OE_ORDER_HEADERS_all h

1330:
1331: CURSOR c4 is
1332: --changed for bug 3196900
1333: select /* MOAC_SQL_CHANGE */ a.HEADER_ID
1334: from OE_HEADER_ACKS a, OE_ORDER_HEADERS_all h
1335: where a.sold_to_org_id in
1336: (select m.duplicate_id
1337: from ra_customer_merges m
1338: where m.process_flag = 'N'

Line 1348: from OE_HEADER_ACKS

1344: for update nowait;
1345:
1346: CURSOR c5 is
1347: select HEADER_ID
1348: from OE_HEADER_ACKS
1349: where sold_to_site_use_id in
1350: (select m.duplicate_id
1351: from ra_customer_merges m
1352: where m.process_flag = 'N'

Line 1360: from OE_HEADER_ACKS

1356: for update nowait;
1357:
1358: CURSOR c6 is
1359: select HEADER_ID
1360: from OE_HEADER_ACKS
1361: where end_customer_site_use_id in
1362: (select m.duplicate_id
1363: from ra_customer_merges m
1364: where m.process_flag = 'N'

Line 1373: from OE_HEADER_ACKS a,OE_ORDER_HEADERS h

1369:
1370: CURSOR c7 is
1371: --changed for bug 3196900
1372: select a.HEADER_ID
1373: from OE_HEADER_ACKS a,OE_ORDER_HEADERS h
1374: where a.end_customer_id in
1375: (select m.duplicate_id
1376: from ra_customer_merges m
1377: where m.process_flag = 'N'

Line 1395: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1391:
1392: IF( process_mode = 'LOCK' ) THEN
1393:
1394: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1395: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1396:
1397: open c1;
1398: close c1;
1399:

Line 1441: 'OE_HEADER_ACKS',

1437: LAST_UPDATED_BY
1438: )
1439: select
1440: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1441: 'OE_HEADER_ACKS',
1442: m.CUSTOMER_MERGE_HEADER_ID,
1443: h.ORIG_SYS_DOCUMENT_REF,
1444: h.ship_to_org_id,
1445: m.customer_site_id,

Line 1453: from oe_header_acks h,

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'
1457: and m.request_id = req_id

Line 1464: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1460: end if;
1461:
1462: /* site level update */
1463: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1464: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1465:
1466: UPDATE OE_HEADER_ACKS a
1467: set ship_to_org_id = (select distinct m.customer_site_id
1468: from ra_customer_merges m

Line 1466: UPDATE OE_HEADER_ACKS a

1462: /* site level update */
1463: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1464: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1465:
1466: UPDATE OE_HEADER_ACKS a
1467: set ship_to_org_id = (select distinct m.customer_site_id
1468: from ra_customer_merges m
1469: where a.ship_to_org_id = m.duplicate_site_id
1470: and m.request_id = req_id

Line 1520: from oe_header_acks h,

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'
1524: and m.request_id = req_id

Line 1530: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1526: and NVL(h.ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1527: end if;
1528:
1529: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1530: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1531:
1532: UPDATE OE_HEADER_ACKS a
1533: set invoice_to_org_id = (select distinct m.customer_site_id
1534: from ra_customer_merges m

Line 1532: UPDATE OE_HEADER_ACKS a

1528:
1529: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1530: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1531:
1532: UPDATE OE_HEADER_ACKS a
1533: set invoice_to_org_id = (select distinct m.customer_site_id
1534: from ra_customer_merges m
1535: where a.invoice_to_org_id = m.duplicate_site_id
1536: and m.request_id = req_id

Line 1557: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1553: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1554: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1555:
1556: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1557: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1558:
1559: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1560: insert into HZ_CUSTOMER_MERGE_LOG (
1561: MERGE_LOG_ID,

Line 1577: 'OE_HEADER_ACKS',

1573: LAST_UPDATED_BY
1574: )
1575: select
1576: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1577: 'OE_HEADER_ACKS',
1578: m.CUSTOMER_MERGE_HEADER_ID,
1579: h.ORIG_SYS_DOCUMENT_REF,
1580: h.deliver_to_org_id,
1581: m.customer_site_id,

Line 1589: from oe_header_acks h,

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'
1593: and m.request_id = req_id

Line 1598: UPDATE OE_HEADER_ACKS a

1594: and m.set_number = set_num
1595: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1596: end if;
1597:
1598: UPDATE OE_HEADER_ACKS a
1599: set deliver_to_org_id = (select distinct m.customer_site_id
1600: from ra_customer_merges m
1601: where a.deliver_to_org_id = m.duplicate_site_id
1602: and m.request_id = req_id

Line 1623: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1619: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1620: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1621:
1622: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1623: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1624:
1625:
1626: /* customer level update */
1627: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

Line 1628: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1624:
1625:
1626: /* customer level update */
1627: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1628: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1629:
1630: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1631: insert into HZ_CUSTOMER_MERGE_LOG (
1632: MERGE_LOG_ID,

Line 1648: 'OE_HEADER_ACKS',

1644: LAST_UPDATED_BY
1645: )
1646: select
1647: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1648: 'OE_HEADER_ACKS',
1649: m.CUSTOMER_MERGE_HEADER_ID,
1650: h.ORIG_SYS_DOCUMENT_REF,
1651: h.sold_to_org_id,
1652: m.customer_site_id,

Line 1660: from oe_header_acks h,

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'
1664: and m.request_id = req_id

Line 1669: UPDATE OE_HEADER_ACKS a

1665: and m.set_number = set_num
1666: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1667: end if;
1668:
1669: UPDATE OE_HEADER_ACKS a
1670: set sold_to_org_id = (select distinct m.customer_id
1671: from ra_customer_merges m
1672: where a.sold_to_org_id = m.duplicate_id
1673: and m.process_flag = 'N'

Line 1700: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1696:
1697: -- sold_to_site_use_id merge
1698:
1699: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1700: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1701:
1702: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1703: insert into HZ_CUSTOMER_MERGE_LOG (
1704: MERGE_LOG_ID,

Line 1720: 'OE_HEADER_ACKS',

1716: LAST_UPDATED_BY
1717: )
1718: select
1719: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1720: 'OE_HEADER_ACKS',
1721: m.CUSTOMER_MERGE_HEADER_ID,
1722: h.ORIG_SYS_DOCUMENT_REF,
1723: h.sold_to_site_use_id,
1724: m.customer_site_id,

Line 1732: from oe_header_acks h,

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
1736: and

Line 1743: UPDATE OE_HEADER_ACKS a

1739: and m.set_number = set_num
1740: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1741: end if;
1742:
1743: UPDATE OE_HEADER_ACKS a
1744: set sold_to_site_use_id = (select distinct m.customer_id
1745: from ra_customer_merges m
1746: where a.sold_to_site_use_id = m.duplicate_id
1747: and m.process_flag = 'N'

Line 1773: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1769:
1770: -- end_customer_site_use_id merge
1771:
1772: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1773: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1774:
1775: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1776: insert into HZ_CUSTOMER_MERGE_LOG (
1777: MERGE_LOG_ID,

Line 1793: 'OE_HEADER_ACKS',

1789: LAST_UPDATED_BY
1790: )
1791: select
1792: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1793: 'OE_HEADER_ACKS',
1794: m.CUSTOMER_MERGE_HEADER_ID,
1795: h.ORIG_SYS_DOCUMENT_REF,
1796: h.end_customer_site_use_id,
1797: m.customer_site_id,

Line 1805: from oe_header_acks h,

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
1809: and

Line 1816: UPDATE OE_HEADER_ACKS a

1812: and m.set_number = set_num
1813: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1814: end if;
1815:
1816: UPDATE OE_HEADER_ACKS a
1817: set end_customer_site_use_id = (select distinct m.customer_id
1818: from ra_customer_merges m
1819: where a.end_customer_site_use_id = m.duplicate_id
1820: and m.process_flag = 'N'

Line 1846: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );

1842: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1843:
1844: /* customer level update */
1845: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1846: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1847:
1848: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1849: insert into HZ_CUSTOMER_MERGE_LOG (
1850: MERGE_LOG_ID,

Line 1866: 'OE_HEADER_ACKS',

1862: LAST_UPDATED_BY
1863: )
1864: select
1865: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1866: 'OE_HEADER_ACKS',
1867: m.CUSTOMER_MERGE_HEADER_ID,
1868: h.ORIG_SYS_DOCUMENT_REF,
1869: h.end_customer_id,
1870: m.customer_site_id,

Line 1878: from oe_header_acks h,

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
1882: and

Line 1889: UPDATE OE_HEADER_ACKS a

1885: and m.set_number = set_num
1886: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1887: end if;
1888:
1889: UPDATE OE_HEADER_ACKS a
1890: set end_customer_id = (select distinct m.customer_id
1891: from ra_customer_merges m
1892: where a.end_customer_id = m.duplicate_id
1893: and m.process_flag = 'N'