View: PAY_CA_CITY_INFORMATION_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_CA_CITY_INFORMATION_V

View Text

SELECT CO.COUNTY_NAME
, CO.COUNTY_ABBREV
, CO.COUNTY_CODE
, CT.CITY_NAME
, CT.CITY_CODE
, ZIP.ZIP_START
, ZIP.ZIP_END
FROM PAY_US_COUNTIES CO
, PAY_US_CITY_NAMES CT
, PAY_US_ZIP_CODES ZIP
, PAY_US_STATES ST
WHERE ST.STATE_CODE = CT.STATE_CODE AND ST.STATE_CODE = CO.STATE_CODE AND CO.COUNTY_CODE = CT.COUNTY_CODE AND ST.STATE_CODE = ZIP.STATE_CODE AND CT.CITY_CODE = ZIP.CITY_CODE AND ZIP.COUNTY_CODE = CO.COUNTY_CODE AND ST.STATE_CODE = 70
AND (CT.DISABLE = 'N' OR CT.DISABLE IS NULL)

Columns