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_PARTY_SITE_USES

Line 1141: FROM HZ_PARTY_SITE_USES

1137: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1138:
1139: BEGIN
1140: SELECT 'Y' INTO l_dummy
1141: FROM HZ_PARTY_SITE_USES
1142: WHERE PARTY_SITE_ID = l_party_site_id
1143: AND SITE_USE_TYPE = p_cust_site_use_rec.site_use_code
1144: AND STATUS = 'A'; --Bug 3322154
1145: EXCEPTION

Line 1545: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;

1541: l_status HZ_CUST_SITE_USES.status%TYPE;
1542: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1543:
1544: /* Bug Fix:5036975 */
1545: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;
1546: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
1547: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
1548: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;
1549: l_message_count NUMBER;

Line 1652: FROM HZ_PARTY_SITE_USES

1648: FROM HZ_CUST_ACCT_SITES_ALL
1649: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
1650: BEGIN
1651: SELECT 'Y' INTO l_dummy
1652: FROM HZ_PARTY_SITE_USES
1653: WHERE PARTY_SITE_ID = l_party_site_id
1654: AND SITE_USE_TYPE = l_site_use_code
1655: AND STATUS = 'A';
1656: EXCEPTION