VIEW: APPS.PAY_CA_CITY_INFORMATION_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)