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_DROP_SHIP_SOURCES

Line 5815: from oe_drop_ship_sources

5811: Process_Mode IN VARCHAR2)
5812: IS
5813: CURSOR c1 is
5814: select DROP_SHIP_SOURCE_ID
5815: from oe_drop_ship_sources
5816: where LINE_LOCATION_ID in
5817: (select m.duplicate_site_id
5818: from ra_customer_merges m
5819: where m.process_flag = 'N'

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

5830:
5831: IF( process_mode = 'LOCK' ) THEN
5832:
5833: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5834: arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
5835:
5836: open c1;
5837: close c1;
5838:

Line 5862: 'OE_DROP_SHIP_SOURCES',

5858: LAST_UPDATED_BY
5859: )
5860: select
5861: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5862: 'OE_DROP_SHIP_SOURCES',
5863: m.customer_merge_header_id,
5864: a.drop_ship_source_id,
5865: to_char(a.line_location_id),
5866: to_char(m.customer_site_id),

Line 5874: from OE_DROP_SHIP_SOURCES a,

5870: hz_utility_pub.CREATION_DATE,
5871: hz_utility_pub.LAST_UPDATE_LOGIN,
5872: hz_utility_pub.LAST_UPDATE_DATE,
5873: hz_utility_pub.LAST_UPDATED_BY
5874: from OE_DROP_SHIP_SOURCES a,
5875: ra_customer_merges m
5876: where a.line_location_id = to_char(m.duplicate_site_id)
5877: and m.process_flag = 'N'
5878: and m.request_id = req_id

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

5881: END IF;
5882:
5883: /* site level update */
5884: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5885: arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
5886:
5887: UPDATE OE_DROP_SHIP_SOURCES a
5888: set line_location_id = (select distinct m.customer_site_id
5889: from ra_customer_merges m

Line 5887: UPDATE OE_DROP_SHIP_SOURCES a

5883: /* site level update */
5884: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5885: arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
5886:
5887: UPDATE OE_DROP_SHIP_SOURCES a
5888: set line_location_id = (select distinct m.customer_site_id
5889: from ra_customer_merges m
5890: where a.line_location_id = m.duplicate_site_id
5891: and m.request_id = req_id