[Home] [Help]
View: HR_H2PI_US_CITY_NAMES_V
Product: | PER - Human Resources |
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US city names |
Implementation/DBA Data: |
APPS.HR_H2PI_US_CITY_NAMES_V
|
View Text
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%'
Columns
Name |
CITY_NAME |
STATE_CODE |
COUNTY_CODE |
CITY_CODE |
PRIMARY_FLAG |