View: PAY_US_NEW_CITIES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_US_NEW_CITIES_V

View Text

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

Columns