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_EM_INFORMATION

Line 8204: -- from OE_EM_INFORMATION_ALL

8200:
8201: CURSOR c1 is
8202: select header_id
8203: --changed for bug 3196900
8204: -- from OE_EM_INFORMATION_ALL
8205: from OE_EM_INFORMATION
8206: where sold_to_org_id in
8207: (select m.duplicate_id
8208: from ra_customer_merges m

Line 8205: from OE_EM_INFORMATION

8201: CURSOR c1 is
8202: select header_id
8203: --changed for bug 3196900
8204: -- from OE_EM_INFORMATION_ALL
8205: from OE_EM_INFORMATION
8206: where sold_to_org_id in
8207: (select m.duplicate_id
8208: from ra_customer_merges m
8209: where m.process_flag = 'N'

Line 8229: arp_message.set_token( 'TABLE_NAME', 'OE_EM_INFORMATION_ALL', FALSE );

8225:
8226: IF( process_mode = 'LOCK' ) THEN
8227:
8228: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
8229: arp_message.set_token( 'TABLE_NAME', 'OE_EM_INFORMATION_ALL', FALSE );
8230:
8231: open c1;
8232: close c1;
8233:

Line 8243: arp_message.set_token( 'TABLE_NAME', 'OE_EM_INFORMATION_ALL', FALSE );

8239:
8240:
8241: -- customer level update
8242: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
8243: arp_message.set_token( 'TABLE_NAME', 'OE_EM_INFORMATION_ALL', FALSE );
8244:
8245: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
8246: insert into HZ_CUSTOMER_MERGE_LOG (
8247: MERGE_LOG_ID,

Line 8263: 'OE_EM_INFORMATION_ALL',

8259: LAST_UPDATED_BY)
8260:
8261: SELECT
8262: HZ_CUSTOMER_MERGE_LOG_s.nextval,
8263: 'OE_EM_INFORMATION_ALL',
8264: m.CUSTOMER_MERGE_HEADER_ID,
8265: h.ORIG_SYS_DOCUMENT_REF,
8266: h.sold_to_org_id,
8267: m.customer_site_id,

Line 8275: from oe_em_information_All h,

8271: hz_utility_pub.CREATION_DATE,
8272: hz_utility_pub.LAST_UPDATE_LOGIN,
8273: hz_utility_pub.LAST_UPDATE_DATE,
8274: hz_utility_pub.LAST_UPDATED_BY
8275: from oe_em_information_All h,
8276: ra_customer_merges m
8277: where h.sold_to_org_id=m.duplicate_site_id
8278: and m.process_flag = 'N'
8279: and m.request_id = req_id

Line 8284: UPDATE OE_EM_INFORMATION_ALL a

8280: and m.set_number = set_num;
8281:
8282: end if;
8283:
8284: UPDATE OE_EM_INFORMATION_ALL a
8285: set sold_to_org_id = (select distinct m.customer_id
8286: from ra_customer_merges m
8287: where a.sold_to_org_id = m.duplicate_id
8288: and m.process_flag = 'N'

Line 8305: (select document_id,em_transaction_type_code from oe_em_information);

8301: and m.request_id = req_id
8302: and m.set_number = set_num)
8303: --added for bug3196900
8304: and (a.document_id,a.em_transaction_type_code) in
8305: (select document_id,em_transaction_type_code from oe_em_information);
8306:
8307:
8308: g_count := sql%rowcount;
8309: