View: HR_CA_CITIES_LOV_V

Product:	PER - Human Resources
Description:	View to retrieve data for web LOV for CA Cities.
Implementation/DBA Data:	APPS.HR_CA_CITIES_LOV_V

View Text

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

Columns