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 1049: FROM HZ_PARTY_SITE_USES

1045: WHERE CUST_ACCT_SITE_ID = p_cust_site_use_rec.cust_acct_site_id;
1046:
1047: BEGIN
1048: SELECT 'Y' INTO l_dummy
1049: FROM HZ_PARTY_SITE_USES
1050: WHERE PARTY_SITE_ID = l_party_site_id
1051: AND SITE_USE_TYPE = p_cust_site_use_rec.site_use_code
1052: AND STATUS = 'A'; --Bug 3322154
1053: EXCEPTION

Line 1414: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;

1410: l_status HZ_CUST_SITE_USES.status%TYPE;
1411: l_orig_sys_reference_rec HZ_ORIG_SYSTEM_REF_PUB.ORIG_SYS_REFERENCE_REC_TYPE;
1412:
1413: /* Bug Fix:5036975 */
1414: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%TYPE;
1415: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
1416: l_created_by_module HZ_CUST_SITE_USES.created_by_module%TYPE;
1417: l_application_id HZ_CUST_SITE_USES.application_id%TYPE;
1418: l_message_count NUMBER;

Line 1521: FROM HZ_PARTY_SITE_USES

1517: FROM HZ_CUST_ACCT_SITES_ALL
1518: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
1519: BEGIN
1520: SELECT 'Y' INTO l_dummy
1521: FROM HZ_PARTY_SITE_USES
1522: WHERE PARTY_SITE_ID = l_party_site_id
1523: AND SITE_USE_TYPE = l_site_use_code
1524: AND STATUS = 'A';
1525: EXCEPTION