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_ORDER_LINES_ALL

Line 1963: -- OE_ORDER_LINES_ALL L

1959: end_customer_id,
1960: m.customer_merge_id
1961: FROM RA_CUSTOMER_MERGES M,
1962: -- change for bug 3196900
1963: -- OE_ORDER_LINES_ALL L
1964: OE_ORDER_LINES L
1965: WHERE
1966: (l.sold_to_org_id = m.duplicate_id
1967: or l.invoice_to_org_id = m.duplicate_site_id

Line 2054: -- OE_ORDER_LINES_ALL L

2050: end_customer_id,
2051: m.customer_merge_id
2052: FROM RA_CUSTOMER_MERGES M,
2053: -- changed for bug 3196900
2054: -- OE_ORDER_LINES_ALL L
2055: OE_ORDER_LINES L
2056: WHERE
2057: (l.sold_to_org_id = m.duplicate_id
2058: or l.invoice_to_org_id = m.duplicate_site_id

Line 2161: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

2157:
2158: IF (process_mode = 'LOCK') THEN
2159:
2160: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2161: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
2162:
2163: open merge_lines;
2164: close merge_lines;
2165:

Line 2309: 'OE_ORDER_LINES_ALL',

2305: LAST_UPDATE_DATE,
2306: LAST_UPDATED_BY
2307: ) VALUES (
2308: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2309: 'OE_ORDER_LINES_ALL',
2310: MERGE_HEADER_ID_LIST(I),
2311: line_line_id_tab(I),
2312: line_sold_to_org_id_tab(I),
2313: decode(line_sold_to_org_id_tab(I),NULL,old_line_sold_to_org_id_tab(I),line_sold_to_org_id_tab(i)),

Line 2337: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

2333: end if;
2334: end if;
2335:
2336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2337: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
2338: IF line_line_id_tab.COUNT <> 0 THEN
2339: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
2340: UPDATE OE_ORDER_LINES_ALL L
2341: SET sold_to_org_id = decode(line_sold_to_org_id_tab(i),null,sold_to_org_id,line_sold_to_org_id_tab(i)),

Line 2340: UPDATE OE_ORDER_LINES_ALL L

2336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2337: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
2338: IF line_line_id_tab.COUNT <> 0 THEN
2339: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
2340: UPDATE OE_ORDER_LINES_ALL L
2341: SET sold_to_org_id = decode(line_sold_to_org_id_tab(i),null,sold_to_org_id,line_sold_to_org_id_tab(i)),
2342: invoice_to_org_id = decode(line_invoice_to_org_id_tab(i),null,invoice_to_org_id,line_invoice_to_org_id_tab(i)),
2343: ship_to_org_id = decode(line_ship_to_org_id_tab(i),null,ship_to_org_id,line_ship_to_org_id_tab(i)),
2344: intmed_ship_to_org_id = decode(line_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,line_intmed_ship_to_org_id_tab(i)),

Line 2449: OE_ORDER_LINES_ALL LN

2445: RA_CUSTOMER_MERGES M6,
2446: RA_CUSTOMER_MERGES M7,
2447: -- changed for bug 3196900
2448: -- OE_ORDER_LINES_HISTORY L
2449: OE_ORDER_LINES_ALL LN
2450: -- Changed for MOAC
2451: WHERE
2452: ( l.sold_to_org_id = m1.duplicate_id(+)
2453: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 2518: OE_ORDER_LINES_ALL LN

2514: RA_CUSTOMER_MERGES M6,
2515: RA_CUSTOMER_MERGES M7,
2516: --changed for bug 3196900
2517: -- OE_ORDER_LINES_HISTORY L
2518: OE_ORDER_LINES_ALL LN
2519: --Changed for MOAC
2520: WHERE
2521: ( l.sold_to_org_id = m1.duplicate_id(+)
2522: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 7516: FROM oe_order_lines_all l

7512: PROCEDURE Oe_Update_DBI_log IS
7513:
7514: CURSOR c_get_lines(p_header_id number) IS
7515: SELECT l.line_id
7516: FROM oe_order_lines_all l
7517: WHERE l.header_id = p_header_id;
7518:
7519: CURSOR c_set_of_books_id IS
7520: SELECT SYS.SET_OF_BOOKS_ID

Line 7608: FROM OE_ORDER_LINES_ALL l, oe_order_headers_all h

7604: ,l_set_of_books_id
7605: ,'XXX'
7606: ,dbi_header_update_date_tab(i)
7607:
7608: FROM OE_ORDER_LINES_ALL l, oe_order_headers_all h
7609: WHERE l.header_id = dbi_header_header_id_tab(i)
7610: AND h.header_id = l.header_id
7611: AND h.booked_flag = 'Y';
7612:

Line 7636: FROM OE_ORDER_LINES_ALL l

7632: ,l.line_id
7633: ,l_set_of_books_id
7634: ,'XXX'
7635: ,dbi_line_update_date_tab(i)
7636: FROM OE_ORDER_LINES_ALL l
7637: WHERE l.line_id = dbi_line_line_id_tab(i)
7638: AND l.booked_flag = 'Y'
7639: AND dbi_line_status_tab(i) = 'Y';
7640: arp_message.set_line(' line insert count='||sql%rowcount);