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 2262: -- OE_ORDER_LINES_ALL L

2258: end_customer_id,
2259: m.customer_merge_id
2260: FROM RA_CUSTOMER_MERGES M,
2261: -- change for bug 3196900
2262: -- OE_ORDER_LINES_ALL L
2263: OE_ORDER_LINES L
2264: WHERE
2265: (l.sold_to_org_id = m.duplicate_id
2266: or l.invoice_to_org_id = m.duplicate_site_id

Line 2354: -- OE_ORDER_LINES_ALL L

2350: end_customer_id,
2351: m.customer_merge_id
2352: FROM RA_CUSTOMER_MERGES M,
2353: -- changed for bug 3196900
2354: -- OE_ORDER_LINES_ALL L
2355: OE_ORDER_LINES L
2356: WHERE
2357: (l.sold_to_org_id = m.duplicate_id
2358: or l.invoice_to_org_id = m.duplicate_site_id

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

2539:
2540: IF (process_mode = 'LOCK') THEN
2541:
2542: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2543: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
2544:
2545: open merge_lines;
2546: close merge_lines;
2547:

Line 2725: 'OE_ORDER_LINES_ALL',

2721: LAST_UPDATE_DATE,
2722: LAST_UPDATED_BY
2723: ) VALUES (
2724: HZ_CUSTOMER_MERGE_LOG_s.nextval,
2725: 'OE_ORDER_LINES_ALL',
2726: MERGE_HEADER_ID_LIST(I),
2727: line_line_id_tab(I),
2728: line_sold_to_org_id_tab(I),
2729: 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 2753: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );

2749: end if;
2750: end if;
2751:
2752: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2753: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
2754: IF line_line_id_tab.COUNT <> 0 THEN
2755: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
2756: UPDATE OE_ORDER_LINES_ALL L
2757: 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 2756: UPDATE OE_ORDER_LINES_ALL L

2752: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2753: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_all', FALSE );
2754: IF line_line_id_tab.COUNT <> 0 THEN
2755: FORALL i in line_line_id_tab.FIRST..line_line_id_tab.LAST
2756: UPDATE OE_ORDER_LINES_ALL L
2757: 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)),
2758: invoice_to_org_id = decode(line_invoice_to_org_id_tab(i),null,invoice_to_org_id,line_invoice_to_org_id_tab(i)),
2759: ship_to_org_id = decode(line_ship_to_org_id_tab(i),null,ship_to_org_id,line_ship_to_org_id_tab(i)),
2760: 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 2876: OE_ORDER_LINES_ALL LN

2872: RA_CUSTOMER_MERGES M6,
2873: RA_CUSTOMER_MERGES M7,
2874: -- changed for bug 3196900
2875: -- OE_ORDER_LINES_HISTORY L
2876: OE_ORDER_LINES_ALL LN
2877: -- Changed for MOAC
2878: WHERE
2879: ( l.sold_to_org_id = m1.duplicate_id(+)
2880: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 2945: OE_ORDER_LINES_ALL LN

2941: RA_CUSTOMER_MERGES M6,
2942: RA_CUSTOMER_MERGES M7,
2943: --changed for bug 3196900
2944: -- OE_ORDER_LINES_HISTORY L
2945: OE_ORDER_LINES_ALL LN
2946: --Changed for MOAC
2947: WHERE
2948: ( l.sold_to_org_id = m1.duplicate_id(+)
2949: and l.invoice_to_org_id = m2.duplicate_site_id(+)

Line 2992: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

2988: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
2989: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
2990: L.END_CUSTOMER_ID
2991: FROM
2992: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
2993: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
2994: AND M1.PROCESS_FLAG='N'
2995: AND M1.REQUEST_ID = req_id
2996: AND M1.SET_NUMBER = set_num

Line 3003: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

2999: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
3000: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
3001: L.END_CUSTOMER_ID
3002: FROM
3003: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
3004: WHERE L.INVOICE_TO_ORG_ID= M1.DUPLICATE_SITE_ID
3005: AND M1.PROCESS_FLAG='N'
3006: AND M1.REQUEST_ID = req_id
3007: AND M1.SET_NUMBER = set_num

Line 3014: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

3010: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
3011: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
3012: L.END_CUSTOMER_ID
3013: FROM
3014: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
3015: WHERE L.SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
3016: AND M1.PROCESS_FLAG='N'
3017: AND M1.REQUEST_ID = req_id
3018: AND M1.SET_NUMBER = set_num

Line 3025: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

3021: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
3022: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
3023: L.END_CUSTOMER_ID
3024: FROM
3025: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
3026: WHERE L.INTMED_SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
3027: AND M1.PROCESS_FLAG='N'
3028: AND M1.REQUEST_ID = req_id
3029: AND M1.SET_NUMBER = set_num

Line 3036: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

3032: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
3033: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
3034: L.END_CUSTOMER_ID
3035: FROM
3036: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
3037: WHERE L.DELIVER_TO_ORG_ID= M1.DUPLICATE_SITE_ID
3038: AND M1.PROCESS_FLAG='N'
3039: AND M1.REQUEST_ID = req_id
3040: AND M1.SET_NUMBER = set_num

Line 3047: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

3043: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
3044: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
3045: L.END_CUSTOMER_ID
3046: FROM
3047: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
3048: WHERE L.END_CUSTOMER_SITE_USE_ID= M1.DUPLICATE_SITE_ID
3049: AND M1.PROCESS_FLAG='N'
3050: AND M1.REQUEST_ID = req_id
3051: AND M1.SET_NUMBER = set_num

Line 3058: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN

3054: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID, L.SHIP_TO_ORG_ID,
3055: L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID, L.END_CUSTOMER_SITE_USE_ID,
3056: L.END_CUSTOMER_ID
3057: FROM
3058: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES_HISTORY L, OE_ORDER_LINES_ALL LN
3059: WHERE L.END_CUSTOMER_ID= M1.DUPLICATE_ID
3060: AND M1.PROCESS_FLAG='N'
3061: AND M1.REQUEST_ID = req_id
3062: AND M1.SET_NUMBER = set_num

Line 8378: FROM oe_order_lines_all l

8374: PROCEDURE Oe_Update_DBI_log IS
8375:
8376: CURSOR c_get_lines(p_header_id number) IS
8377: SELECT l.line_id
8378: FROM oe_order_lines_all l
8379: WHERE l.header_id = p_header_id;
8380:
8381: CURSOR c_set_of_books_id IS
8382: SELECT SYS.SET_OF_BOOKS_ID

Line 8470: FROM OE_ORDER_LINES_ALL l, oe_order_headers_all h

8466: ,l_set_of_books_id
8467: ,'XXX'
8468: ,l.last_update_date ----dbi_header_update_date_tab(i) bug 9349882,9558975
8469:
8470: FROM OE_ORDER_LINES_ALL l, oe_order_headers_all h
8471: WHERE l.header_id = dbi_header_header_id_tab(i)
8472: AND h.header_id = l.header_id
8473: AND h.booked_flag = 'Y';
8474:

Line 8498: FROM OE_ORDER_LINES_ALL l

8494: ,l.line_id
8495: ,l_set_of_books_id
8496: ,'XXX'
8497: ,l.last_update_date ---dbi_line_update_date_tab(i) bug 9349882,9558975
8498: FROM OE_ORDER_LINES_ALL l
8499: WHERE l.line_id = dbi_line_line_id_tab(i)
8500: AND l.booked_flag = 'Y'
8501: AND dbi_line_status_tab(i) = 'Y';
8502: arp_message.set_line(' line insert count='||sql%rowcount);