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.CSE_ASSET_UTIL_PKG dependencies on HZ_PARTY_SITES

Line 2434: hz_party_sites hzps

2430: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate
2431: UNION
2432: SELECT cal.fa_location_id fa_location_id
2433: FROM csi_a_locations cal,
2434: hz_party_sites hzps
2435: WHERE hzps.location_id = cal.location_id
2436: AND hzps.party_site_id = l_location_id -- Modified for bug 4149685
2437: AND l_location_type_code = 'HZ_PARTY_SITES'
2438: AND cal.location_table IN ('HZ_LOCATIONS','LOCATION_CODES')

Line 2437: AND l_location_type_code = 'HZ_PARTY_SITES'

2433: FROM csi_a_locations cal,
2434: hz_party_sites hzps
2435: WHERE hzps.location_id = cal.location_id
2436: AND hzps.party_site_id = l_location_id -- Modified for bug 4149685
2437: AND l_location_type_code = 'HZ_PARTY_SITES'
2438: AND cal.location_table IN ('HZ_LOCATIONS','LOCATION_CODES')
2439: AND NVL(cal.active_start_date,l_sysdate) <= l_sysdate
2440: AND NVL(cal.active_end_date , l_sysdate) >= l_sysdate ;
2441: