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

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 2263: OE_ORDER_LINES L

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
2267: or l.ship_to_org_id = m.duplicate_site_id

Line 2296: OE_ORDER_LINES L

2292: RA_CUSTOMER_MERGES M4,
2293: RA_CUSTOMER_MERGES M5,
2294: RA_CUSTOMER_MERGES M6,
2295: RA_CUSTOMER_MERGES M7,
2296: OE_ORDER_LINES L
2297: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
2298: AND L.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
2299: AND L.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)
2300: AND L.INTMED_SHIP_TO_ORG_ID = M4.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 2355: OE_ORDER_LINES L

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
2359: or l.ship_to_org_id = m.duplicate_site_id

Line 2387: OE_ORDER_LINES L

2383: RA_CUSTOMER_MERGES M4,
2384: RA_CUSTOMER_MERGES M5,
2385: RA_CUSTOMER_MERGES M6,
2386: RA_CUSTOMER_MERGES M7,
2387: OE_ORDER_LINES L
2388: WHERE ( L.SOLD_TO_ORG_ID = M1.DUPLICATE_ID(+)
2389: AND L.INVOICE_TO_ORG_ID = M2.DUPLICATE_SITE_ID(+)
2390: AND L.SHIP_TO_ORG_ID = M3.DUPLICATE_SITE_ID(+)
2391: AND L.INTMED_SHIP_TO_ORG_ID = M4.DUPLICATE_SITE_ID(+)

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 2441: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L

2437: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2438: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2439: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID, 'N',M1.CUSTOMER_MERGE_ID
2440: FROM
2441: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L
2442: WHERE L.INVOICE_TO_ORG_ID= M1.DUPLICATE_SITE_ID
2443: AND M1.PROCESS_FLAG='N'
2444: AND M1.REQUEST_ID = req_id
2445: AND M1.SET_NUMBER = set_num

Line 2452: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L

2448: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2449: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2450: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID, 'N',M1.CUSTOMER_MERGE_ID
2451: FROM
2452: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L
2453: WHERE L.SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
2454: AND M1.PROCESS_FLAG='N'
2455: AND M1.REQUEST_ID = req_id
2456: AND M1.SET_NUMBER = set_num

Line 2463: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L

2459: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2460: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2461: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID,'N', M1.CUSTOMER_MERGE_ID
2462: FROM
2463: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L
2464: WHERE L.INTMED_SHIP_TO_ORG_ID= M1.DUPLICATE_SITE_ID
2465: AND M1.PROCESS_FLAG='N'
2466: AND M1.REQUEST_ID = req_id
2467: AND M1.SET_NUMBER = set_num

Line 2474: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L

2470: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2471: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2472: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID, 'N',M1.CUSTOMER_MERGE_ID
2473: FROM
2474: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L
2475: WHERE L.DELIVER_TO_ORG_ID= M1.DUPLICATE_SITE_ID
2476: AND M1.PROCESS_FLAG='N'
2477: AND M1.REQUEST_ID = req_id
2478: AND M1.SET_NUMBER = set_num

Line 2485: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L

2481: L.LINE_ID , L.HEADER_ID, L.LAST_UPDATE_DATE, L.LINE_ID,
2482: 'Y', SOLD_TO_ORG_ID, INVOICE_TO_ORG_ID, SHIP_TO_ORG_ID, INTMED_SHIP_TO_ORG_ID,
2483: DELIVER_TO_ORG_ID, END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_ID, 'N',M1.CUSTOMER_MERGE_ID
2484: FROM
2485: RA_CUSTOMER_MERGES M1, OE_ORDER_LINES L
2486: WHERE L.END_CUSTOMER_SITE_USE_ID= M1.DUPLICATE_SITE_ID
2487: AND M1.PROCESS_FLAG='N'
2488: AND M1.REQUEST_ID = req_id
2489: 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 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 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 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 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 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 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)),

Line 3513: from oe_line_acks a, oe_order_lines l

3509:
3510: CURSOR c5 is
3511: --changed for bug 3196900
3512: select a.line_id
3513: from oe_line_acks a, oe_order_lines l
3514: where a.sold_to_org_id in
3515: (select m.duplicate_id
3516: from ra_customer_merges m
3517: where m.process_flag = 'N'

Line 3540: from oe_line_acks a,oe_order_lines l

3536:
3537: CURSOR c7 is
3538: --changed for bug 3196900
3539: select a.line_id
3540: from oe_line_acks a,oe_order_lines l
3541: where a.end_customer_id in
3542: (select m.duplicate_id
3543: from ra_customer_merges m
3544: where m.process_flag = 'N'

Line 3935: and a.line_id in (select line_id from oe_order_lines);

3931: and m.request_id = req_id
3932: and m.set_number = set_num)
3933: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'
3934: --added for bug 3196900
3935: and a.line_id in (select line_id from oe_order_lines);
3936:
3937: g_count := sql%rowcount;
3938:
3939: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

Line 4087: and a.line_id in (select line_id from oe_order_lines);

4083: and m.request_id = req_id
4084: and m.set_number = set_num)
4085: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y'
4086: --added for bug 3196900
4087: and a.line_id in (select line_id from oe_order_lines);
4088:
4089: g_count := sql%rowcount;
4090:
4091: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );

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);