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_HISTORY

Line 2439: FROM OE_ORDER_LINES_HISTORY L,

2435: l.intmed_ship_to_org_id,
2436: l.deliver_to_org_id,
2437: l.end_customer_site_use_id,
2438: l.end_customer_id
2439: FROM OE_ORDER_LINES_HISTORY L,
2440: RA_CUSTOMER_MERGES M1,
2441: RA_CUSTOMER_MERGES M2,
2442: RA_CUSTOMER_MERGES M3,
2443: RA_CUSTOMER_MERGES M4,

Line 2448: -- OE_ORDER_LINES_HISTORY L

2444: RA_CUSTOMER_MERGES M5,
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(+)

Line 2508: FROM OE_ORDER_LINES_HISTORY L ,

2504: l.intmed_ship_to_org_id,
2505: l.deliver_to_org_id,
2506: l.end_customer_site_use_id,
2507: l.end_customer_id
2508: FROM OE_ORDER_LINES_HISTORY L ,
2509: RA_CUSTOMER_MERGES M1,
2510: RA_CUSTOMER_MERGES M2,
2511: RA_CUSTOMER_MERGES M3,
2512: RA_CUSTOMER_MERGES M4,

Line 2517: -- OE_ORDER_LINES_HISTORY L

2513: RA_CUSTOMER_MERGES M5,
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(+)

Line 2580: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

2576:
2577: IF (process_mode = 'LOCK') THEN
2578:
2579: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2580: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
2581:
2582: open merge_lines_history;
2583: close merge_lines_history;
2584:

Line 2653: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

2649: end if;
2650:
2651:
2652: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2653: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
2654:
2655: IF lhst_line_id_tab.COUNT <> 0 THEN
2656: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
2657: UPDATE OE_ORDER_LINES_HISTORY LHIST

Line 2657: UPDATE OE_ORDER_LINES_HISTORY LHIST

2653: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
2654:
2655: IF lhst_line_id_tab.COUNT <> 0 THEN
2656: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
2657: UPDATE OE_ORDER_LINES_HISTORY LHIST
2658: SET sold_to_org_id = decode(lhst_sold_to_org_id_tab(i),null,sold_to_org_id,lhst_sold_to_org_id_tab(i)),
2659: invoice_to_org_id = decode(lhst_invoice_to_org_id_tab(i),null,invoice_to_org_id,lhst_invoice_to_org_id_tab(i)),
2660: ship_to_org_id = decode(lhst_ship_to_org_id_tab(i),null,ship_to_org_id,lhst_ship_to_org_id_tab(i)),
2661: intmed_ship_to_org_id = decode(lhst_intmed_ship_to_org_id_tab(i),null,intmed_ship_to_org_id,lhst_intmed_ship_to_org_id_tab(i)),