APPS.ARP_CMERGE_MASTER dependencies on HZ_CUST_ACCT_SITES

Line 1094: -- exists in hz_cust_acct_sites.

1090: -- if there exists one merge detail which has process_flag = 'Y', update
1091: -- merge table's process_flag to 'Y'.
1092: -- 2. mark merge rows by updating process_flag and request_id in detail table.
1093: -- 3. exclude those addresses in other operating units by checking if address
1094: -- exists in hz_cust_acct_sites.
1095:
1096: -- Added l_new_process_flag for backward compatible.
1097: IF p_merge_rule = 'NEW' THEN
1098: l_new_process_flag := p_process_flag;

Line 1182: FROM ra_customer_merges m, hz_cust_acct_sites site

1178: )
1179: --End of SSUptake
1180: AND ( EXISTS (
1181: SELECT 'Y'
1182: FROM ra_customer_merges m, hz_cust_acct_sites site
1183: WHERE m.customer_merge_header_id = mh.customer_merge_header_id
1184: AND m.duplicate_address_id = site.cust_acct_site_id
1185: AND ROWNUM = 1)
1186: OR EXISTS( --4693912

Line 1369: will be HZ_CUST_ACCT_SITES and HZ_CUST_SITE_USES.

1365: With the new cust. model, cust acct and sites are already
1366: striped by ou. The cust accts are no longer global.
1367: Because the sites will not be referenced in other ou,
1368: the tables that will replace RA_ADDRESSES and RA_SITE_USES
1369: will be HZ_CUST_ACCT_SITES and HZ_CUST_SITE_USES.
1370: Columns will be changed correspondingly.
1371: */
1372:
1373: --Bug 1725662: rewrite query to use index on

Line 1378: FROM hz_cust_acct_sites addr,

1374: --ra_customer_merge_headers.(request_id, process_flag);
1375:
1376: SELECT su.site_use_id site_use_id,
1377: mh.duplicate_id duplicate_id
1378: FROM hz_cust_acct_sites addr,
1379: hz_cust_site_uses su,
1380: ra_customer_merge_headers mh
1381: WHERE mh.request_id = req_id
1382: AND mh.process_flag = p_process_flag

Line 2346: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake

2342: program_id = hz_utility_v2pub.program_id,
2343: program_update_date = sysdate
2344: WHERE EXISTS
2345: ( select 'Y'
2346: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake
2347: where site.cust_account_id = from_customer_id
2348: and m.duplicate_address_id = site.cust_acct_site_id
2349: and su.cust_acct_site_id = site.cust_acct_site_id
2350: and m.request_id = req_id

Line 2363: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/

2359:
2360: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');
2361:
2362:
2363: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2364: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2365: set status = 'I',
2366: last_update_date = sysdate,
2367: last_updated_by = hz_utility_v2pub.user_id,

Line 2364: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake

2360: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');
2361:
2362:
2363: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2364: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2365: set status = 'I',
2366: last_update_date = sysdate,
2367: last_updated_by = hz_utility_v2pub.user_id,
2368: last_update_login = hz_utility_v2pub.last_update_login,

Line 2385: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');

2381: )
2382: AND addr.status = 'D'
2383: AND part_delete = 'N'; --5747129
2384:
2385: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');
2386:
2387: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2388: UPDATE HZ_CUST_ACCOUNTS acct
2389: set status = decode(part_delete,'N','I','A'),