eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_ACCOUNT_SITE_V2PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 561: hz_cust_site_uses_all su

557: CURSOR c_site (l_cust_acct_id VARCHAR2) IS
558: SELECT su.site_use_id,su.cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas,
561: hz_cust_site_uses_all su
562: WHERE a.cust_account_id = l_cust_acct_id
563: AND l_cust_acct_id = cas.cust_account_id
564: AND cas.cust_acct_site_id = su.cust_acct_site_id
565: AND su.site_use_code = p_site_use_code

Line 590: hz_cust_site_uses_all su -- Bug 3456489

586: SELECT su.site_use_id,su.cust_acct_site_id
587: INTO l_site_use_id,l_cust_acct_site_id
588: FROM hz_cust_accounts a,
589: hz_cust_acct_sites_all cas, -- Bug 3456489
590: hz_cust_site_uses_all su -- Bug 3456489
591: WHERE a.cust_account_id = l_cust_acct_id
592: AND l_cust_acct_id = cas.cust_account_id
593: AND cas.cust_acct_site_id = su.cust_acct_site_id
594: AND su.site_use_code = p_site_use_code

Line 600: UPDATE hz_cust_site_uses_all -- Bug 3456489

596: AND su.primary_flag = 'Y'
597: AND cas.org_id = p_org_id -- TCA SSA Uptake (Bug 3456489)
598: AND su.org_id = p_org_id; -- TCA SSA Uptake (Bug 3456489)
599:
600: UPDATE hz_cust_site_uses_all -- Bug 3456489
601: SET primary_flag = 'N',
602: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
603: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
604: WHERE site_use_id =l_site_use_id;

Line 642: UPDATE hz_cust_site_uses_all -- Bug 3456489

638: p_msg_level=>fnd_log.level_procedure);
639: END IF;
640:
641:
642: UPDATE hz_cust_site_uses_all -- Bug 3456489
643: SET primary_flag = 'N',
644: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
645: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
646: WHERE site_use_id =r_site.site_use_id;

Line 1055: hz_cust_site_uses_all hcsu

1051: -- if record already exists for this site with 'DUNNING' or 'STATEMENTS' site_use_id
1052: CURSOR c_check_site_use_id IS
1053: SELECT hcp.cust_account_profile_id
1054: FROM hz_customer_profiles hcp,
1055: hz_cust_site_uses_all hcsu
1056: WHERE hcsu.cust_acct_site_id = p_cust_site_use_rec.cust_acct_site_id
1057: AND hcp.site_use_id = hcsu.site_use_id
1058: AND hcsu.site_use_code IN ('DUN','STMTS');
1059:

Line 1209: hz_cust_site_uses_all su

1205: -- New Query Below
1206: SELECT count(*) into l_cnt
1207: FROM hz_cust_accounts a,
1208: hz_cust_acct_sites_all cas,
1209: hz_cust_site_uses_all su
1210: WHERE
1211: a.cust_account_id = l_cust_acct_id
1212: and a.cust_account_id = cas.cust_account_id
1213: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1222: hz_cust_site_uses_all su

1218: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1219:
1220: SELECT count(*) into l_cnt
1221: FROM hz_cust_acct_sites_all cas,
1222: hz_cust_site_uses_all su
1223: WHERE
1224: cas.cust_account_id = l_cust_acct_id
1225: and cas.status = 'A'
1226: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1411: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_SITE_USES_ALL';

1407: if (p_cust_site_use_rec.orig_system is not null and p_cust_site_use_rec.orig_system<>fnd_api.g_miss_char ) then
1408:
1409: l_orig_sys_reference_rec.orig_system := p_cust_site_use_rec.orig_system;
1410: l_orig_sys_reference_rec.orig_system_reference := p_cust_site_use_rec.orig_system_reference;
1411: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_SITE_USES_ALL';
1412: l_orig_sys_reference_rec.owner_table_id := p_cust_site_use_rec.site_use_id;
1413: l_orig_sys_reference_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1414: hz_orig_system_ref_pub.create_orig_system_reference(
1415: FND_API.G_FALSE,

Line 1753: hz_cust_site_uses_all su

1749: -- New Query Below
1750: SELECT count(*) into l_cnt
1751: FROM hz_cust_accounts a,
1752: hz_cust_acct_sites_all cas,
1753: hz_cust_site_uses_all su
1754: WHERE
1755: a.cust_account_id = l_cust_acct_id
1756: and a.cust_account_id = cas.cust_account_id
1757: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1767: hz_cust_site_uses_all su

1763: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1764:
1765: SELECT count(*) into l_cnt
1766: FROM hz_cust_acct_sites_all cas,
1767: hz_cust_site_uses_all su
1768: WHERE
1769: cas.cust_account_id = l_cust_acct_id
1770: and cas.status = 'A'
1771: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1809: hz_cust_site_uses_all su -- Bug 3456489

1805: BEGIN
1806: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1807: FROM hz_cust_accounts a,
1808: hz_cust_acct_sites_all cas, -- Bug 3456489
1809: hz_cust_site_uses_all su -- Bug 3456489
1810: WHERE
1811: a.cust_account_id = l_cust_acct_id
1812: and a.cust_account_id = cas.cust_account_id
1813: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1824: UPDATE hz_cust_site_uses_all -- Bug 3456489

1820: END;
1821:
1822: IF l_cnt > 0 THEN
1823: BEGIN
1824: UPDATE hz_cust_site_uses_all -- Bug 3456489
1825: SET primary_flag = 'Y',
1826: last_updated_by = hz_utility_pub.LAST_UPDATED_BY,
1827: last_update_date = hz_utility_pub.LAST_UPDATE_DATE
1828: WHERE rowid = l_minrowid;

Line 1832: from hz_cust_site_uses_all -- Bug 3456489

1828: WHERE rowid = l_minrowid;
1829: -- Bug 3294182.
1830: select cust_acct_site_id
1831: into l_casid
1832: from hz_cust_site_uses_all -- Bug 3456489
1833: where rowid=l_minrowid;
1834: denormalize_site_use_flag(
1835: l_casid,
1836: nvl(p_cust_site_use_rec.site_use_code,l_site_use_code),

Line 2899: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

2895: END IF;
2896:
2897: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2898: -- populate function for integration service
2899: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2900: p_operation => 'I',
2901: p_site_use_id => x_site_use_id );
2902: END IF;
2903: END IF;

Line 3083: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',

3079: and (p_cust_site_use_rec.site_use_id = FND_API.G_MISS_NUM or p_cust_site_use_rec.site_use_id is null) THEN
3080: hz_orig_system_ref_pub.get_owner_table_id
3081: (p_orig_system => p_cust_site_use_rec.orig_system,
3082: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
3083: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
3084: x_owner_table_id => l_cust_site_use_rec.site_use_id ,
3085: x_return_status => x_return_status);
3086: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3087: RAISE FND_API.G_EXC_ERROR;

Line 3123: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

3119: END IF;
3120:
3121: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
3122: -- populate function for integration service
3123: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
3124: p_operation => 'U',
3125: p_site_use_id => l_cust_site_use_rec.site_use_id );
3126: END IF;
3127: END IF;