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_CUST_ITEM_SETTINGS

Line 3335: from oe_cust_item_settings

3331: Process_Mode IN VARCHAR2)
3332: IS
3333: CURSOR c1 is
3334: select CUST_ITEM_SETTING_ID
3335: from oe_cust_item_settings
3336: where site_use_id in
3337: (select m.duplicate_site_id
3338: from ra_customer_merges m
3339: where m.process_flag = 'Y'

Line 3346: from oe_cust_item_settings

3342: for update nowait;
3343:
3344: CURSOR c2 is
3345: select CUST_ITEM_SETTING_ID
3346: from oe_cust_item_settings
3347: where customer_id in
3348: (select m.duplicate_id
3349: from ra_customer_merges m
3350: where m.process_flag = 'Y'

Line 3371: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );

3367:
3368: IF( process_mode = 'LOCK' ) THEN
3369:
3370: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3371: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
3372: IF l_debug_level > 0 THEN
3373: oe_debug_pub.add( 'LOCKING TABLE OE_CUST_ITEM_SETTINGS' ) ;
3374: END IF;
3375:

Line 3373: oe_debug_pub.add( 'LOCKING TABLE OE_CUST_ITEM_SETTINGS' ) ;

3369:
3370: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3371: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
3372: IF l_debug_level > 0 THEN
3373: oe_debug_pub.add( 'LOCKING TABLE OE_CUST_ITEM_SETTINGS' ) ;
3374: END IF;
3375:
3376: open c1;
3377: close c1;

Line 3391: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );

3387: IF l_debug_level > 0 THEN
3388: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
3389: END IF;
3390: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3391: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
3392: IF l_debug_level > 0 THEN
3393: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.SITE_USE_ID' ) ;
3394: END IF;
3395:

Line 3393: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.SITE_USE_ID' ) ;

3389: END IF;
3390: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3391: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
3392: IF l_debug_level > 0 THEN
3393: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.SITE_USE_ID' ) ;
3394: END IF;
3395:
3396: UPDATE OE_CUST_ITEM_SETTINGS a
3397: set site_use_id = (select distinct m.customer_site_id

Line 3396: UPDATE OE_CUST_ITEM_SETTINGS a

3392: IF l_debug_level > 0 THEN
3393: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.SITE_USE_ID' ) ;
3394: END IF;
3395:
3396: UPDATE OE_CUST_ITEM_SETTINGS a
3397: set site_use_id = (select distinct m.customer_site_id
3398: from ra_customer_merges m
3399: where a.site_use_id = m.duplicate_site_id
3400: and m.request_id = req_id

Line 3423: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );

3419: IF l_debug_level > 0 THEN
3420: oe_debug_pub.add( 'CUSTOMER LEVEL UPDATE' ) ;
3421: END IF;
3422: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3423: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
3424: IF l_debug_level > 0 THEN
3425: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.CUSTOMER_ID' ) ;
3426: END IF;
3427:

Line 3425: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.CUSTOMER_ID' ) ;

3421: END IF;
3422: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3423: -- arp_message.set_token( 'TABLE_NAME', 'OE_CUST_ITEM_SETTINGS', FALSE );
3424: IF l_debug_level > 0 THEN
3425: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.CUSTOMER_ID' ) ;
3426: END IF;
3427:
3428: UPDATE OE_CUST_ITEM_SETTINGS a
3429: set customer_id = (select distinct m.customer_id

Line 3428: UPDATE OE_CUST_ITEM_SETTINGS a

3424: IF l_debug_level > 0 THEN
3425: oe_debug_pub.add( 'UPDATING OE_CUST_ITEM_SETTINGS.CUSTOMER_ID' ) ;
3426: END IF;
3427:
3428: UPDATE OE_CUST_ITEM_SETTINGS a
3429: set customer_id = (select distinct m.customer_id
3430: from ra_customer_merges m
3431: where a.customer_id = m.duplicate_id
3432: and m.request_id = req_id