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.CSI_UTILITY_GRP dependencies on HZ_LOCATIONS

Line 1848: FROM hz_parties hp, hz_party_sites hzp, hz_locations hz

1844: hz.address_style,
1845: hz.address_lines_phonetic,
1846: hz.county,
1847: hz.province
1848: FROM hz_parties hp, hz_party_sites hzp, hz_locations hz
1849: WHERE hp.party_id = hzp.party_id
1850: AND hzp.party_site_id = cp_location_id
1851: AND hzp.location_id = hz.location_id ;
1852:

Line 1871: FROM hz_locations hz

1867: hz.address_style,
1868: hz.address_lines_phonetic,
1869: hz.county,
1870: hz.province
1871: FROM hz_locations hz
1872: WHERE hz.location_id = cp_location_id ;
1873:
1874: Cursor c_hr_address( cp_location_id NUMBER) IS
1875: SELECT hr.location_id location_id,

Line 1977: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN

1973:
1974: END IF;
1975: CLOSE c_party_address;
1976:
1977: ELSIF l_location_type_code = 'HZ_LOCATIONS' THEN
1978: OPEN c_hz_address( l_location_id );
1979: FETCH c_hz_address INTO l_hz_address ;
1980: IF c_hz_address%FOUND THEN
1981: x_install_address_rec.party_site_number := l_hz_address.party_site_number;