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_DROP_SHIP_SOURCES

Line 3243: from oe_drop_ship_sources

3239: Process_Mode IN VARCHAR2)
3240: IS
3241: CURSOR c1 is
3242: select DROP_SHIP_SOURCE_ID
3243: from oe_drop_ship_sources
3244: where LINE_LOCATION_ID in
3245: (select m.duplicate_site_id
3246: from ra_customer_merges m
3247: where m.process_flag = 'Y'

Line 3267: -- arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );

3263:
3264: IF( process_mode = 'LOCK' ) THEN
3265:
3266: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3267: -- arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
3268: IF l_debug_level > 0 THEN
3269: oe_debug_pub.add( 'LOCKING TABLE OE_DROP_SHIP_SOURCES' ) ;
3270: END IF;
3271:

Line 3269: oe_debug_pub.add( 'LOCKING TABLE OE_DROP_SHIP_SOURCES' ) ;

3265:
3266: -- arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3267: -- arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
3268: IF l_debug_level > 0 THEN
3269: oe_debug_pub.add( 'LOCKING TABLE OE_DROP_SHIP_SOURCES' ) ;
3270: END IF;
3271:
3272: open c1;
3273: close c1;

Line 3282: -- arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );

3278: IF l_debug_level > 0 THEN
3279: oe_debug_pub.add( 'SITE LEVEL UPDATE' ) ;
3280: END IF;
3281: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3282: -- arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
3283: IF l_debug_level > 0 THEN
3284: oe_debug_pub.add( 'UPDATING OE_DROP_SHIP_SOURCES.LINE_LOCATION_ID' ) ;
3285: END IF;
3286:

Line 3284: oe_debug_pub.add( 'UPDATING OE_DROP_SHIP_SOURCES.LINE_LOCATION_ID' ) ;

3280: END IF;
3281: -- arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3282: -- arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
3283: IF l_debug_level > 0 THEN
3284: oe_debug_pub.add( 'UPDATING OE_DROP_SHIP_SOURCES.LINE_LOCATION_ID' ) ;
3285: END IF;
3286:
3287: UPDATE OE_DROP_SHIP_SOURCES a
3288: set line_location_id = (select distinct m.customer_site_id

Line 3287: UPDATE OE_DROP_SHIP_SOURCES a

3283: IF l_debug_level > 0 THEN
3284: oe_debug_pub.add( 'UPDATING OE_DROP_SHIP_SOURCES.LINE_LOCATION_ID' ) ;
3285: END IF;
3286:
3287: UPDATE OE_DROP_SHIP_SOURCES a
3288: set line_location_id = (select distinct m.customer_site_id
3289: from ra_customer_merges m
3290: where a.line_location_id = m.duplicate_site_id
3291: and m.request_id = req_id