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.JL_ZZ_AP_AWT_DEFAULT_PKG dependencies on HZ_GEOGRAPHIES

Line 595: -- v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511

591:
592: v_hr_zone hr_locations_all.region_1%TYPE;
593: v_hr_province hr_locations_all.region_2%TYPE;
594: v_hr_city hr_locations_all.town_or_city%TYPE;
595: -- v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
596: v_hr_city_code hz_geographies.geography_code%TYPE; --Added Bug 11724717
597: pc_vendor_id number;
598: p_calling_sequence varchar2(2000):= 'Supp_Wh_Def_Line';
599: v_country_code varchar2(100); --bug 11666467

Line 596: v_hr_city_code hz_geographies.geography_code%TYPE; --Added Bug 11724717

592: v_hr_zone hr_locations_all.region_1%TYPE;
593: v_hr_province hr_locations_all.region_2%TYPE;
594: v_hr_city hr_locations_all.town_or_city%TYPE;
595: -- v_hr_city_name hz_geographies.geography_name%TYPE; --Added Bug 6147511
596: v_hr_city_code hz_geographies.geography_code%TYPE; --Added Bug 11724717
597: pc_vendor_id number;
598: p_calling_sequence varchar2(2000):= 'Supp_Wh_Def_Line';
599: v_country_code varchar2(100); --bug 11666467
600:

Line 781: from hz_geographies

777: --Bug no: 6147511. Added this query to get the city name from geographies table
778: --bug 11724717: Modified query to retrieve Geo Code
779: select geography_code
780: into v_hr_city_code
781: from hz_geographies
782: where geography_name = v_hr_city
783: and geography_element2_code = v_hr_province
784: and geography_type='CITY'
785: --bug 11666467: Start