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_CUST_MERGES_GTT

Line 191: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS H

187: H.INVOICE_TO_ORG_ID, H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
188: H.SOLD_TO_SITE_USE_ID, H.END_CUSTOMER_SITE_USE_ID,
189: H.END_CUSTOMER_ID,'N',M1.CUSTOMER_MERGE_ID
190: FROM
191: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS H
192: WHERE H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
193: AND M1.PROCESS_FLAG='N'
194: AND M1.REQUEST_ID = req_id
195: AND M1.SET_NUMBER = set_num

Line 263: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS H

259: H.INVOICE_TO_ORG_ID, H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
260: H.SOLD_TO_SITE_USE_ID, H.END_CUSTOMER_SITE_USE_ID,
261: H.END_CUSTOMER_ID,'N',M1.CUSTOMER_MERGE_ID
262: FROM
263: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS H
264: WHERE H.END_CUSTOMER_ID= M1.DUPLICATE_ID
265: AND M1.PROCESS_FLAG='N'
266: AND M1.REQUEST_ID = req_id
267: AND M1.SET_NUMBER = set_num;

Line 337: INSERT INTO OE_CUST_MERGES_GTT(duplicate_id,request_id,set_number,process_flag,customer_merge_id)

333:
334: -- GTT insertion , bug 8883694 ,9349882 ,9558975
335: IF l_run_parallel_query = 'N' THEN
336: ----bug 8883694,9349882 Inserting unique duplicate_id into GTT for a request .
337: INSERT INTO OE_CUST_MERGES_GTT(duplicate_id,request_id,set_number,process_flag,customer_merge_id)
338: SELECT duplicate_id,request_id,set_number,process_flag, customer_merge_id
339: FROM RA_CUSTOMER_MERGES M1
340: WHERE M1.PROCESS_FLAG='N'
341: AND M1.REQUEST_ID = req_id

Line 785: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

781: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
782: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
783: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
784: FROM
785: OE_CUST_MERGES_GTT M1, OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
786: WHERE HIST.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
787: AND M1.PROCESS_FLAG='N'
788: AND M1.REQUEST_ID = req_id
789: AND M1.SET_NUMBER = set_num

Line 857: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST

853: HIST.HEADER_ID , HIST.SOLD_TO_ORG_ID, HIST.INVOICE_TO_ORG_ID,
854: HIST.SHIP_TO_ORG_ID, HIST.SOLD_TO_SITE_USE_ID, HIST.DELIVER_TO_ORG_ID,
855: HIST.END_CUSTOMER_SITE_USE_ID, HIST.END_CUSTOMER_ID
856: FROM
857: OE_CUST_MERGES_GTT M1,OE_ORDER_HEADERS_ALL H, OE_ORDER_HEADER_HISTORY HIST
858: WHERE HIST.END_CUSTOMER_ID= M1.DUPLICATE_ID
859: AND M1.PROCESS_FLAG='N'
860: AND M1.REQUEST_ID = req_id
861: AND M1.SET_NUMBER = set_num

Line 2430: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L

2426: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2427: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2428: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID,'N', M1.CUSTOMER_MERGE_ID
2429: FROM
2430: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L
2431: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
2432: AND M1.PROCESS_FLAG='N'
2433: AND M1.REQUEST_ID = req_id
2434: AND M1.SET_NUMBER = set_num

Line 2496: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L

2492: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2493: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2494: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID, 'N',M1.CUSTOMER_MERGE_ID
2495: FROM
2496: OE_CUST_MERGES_GTT M1, OE_ORDER_LINES L
2497: WHERE L.END_CUSTOMER_ID= M1.DUPLICATE_ID
2498: AND M1.PROCESS_FLAG='N'
2499: AND M1.REQUEST_ID = req_id
2500: AND M1.SET_NUMBER = set_num;

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 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 6572: OE_CUST_MERGES_GTT M1, OE_BLANKET_HEADERS H

6568: H.HEADER_ID, H.SOLD_TO_ORG_ID, H.INVOICE_TO_ORG_ID,
6569: H.SHIP_TO_ORG_ID, H.DELIVER_TO_ORG_ID,
6570: H.SOLD_TO_SITE_USE_ID, M1.CUSTOMER_MERGE_ID
6571: FROM
6572: OE_CUST_MERGES_GTT M1, OE_BLANKET_HEADERS H
6573: WHERE H.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
6574: AND M1.PROCESS_FLAG='N'
6575: AND M1.REQUEST_ID = req_id
6576: AND M1.SET_NUMBER = set_num

Line 7461: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES L

7457: INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID,
7458: INTMED_SHIP_TO_ORG_ID, DELIVER_TO_ORG_ID,
7459: M1.CUSTOMER_MERGE_ID
7460: FROM
7461: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES L
7462: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
7463: AND M1.PROCESS_FLAG='N'
7464: AND M1.REQUEST_ID = req_id
7465: AND M1.SET_NUMBER = set_num

Line 7891: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN

7887: SELECT L.LINE_ID , L.SOLD_TO_ORG_ID, L.INVOICE_TO_ORG_ID,
7888: L.SHIP_TO_ORG_ID, L.INTMED_SHIP_TO_ORG_ID, L.DELIVER_TO_ORG_ID,
7889: L.VERSION_NUMBER, M1.CUSTOMER_MERGE_ID
7890: FROM
7891: OE_CUST_MERGES_GTT M1, OE_BLANKET_LINES_HIST L , OE_BLANKET_LINES_all LN
7892: WHERE L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID
7893: AND M1.PROCESS_FLAG='N'
7894: AND M1.REQUEST_ID = req_id
7895: AND M1.SET_NUMBER = set_num