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.

[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on HZ_LOCATIONS

Line 822: , hz_locations loc

818: SELECT
819: loc.timezone_id
820: FROM
821: hz_party_sites site
822: , hz_locations loc
823: WHERE site.location_id = loc.location_id
824: AND site.party_id = p_contact_party_id
825: AND site.identifying_address_flag = 'Y'
826: AND site.status = 'A';

Line 2226: FROM hz_locations

2222: WHERE party_site_id = l_service_request_rec.incident_location_id
2223: AND created_by_module = 'SR_ONETIME';
2224: elsif l_service_request_rec.incident_location_type='HZ_LOCATION' then
2225: SELECT count(location_id) into l_onetime_add_cnt
2226: FROM hz_locations
2227: WHERE location_id = l_service_request_rec.incident_location_id
2228: AND created_by_module = 'SR_ONETIME';
2229: end if;
2230:

Line 4844: FROM hz_locations

4840: WHERE party_site_id = l_service_request_rec.incident_location_id
4841: AND created_by_module = 'SR_ONETIME';
4842: elsif l_service_request_rec.incident_location_type='HZ_LOCATION' then
4843: SELECT count(location_id) into G_ONETIME_ADD_CNT
4844: FROM hz_locations
4845: WHERE location_id = l_service_request_rec.incident_location_id
4846: AND created_by_module = 'SR_ONETIME';
4847: end if;
4848: /*

Line 22675: l_address1 hz_locations.address1%TYPE;

22671: l_addr_warn_msg VARCHAR2(200);
22672:
22673:
22674: --variables for address
22675: l_address1 hz_locations.address1%TYPE;
22676: l_address2 hz_locations.address2%TYPE;
22677: l_address3 hz_locations.address3%TYPE;
22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;

Line 22676: l_address2 hz_locations.address2%TYPE;

22672:
22673:
22674: --variables for address
22675: l_address1 hz_locations.address1%TYPE;
22676: l_address2 hz_locations.address2%TYPE;
22677: l_address3 hz_locations.address3%TYPE;
22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;

Line 22677: l_address3 hz_locations.address3%TYPE;

22673:
22674: --variables for address
22675: l_address1 hz_locations.address1%TYPE;
22676: l_address2 hz_locations.address2%TYPE;
22677: l_address3 hz_locations.address3%TYPE;
22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;

Line 22678: l_address4 hz_locations.address4%TYPE;

22674: --variables for address
22675: l_address1 hz_locations.address1%TYPE;
22676: l_address2 hz_locations.address2%TYPE;
22677: l_address3 hz_locations.address3%TYPE;
22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;

Line 22679: l_city hz_locations.city%TYPE;

22675: l_address1 hz_locations.address1%TYPE;
22676: l_address2 hz_locations.address2%TYPE;
22677: l_address3 hz_locations.address3%TYPE;
22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;

Line 22680: l_state hz_locations.state%TYPE;

22676: l_address2 hz_locations.address2%TYPE;
22677: l_address3 hz_locations.address3%TYPE;
22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;

Line 22681: l_postal_code hz_locations.postal_code%TYPE;

22677: l_address3 hz_locations.address3%TYPE;
22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;

Line 22682: l_county hz_locations.county%TYPE;

22678: l_address4 hz_locations.address4%TYPE;
22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;

Line 22683: l_province hz_locations.province%TYPE;

22679: l_city hz_locations.city%TYPE;
22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;
22687: l_party_site_number hz_party_sites.party_site_number%TYPE;

Line 22684: l_country hz_locations.country%TYPE;

22680: l_state hz_locations.state%TYPE;
22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;
22687: l_party_site_number hz_party_sites.party_site_number%TYPE;
22688: l_party_site_name hz_party_sites.party_site_name%TYPE;

Line 22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;

22681: l_postal_code hz_locations.postal_code%TYPE;
22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;
22687: l_party_site_number hz_party_sites.party_site_number%TYPE;
22688: l_party_site_name hz_party_sites.party_site_name%TYPE;
22689: l_addressee hz_party_sites.addressee%TYPE;

Line 22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;

22682: l_county hz_locations.county%TYPE;
22683: l_province hz_locations.province%TYPE;
22684: l_country hz_locations.country%TYPE;
22685: l_postal_plus4_code hz_locations.postal_plus4_code%TYPE;
22686: l_address_lines_phonetic hz_locations.address_lines_phonetic%TYPE;
22687: l_party_site_number hz_party_sites.party_site_number%TYPE;
22688: l_party_site_name hz_party_sites.party_site_name%TYPE;
22689: l_addressee hz_party_sites.addressee%TYPE;
22690:

Line 22729: from hz_locations a,

22725: l_party_site_name,
22726: l_addressee,
22727: l_loc_object_version_number,
22728: l_ps_object_version_number
22729: from hz_locations a,
22730: hz_party_sites b
22731: where b.party_site_id = l_service_req_rec.incident_location_id
22732: and b.location_id = a.location_id
22733: and b.created_by_module = a.created_by_module;