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_ATTR_DEF_RULES

Line 2355: from oe_def_attr_def_rules

2351: for update nowait;
2352:
2353: CURSOR c5 is
2354: select ATTR_DEF_RULE_ID
2355: from oe_def_attr_def_rules
2356: where src_constant_value in (select to_char(m.duplicate_site_id)
2357: from ra_customer_merges m
2358: where m.process_flag = 'Y'
2359: and m.request_id = req_id

Line 2366: from oe_def_attr_def_rules

2362: for update nowait;
2363:
2364: CURSOR c6 is
2365: select ATTR_DEF_RULE_ID
2366: from oe_def_attr_def_rules
2367: where src_constant_value in (select to_char(m.duplicate_site_id)
2368: from ra_customer_merges m
2369: where m.process_flag = 'Y'
2370: and m.request_id = req_id

Line 2377: from oe_def_attr_def_rules

2373: for update nowait;
2374:
2375: CURSOR c7 is
2376: select ATTR_DEF_RULE_ID
2377: from oe_def_attr_def_rules
2378: where src_constant_value in (select to_char(m.duplicate_site_id)
2379: from ra_customer_merges m
2380: where m.process_flag = 'Y'
2381: and m.request_id = req_id

Line 2388: from oe_def_attr_def_rules

2384: for update nowait;
2385:
2386: CURSOR c8 is
2387: select ATTR_DEF_RULE_ID
2388: from oe_def_attr_def_rules
2389: where src_constant_value in (select to_char(m.duplicate_id)
2390: from ra_customer_merges m
2391: where m.process_flag = 'Y'
2392: and m.request_id = req_id

Line 2599: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

2595: IF l_debug_level > 0 THEN
2596: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2597: END IF;
2598: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2599: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2600:
2601: IF l_debug_level > 0 THEN
2602: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SHIP_TO_ORG_ID' ) ;
2603: END IF;

Line 2602: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SHIP_TO_ORG_ID' ) ;

2598: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2599: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2600:
2601: IF l_debug_level > 0 THEN
2602: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SHIP_TO_ORG_ID' ) ;
2603: END IF;
2604:
2605: UPDATE OE_DEF_ATTR_DEF_RULES a
2606: set src_constant_value = (select distinct to_char(m.customer_site_id)

Line 2605: UPDATE OE_DEF_ATTR_DEF_RULES a

2601: IF l_debug_level > 0 THEN
2602: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SHIP_TO_ORG_ID' ) ;
2603: END IF;
2604:
2605: UPDATE OE_DEF_ATTR_DEF_RULES a
2606: set src_constant_value = (select distinct to_char(m.customer_site_id)
2607: from ra_customer_merges m
2608: where a.src_constant_value =
2609: to_char(m.duplicate_site_id)

Line 2637: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

2633: IF l_debug_level > 0 THEN
2634: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2635: END IF;
2636: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2637: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INVOICE_TO_ORG_ID' ) ;
2640: END IF;
2641:

Line 2639: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INVOICE_TO_ORG_ID' ) ;

2635: END IF;
2636: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2637: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INVOICE_TO_ORG_ID' ) ;
2640: END IF;
2641:
2642: UPDATE OE_DEF_ATTR_DEF_RULES a
2643: set src_constant_value = (select distinct to_char(m.customer_site_id)

Line 2642: UPDATE OE_DEF_ATTR_DEF_RULES a

2638: IF l_debug_level > 0 THEN
2639: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INVOICE_TO_ORG_ID' ) ;
2640: END IF;
2641:
2642: UPDATE OE_DEF_ATTR_DEF_RULES a
2643: set src_constant_value = (select distinct to_char(m.customer_site_id)
2644: from ra_customer_merges m
2645: where a.src_constant_value =
2646: to_char(m.duplicate_site_id)

Line 2674: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

2670: IF l_debug_level > 0 THEN
2671: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
2672: END IF;
2673: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2674: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INTMED_TO_ORG_ID' ) ;
2677: END IF;
2678:

Line 2676: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INTMED_TO_ORG_ID' ) ;

2672: END IF;
2673: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2674: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INTMED_TO_ORG_ID' ) ;
2677: END IF;
2678:
2679: UPDATE OE_DEF_ATTR_DEF_RULES a
2680: set src_constant_value = (select distinct to_char(m.customer_site_id)

Line 2679: UPDATE OE_DEF_ATTR_DEF_RULES a

2675: IF l_debug_level > 0 THEN
2676: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE INTMED_TO_ORG_ID' ) ;
2677: END IF;
2678:
2679: UPDATE OE_DEF_ATTR_DEF_RULES a
2680: set src_constant_value = (select distinct to_char(m.customer_site_id)
2681: from ra_customer_merges m
2682: where a.src_constant_value =
2683: to_char(m.duplicate_site_id)

Line 2711: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );

2707: IF l_debug_level > 0 THEN
2708: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
2709: END IF;
2710: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2711: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2712: IF l_debug_level > 0 THEN
2713: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SOLD_TO_ORG_ID' ) ;
2714: END IF;
2715:

Line 2713: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SOLD_TO_ORG_ID' ) ;

2709: END IF;
2710: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
2711: -- arp_message.set_token( 'TABLE_NAME', 'OE_DEF_ATTR_DEF_RULES', FALSE );
2712: IF l_debug_level > 0 THEN
2713: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SOLD_TO_ORG_ID' ) ;
2714: END IF;
2715:
2716: UPDATE OE_DEF_ATTR_DEF_RULES a
2717: set src_constant_value = (select distinct to_char(m.customer_id)

Line 2716: UPDATE OE_DEF_ATTR_DEF_RULES a

2712: IF l_debug_level > 0 THEN
2713: oe_debug_pub.add( 'UPDATING OE_DEF_ATTR_DEF_RULES.SRC_CONSTANT_VALUE FOR ATTRIBUTE CODE SOLD_TO_ORG_ID' ) ;
2714: END IF;
2715:
2716: UPDATE OE_DEF_ATTR_DEF_RULES a
2717: set src_constant_value = (select distinct to_char(m.customer_id)
2718: from ra_customer_merges m
2719: where a.src_constant_value =
2720: to_char(m.duplicate_id)