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 -- Bug 3456489

557: SELECT su.site_use_id,su.cust_acct_site_id
558: INTO l_site_use_id,l_cust_acct_site_id
559: FROM hz_cust_accounts a,
560: hz_cust_acct_sites_all cas, -- Bug 3456489
561: hz_cust_site_uses_all su -- Bug 3456489
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 571: UPDATE hz_cust_site_uses_all -- Bug 3456489

567: AND su.primary_flag = 'Y'
568: AND cas.org_id = p_org_id -- TCA SSA Uptake (Bug 3456489)
569: AND su.org_id = p_org_id; -- TCA SSA Uptake (Bug 3456489)
570:
571: UPDATE hz_cust_site_uses_all -- Bug 3456489
572: SET primary_flag = 'N'
573: WHERE site_use_id =l_site_use_id;
574:
575: denormalize_site_use_flag(l_cust_acct_site_id,p_site_use_code,'Y');

Line 1117: hz_cust_site_uses_all su

1113: -- New Query Below
1114: SELECT count(*) into l_cnt
1115: FROM hz_cust_accounts a,
1116: hz_cust_acct_sites_all cas,
1117: hz_cust_site_uses_all su
1118: WHERE
1119: a.cust_account_id = l_cust_acct_id
1120: and a.cust_account_id = cas.cust_account_id
1121: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1130: hz_cust_site_uses_all su

1126: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1127:
1128: SELECT count(*) into l_cnt
1129: FROM hz_cust_acct_sites_all cas,
1130: hz_cust_site_uses_all su
1131: WHERE
1132: cas.cust_account_id = l_cust_acct_id
1133: and cas.status = 'A'
1134: and cas.cust_acct_site_id = su.cust_acct_site_id

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

1276: 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
1277:
1278: l_orig_sys_reference_rec.orig_system := p_cust_site_use_rec.orig_system;
1279: l_orig_sys_reference_rec.orig_system_reference := p_cust_site_use_rec.orig_system_reference;
1280: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_SITE_USES_ALL';
1281: l_orig_sys_reference_rec.owner_table_id := p_cust_site_use_rec.site_use_id;
1282: l_orig_sys_reference_rec.created_by_module := p_cust_site_use_rec.created_by_module;
1283: hz_orig_system_ref_pub.create_orig_system_reference(
1284: FND_API.G_FALSE,

Line 1622: hz_cust_site_uses_all su

1618: -- New Query Below
1619: SELECT count(*) into l_cnt
1620: FROM hz_cust_accounts a,
1621: hz_cust_acct_sites_all cas,
1622: hz_cust_site_uses_all su
1623: WHERE
1624: a.cust_account_id = l_cust_acct_id
1625: and a.cust_account_id = cas.cust_account_id
1626: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1636: hz_cust_site_uses_all su

1632: and su.org_id = p_cust_site_use_rec.org_id; -- TCA SSA Uptake (Bug 3456489) */
1633:
1634: SELECT count(*) into l_cnt
1635: FROM hz_cust_acct_sites_all cas,
1636: hz_cust_site_uses_all su
1637: WHERE
1638: cas.cust_account_id = l_cust_acct_id
1639: and cas.status = 'A'
1640: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1678: hz_cust_site_uses_all su -- Bug 3456489

1674: BEGIN
1675: SELECT min(su.rowid),count(*) into l_minrowid,l_cnt
1676: FROM hz_cust_accounts a,
1677: hz_cust_acct_sites_all cas, -- Bug 3456489
1678: hz_cust_site_uses_all su -- Bug 3456489
1679: WHERE
1680: a.cust_account_id = l_cust_acct_id
1681: and a.cust_account_id = cas.cust_account_id
1682: and cas.cust_acct_site_id = su.cust_acct_site_id

Line 1693: UPDATE hz_cust_site_uses_all -- Bug 3456489

1689: END;
1690:
1691: IF l_cnt > 0 THEN
1692: BEGIN
1693: UPDATE hz_cust_site_uses_all -- Bug 3456489
1694: SET primary_flag = 'Y'
1695: WHERE rowid = l_minrowid;
1696: -- Bug 3294182.
1697: select cust_acct_site_id

Line 1699: from hz_cust_site_uses_all -- Bug 3456489

1695: WHERE rowid = l_minrowid;
1696: -- Bug 3294182.
1697: select cust_acct_site_id
1698: into l_casid
1699: from hz_cust_site_uses_all -- Bug 3456489
1700: where rowid=l_minrowid;
1701: denormalize_site_use_flag(
1702: l_casid,
1703: nvl(p_cust_site_use_rec.site_use_code,l_site_use_code),

Line 2760: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

2756: END IF;
2757:
2758: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2759: -- populate function for integration service
2760: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2761: p_operation => 'I',
2762: p_site_use_id => x_site_use_id );
2763: END IF;
2764: END IF;

Line 2944: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',

2940: 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
2941: hz_orig_system_ref_pub.get_owner_table_id
2942: (p_orig_system => p_cust_site_use_rec.orig_system,
2943: p_orig_system_reference => p_cust_site_use_rec.orig_system_reference,
2944: p_owner_table_name => 'HZ_CUST_SITE_USES_ALL',
2945: x_owner_table_id => l_cust_site_use_rec.site_use_id ,
2946: x_return_status => x_return_status);
2947: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2948: RAISE FND_API.G_EXC_ERROR;

Line 2984: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(

2980: END IF;
2981:
2982: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2983: -- populate function for integration service
2984: HZ_POPULATE_BOT_PKG.pop_hz_cust_site_uses_all(
2985: p_operation => 'U',
2986: p_site_use_id => l_cust_site_use_rec.site_use_id );
2987: END IF;
2988: END IF;