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_AIA_CUSTOM_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 607: FROM HZ_CUST_SITE_USES_ALL

603: AND rownum = 1;
604:
605: CURSOR get_casu_id(l_cas_id NUMBER, l_su_code VARCHAR2, l_org_id NUMBER) IS
606: SELECT site_use_id
607: FROM HZ_CUST_SITE_USES_ALL
608: WHERE cust_acct_site_id = l_cas_id
609: AND site_use_code = l_su_code
610: AND status = 'A'
611: AND org_id = l_org_id

Line 798: FROM HZ_CUST_SITE_USES_ALL

794: AND rownum = 1;
795:
796: CURSOR get_casu_id(l_cas_id NUMBER, l_su_code VARCHAR2, l_org_id NUMBER) IS
797: SELECT site_use_id
798: FROM HZ_CUST_SITE_USES_ALL
799: WHERE cust_acct_site_id = l_cas_id
800: AND site_use_code = l_su_code
801: AND status = 'A'
802: AND org_id = l_org_id