APPS.HZ_ACCOUNT_MERGE_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 281: FROM HZ_CUST_ACCT_SITES_ALL

277: ) IS
278:
279: CURSOR get_account_site (c_acct_site_id NUMBER) IS
280: SELECT cust_acct_site_id, cust_account_id, party_site_id, status, org_id, orig_system_reference
281: FROM HZ_CUST_ACCT_SITES_ALL
282: WHERE cust_acct_site_id = c_acct_site_id;
283:
284: l_cust_acct_site_id NUMBER;
285: l_cust_account_id NUMBER;

Line 345: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL');

341: -- Get how many rows return
342: l_count := HZ_MOSR_VALIDATE_PKG.get_orig_system_ref_count(
343: p_orig_system => p_site_os,
344: p_orig_system_reference => p_site_osr,
345: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL');
346:
347: IF (l_count = 0) THEN
348:
349: FND_MESSAGE.SET_NAME('AR','HZ_CM_INV_OSOSR');

Line 359: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',

355: -- Get owner_table_id
356: HZ_ORIG_SYSTEM_REF_PUB.get_owner_table_id(
357: p_orig_system => p_site_os,
358: p_orig_system_reference => p_site_osr,
359: p_owner_table_name => 'HZ_CUST_ACCT_SITES_ALL',
360: x_owner_table_id => l_owner_table_id,
361: x_return_status => x_return_status);
362:
363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 935: from ra_customer_merges cm, ra_customer_merge_headers cmh , hz_cust_acct_sites_all cas

931: l_exist := 'N';
932:
933: select 'Y' , cmh.duplicate_number, cmh.customer_number
934: into l_exist, tmp_duplicate_number, tmp_customer_number
935: from ra_customer_merges cm, ra_customer_merge_headers cmh , hz_cust_acct_sites_all cas
936: where cas.cust_account_id = cm.duplicate_id
937: and (cmh.process_flag NOT IN ('FAILED' ,'Y','DISCARD') )
938: and cmh.customer_merge_header_id = cm.customer_merge_header_id
939: and cas.cust_account_id = l_account_merge_request_obj.merge_from_account.account_id

Line 1620: FROM hz_cust_acct_sites_all

1616: l_site_cnt := 0;
1617:
1618: BEGIN
1619: SELECT 1 INTO l_site_cnt
1620: FROM hz_cust_acct_sites_all
1621: WHERE cust_account_id = l_account_merge_request_obj.merge_from_account.account_id
1622: AND rownum = 1;
1623: EXCEPTION
1624: WHEN NO_DATA_FOUND THEN

Line 1794: FROM hz_cust_site_uses_all use,hz_cust_acct_sites_all site

1790: WHERE m.customer_merge_header_id = l_header_id
1791: AND m.customer_createsame = 'Y'
1792: AND m.duplicate_site_id <> -99
1793: AND exists (SELECT 'Y'
1794: FROM hz_cust_site_uses_all use,hz_cust_acct_sites_all site
1795: WHERE site.cust_account_id = m.customer_id
1796: AND site.org_id = m.org_id --SSUptake
1797: AND site.cust_acct_site_id = use.cust_acct_site_id
1798: AND site.org_id = use.org_id --SSUptake