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 5267: from oe_drop_ship_sources

5263: Process_Mode IN VARCHAR2)
5264: IS
5265: CURSOR c1 is
5266: select DROP_SHIP_SOURCE_ID
5267: from oe_drop_ship_sources
5268: where LINE_LOCATION_ID in
5269: (select m.duplicate_site_id
5270: from ra_customer_merges m
5271: where m.process_flag = 'N'

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

5282:
5283: IF( process_mode = 'LOCK' ) THEN
5284:
5285: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
5286: arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
5287:
5288: open c1;
5289: close c1;
5290:

Line 5314: 'OE_DROP_SHIP_SOURCES',

5310: LAST_UPDATED_BY
5311: )
5312: select
5313: HZ_CUSTOMER_MERGE_LOG_s.nextval,
5314: 'OE_DROP_SHIP_SOURCES',
5315: m.customer_merge_header_id,
5316: a.drop_ship_source_id,
5317: to_char(a.line_location_id),
5318: to_char(m.customer_site_id),

Line 5326: from OE_DROP_SHIP_SOURCES a,

5322: hz_utility_pub.CREATION_DATE,
5323: hz_utility_pub.LAST_UPDATE_LOGIN,
5324: hz_utility_pub.LAST_UPDATE_DATE,
5325: hz_utility_pub.LAST_UPDATED_BY
5326: from OE_DROP_SHIP_SOURCES a,
5327: ra_customer_merges m
5328: where a.line_location_id = to_char(m.duplicate_site_id)
5329: and m.process_flag = 'N'
5330: and m.request_id = req_id

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

5333: END IF;
5334:
5335: /* site level update */
5336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5337: arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
5338:
5339: UPDATE OE_DROP_SHIP_SOURCES a
5340: set line_location_id = (select distinct m.customer_site_id
5341: from ra_customer_merges m

Line 5339: UPDATE OE_DROP_SHIP_SOURCES a

5335: /* site level update */
5336: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
5337: arp_message.set_token( 'TABLE_NAME', 'OE_DROP_SHIP_SOURCES', FALSE );
5338:
5339: UPDATE OE_DROP_SHIP_SOURCES a
5340: set line_location_id = (select distinct m.customer_site_id
5341: from ra_customer_merges m
5342: where a.line_location_id = m.duplicate_site_id
5343: and m.request_id = req_id