VIEW: APPS.HXC_TK_PAY_LOCATIONS

Source

View Text - Preformatted

SELECT pcy.CITY_NAME||','||pst.STATE_NAME||','||pct.COUNTY_NAME||' county,'||pzc.ZIP_START , pst.STATE_ABBREV, pst.STATE_NAME, pct.COUNTY_NAME , pcy.CITY_NAME , pzc.ZIP_START , pzc.ZIP_END FROM pay_us_states pst, pay_us_counties pct, pay_us_city_names pcy, pay_us_zip_codes pzc WHERE pcy.STATE_CODE = pst.STATE_CODE and pcy.COUNTY_CODE = pct.COUNTY_CODE and pct.STATE_CODE = pst.STATE_CODE and pcy.CITY_CODE = pzc.CITY_CODE and pcy.STATE_CODE = pzc.STATE_CODE and pcy.COUNTY_CODE = pzc.COUNTY_CODE and (pst.state_code<52 or pst.state_code=72) order by pcy.CITY_NAME, pst.STATE_NAME, pct.COUNTY_NAME, pzc.ZIP_START

View Text - HTML Formatted

SELECT PCY.CITY_NAME||'
, '||PST.STATE_NAME||'
, '||PCT.COUNTY_NAME||' COUNTY
, '||PZC.ZIP_START
, PST.STATE_ABBREV
, PST.STATE_NAME
, PCT.COUNTY_NAME
, PCY.CITY_NAME
, PZC.ZIP_START
, PZC.ZIP_END
FROM PAY_US_STATES PST
, PAY_US_COUNTIES PCT
, PAY_US_CITY_NAMES PCY
, PAY_US_ZIP_CODES PZC
WHERE PCY.STATE_CODE = PST.STATE_CODE
AND PCY.COUNTY_CODE = PCT.COUNTY_CODE
AND PCT.STATE_CODE = PST.STATE_CODE
AND PCY.CITY_CODE = PZC.CITY_CODE
AND PCY.STATE_CODE = PZC.STATE_CODE
AND PCY.COUNTY_CODE = PZC.COUNTY_CODE
AND (PST.STATE_CODE<52 OR PST.STATE_CODE=72) ORDER BY PCY.CITY_NAME
, PST.STATE_NAME
, PCT.COUNTY_NAME
, PZC.ZIP_START