VIEW: APPS.PAY_CA_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_eng_name ,flv.meaning 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 ,fnd_lookup_values flv 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 AND co.county_abbrev = flv.lookup_code and flv.lookup_type='CA_PROVINCE' AND flv.language = userenv('LANG')

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_ENG_NAME
, FLV.MEANING 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
, FND_LOOKUP_VALUES FLV
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
AND CO.COUNTY_ABBREV = FLV.LOOKUP_CODE
AND FLV.LOOKUP_TYPE='CA_PROVINCE'
AND FLV.LANGUAGE = USERENV('LANG')