VIEW: APPS.PAY_CA_CITIES_V

Source

View Text - Preformatted

SELECT city_name ,city_code ,county_code ,primary_flag from pay_us_city_names where state_code = 70 and (disable = 'N' or disable IS NULL)

View Text - HTML Formatted

SELECT CITY_NAME
, CITY_CODE
, COUNTY_CODE
, PRIMARY_FLAG
FROM PAY_US_CITY_NAMES
WHERE STATE_CODE = 70
AND (DISABLE = 'N' OR DISABLE IS NULL)