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 1193: FROM ra_customer_merges m, hz_cust_acct_sites site

1189: )
1190:
1191: AND ( EXISTS (
1192: SELECT 'Y'
1193: FROM ra_customer_merges m, hz_cust_acct_sites site
1194: WHERE m.customer_merge_header_id = mh1.customer_merge_header_id
1195: AND m.duplicate_address_id = site.cust_acct_site_id
1196: AND ROWNUM = 1)
1197: OR EXISTS(

Line 1376: will be HZ_CUST_ACCT_SITES and HZ_CUST_SITE_USES.

1372: With the new cust. model, cust acct and sites are already
1373: striped by ou. The cust accts are no longer global.
1374: Because the sites will not be referenced in other ou,
1375: the tables that will replace RA_ADDRESSES and RA_SITE_USES
1376: will be HZ_CUST_ACCT_SITES and HZ_CUST_SITE_USES.
1377: Columns will be changed correspondingly.
1378: */
1379:
1380: --Bug 1725662: rewrite query to use index on

Line 1385: FROM hz_cust_acct_sites addr,

1381: --ra_customer_merge_headers.(request_id, process_flag);
1382:
1383: SELECT su.site_use_id site_use_id,
1384: mh.duplicate_id duplicate_id
1385: FROM hz_cust_acct_sites addr,
1386: hz_cust_site_uses su,
1387: ra_customer_merge_headers mh
1388: WHERE mh.request_id = req_id
1389: AND mh.process_flag = p_process_flag

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

2349: program_id = hz_utility_v2pub.program_id,
2350: program_update_date = sysdate
2351: WHERE EXISTS
2352: ( select 'Y'
2353: from hz_cust_acct_sites_ALL site,ra_customer_merges m --SSUptake
2354: where site.cust_account_id = from_customer_id
2355: and m.duplicate_address_id = site.cust_acct_site_id
2356: and su.cust_acct_site_id = site.cust_acct_site_id
2357: and m.request_id = req_id

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

2366:
2367: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');
2368:
2369:
2370: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2372: set status = 'I',
2373: last_update_date = sysdate,
2374: last_updated_by = hz_utility_v2pub.user_id,

Line 2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake

2367: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_SITE_USES');
2368:
2369:
2370: /*--Unset the status to 'I'for HZ_CUST_ACCT_SITES which was set to 'D' --*/
2371: UPDATE HZ_CUST_ACCT_SITES_ALL addr --SSUptake
2372: set status = 'I',
2373: last_update_date = sysdate,
2374: last_updated_by = hz_utility_v2pub.user_id,
2375: last_update_login = hz_utility_v2pub.last_update_login,

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

2388: )
2389: AND addr.status = 'D'
2390: AND part_delete = 'N'; --5747129
2391:
2392: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');
2393:
2394: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2395: UPDATE HZ_CUST_ACCOUNTS acct
2396: set status = decode(part_delete,'N','I','A'),