APPS.OE_CUST_MERGE dependencies on OE_EM_INFORMATION_ALL

Line 7343: -- from OE_EM_INFORMATION_ALL

7339:
7340: CURSOR c1 is
7341: select header_id
7342: --changed for bug 3196900
7343: -- from OE_EM_INFORMATION_ALL
7344: from OE_EM_INFORMATION
7345: where sold_to_org_id in
7346: (select m.duplicate_id
7347: from ra_customer_merges m

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

7364:
7365: IF( process_mode = 'LOCK' ) THEN
7366:
7367: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
7368: arp_message.set_token( 'TABLE_NAME', 'OE_EM_INFORMATION_ALL', FALSE );
7369:
7370: open c1;
7371: close c1;
7372:

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

7378:
7379:
7380: -- customer level update
7381: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
7382: arp_message.set_token( 'TABLE_NAME', 'OE_EM_INFORMATION_ALL', FALSE );
7383:
7384: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
7385: insert into HZ_CUSTOMER_MERGE_LOG (
7386: MERGE_LOG_ID,

Line 7402: 'OE_EM_INFORMATION_ALL',

7398: LAST_UPDATED_BY)
7399:
7400: SELECT
7401: HZ_CUSTOMER_MERGE_LOG_s.nextval,
7402: 'OE_EM_INFORMATION_ALL',
7403: m.CUSTOMER_MERGE_HEADER_ID,
7404: h.ORIG_SYS_DOCUMENT_REF,
7405: h.sold_to_org_id,
7406: m.customer_site_id,

Line 7414: from oe_em_information_All h,

7410: hz_utility_pub.CREATION_DATE,
7411: hz_utility_pub.LAST_UPDATE_LOGIN,
7412: hz_utility_pub.LAST_UPDATE_DATE,
7413: hz_utility_pub.LAST_UPDATED_BY
7414: from oe_em_information_All h,
7415: ra_customer_merges m
7416: where h.sold_to_org_id=m.duplicate_site_id
7417: and m.process_flag = 'N'
7418: and m.request_id = req_id

Line 7423: UPDATE OE_EM_INFORMATION_ALL a

7419: and m.set_number = set_num;
7420:
7421: end if;
7422:
7423: UPDATE OE_EM_INFORMATION_ALL a
7424: set sold_to_org_id = (select distinct m.customer_id
7425: from ra_customer_merges m
7426: where a.sold_to_org_id = m.duplicate_id
7427: and m.process_flag = 'N'