VIEW: APPS.PAY_US_UNIQUE_CITY_NAMES

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 )