VIEW: APPS.HR_H2PI_US_CITY_NAMES_V

Source

View Text - Preformatted

SELECT cit.city_name, cit.state_code, cit.county_code, cit.city_code, cit.primary_flag from pay_us_city_names cit WHERE city_code like 'U%'

View Text - HTML Formatted

SELECT CIT.CITY_NAME
, CIT.STATE_CODE
, CIT.COUNTY_CODE
, CIT.CITY_CODE
, CIT.PRIMARY_FLAG
FROM PAY_US_CITY_NAMES CIT
WHERE CITY_CODE LIKE 'U%'