VIEW: APPS.PAY_US_NEW_CITIES_V

Source

View Text - Preformatted

SELECT ZP.ROWID ZPROW_ID , CI.ROWID CIROW_ID , GE.ROWID GEROW_ID , ZP.STATE_CODE , ZP.CITY_CODE , ZP.COUNTY_CODE , ST.STATE_NAME STATE_NAME , ST.STATE_ABBREV , CO.COUNTY_NAME COUNTY_NAME , CI.CITY_NAME CITY_NAME , ZP.ZIP_START , ZP.ZIP_END , CI.DISABLE FROM PAY_US_STATES ST, PAY_US_COUNTIES CO, PAY_US_CITY_NAMES CI, PAY_US_ZIP_CODES ZP, PAY_US_CITY_GEOCODES GE WHERE ZP.STATE_CODE = ST.STATE_CODE AND ZP.STATE_CODE = CO.STATE_CODE AND ZP.COUNTY_CODE = CO.COUNTY_CODE AND ZP.STATE_CODE = CI.STATE_CODE AND ZP.COUNTY_CODE = CI.COUNTY_CODE AND ZP.CITY_CODE = CI.CITY_CODE AND ZP.STATE_CODE = GE.STATE_CODE AND ZP.COUNTY_CODE = GE.COUNTY_CODE AND ZP.CITY_CODE = GE.CITY_CODE AND CI.STATE_CODE = GE.STATE_CODE AND CI.COUNTY_CODE = GE.COUNTY_CODE AND CI.CITY_CODE = GE.CITY_CODE AND CO.STATE_CODE = GE.STATE_CODE AND CO.COUNTY_CODE = GE.COUNTY_CODE AND ST.STATE_CODE = GE.STATE_CODE --ORDER BY ST.STATE_NAME

View Text - HTML Formatted

SELECT ZP.ROWID ZPROW_ID
, CI.ROWID CIROW_ID
, GE.ROWID GEROW_ID
, ZP.STATE_CODE
, ZP.CITY_CODE
, ZP.COUNTY_CODE
, ST.STATE_NAME STATE_NAME
, ST.STATE_ABBREV
, CO.COUNTY_NAME COUNTY_NAME
, CI.CITY_NAME CITY_NAME
, ZP.ZIP_START
, ZP.ZIP_END
, CI.DISABLE
FROM PAY_US_STATES ST
, PAY_US_COUNTIES CO
, PAY_US_CITY_NAMES CI
, PAY_US_ZIP_CODES ZP
, PAY_US_CITY_GEOCODES GE
WHERE ZP.STATE_CODE = ST.STATE_CODE
AND ZP.STATE_CODE = CO.STATE_CODE
AND ZP.COUNTY_CODE = CO.COUNTY_CODE
AND ZP.STATE_CODE = CI.STATE_CODE
AND ZP.COUNTY_CODE = CI.COUNTY_CODE
AND ZP.CITY_CODE = CI.CITY_CODE
AND ZP.STATE_CODE = GE.STATE_CODE
AND ZP.COUNTY_CODE = GE.COUNTY_CODE
AND ZP.CITY_CODE = GE.CITY_CODE
AND CI.STATE_CODE = GE.STATE_CODE
AND CI.COUNTY_CODE = GE.COUNTY_CODE
AND CI.CITY_CODE = GE.CITY_CODE
AND CO.STATE_CODE = GE.STATE_CODE
AND CO.COUNTY_CODE = GE.COUNTY_CODE
AND ST.STATE_CODE = GE.STATE_CODE --ORDER BY ST.STATE_NAME