[Home] [Help]
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
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
1383: AND (mh.org_id = -1 OR (mh.org_id <> -1 AND addr.org_id = mh.org_id)) --SSUptake
2329: AND m.request_id = req_id
2330: AND m.set_number = set_num)
2331: AND part_delete = 'N'; --5747129
2332:
2333: /*--Unset the status to 'I'for HZ_CUST_SITE_USES which was set to 'D'--*/
2334: --undo
2335: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2336: SET status = 'I',
2337: last_update_date = sysdate,
2331: AND part_delete = 'N'; --5747129
2332:
2333: /*--Unset the status to 'I'for HZ_CUST_SITE_USES which was set to 'D'--*/
2334: --undo
2335: UPDATE HZ_CUST_SITE_USES_ALL su --SSUptake
2336: SET status = 'I',
2337: last_update_date = sysdate,
2338: last_updated_by = hz_utility_v2pub.user_id,
2339: last_update_login = hz_utility_v2pub.last_update_login,
2356: )
2357: AND status = 'D'
2358: AND part_delete = 'N'; --5747129
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