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_MERGE_DUP_PVT dependencies on HZ_FORMAT_PUB

Line 4634: select hz_format_pub.format_address(l.location_id,null,null,', ')

4630: --private function
4631: function get_addresses(p_to_site_id in number, get_from_addr_flag in varchar2) return varchar2
4632: is
4633: cursor get_to_addr_csr is
4634: select hz_format_pub.format_address(l.location_id,null,null,', ')
4635: from hz_party_sites ps, hz_locations l
4636: where ps.location_id = l.location_id
4637: and ps.party_site_id = p_to_site_id;
4638:

Line 4640: select hz_format_pub.format_address(l.location_id,null,null,', ')

4636: where ps.location_id = l.location_id
4637: and ps.party_site_id = p_to_site_id;
4638:
4639: cursor get_from_addr_csr is
4640: select hz_format_pub.format_address(l.location_id,null,null,', ')
4641: from hz_merge_parties p,
4642: hz_merge_party_details pd,
4643: hz_party_sites s,
4644: hz_locations l,