VIEW: APPS.PAY_CA_UNIQUE_CITIES_V

Source

View Text - Preformatted

SELECT distinct city_name from pay_us_city_names where state_code = 70 and (disable = 'N' or disable IS NULL)

View Text - HTML Formatted

SELECT DISTINCT CITY_NAME
FROM PAY_US_CITY_NAMES
WHERE STATE_CODE = 70
AND (DISABLE = 'N' OR DISABLE IS NULL)