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 2866: FROM OE_ORDER_LINES_HISTORY L,

2862: l.intmed_ship_to_org_id,
2863: l.deliver_to_org_id,
2864: l.end_customer_site_use_id,
2865: l.end_customer_id
2866: FROM OE_ORDER_LINES_HISTORY L,
2867: RA_CUSTOMER_MERGES M1,
2868: RA_CUSTOMER_MERGES M2,
2869: RA_CUSTOMER_MERGES M3,
2870: RA_CUSTOMER_MERGES M4,

Line 2875: -- OE_ORDER_LINES_HISTORY L

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

Line 2935: FROM OE_ORDER_LINES_HISTORY L ,

2931: l.intmed_ship_to_org_id,
2932: l.deliver_to_org_id,
2933: l.end_customer_site_use_id,
2934: l.end_customer_id
2935: FROM OE_ORDER_LINES_HISTORY L ,
2936: RA_CUSTOMER_MERGES M1,
2937: RA_CUSTOMER_MERGES M2,
2938: RA_CUSTOMER_MERGES M3,
2939: RA_CUSTOMER_MERGES M4,

Line 2944: -- OE_ORDER_LINES_HISTORY L

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

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 3085: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );

3081:
3082: IF (process_mode = 'LOCK') THEN
3083:
3084: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3085: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
3086:
3087: open merge_lines_history;
3088: close merge_lines_history;
3089:

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

3178: end if;
3179:
3180:
3181: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3182: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
3183:
3184: IF lhst_line_id_tab.COUNT <> 0 THEN
3185: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
3186: UPDATE OE_ORDER_LINES_HISTORY LHIST

Line 3186: UPDATE OE_ORDER_LINES_HISTORY LHIST

3182: arp_message.set_token( 'TABLE_NAME', 'oe_order_lines_history', FALSE );
3183:
3184: IF lhst_line_id_tab.COUNT <> 0 THEN
3185: FORALL i in lhst_line_id_tab.FIRST..lhst_line_id_tab.LAST
3186: UPDATE OE_ORDER_LINES_HISTORY LHIST
3187: 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)),
3188: invoice_to_org_id = decode(lhst_invoice_to_org_id_tab(i),null,invoice_to_org_id,lhst_invoice_to_org_id_tab(i)),
3189: ship_to_org_id = decode(lhst_ship_to_org_id_tab(i),null,ship_to_org_id,lhst_ship_to_org_id_tab(i)),
3190: 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)),