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_DATA_FIX dependencies on OE_LINE_ACKS

Line 1751: from oe_line_acks

1747: Process_Mode IN VARCHAR2)
1748: IS
1749: CURSOR c1 is
1750: select line_id
1751: from oe_line_acks
1752: where ship_to_org_id in
1753: (select m.duplicate_site_id
1754: from ra_customer_merges m
1755: where m.process_flag = 'Y'

Line 1764: from oe_line_acks

1760:
1761:
1762: CURSOR c2 is
1763: select line_id
1764: from oe_line_acks
1765: where invoice_to_org_id in
1766: (select m.duplicate_site_id
1767: from ra_customer_merges m
1768: where m.process_flag = 'Y'

Line 1777: from oe_line_acks

1773:
1774:
1775: CURSOR c3 is
1776: select line_id
1777: from oe_line_acks
1778: where deliver_to_org_id in
1779: (select m.duplicate_site_id
1780: from ra_customer_merges m
1781: where m.process_flag = 'Y'

Line 1790: from oe_line_acks

1786:
1787:
1788: CURSOR c4 is
1789: select line_id
1790: from oe_line_acks
1791: where intmed_ship_to_org_id in
1792: (select m.duplicate_site_id
1793: from ra_customer_merges m
1794: where m.process_flag = 'Y'

Line 1802: from oe_line_acks

1798: for update nowait;
1799:
1800: CURSOR c5 is
1801: select line_id
1802: from oe_line_acks
1803: where sold_to_org_id in
1804: (select m.duplicate_id
1805: from ra_customer_merges m
1806: where m.process_flag = 'Y'

Line 1825: oe_debug_pub.add( 'LOCKING TABLE OE_LINE_ACKS' ) ;

1821: /* both customer and site level */
1822:
1823: IF( process_mode = 'LOCK' ) THEN
1824: IF l_debug_level > 0 THEN
1825: oe_debug_pub.add( 'LOCKING TABLE OE_LINE_ACKS' ) ;
1826: END IF;
1827: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1828: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1829:

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

1824: IF l_debug_level > 0 THEN
1825: oe_debug_pub.add( 'LOCKING TABLE OE_LINE_ACKS' ) ;
1826: END IF;
1827: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
1828: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1829:
1830: open c1;
1831: close c1;
1832:

Line 1852: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

1848: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
1849: END IF;
1850:
1851: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1852: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1853: IF l_debug_level > 0 THEN
1854: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SHIP_TO_ORG_ID' ) ;
1855: END IF;
1856:

Line 1854: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SHIP_TO_ORG_ID' ) ;

1850:
1851: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1852: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1853: IF l_debug_level > 0 THEN
1854: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SHIP_TO_ORG_ID' ) ;
1855: END IF;
1856:
1857: UPDATE oe_line_acks a
1858: set ship_to_org_id = (select distinct m.customer_site_id

Line 1857: UPDATE oe_line_acks a

1853: IF l_debug_level > 0 THEN
1854: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SHIP_TO_ORG_ID' ) ;
1855: END IF;
1856:
1857: UPDATE oe_line_acks a
1858: set ship_to_org_id = (select distinct m.customer_site_id
1859: from ra_customer_merges m
1860: where a.ship_to_org_id = m.duplicate_site_id
1861: and m.request_id = req_id

Line 1884: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

1880: IF l_debug_level > 0 THEN
1881: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1882: END IF;
1883: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1884: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1885: IF l_debug_level > 0 THEN
1886: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INVOICE_TO_ORG_ID' ) ;
1887: END IF;
1888:

Line 1886: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INVOICE_TO_ORG_ID' ) ;

1882: END IF;
1883: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1884: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1885: IF l_debug_level > 0 THEN
1886: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INVOICE_TO_ORG_ID' ) ;
1887: END IF;
1888:
1889: UPDATE oe_line_acks a
1890: set invoice_to_org_id = (select distinct m.customer_site_id

Line 1889: UPDATE oe_line_acks a

1885: IF l_debug_level > 0 THEN
1886: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INVOICE_TO_ORG_ID' ) ;
1887: END IF;
1888:
1889: UPDATE oe_line_acks a
1890: set invoice_to_org_id = (select distinct m.customer_site_id
1891: from ra_customer_merges m
1892: where a.invoice_to_org_id = m.duplicate_site_id
1893: and m.request_id = req_id

Line 1916: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

1912: IF l_debug_level > 0 THEN
1913: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1914: END IF;
1915: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1916: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.DELIVER_TO_ORG_ID' ) ;
1919: END IF;
1920:

Line 1918: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.DELIVER_TO_ORG_ID' ) ;

1914: END IF;
1915: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1916: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.DELIVER_TO_ORG_ID' ) ;
1919: END IF;
1920:
1921: UPDATE oe_line_acks a
1922: set deliver_to_org_id = (select distinct m.customer_site_id

Line 1921: UPDATE oe_line_acks a

1917: IF l_debug_level > 0 THEN
1918: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.DELIVER_TO_ORG_ID' ) ;
1919: END IF;
1920:
1921: UPDATE oe_line_acks a
1922: set deliver_to_org_id = (select distinct m.customer_site_id
1923: from ra_customer_merges m
1924: where a.deliver_to_org_id = m.duplicate_site_id
1925: and m.request_id = req_id

Line 1948: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

1944: IF l_debug_level > 0 THEN
1945: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1946: END IF;
1947: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1948: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1949: IF l_debug_level > 0 THEN
1950: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INTMED_TO_ORG_ID' ) ;
1951: END IF;
1952:

Line 1950: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INTMED_TO_ORG_ID' ) ;

1946: END IF;
1947: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1948: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1949: IF l_debug_level > 0 THEN
1950: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INTMED_TO_ORG_ID' ) ;
1951: END IF;
1952:
1953: UPDATE oe_line_acks a
1954: set intmed_ship_to_org_id = (select distinct m.customer_site_id

Line 1953: UPDATE oe_line_acks a

1949: IF l_debug_level > 0 THEN
1950: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.INTMED_TO_ORG_ID' ) ;
1951: END IF;
1952:
1953: UPDATE oe_line_acks a
1954: set intmed_ship_to_org_id = (select distinct m.customer_site_id
1955: from ra_customer_merges m
1956: where a.intmed_ship_to_org_id = m.duplicate_site_id
1957: and m.request_id = req_id

Line 1980: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

1976: IF l_debug_level > 0 THEN
1977: oe_debug_pub.add( G_COUNT || ' ROWS UPDATED' ) ;
1978: END IF;
1979: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1980: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1981:
1982:
1983: /* customer level update */
1984: IF l_debug_level > 0 THEN

Line 1988: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

1984: IF l_debug_level > 0 THEN
1985: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
1986: END IF;
1987: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1988: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1989: IF l_debug_level > 0 THEN
1990: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SOLD_TO_ORG_ID' ) ;
1991: END IF;
1992:

Line 1990: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SOLD_TO_ORG_ID' ) ;

1986: END IF;
1987: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
1988: -- arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
1989: IF l_debug_level > 0 THEN
1990: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SOLD_TO_ORG_ID' ) ;
1991: END IF;
1992:
1993: UPDATE oe_line_acks a
1994: set sold_to_org_id = (select distinct m.customer_id

Line 1993: UPDATE oe_line_acks a

1989: IF l_debug_level > 0 THEN
1990: oe_debug_pub.add( 'UPDATING OE_LINE_ACKS.SOLD_TO_ORG_ID' ) ;
1991: END IF;
1992:
1993: UPDATE oe_line_acks a
1994: set sold_to_org_id = (select distinct m.customer_id
1995: from ra_customer_merges m
1996: where a.sold_to_org_id = m.duplicate_id
1997: and m.process_flag = 'Y'