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_DATA_FIX dependencies on OE_DEF_CONDN_ELEMS

Line 2311: from oe_def_condn_elems

2307: Process_Mode IN VARCHAR2)
2308: IS
2309: CURSOR c1 is
2310: select CONDITION_ELEMENT_ID
2311: from oe_def_condn_elems
2312: where value_string in (select to_char(m.duplicate_site_id)
2313: from ra_customer_merges m
2314: where m.process_flag = 'Y'
2315: and m.request_id = req_id

Line 2322: from oe_def_condn_elems

2318: for update nowait;
2319:
2320: CURSOR c2 is
2321: select CONDITION_ELEMENT_ID
2322: from oe_def_condn_elems
2323: where value_string in (select to_char(m.duplicate_site_id)
2324: from ra_customer_merges m
2325: where m.process_flag = 'Y'
2326: and m.request_id = req_id

Line 2333: from oe_def_condn_elems

2329: for update nowait;
2330:
2331: CURSOR c4 is
2332: select CONDITION_ELEMENT_ID
2333: from oe_def_condn_elems
2334: where value_string in (select to_char(m.duplicate_site_id)
2335: from ra_customer_merges m
2336: where m.process_flag = 'Y'
2337: and m.request_id = req_id

Line 2344: from oe_def_condn_elems

2340: for update nowait;
2341:
2342: CURSOR c3 is
2343: select CONDITION_ELEMENT_ID
2344: from oe_def_condn_elems
2345: where value_string in (select to_char(m.duplicate_id)
2346: from ra_customer_merges m
2347: where m.process_flag = 'Y'
2348: and m.request_id = req_id

Line 2407: | OE_DEF_CONDN_ELEMS|

2403: oe_debug_pub.add( 'BEGIN OE_CUST_MERGE_DATA_FIX.OE_DEFAULTING_MERGE' ) ;
2404: END IF;
2405:
2406: /*-----------------------------+
2407: | OE_DEF_CONDN_ELEMS|
2408: +-----------------------------*/
2409: /* both customer and site level */
2410:
2411: IF( process_mode = 'LOCK' ) THEN

Line 2416: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

2412: IF l_debug_level > 0 THEN
2413: oe_debug_pub.add( 'LOCKING TABLE OE_DEF_CONDN_ELEMENTS' ) ;
2414: END IF;
2415: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
2416: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2417:
2418:
2419: open c1;
2420: close c1;

Line 2453: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

2449: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2450: END IF;
2451:
2452: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2453: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2454: IF l_debug_level > 0 THEN
2455: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE SHIP_TO_ORG_ID' ) ;
2456: END IF;
2457: UPDATE OE_DEF_CONDN_ELEMS a

Line 2457: UPDATE OE_DEF_CONDN_ELEMS a

2453: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2454: IF l_debug_level > 0 THEN
2455: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE SHIP_TO_ORG_ID' ) ;
2456: END IF;
2457: UPDATE OE_DEF_CONDN_ELEMS a
2458: set value_string = (select distinct to_char(m.customer_site_id)
2459: from ra_customer_merges m
2460: where a.value_string =
2461: to_char(m.duplicate_site_id)

Line 2489: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

2485: IF l_debug_level > 0 THEN
2486: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2487: END IF;
2488: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2489: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2490: IF l_debug_level > 0 THEN
2491: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE INVOICE_TO_ORG_ID' ) ;
2492: END IF;
2493: UPDATE OE_DEF_CONDN_ELEMS a

Line 2493: UPDATE OE_DEF_CONDN_ELEMS a

2489: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2490: IF l_debug_level > 0 THEN
2491: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE INVOICE_TO_ORG_ID' ) ;
2492: END IF;
2493: UPDATE OE_DEF_CONDN_ELEMS a
2494: set value_string = (select distinct to_char(m.customer_site_id)
2495: from ra_customer_merges m
2496: where a.value_string =
2497: to_char(m.duplicate_site_id)

Line 2525: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

2521: IF l_debug_level > 0 THEN
2522: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2523: END IF;
2524: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2525: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2526: IF l_debug_level > 0 THEN
2527: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE INTMED_TO_ORG_ID' ) ;
2528: END IF;
2529: UPDATE OE_DEF_CONDN_ELEMS a

Line 2529: UPDATE OE_DEF_CONDN_ELEMS a

2525: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2526: IF l_debug_level > 0 THEN
2527: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE INTMED_TO_ORG_ID' ) ;
2528: END IF;
2529: UPDATE OE_DEF_CONDN_ELEMS a
2530: set value_string = (select distinct to_char(m.customer_site_id)
2531: from ra_customer_merges m
2532: where a.value_string =
2533: to_char(m.duplicate_site_id)

Line 2561: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );

2557: IF l_debug_level > 0 THEN
2558: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
2559: END IF;
2560: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2561: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_CONDN_ELEMS', FALSE );
2562: IF l_debug_level > 0 THEN
2563: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE SOLD_TO_ORG_ID' ) ;
2564: END IF;
2565:

Line 2566: UPDATE OE_DEF_CONDN_ELEMS a

2562: IF l_debug_level > 0 THEN
2563: oe_debug_pub.add( 'UPDATING OE_DEF_CONDN_ELEMENTS.VALUE_STRING FOR ATTRIBUTE CODE SOLD_TO_ORG_ID' ) ;
2564: END IF;
2565:
2566: UPDATE OE_DEF_CONDN_ELEMS a
2567: set value_string = (select distinct to_char(m.customer_id)
2568: from ra_customer_merges m
2569: where a.value_string =
2570: to_char(m.duplicate_id)