VIEW: APPS.HR_CA_CITIES_LOV_V

Source

View Text - Preformatted

SELECT a.city_name, a.city_code, c.state_code, z.zip_start, z.zip_end, b.county_name, b.county_abbrev, b.county_code From pay_us_city_names a, pay_us_counties b, pay_us_states c, pay_us_zip_codes z Where a.state_code = c.state_code and a.county_code = b.county_code and b.state_code = c.state_code and a.city_code = z.city_code and a.state_code = z.state_code and a.county_code = z.county_code and a.state_code = 70

View Text - HTML Formatted

SELECT A.CITY_NAME
, A.CITY_CODE
, C.STATE_CODE
, Z.ZIP_START
, Z.ZIP_END
, B.COUNTY_NAME
, B.COUNTY_ABBREV
, B.COUNTY_CODE
FROM PAY_US_CITY_NAMES A
, PAY_US_COUNTIES B
, PAY_US_STATES C
, PAY_US_ZIP_CODES Z
WHERE A.STATE_CODE = C.STATE_CODE
AND A.COUNTY_CODE = B.COUNTY_CODE
AND B.STATE_CODE = C.STATE_CODE
AND A.CITY_CODE = Z.CITY_CODE
AND A.STATE_CODE = Z.STATE_CODE
AND A.COUNTY_CODE = Z.COUNTY_CODE
AND A.STATE_CODE = 70