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 1593: from OE_HEADER_ACKS

1589: Process_Mode IN VARCHAR2)
1590: IS
1591: CURSOR c1 is
1592: select HEADER_ID
1593: from OE_HEADER_ACKS
1594: where ship_to_org_id in
1595: (select m.duplicate_site_id
1596: from ra_customer_merges m
1597: where m.process_flag = 'N'

Line 1606: from OE_HEADER_ACKS

1602:
1603:
1604: CURSOR c2 is
1605: select HEADER_ID
1606: from OE_HEADER_ACKS
1607: where invoice_to_org_id in
1608: (select m.duplicate_site_id
1609: from ra_customer_merges m
1610: where m.process_flag = 'N'

Line 1619: from OE_HEADER_ACKS

1615:
1616:
1617: CURSOR c3 is
1618: select HEADER_ID
1619: from OE_HEADER_ACKS
1620: where deliver_to_org_id in
1621: (select m.duplicate_site_id
1622: from ra_customer_merges m
1623: where m.process_flag = 'N'

Line 1632: from OE_HEADER_ACKS a, OE_ORDER_HEADERS_all h

1628:
1629: CURSOR c4 is
1630: --changed for bug 3196900
1631: select /* MOAC_SQL_CHANGE */ a.HEADER_ID
1632: from OE_HEADER_ACKS a, OE_ORDER_HEADERS_all h
1633: where a.sold_to_org_id in
1634: (select m.duplicate_id
1635: from ra_customer_merges m
1636: where m.process_flag = 'N'

Line 1646: from OE_HEADER_ACKS

1642: for update nowait;
1643:
1644: CURSOR c5 is
1645: select HEADER_ID
1646: from OE_HEADER_ACKS
1647: where sold_to_site_use_id in
1648: (select m.duplicate_id
1649: from ra_customer_merges m
1650: where m.process_flag = 'N'

Line 1658: from OE_HEADER_ACKS

1654: for update nowait;
1655:
1656: CURSOR c6 is
1657: select HEADER_ID
1658: from OE_HEADER_ACKS
1659: where end_customer_site_use_id in
1660: (select m.duplicate_id
1661: from ra_customer_merges m
1662: where m.process_flag = 'N'

Line 1671: from OE_HEADER_ACKS a,OE_ORDER_HEADERS h

1667:
1668: CURSOR c7 is
1669: --changed for bug 3196900
1670: select a.HEADER_ID
1671: from OE_HEADER_ACKS a,OE_ORDER_HEADERS h
1672: where a.end_customer_id in
1673: (select m.duplicate_id
1674: from ra_customer_merges m
1675: where m.process_flag = 'N'

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

1689:
1690: IF( process_mode = 'LOCK' ) THEN
1691:
1692: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1693: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1694:
1695: open c1;
1696: close c1;
1697:

Line 1739: 'OE_HEADER_ACKS',

1735: LAST_UPDATED_BY
1736: )
1737: select
1738: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1739: 'OE_HEADER_ACKS',
1740: m.CUSTOMER_MERGE_HEADER_ID,
1741: h.ORIG_SYS_DOCUMENT_REF,
1742: h.ship_to_org_id,
1743: m.customer_site_id,

Line 1751: from oe_header_acks h,

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

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

1758: end if;
1759:
1760: /* site level update */
1761: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1762: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1763:
1764: UPDATE OE_HEADER_ACKS a
1765: set ship_to_org_id = (select distinct m.customer_site_id
1766: from ra_customer_merges m

Line 1764: UPDATE OE_HEADER_ACKS a

1760: /* site level update */
1761: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1762: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1763:
1764: UPDATE OE_HEADER_ACKS a
1765: set ship_to_org_id = (select distinct m.customer_site_id
1766: from ra_customer_merges m
1767: where a.ship_to_org_id = m.duplicate_site_id
1768: and m.request_id = req_id

Line 1818: from oe_header_acks h,

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

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

1824: and NVL(h.ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1825: end if;
1826:
1827: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1828: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1829:
1830: UPDATE OE_HEADER_ACKS a
1831: set invoice_to_org_id = (select distinct m.customer_site_id
1832: from ra_customer_merges m

Line 1830: UPDATE OE_HEADER_ACKS a

1826:
1827: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1828: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1829:
1830: UPDATE OE_HEADER_ACKS a
1831: set invoice_to_org_id = (select distinct m.customer_site_id
1832: from ra_customer_merges m
1833: where a.invoice_to_org_id = m.duplicate_site_id
1834: and m.request_id = req_id

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

1851: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1852: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1853:
1854: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1855: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1856:
1857: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1858: insert into HZ_CUSTOMER_MERGE_LOG (
1859: MERGE_LOG_ID,

Line 1875: 'OE_HEADER_ACKS',

1871: LAST_UPDATED_BY
1872: )
1873: select
1874: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1875: 'OE_HEADER_ACKS',
1876: m.CUSTOMER_MERGE_HEADER_ID,
1877: h.ORIG_SYS_DOCUMENT_REF,
1878: h.deliver_to_org_id,
1879: m.customer_site_id,

Line 1887: from oe_header_acks h,

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

Line 1896: UPDATE OE_HEADER_ACKS a

1892: and m.set_number = set_num
1893: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1894: end if;
1895:
1896: UPDATE OE_HEADER_ACKS a
1897: set deliver_to_org_id = (select distinct m.customer_site_id
1898: from ra_customer_merges m
1899: where a.deliver_to_org_id = m.duplicate_site_id
1900: and m.request_id = req_id

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

1917: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
1918: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
1919:
1920: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1921: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1922:
1923:
1924: /* customer level update */
1925: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');

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

1922:
1923:
1924: /* customer level update */
1925: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1926: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1927:
1928: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1929: insert into HZ_CUSTOMER_MERGE_LOG (
1930: MERGE_LOG_ID,

Line 1946: 'OE_HEADER_ACKS',

1942: LAST_UPDATED_BY
1943: )
1944: select
1945: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1946: 'OE_HEADER_ACKS',
1947: m.CUSTOMER_MERGE_HEADER_ID,
1948: h.ORIG_SYS_DOCUMENT_REF,
1949: h.sold_to_org_id,
1950: m.customer_site_id,

Line 1958: from oe_header_acks h,

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

Line 1967: UPDATE OE_HEADER_ACKS a

1963: and m.set_number = set_num
1964: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
1965: end if;
1966:
1967: UPDATE OE_HEADER_ACKS a
1968: set sold_to_org_id = (select distinct m.customer_id
1969: from ra_customer_merges m
1970: where a.sold_to_org_id = m.duplicate_id
1971: and m.process_flag = 'N'

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

1994:
1995: -- sold_to_site_use_id merge
1996:
1997: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1998: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
1999:
2000: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2001: insert into HZ_CUSTOMER_MERGE_LOG (
2002: MERGE_LOG_ID,

Line 2018: 'OE_HEADER_ACKS',

2014: LAST_UPDATED_BY
2015: )
2016: select
2017: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2018: 'OE_HEADER_ACKS',
2019: m.CUSTOMER_MERGE_HEADER_ID,
2020: h.ORIG_SYS_DOCUMENT_REF,
2021: h.sold_to_site_use_id,
2022: m.customer_site_id,

Line 2030: from oe_header_acks h,

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

Line 2041: UPDATE OE_HEADER_ACKS a

2037: and m.set_number = set_num
2038: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
2039: end if;
2040:
2041: UPDATE OE_HEADER_ACKS a
2042: set sold_to_site_use_id = (select distinct m.customer_id
2043: from ra_customer_merges m
2044: where a.sold_to_site_use_id = m.duplicate_id
2045: and m.process_flag = 'N'

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

2067:
2068: -- end_customer_site_use_id merge
2069:
2070: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2071: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
2072:
2073: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2074: insert into HZ_CUSTOMER_MERGE_LOG (
2075: MERGE_LOG_ID,

Line 2091: 'OE_HEADER_ACKS',

2087: LAST_UPDATED_BY
2088: )
2089: select
2090: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2091: 'OE_HEADER_ACKS',
2092: m.CUSTOMER_MERGE_HEADER_ID,
2093: h.ORIG_SYS_DOCUMENT_REF,
2094: h.end_customer_site_use_id,
2095: m.customer_site_id,

Line 2103: from oe_header_acks h,

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

Line 2114: UPDATE OE_HEADER_ACKS a

2110: and m.set_number = set_num
2111: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
2112: end if;
2113:
2114: UPDATE OE_HEADER_ACKS a
2115: set end_customer_site_use_id = (select distinct m.customer_id
2116: from ra_customer_merges m
2117: where a.end_customer_site_use_id = m.duplicate_id
2118: and m.process_flag = 'N'

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

2140: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
2141:
2142: /* customer level update */
2143: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2144: arp_message.set_token( 'TABLE_NAME', 'OE_HEADER_ACKS', FALSE );
2145:
2146: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2147: insert into HZ_CUSTOMER_MERGE_LOG (
2148: MERGE_LOG_ID,

Line 2164: 'OE_HEADER_ACKS',

2160: LAST_UPDATED_BY
2161: )
2162: select
2163: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2164: 'OE_HEADER_ACKS',
2165: m.CUSTOMER_MERGE_HEADER_ID,
2166: h.ORIG_SYS_DOCUMENT_REF,
2167: h.end_customer_id,
2168: m.customer_site_id,

Line 2176: from oe_header_acks h,

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
2180: h.end_customer_id=m.duplicate_id ----added for bug# 13058344

Line 2188: UPDATE OE_HEADER_ACKS a

2184: and m.set_number = set_num
2185: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
2186: end if;
2187:
2188: UPDATE OE_HEADER_ACKS a
2189: set end_customer_id = (select distinct m.customer_id
2190: from ra_customer_merges m
2191: where a.end_customer_id = m.duplicate_id
2192: and m.process_flag = 'N'