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 4637: select hz_format_pub.format_address(l.location_id,null,null,', ')

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

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

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