FND Design Data [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: ViewAPPS.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