[Home] [Help]
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
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
1390: AND (mh.org_id = -1 OR (mh.org_id <> -1 AND addr.org_id = mh.org_id)) --SSUptake
2336: AND m.request_id = req_id
2337: AND m.set_number = set_num)
2338: AND part_delete = 'N'; --5747129
2339:
2340: /*--Unset the status to 'I'for HZ_CUST_SITE_USES which was set to 'D'--*/
2341: --undo
2342: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2343: SET status = 'I',
2344: last_update_date = sysdate,
2338: AND part_delete = 'N'; --5747129
2339:
2340: /*--Unset the status to 'I'for HZ_CUST_SITE_USES which was set to 'D'--*/
2341: --undo
2342: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2343: SET status = 'I',
2344: last_update_date = sysdate,
2345: last_updated_by = hz_utility_v2pub.user_id,
2346: last_update_login = hz_utility_v2pub.last_update_login,
2363: )
2364: AND status = 'D'
2365: AND part_delete = 'N'; --5747129
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